1.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 [Menu] button in the upper left section of Store Manager window:
- Press [Preferences] to call the drop-down list:
- Click the necessary button on the toolbar of "Categories" section:
Categories Export steps:
Launch export wizard
Select "Export" action and click [Next >] button to continue.
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.
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.
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.
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.
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.
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 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.
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 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.