8. Export Orders

To start Export orders you need to click on Export/Import button which starts the X-Cart orders Import/Export Wizard. Or you can use "Export Orders to Excel" or "Export Orders to HTML" buttons  as well.

Import/Export Orders Wizard is a lot like Categories Import/Export Wizard.

You can select "Simple orders export" or "Custom orders export". "Simple orders export" helps you to export data that you can manage in the Store manager. "Custom orders export' allows you to customise exporting data or export all data.

Simple Orders Export

You can select "Simple orders export" or "Custom orders export". "Simple orders export" helps you to export data that you can manage in the Store Manager. "Custom orders export' allows you to customise exporting data or export all data.

To make Simple orders export follow up several steps:

  1. Select "Simple orders export" to perform, and click "Next >" button.


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


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


    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. 

    Also you can enable option that will convert date from Unix to DateTime format. In this case system format settings will be used.

     Second option. Quote string values is used to separate strings in CSV file.

    4. Export options page helps you to select X-Cart orders to export. You can Filter them by Time Period, Order Number and by Order status.


Attention! When you press "Export" Button, export process will start!

    5. Preview Export.

If you don't want to perform any action after saving export data, use "Just close this window" option and Wizard will be automatically closed when you press Finish button. If you choose to open a directory containing result file, check corresponding option. Open result file option allows you to see export file opened in Excel.

Custom Orders Export

You can select "Simple orders export" or "Custom orders export". "Simple orders export" helps you to export data that you can manage in the Store Manager. 

"Custom orders export' allows you to customise exporting data or export all data.

To make Custom orders export follow up several steps:

  1. Select "Custom orders export" to perform, and click "Next >" button.


    You can select "Simple orders export" or "Custom orders export". "Simple orders export" helps you to export data that you can manage in the Store manager. 

        "Custom orders export' allows you to customize exporting data or export all orders data.

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



    3. Select delimiter and quote character. Check them to ensure proper configuration.


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 products will not be imported.

Second option. Quote string values is used to separate strings in CSV file.

Also you can enable option that will convert date from Unix to DateTime format. In this case system format settings will be used.

    4. Select fields you want to be exported:



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.

    5. Select period of time or Orders Numbers you want to be Exported.


Attention! When you press "Export" Button, export process will start!

    6. Preview Export.

If you don't want to perform any action after saving export data, use "Just close this window" option and Wizard will be automatically closed when you press Finish button. If you choose to open a directory containing result file, check corresponding option. Open result file option allows you to see export file opened in Excel.

Now X-Cart orders export is finished!

By eMagicOne Inc.

Comments