2.3. Export Categories
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 the [Menu] button in the left section of Store Manager window:
Click the necessary button on the toolbar of "Categories" section:
Categories Export steps:
Launch export wizard
Select the "Export" action and click the [Next >] button to continue.
2. Select File
Store Manager can export PrestaShop categories to .csv file. You should enter the file name or select the one you need to replace.
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 the current store. If you wish to export products only from the specific category, select the "Only from the current category and its subcategories" option. But, you need to make sure that the category is open before you run the Wizard.
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 the [Test FTP Connection] button.
The first option is delimiter character. The most popular delimiters are comma (,), semicolon (;) and tab character ( ), but 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 the .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 a subcategory can contain one or more other categories. The Category delimiter character is used to separate category names and specify the full category tree path for a given product. The Category path is very similar to the 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, the category path for the "T-shirts" subcategory is Root|Home|Clothes|Women|ira. Pipe (|) character is a separator.
The default image 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.
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 the [->] 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.
To do this you can move exported columns up and down using corresponding buttons.
You can use an "Add Group of Fields" option to move Group of Fields in bulk.
This option Contains the following groups:
Category Language Fields
Attention! When you press [Export] button, export of PrestaShop categories will start! This process will take some time.
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 the "Just close this window" option and Wizard will close when you press the [Finish] button.
If you choose to open a directory containing the result file, check the corresponding option. The "Open result file" option allows you to see the export file opened in Excel.
Now export of PrestaShop categories is done and you can check the result.
Check the PrestaShop Category Management section to find more about category editing.
To find more details on the export Categories process check the following article from the Useful Articles page: