2016-09-27
Rating 0 stars - 0 votes

PrestaShop – Export Categories

When you plan to rearrange PrestaShop category tree, adding some categories or subcategories of different levels or want to transfer it to another store, you definitely consider performing PrestaShop export of all categories.


Export lets you easily pull out category related information to CSV. Further you can import it to another PrestaShop installation or simply use as a sample, edit with new categories/subcategories and bulk add them to PrestaShop.


Store Manager for PrestaShop facilitates category export to CSV, in the other words you can transfer category tree to the file in two ways and you can find them outlined below.


Method #1 PrestaShop Export of Category Tree

Use this method in case you need to export category structure. Result file will list categories and subcategories of all levels preserving category hierarchy you have at PrestaShop. This task is accomplished respectively, via category export wizard.
  1. PrestaShop export category wizard can be accessed via Tools->Import/Export->Import/Export Categories or on the category toolbar. Click its icon to initiate the wizard.


  2. Wizard offers you two options: categories import or export. Choose export action and Store Manager will automatically move to the next step.


  3. Here you need to specify csv file name, you will export category structure to. You have also a possibility to load saved previously export configuration.


  4. The third wizard step lets you choose categories you want to list in the export file, either all categories you have at PrestaShop database or selected at the moment category with its subcategories.


  5. Next in turn is file delimiter configuring. You can leave default values as they are specified in PrestaShop export category wizard. Although you can replace them with the ones you prefer. Press ‘Next’ button to move to the following stage of data export.


  6. This window of the export wizard is divided into two sections, the first is listing all category fields, the second one displays fields you select for export.


  7. This window of Store Manager export wizard gives you a possibility to look through information exported. You are allowed to save data export settings – all the columns, delimiters, format settings, etc will be saved into configuration and use for further export procedures. You can press ‘Finish’ button and export wizard window will automatically close or you can open CSV file, containing data clicking ‘Open directory containing result file’ or ‘Open result file’ options.



Export PrestaShop Category Structure to CSV Export FREE


Export Results

Export file, as the screenshot below demonstrates, keeps each category in separate row, lists all the details we have selected, like category name, ID, status, customer group, position and other.



Method #2 Export PrestaShop Categories With Products

This is another way of retrieving categories to CSV. Performing product export via Store Manager, you can export PrestaShop category(ies), each of the products is assigned to and see full category path in the file.


Detailed product export tutorial is available in this article – PrestaShop Export Products

To get full category paths in the file after export is done you need also consider the following settings


  • Enable ‘Export full category path’ option on ‘Export Options’ step of product export wizard.


  • If you do not enable this option, name if the categories, products are assigned to, will be exported only.

  • Select category field for export on ‘Select Fields to be Exported’ step.


  • Export Results

    Category paths are specified in corresponding ‘Category’ column for each product.


    Store Manager for PrestaShop offers you easy-to-use wizard tool for flawless PrestaShop export of all categories. Pull out categories and all related details to CSV in several simple steps.

    Export Categories FREE Export Now