Categories: Sheet Categories

Before you begin

This section describes the XLSX stucture for importing categories.

Follow these guidelines to properly structure your category file. To follow along, feel free to download an example file.

Important
  • This sheet is required for Category import.
  • All columns must be present in the order specified below.
  • Do not change/translate the names of the columns.
  • Allowed names for this sheet: Categories
  • Maximum number of rows: 800. More info here

Spreadsheet structure

To follow along, feel free to download an example file.

Column Letter Column Name Extra Info Allowed Values Required
A Category ID If you have an existing category in your store with this Category ID, it will be overwritten. If left empty, the category will be imported as a new category. Integer number
Minimum: -2147483647
Maximum: 2147483647
(Conditional)*
B Category Name Make sure to always provide a value for this field. Text Yes
C Description Text No
D Meta Tag Description Text No
E Meta Tag Keywords Text No
F Parent ID Insert only a single number here. Categories cannot have more than 1 parent.

If this value is left empty, the importer will assume 0.
Any existing Category ID in your store is a possible value. 0 is also allowed if this is the top-most category. No
G Stores Comma-separated Store ID's. Example: 0,1,2. Note that the default store has Store ID = 0.

If you leave this field without a value, the category will not be linked with any stores.
See Meta sheet, column C for allowed values. No
H Filters Comma-separated Filter ID's. Example: 10,42 See Meta sheet, column G for allowed values. No
I SEO Keyword Text No
J Image If your image file is placed in image/catalog/product/theimage.JPEG, insert catalog/product/theimage.JPEG (case-sensitive) Image path, relative to your image/ directory. The field is case-sensitive. No
K Top Any value different than "Yes" will be regarded as "No". Yes / No No
L Columns Integer number
Minimum: 0
Maximum: 2147483647
No
M Sort Order Integer number
Minimum: -2147483647
Maximum: 2147483647
No
N Status Any value different than "Enabled" will disable the product. Enabled / Disabled No
O Design Imagine you have a layout "Home" with ID 4. The ID of your default store is 0. To associate the category with the "Home" layout in the Default store, insert 0:4 as the value. A valid pair <Store ID>:<Layout ID>. See Meta sheet, column C for allowed Store ID's. See column E for allowed Layout ID's No
P Meta Title Not used in OpenCart 1.x. This is a required field in the standard OpenCart admin panel. However, ExcelPort will allow you to import categories without a meta title. Text (Conditional)*
Note* (Conditional) fields accept empty values for the purposes of an ExcelPort import. There are cases when you might need a value for this field. More information in column Extra Info.