6. Export Products

fmProductImportExport, fmImportExport. 

X-Cart Export Products wizard will help you to export your products from X-Cart to comma-separated values file (.csv) which can be easily opened in MS Excel or other application for detailed analysis.

To start X-Cart Export Products procedure you need to click on  button which starts the X-Cart Import/Export Wizard. Or you can use "Export Products to Excel" or "Export Products to HTML" Buttons  for fast Export as well - .

Products' Import/Export Wizard is a lot like Categories Import/Export Wizard.

Custom Export

To perform X-Cart Custom Export follow up several steps:

1. Select "Custom export" and click "Next >" button to continue.


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


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


All products - if you want to export all products at current store. If you wish to export X-Cart products only from specific category, select "Only from current category" option. But, you'll need to make sure that category is open before you run the Wizard.

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.

X-Cart 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.

Third setting is category delimiter. This is not native .csv setting, it is used only in Store Manager. As you know categories are organized in a form of tree, where one category can contain one or more subcategories and subcategory can contain one or more other categories. Category delimiter character is used to separate category names and specify full category tree path for given product. Category path is very similar to directory path, used to specify full file name in Windows, where every directory separated by backslash (\) character like this one C:\\Program Files\eMagicOne\Store Manager for X-Cart\.

As for example category path for "Test Subcategory" (see image below) will be X-Cart Products|XCart Services|Test Subcategory. Pipe (|) character was used as separator.


Images - Default images path is the exact place to store image files.

5. 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. 

Attention! When you press "Export" button, export process will start! You can save all your X-Cart Export Settings or Load an Existing ones.

6. Preview X-Cart Export. On the last page of X-Cart Export Wizard you can preview the result.


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.

Export to .csv File

Store Manager can export products from X-Cart to .csv file compatible with Sage Line. Just follow up a few X-Cart Import/Export Wizard steps:

1. Select "Export to .csv file compatible with Sage Line 50" and click "Next >" button to continue.


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


3. On the next page you can see some general X-Cart export options.


All products- if you want to export all products at current store. If you wish to export products only from specific category, select "Only from current category" option. But, you'll need to make sure that category is open before you run the Wizard.

4. The next step is to Select fields you want to be exported:


Enable and fill in all necessary fields for X-Cart export. Empty fields can be set by Default/you can enter the Default value.

Attention! When you press "Export" button, export process will start! You can save all your X-Cart Export Settings or Load an Existing ones.

5. Preview X-Cart Export.


If you don't want to perform any action after saving X-Cart 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 X-Cart export file opened in Excel.

Now X-Cart products export is finished.

By eMagicOne Inc.

Comments