3.3.2. Export Orders

fmOrders

1. To start export pf PrestaShop orders you need to select "Export Orders" wizard tool on the "Orders" page:

Export wizard option

2. Store Manager can export orders from PrestaShop to .csv file. You should enter the file name or select (browse [...] ) one to be replaced.

You can also load or save export settings (configuration) there:

Select file step

To place exported data on FTP server, select the field below and fill the form with necessary FTP details. Specify the directory where the data will be transferred to.

Select file via FTP

3. Select positions you want to use in exporting from the proposed options:

Export options

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

  • The first option is delimiter character. Most popular delimiters are the comma (,), semicolon (;) and tab character ( ), however, other symbols can be used, as well. The export file is usually generated for further import.

If the incorrect delimiter is specified during import, the file will not be parsed properly and customers will not be imported.

  • The second option is "Quote string values". It is used to separate strings in CSV file.
Select fields delimiter and quote character

5. "Select Fields to be Exported" step contains fields in the left pane that can be selected and moved to the right pane, that is the area with data to export.

Select fields to export
Move field to right

All available fields that can be exported are listed in the left pane. Select fields you want to be exported and click button to move them to the right pane.

Move all fields

If you'd like to export all fields simply press this button.

There are also groups of fields related to the particular order details. These fields help to automatically transfer necessary data sets of the order information to the right at once:

Select fields to be Exported

To customize the data, which is exporting, use the Expression formula. Press the [Add Expression Field] in the top and specify necessary value in the "Expression Editor" form.

Expression editor

If you want to see the column title in the first row of the exported file, make sure the corresponding option is selected:

Column title at the first row

Attention! When you press [Export] button, export process will start!

6. Final step of the export

Finish step

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, select corresponding option.
  • "Open result file" option allows you to see export file opened in Excel.

Also, you can [Save Export Settings] for future in the Wizard directly(1) or to a separate file (2) as in the illustration below:

Save export configuration

To delete selected configuration from a wizard list use the option for removal:

Save export configuration

Now PrestaShop orders export is completed.