3. Export Categories


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

To start Import/Export you need to click on the button which starts the Import/Export Categories Wizard. You can find it in such ways:

- from the upper left section of Store Manager window:

Import/export categories wizard

- by using the drop-down list of the top settings option:

Import/export categories wizard in top

- or by clicking on the appropriate option from the top toolbar of Categories section:

Run categories export/import wizard

Export Wizard steps:

Export action

    1. Select and click "Export" button to continue.
Export action

2. Select File

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

Select file step

3. Select categories to export

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

Select categories to export

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

4. Select fields delimiter and quote character

Fields Delimiter page has some important settings. Check them to ensure proper configuration. In order to check the field for image exporting you should have the FTP connection properly installed. Check your FTP details in the Preferences section, use for this the 'Test FTP Connection' button.

Select fields delimiter and quote character

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.

Quote string values are used to separate strings in CSV file.

The 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 the full file name in Windows, where every directory separated by a backslash (\) character like this one C:\Program Files\eMagicOne\Store Manager for PrestaShop\.

As for example category path for "T-shirts" sub-category (see an image below) will be Root|Home|Women|Tops|T-shirts. Pipe (|) character was used as a separator.

Simple categories tree

Images - Default images path is the exact place to the store image files. Click on the browse button next to the 'Default images path' field to define the correct location.

Upload images

Please note, the image can be exported once you have the FTP configured. In other cases, please set the FTP required details in the form which appears after pressing the browser button below:

FTP configure to export images

5. Select fields you want to be exported

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 panel. If you'd like to export all fields simply press ">>".

The order in which columns will be saved in the .csv file can be changed. To do this you can move exported columns up and down using corresponding buttons.

Select fields to be exported

Attention! When you press "Export" button, export of PrestaShop categories will start! This process will take some time.

6. Summary results

On the last page of Export Wizard you can preview the result.

Finish step

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 export of PrestaShop categories is done and you can check the result.

Check PrestaShop Category Management section to find more about category editing.

To find more details on export Categories process check the following article from the Useful Articles page:

PrestaShop - Export Categories

By eMagicOne Inc.