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:
- by using the drop-down list of the top settings option:
- or by clicking on the appropriate option from the top toolbar of Categories section:
Export Wizard steps:
- Select and click "Export" button to continue.
2. Select File
Store Manager can export PrestaShop categories to .csv file. You should enter the file name or select one to be replaced.
3. Select categories to export
On the next page, you can see some general export options.
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.
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.
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.
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:
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.
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.
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: