Magento – Export Orders

Magento Orders Export Wizard will help you to export your Magento orders to comma-separated values file (.csv) which can be easily opened in MS Excel or other application for detailed analysis.

Before you start Magento Orders Export, choose what orders should be exported.

Export Wizard suggests 3 options to choose from:

  1. Export all orders
  2. Export filtered orders
  3. Export selected orders

To start Magento Export Orders you need to click on Magento Export Orders Button

Magento Orders’ Export Wizard is a lot like Magento Products Import / Export Wizard. To export orders from Magento store follow several steps:

1. Press “Export” to continue:

2. Store Manager can export orders to .csv file. You should enter the file name or select one to be replaced

Magento Export Orders

Also you can Save Export Settings or Load one to use now.

3. On the next page you can see some general Magento orders export options.

Here you choose Magento Orders you’d like to export. Default setting for this option is to export all Orders at current Magento store. If you wish to export orders filtered by some criteria, select Only filtered orders option. If you’d selected orders before starting Orders Export you can choose to Export only selected orders.

4. Fields Delimiter page has some important settings. Check them to ensure proper configuration.

Magento Export Orders

First option is delimiter character. Most popular delimiters are comma (,), semicolon (;) and tab character ( ) however other symbols can be used as well. Export file is usually generated for further import. If incorrect delimiter is specified during import, file will not be parsed properly and orders will not be imported. Second option is quote string values. It is used to separate strings in CSV file.

5. Select fields you want to be exported:

Magento Export Orders view

All available fields that can be exported are listed in left pane. Select fields you want to be exported and click “>” button to move them to right pane. If you’d like to export all fields simply press “>>”. The order in which columns will be saved in .csv file can be changed. To do this you can move exported columns up and down using corresponding buttons.

6. Preview export file and proceed.

Magento Orders

Choose what action to perform after saving export data, use “None” option and Wizard will be automatically closed. If you wish to open a directory containing result file, check corresponding option. Open result file option allows you to see export file opened in Excel.

Also you can Save Export Settings for future or load one.

Attenion! When you press “Export” button, Magento Export Orders process will start!

You can save all your export settings

Read more Useful articles about Store Manager for Magento here

Documentation for Store Manager for Magento is available here

If you have any suggestions on Magento Export Orders you’re welcome to contact our support team.