For more details see the Efficient Order Export for Magento 2 extension page.
Easily manage orders export. Configure flexible export profiles and gather all valuable order data, including the data generated by third-party extensions.
Automatic Execution - Turn this setting to ‘Yes’ to start order export process automatically after each new order is placed.
Skip Child Products - Enable this option if you want to exclude child products from export (for example, to export only main configurable products).
Skip Parent Products - If the option is set to 'yes' the module will ignore parent products (bundle and configurable) during the export process.
Change Status with - Specify a status that orders will get after export.
Store View - Select store view from which the data should be exported.
Use Order Nimber Filters - Turn this setting to 'Yes' if you want to preselect starting and ending order numbers.
Starting From #/ Ending with # - Limit the export file with specific starting and ending order numbers. Leave the fields blank to export all order numbers.
Skip Starting from - Switch to 'Yes' to start the export from the order that comes next after the one indicated in the 'Starting From #' field.
Automatically Increment Staring From -Set this option to 'Yes' to automatically populate the 'Starting From #' field with the last exported order. In combination with the enabled 'Skip Starting From' option this would let you export only new orders with each profile run.
Invoice numbers/Shipping numbers - Turn these settings to 'Yes' if you want to preselect starting and ending invoice/shipment numbers. The settings are similar to the previous settings block.
Date Range - Enable this option and specify a certain date range for which you want to export orders.
Filter by Customer Group - Turn this setting to 'Yes' if you want to export orders for a particular customer group.
For Customer Groups - Select customer groups for which you’d like to export orders.
Order Statuses - It's also possible to export orders with particular order statuses.
File Name - Select a name of the exported file. Warning! If the 'Add Timestamp' option is disabled, the file will be overwritten on each new export run.
File Path (local) - Specify the path to where the exported file should be placed.
Add Timestamp - You can either add a timestamp to a file name as a prefix or create a new folder to place the file in it.
File Format - Choose the format of the file you want to export orders to.
Upload exported File by FTP - You can save the file with exported data either to the server, where Magento 2 is installed or upload it via FTP to a different server.
Type - You can use either the FTP or SFTP type.
Email Address - Please define an e-mail address and a message subject if you want to receive the file via e-mail.
Fields to Export - To export custom product options, please choose ‘Export Specified Fields Only’. It’s also possible to export all fields.
Database Field - Choose the fields that you would like to export in this dropdown.
Mapping - Specify how each field should be named in the exported file.
Name - Indicate the field name for the data of the third-party extension.
Table to Join - Indicate db table of the third-party extension, from which the data should be taken.
Base Table Key - Specify to which field of the sales_flat_order table the third-party extension table should be added (in most cases it is the entity_id field).
Referenced Table Key - Indicate a field of the third-party extension table, by which the table will be added to the Magento 2 order table (usually it is the field that contains an order id).
To set up the export profile run by URL, please, go to Store → Configuration → Amasty Extensions → Efficient Order Export and expand the Run Profile by URL section.
Allow to Run Profile by direct URL — enable this option to get the ability to run export profiles using URL;
Security Code — specify the security code here. It will be used to authorize you when running the export.
The URL to run export profile will be the following:
where [code] is your security code and [profile_id] is the ID of the profile you want to run. Please remember to replace yourmagentourl with your Magento 2 installation URL.