Salesforce Docs Portal

CSV File Format for Importing Category Data for a B2B Commerce Store

When you construct a category import file, specify column headings that correspond to category path, URL slug, and category description information. Each row in the file represents a category and its structure. The column headings are case-insensitive, and the columns can be in any order.

Required Editions

View supported editions.

Which Salesforce Commerce Product Do I Have?

Column Heading Column Value
Category Description (Optional) The description of the category, corresponding to the Description field on the ProductCategory object. Put quotation marks around a category description value if it includes a comma.
Category Path

The path of the category, with / to delimit path segments. For example, the category path coffee/whole-bean creates the path store.com/category/coffee/whole-bean.

  • The last delimited value in the category path is used as the category name.
Slug <language code>

(Optional) The SEO-friendly URL slug for the category in a specified language.

  • In the column heading, specify a Salesforce-supported language code. For example, Slug en_US.

  • Use of the term Product2 isn’t allowed in a URL slug. This URL is reserved for use in your site.

URL slugs have a character limit of 150 and allow these characters: a-z A-Z 0-9 . - _ $ & : ; * , = @. Foreign language characters are also allowed.

See Also