Importing Product Categories

To import product categories, go to "Settings > Product Category Configuration" and select the "Import Product Categories" link in the "Product Category Tools" panel as shown below.

The "Download Template" link to the right of "Import Categories" link provides a spreadsheet template for providing the product category information along with instructions.

This will bring up a four-step wizard that walks the user thru the import process. In this first step, select an option from a data source mapping method. If this is the first time you are importing data, choose "Custom" . If a previous mapping exists under "My Saved Sources" , then you may select that if the mapping has not changed. Click the "Next" button.

Note: If the header row or the columns of the CSV file are changed, the saved mappings will need to be mapped again.

In the next step, select the import file by clicking the "Browse" button. Check the "Has Header" checkbox if the import file has a header line that identifies the data fields in the file. Click the "Next" button to go to the next step.

The next step involves mapping each field in the file to the corresponding field in this application's product category database. Select the relevant fields that can be mapped. If this a mapping that you plan to use again, save it using the "Save as Custom Mapping" check box and a name. Then click "Import Now" button.

An example mapping of the data fields is shown above.

Reimporting Categories:

  • Importing of product categories that already exist in the system (as identified by their name) will replace all the attributes in the system for that product category with the ones imported thru the file.