ExcelPort 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
Structure of the sheet
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 IDs. 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 IDs. 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 IDs. See column E for allowed Layout IDs | 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.