1.3. Export Categories

fmCategoryEdit

Export PrestaShop categories wizard exports categories from PrestaShop to comma-separated values file (.csv). You can open this file in MS Excel or other application for detailed analysis.

To start import or export you need to click on the [Import/Export] button. You can find it in these ways:

  • Press [Menu] button in the upper left section of Store Manager window:
Import/export categories wizard
  • Press [Preferences] to call the drop-down list:
Import/export categories wizard in top
  • Click the necessary button on the toolbar of "Categories" section:
Run categories export/import wizard

Categories Export steps:

Launch export wizard

1. Welcome

Select "Export" action and click [Next >] 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 you need to replace.

Select file step

3. Select Categories to Export

There are general export options on the next page. Choose "All categories" if you want to export all categories of 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 need to make sure that category is open before you run the Wizard.

Select categories to export

4. Select Fields Delimiter and Quote Character

There are important settings on this page that determine proper configuration. To check the field for image exporting you should have the FTP connection properly installed. Check your FTP details in the Preferences section; to do so press [Test FTP Connection] button.

Select fields delimiter and quote character

The first option is delimiter character. Most popular delimiters are comma (,), semicolon (;) and tab character ( ), but other symbols can be used as well.

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 a tree. 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 is separated by a backslash (\) character. For example, C:\Program Files\eMagicOne\Store Manager for PrestaShop\

As it is shown in the illustration below, category path for "T-shirts" subcategory is Root|Home|Women|Tops|T-shirts. Pipe (|) character is a separator.

Simple categories tree

"Images"

Default images path is the exact place of the store image files. Click 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 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. Finish

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 close 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