Documentation Home

Category Import

Categories can be imported into the admin either directly into production or into a user sandbox for review. Categories can be imported using CSV file.

Adding vs Updating Categories

The externalId is the key to distinguish between Add and Update. If a row has an externalId that is already present, it will update the category with the information in that row.
If the externalId is not present, new category is created.

Default Import Specification and Fields

These are the fields defined by DefaultCategoryImportSpecification:

Column name Description Required
externalId Id given by you Yes
name Name of category Yes
defaultParentCategory Default parent. Can be Only One No
parentCategories Other possible parents. Can be multiple No
url Url for the category No
activeStartDate Date when category becomes active No

Example

Here is an example CSV for categories

externalId,defaultParentCategory,name,parentCategories
S1,,CategoryA1,
S2,,CategoryB2,
S3,,CategoryB3,
S4,,CategoryB4,
S5,,CategoryB5,
S6,S3,CategoryC6,S2|S4|S5
S7,S2,CategoryC7,S3|S4|S5