To import/export categories, go to Catalog > Categories from the Storefront module menu. Click on the Import or Export link.
When dealing with objects that have a parent hierarchy such as categories, it's recommended that you perform the import in 2 steps to avoid row not found errors. First, create a copy of your category import file. In one file, remove all the parent relationship (i.e. make the ParentCategoryID and ParentCategoryKey empty) and perform an import with the Act = i for insertion. This will import your categories as a flat structure. In your 2nd file that has the parent relationships (i.e. ParentCategoryID or ParentCategoryKey have values in them), perform an Act = u for bulk update to restore the relationship.
| Column |
Type |
Data required |
Description |
Example |
| Act |
String |
Yes |
Type of import action to perform (Insert = i, Update = u, Delete = d) |
u |
| CategoryID |
Integer |
Yes/No |
Database object identifier. This value is required when performing an update or delete action if the CategoryKey is not provided. |
12 |
| CategoryKey |
String |
Yes/No |
A unique key that can be used to uniquely identify this object. This could be a short meaningful text or simply a GUID. If you don't specify a value, the system will generate a unique key for you during insertion. This key can be used to lookup the object if the ProductCategoryID is not specified. |
business-finance |
| AvailabilityRule |
XML Rule |
No |
The rule to describe the conditions when the category can be shown. |
|
| CreateDate |
DateTime |
No |
|
|
| Description |
String |
No |
Category description. |
Buy the latest books |
| DisplayOrder |
Integer |
Yes |
Sort display order from smallest to largest number. |
1000 |
| DisplayTemplate |
String |
No |
Custom display template name. |
Custom12 |
| Extension |
XML |
No |
Extra data in XML string. |
<data><misc>True</misc></data> |
| MetaDescription |
String |
No |
Meta description. |
Popular books, magazines |
| MetaKeywords |
String |
No |
Meta keywords. |
Books, magazines |
| Name |
String |
Yes |
Category name. |
Books |
| PageTitle |
String |
No |
Page title. |
Popular books |
| ParentCategoryID |
Integer |
No |
For sub-category, reference to a parent object by its CategoryID. If you specify ParentCategoryID, the ParentCategoryKey will be ignored. |
10 |
| ParentCategoryKey |
String |
No |
For sub-category, reference to a parent object by its CategoryKey instead of its CategoryID. If you specify ParentCategoryID, the ParentCategoryKey will be ignored. |
business |
| Published |
Boolean |
Yes |
Enable display of the category. |
True |
| UrlName |
String |
No |
Name to appear in URL for SEO purposes. |
Popular books |
| UpdateDate |
DateTime |
No |
|
|