2.3. Export Categories


The Export Categories wizard will help you in exporting your Magento categories to a comma-separated values file (.csv), which can be opened in MS Excel, or other applications, for editing and, or, detailed analysis.

Export Magento Categories

To export Magento categories, follow these steps:

1. Import/Export Wizard

Go to Import/Export -> Import/Export Categories or click on the Import/Export button, in the Categories top toolbar.

2. Welcome

Select [Export], and click [Next >], to proceed.

Export Wizard

3. Export file name

Store Manager for Magento can export categories to a .csv file. Enter a new file name, select a previously stored one via the drop-down, or by clicking the ellipsis [...] button and browsing to make a new selection, from the directories on your local or remote system.

Export File Name

4. Select products to export

The following dialog will display a set of general export options.

Select Categories to Export
  • Select categories you'd like to export. The Default setting for this option is to export all categories from the current Magento store configuration. If you wish to export products only from the currently selected category, select the Only from the current category and its subcategories option. If you wish to export products only from a specific category, you'll need to make sure that particular category is open, before you run the Wizard.

  • Select store View to Export. At your choice, you may choose to include the default values option, which will restrict the export to only selected store view categories.

5. Select fields delimiter and quote character

The "Fields delimiter and quote character" dialog has several very important settings. Be sure to check them, to ensure proper configuration and accurate exporting of Magento categories.

Select Fields Delimeter and Quote Chatacter
  • "Delimiter Character". The typical delimiters are the comma (,), semicolon (;) and tab character ( ), however other symbols can be used as well. The resultant export file is usually generated for further processing, and subsequent re-importing, or import into another Store, or application.

  • "Quote string values with". This specifies the character used to separate strings in the CSV file.

  • "Category Delimiter". This is not a native .csv setting option in Magento, It is used only in Store Manager, to facilitate its operational functionality.

  • Categories are organized in a tree form, by which one category can contain one, or more, subcategories and each subcategory may contain one, or more, other categories. The category delimiter character is used to separate category names and to specify the full category tree path for a given product. A category path is very similar to a directory path and is used to specify the full qualified file name in Windows, in which every directory is separated by the backslash (\) character (i.e. C:\Program Files\eMagicOne\Store Manager for Magento\).

  • "Export images". You may select whether to also export the images, from a specified "image directory", on your local PC, along with your general data export. Note, that you must have the FTP connection accurately configured on the Settings-> Preferences -> FTP tab, prior to performing the export, for the operation to properly function.

6. Select fields to export

Select the fields you want to be exported:

Select Fields to Export
  • Enable "Export field names as the first row". It is often helpful to enable this feature, as it will facilitate accurate tracking of columns/data fields.

  • "Add attribute code to column name" (recommended for import). Check this option when you want to change the Target Column Name.

All available fields are listed in the left pane. Select the fields you want to be exported, and click the [>] button, to move them to the right pane. If you'd like to export all fields, press [>>].

Tip: The order in which columns will be saved in the .csv file can be changed. Move the exported columns up and down, using the corresponding buttons.

7. Preview Export

On the last page of Export Wizard, you will be able to preview the results of your selected choices and options.

Preview Export

You can save your export settings as a default, or save the settings into a named file, clicking on the [Save Settings to File] button.

This allows you to use configuration data in the following procedure of export categories in Magento.

Note! Upon pressing the [Export] button, the export process will begin. Also note that this process can take some time, depending upon the amount of data to be processed.

If you do not wish to perform any further operations, after saving your exported data, select the "Just close this window" option.

The Wizard will be closed, upon pressing the [Finish] button. If you want to automatically open the directory containing the results file, select the option in the "after export action" section.

This will open the exported file in Microsoft Excel, allowing for review, or further processing.