Magento – Export Categories

Import/Export categories wizard in Store Manager for Magento will help you in exporting your categories from Magento store to comma-separated values file (.csv) which can be easily opened in MS Excel or other application for detailed analysis.

To start Export Categories you need to click on button Magento Export.

  1. Select “Export” and click “Next >” to proceed.Magento Export Categories 1
  2. Store Manager for Magento can export categories to .csv file. You should enter the file name or select one to be replaced.Magneto Export Categories 2
  3. On the next page you can see some general options for “Magento Categories“.Magento Export Categories 3
    • Categories you’d like to export – Default setting for this option is to export all Magento categories at current Magento store. If you wish to Export products only from the category shown below, select Only from current category and it’s subcategories option. If you wish to export products only from specific category, you’ll need to make sure that category is open before you run the Wizard.
    • Select store View to Export: you can include default values of export only selected store view categories.
  4. Fields delimiter and quote character step has some important settings. Check them to ensure proper configuration to perform export of Magento categories.Magento Export 2
    • Delimiter Character. Most popular delimiters are comma (,), semicolon (;) and tab character ( ) however 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.
    • 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 full file name in Windows, where every directory separated by backslash (\) character like this one C:\Program Files\MagneticOne\Store Manager for X-Cart\.
    • Export images. You have to select whether to export images and their names and specify image directory on your local PC to export images. Note that you should configure FTP connection in Preferences -> FTP tab before export in order to be able to download images to your local PC.
  5. Select fields you want to be exported:Magento CategoriesEnable Export field names as first row if you need one.All available fields are listed in left pane. Select fields you want to be exported and click “>” button to move them to the right pane. If you’d like to export all fields simply press “>>”.

    Tip: The order in which columns will be saved in .csv file can be changed. To do this you can move exported columns up and down using corresponding buttons.

  6. Preview Magento Categories. On the last page of Export Wizard you can preview the result.Magento Categories 2Also you can save export settings or save export settings into file using Save Settings button. You can use them to save time while further Magento categories operations.
    Attention! When you press “Export” Button, export process will start! This process will take some time.

    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 and check Magento categories outcome.

    Read more Useful articles about Store Manager for Magento here

    Documentation for Store Manager for Magento is available here


    If you have any suggestions on Magento Export Categories you’re welcome to contact our support team.
 Previous Article
Next Article