3. Export Categories

This section will help you in exporting your CubeCart categories to comma-separated values file (.csv) which can be easily opened in MS Excel or other application for editing.

To export CubeCart categories follow few steps:

  1. Go to Store -> Categories and Products, open Import/Export categories wizard and select Export.



    Also you can load export settings from file using Settings button or you can save settings on the last step of export wizard for future CubeCart category export.
  2. Store Manager can export categories to .csv file. You can enter any file name or select one to be replaced.



  3. On the next page you can see some general export options.


     
    Categories you'd like to export - Default setting for this option is to export all categories from current CubeCart store. If you wish to export subcategories only from the current category, highlighted in the list of categories, select "Only from current category and it's subcategories" option. Note that if you wish to export subcategories only from specific category, you'll need to make sure that category is highlighted before you run the wizard.
  4. Fields delimiter and quote character step has some important settings. Check them to ensure proper configuration.



    • 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, so the same delimiter should be used while import. Also if you have any troubles opening the result file in excel, try to use different delimiter and check how it goes.
    • Quote string values are used to separate strings in CSV file. It is recommended to enable the option if you have descriptions with any special symbols, commas and semicolons.
    • Category Delimiter. This is not native .csv setting, it is used by Store Manager only.
      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. 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\eMagicOne\Store Manager for CubeCart\.
    • Export images. You have to select whether to export images and their names and specify image directory on your local PC to download images to. Note that you should configure FTP connection in Preferences -> FTP tab in order to be able to download images to your local PC.
  5. Select fields you want to be exported:



    Enable Export field names as first row in order to see column headings in the exported file.
    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.
    Note:
    When you press "Export" Button, export process will start! This process will take some time.
    Also you can save export settings into file using Settings button in order to use them further.
  6. Preview Export. 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 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.

Now CubeCart category export is finished.

By eMagicOne Inc.

Comments