The following cells need to be populated first and foremost, if creating new categories in bulk:
A1: action=add
B1: cid
The rest of the data that should be filled out is relevant to the headers listed with their definitions below:
title: title of the category
All values are acceptable for this field.
navdisplay: display the category on the storefront
0: category will be hidden
1: category will be displayed
navorder: the sequential order of the categories - the lower the number, the higher up the category tree it will be displayed
0: the first category
1: the second category
2: the third category
metadescription: category description including metadata
level: category level / hierarchy
1: 1st (top) level category
2: 2nd level category
3: 3rd level category
4: 4th level category
5: 5th level category
category1-5: database name for the category
The value for this field should be simplified as much as possible and should only contain alphanumerical characters and spaces. The values should be similar or the same as the title.
*Note: when creating 2nd, 3rd, 4th, or 5th level categories, you must populate the values for their parent categories as well.
Download file