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.
Enable Automatic Execution - Turn this setting to ‘Yes’ to start the order export process automatically after each new order is placed.
Click on any export profile in the grid to configure it.
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.
Run After Each New Order is Placed [Automatic Execution] - Turn this setting to ‘Yes’ to start the order export process automatically after each new order is placed for this particular export profile.
Use Order Number 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 - Turn these settings to 'Yes' if you want to preselect starting and ending invoice numbers. The settings are similar to the previous settings block.
Shipping numbers - Turn these settings to 'Yes' if you want to preselect starting and ending shipment numbers.
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 the 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).
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.