Catalogs Template - Kibo Documentation

The Catalogs template for the import/export tools is the largest of the import/export template files, and is likely the one you will use the most. Together, the sheets of the Catalogs template represent your entire catalog structure for all the sites on your tenant. You can use this template to add or update master catalogs, sub-catalogs, product types, product attributes and options, images, inventory, and discounts. If you are preparing your initial data import for a new tenant, import contacts before you import products. As you work with this file, you will enter information about a single product across multiple sheets. A a combination of IDs, codes, names, and catalog information are used to make the proper data connections. For example, most sheets require a ProductCode to bind the data the sheet contains to the correct product.

Catalogs template file content with example data

Access the Tools

With the Import-Export Application installed and enabled, go to Main > Catalog > Import/Export in the Admin.

Supported File Formats

CSV (.csv): Each sheet is a separate CSV file. For both imports and exports, sheets are compressed into a ZIP file. When importing, the ZIP file can have any file name but each individual CSV file name must match the export file name and the sheet. You can remove CSV files for data you do not want to import.

These CSV files should not be opened in Excel, as that may cause errors with their formatting. Instead, use a different CSV editing program to make changes to the data. You should only use the default Windows zipper to zip the files, as using different software may cause errors. You can upload multiple files at once as long as they all are zipped.

Template Key

For each sheet, we define each column and describe valid values for the column. If you have questions or concerns specific to your data, please contact your integration partner or Kibo Support.

Information Provided for Each Sheet of the Template
Corresponding REST API Resource	Every column in a sheet corresponds to a property in the REST API. For each sheet, we provide a link to any API resources that contain properties in the sheet.
Column Name	The name of the column in the sheet.
Description	A description of the data a column contains.
Valid Values	Lists valid values for the column.

Sheets

Attributes

Corresponding REST API Resource: commerce/catalog/admin/attributedefinition/attributes Required With: AttributeValues Product attributes are the variable properties that define a product. Attributes can be options (such as size or color), properties (such as the brand of the product), or extras (such as custom printing or warranties). Because many products share common attributes, you define general attributes before you apply them to specific products.

Column Name	Description	Valid Values
AttributeCode	The unique code that identifies the attribute. Once an attribute is created, you cannot change its AttributeCode.	Any string. The string must be unique to a single attribute in the master catalog.
MasterCatalogName	The name of the master catalog that includes the attribute. All attributes are defined on the master catalog level, and populate down to sub-catalogs within the master catalog.	A string matching the name of the master catalog as it appears at Settings > System Administration > Catalog and Site Structure in Admin.
Namespace	The namespace to which the attribute belongs. All attributes you create through Admin have a namespace of `Tenant`. Attributes that custom applications create through the API might have a custom namespace.	Any string that is a valid, registered namespace. If empty, the default is `Tenant`. Note: To avoid overwriting attributes created by custom applications, the Import/Export Tool only processes attributes with a namespace of `Tenant`. If you want to edit attributes in another namespace, you must use the API.
SearchableInAdmin	Specifies whether the attribute Value (specified on the AttributeValues sheet) is included in product search results in Admin. If an attribute has multiple values, this setting applies to all the values. The default is `No`.	A Boolean value, specified as `Yes` or `No`.
SearchableInStorefront	Specifies whether the attribute (specified on the AttributeValues sheet) is included in product search results on the public storefront. If an attribute has multiple values, this setting applies to all the values. The default is `No`.	A Boolean value, specified as `Yes` or `No`.
SearchDisplayValue	Specifies whether the display value or the canonical value of an attribute with a DataType of `String` is indexed for searching. If `Yes`, the system indexes the display value. If `No`, it indexes the canonical value. The default is `No`.	A Boolean value, specified as `Yes` or `No`. This value is ignored if the DataType of the attribute is anything other than `String`.
AttributeName	The name of the attribute as it appears to customers. For example: `Size` This value corresponds to the Attribute Label in Admin. If you are creating a new attribute, this value is used for the Administration Name that Admin users see.	Any string. The string must be unique to a single attribute in the master catalog.
DataType	The type of data the user must select or enter for the attribute.	A string matching one of the following: `String`, `Number`, `Bool`, `Product` Valid data types depend on the InputType. For example, an InputType of `YesNo` must have a DataType of `Bool`. `Product` is only valid for an InputType of `List`.
Description	A text description for the attribute.	Any string.
InputType	The format in which the attribute is displayed to customers. The best InputType to use often depends on whether the attribute is a Property, an Option, or an Extra. For example, a selectable Option, such as size or color, must be a `List`. An Extra, such as a monogram or custom print, is typically displayed as a `TextBox` or `TextArea`.	A string matching one of the following: `YesNo`, `Date`, `DateTime`, `List`, `TextBox`, `TextArea`
IsExtra	Specifies whether the attribute type is Extra. An Extra is an add-on configuration that the customer can select or configure, such as a monogram or warranty.	A Boolean value, specified as `Yes` or `No`. If IsExtra is `Yes`, IsOption and IsProperty must be `No`.
IsOption	Specifies whether the attribute type is Option. An Option is a product detail that a customer can select, such as size or color. Options generate product variations, which have unique product codes.	A Boolean value, specified as `Yes` or `No`. If IsOption is `Yes`, IsExtra and IsProperty must be `No`. If IsOption is `Yes`, InputType must be `List`.
IsProperty	Specifies whether the attribute type is Property. A Property is a product detail that a customer cannot configure, such as brand or material.	A Boolean value, specified as `Yes` or `No`. If IsProperty is `Yes`, IsExtra and IsOption must be `No`.
AvailableForOrderRouting	Specifies whether the attribute is enabled for use in routing filters through Extensible Order Routing.	A Boolean value, specified as `Yes` or `No`.
[ Locale ]	This sheet can include a series of columns for all supported locales, such as en-US and fr-CA. The values within this column will be the localized version of the attribute.	Any string or number.

AttributeValues

Corresponding REST API Resource: commerce/catalog/admin/attributedefinition/attributes Required With: Attributes Attribute values define what customers see for a given attribute. A single attribute can have multiple values. For example, if an attribute has an InputType of List in the Attributes sheet, every item in the list is a value of the attribute. Attribute values are mapped to attributes by the AttributeCode.

Column Name	Description	Valid Values
AttributeCode	A unique code that identifies the attribute to which the attribute value belongs. Once an attribute is created, you cannot change its AttributeCode.	Any string. The string must be unique to a single attribute in the master catalog.
DataType	The type of data the user must select or enter for the attribute value.	A string matching one of the following: `String`, `Number`
DisplayOrder	The order in which attribute values display within a product and in Admin.	Any unique number in a sequential order.
MasterCatalogName	The name of the master catalog that includes the attribute with which the value is associated. All attributes are defined on the master catalog level, and populate down to sub-catalogs within the master catalog.	A string matching the name of the master catalog as it appears at Settings > System Administration > Catalog and Site Structure in Admin.
Name	The name of the attribute value as it is displayed in Admin	A string or number. The value cannot contain spaces or special characters. You can use a hyphen (-) to escape spaces or characters.
Label	The description for the value in US English. This string defines how the Value appears to customers on the storefront and to users in Admin. Note: This column only appears when you have more than one language associated with your tenant.	Any string.
Namespace	The namespace to which the attribute values belongs. All attributes you create through Admin have a namespace of `Tenant`. Attributes that custom applications create through the API might have a custom namespace.	Any string that is a valid, registered namespace. If empty, the default is `Tenant`. Note: To avoid overwriting attributes created by custom applications, the Import/Export Tool only processes attributes with a namespace of `Tenant`. If you want to edit attributes in another namespace, you must use the API.
Value	The actual value for the attribute value. This is not the string that a customer sees, but rather the value as it appears in the Value column of the Values table for the attribute in `Admin`. This value must be unique within the vocabulary for a single attribute and match the DataType of the attribute. If an attribute has multiple values, each Value is specified on a separate row in this sheet.	A string or number. The value cannot contain spaces or special characters. You can use a hyphen (-) to escape spaces or characters.
[ Locale ]	This sheet can include a series of columns for all supported locales, such as en-US and fr-CA. The values within this column will be the localized value of the attribute.	Any string or number.

ProductContent

Corresponding REST API Resource: commerce/catalog/admin/products Required With: NA This template contains localized product and SEO content for locales other than the default master catalog locale. For more information about this catalog structure, see the Multi-Locale Catalogs documentation.

Column Name	Description	Valid Values
MasterCatalogName	The name of the master catalog that includes the product. Products are defined on the master catalog level. After you define a product in the master catalog, you can use the ProductCatalog sheet to add it to sub-catalogs.	A string matching the name of the master catalog as it appears at Settings > System Administration > Catalog and Site Structure in Admin.
ProductCode	The unique identifier for the product.	Any number that is unique among all product codes in the master catalog. Character limit: 3-30.
ContentLocaleCode	The locale code that you are localizing this content into.	An ISO locale code. for example, `en-US`.
ProductName	The name the customer sees for the product, in the language specified by the ContentLocaleCode.	Any string.
ProductShortDescription	A short (260 characters) description for the product. This value is typically used when the product is displayed in a list of search results.	Any string. Character limit: 260. HTML tags are supported, and are not counted in the description character limit.
ContentFullProductDescription	The full description to display on the details page for the product.	Any string. HTML tags are supported.
SEOMetaTagTitle	Maps to the HTML meta title tag. While most search engines place little value on this tag, most themes inject the value of the meta title tag into the HTML title tag. The HTML title tag is used by search engines and browsers to display the title of the page, and is critical to SEO. Search engines place very high importance on the correlation between a page’s title tag and its content.	Any string.
SEOMetaTagDescription	Maps to the HTML meta description tag, which is used by search engines to summarize the content of the page.	Any string.
SEOMetaTagKeywords	Maps to the HTML meta keywords tag, which is used to tell search engines what the page is about. From an SEO-perspective, search engines place little value on this tag, but the search implementation uses these keywords to help construct search results for pages on your storefront.	Any string.
SEOFriendlyURL	The default URL structure for products is `yourSite.com/{slug}/p/{productCode}` and for categories is `yourSite.com/{slug}/c/{categoryId}`. The slug (or SEO-friendly URL) gives you the ability to add a meaningful component to the URL structure in order to boost search results.	Any string.

ProductTypes

Corresponding REST API Resource: commerce/catalog/admin/attributedefinition/producttypes Required With: ProductTypeAttributes, ProductTypeAttributeValues A product type is a template of settings and attributes you create for a specific set of products. Every product in your catalog has a single product type associated with it. The ProductTypes sheet simply specifies the usage type(s) and master catalog for the product type. You specify details for product types on the ProductTypeAttributes and ProductTypeAttributeValues sheets. A single product type can support multiple usage types. For example, a shirt can be Configurable and a Component of a larger Bundle.

Column Name	Description	Valid Values
MasterCatalogName	The name of the master catalog that includes the product type. All product types are defined on the master catalog level, and populate down to sub-catalogs within the master catalog.	A string matching the name of the master catalog as it appears at Settings > System Administration > Catalog and Site Structure in Admin.
ProductType	The name of the product type. This name appears whenever a user is working with product types in Admin, so it should be meaningful and human-readable.	Any string.
Bundle	Specifies whether the product type supports the Bundle usage type. Bundles are collections of products sold as a single entity. For example, a suit Bundle can contain a shirt, pants, and a jacket.	A Boolean value, specified as `Yes` or `No`.
Component	Specifies whether the product type supports the Component usage type. Components can belong to Bundles. For example, a shirt can be a Component of a suit Bundle.	A Boolean value, specified as `Yes` or `No`.
Configurable	Specifies whether the product type supports the Configurable usage type. Configurable products allow the user to specify a product variation based on product options. For example, a shirt in size Small.	A Boolean value, specified as `Yes` or `No`.
GoodsType	The type of goods the product type contains. This value distinguishes between physical items, digital items, and digital store credits (such as gift cards). The default is `Physical`.	A string matching one of the following: `Physical`, `Digital`, `DigitalCredit`
Standard	Specifies whether the product type supports the Standard usage type. Standard products are not configurable and do not have variations.	A Boolean value, specified as `Yes` or `No`.

ProductTypeAttributes

Corresponding REST API Resource: commerce/catalog/admin/attributedefinition/producttypes Required With: ProductTypes, ProductTypeAttributeValues Attributes are linked to products at the product type level. The ProductTypeAttributes sheet ties the attributes you define on the Attributes and AttributeValues sheets to the product types you define in the ProductTypes sheet. You must define your attributes, either on the Attributes sheet or from the UI itself, before you can connect them to product types. Multiple product types can share the same attributes.

Column Name	Description	Valid Values
AttributeCode	The unique code that identifies the attribute.	Any string. This value must match the AttributeCode value on the Attributes sheet and be unique to a single attribute in the master catalog.
MasterCatalogName	The name of the master catalog that includes the product type. All product types are defined on the master catalog level, and populate down to sub-catalogs within the master catalog.	A string matching the name of the master catalog as it appears at Settings > System Administration > Catalog and Site Structure in Admin.
ProductType	The name of the product type.	Any string. This value must match the ProductType value on the ProductTypes sheet.
IsHiddenProperty	Specifies whether the attribute is hidden from customers on the storefront. This value only applies if Type is `Property`. The default is `No`.	A Boolean value, specified as `Yes` or `No`.
IsMultiValueProperty	Specifies whether the attribute can have more than one possible value for a single product. The default is `No`.	A Boolean value, specified as `Yes` or `No`.
IsRequiredByAdmin	Specifies whether the attribute is required on products of this product type in Admin. The default is `No`.	A Boolean value, specified as `Yes` or `No`.
Order	Specifies the order in which the attribute appears in a list of all attributes on the product type.	Any integer value, such as `1` or `3`.
Type	The type of the attribute.	A string matching one of the following: `Property`, `Option`, `Extra` The attribute type you specify must be enabled for the attribute. For example, if you set this Type to `Property`, the IsProperty column on the Attributes sheet must have a value of `Yes`.

ProductTypeAttributeValues

Corresponding REST API Resource: commerce/catalog/admin/attributedefinition/producttypes Required With: ProductTypes, ProductTypeAttributes The attribute values you specify for a given product type define what users and customers see for that product type. These values might differ from the values defined on the AttributeValues sheet. For example, your store might include a line of shirts that are only available in sizes Small, Medium, and Large. However, your Size attribute from the AttributeValues sheet has possible values of XS, S, M, L, and XL. You can still use your Size attribute for the shirts by giving them their own ProductType and only enabling the three relevant values for Size on this sheet.

Column Name	Description	Valid Values
AttributeCode	The unique code that identifies the attribute. This value must match the AttributeCode value on the Attributes and ProductTypeAttributes sheets.	Any string. The string must be unique to a single attribute in the master catalog.
MasterCatalogName	The name of the master catalog that includes the attribute. This value must match the MasterCatalogName value on the ProductTypes and ProductTypeAttributes sheets.	A string matching the name of the master catalog as it appears at Settings > System Administration > Catalog and Site Structure in Admin.
Order	Determines the order in which attributes are displayed on a product type. For instance, an attribute with three values should order them as 0, 1, and 2.	Any integer.
ProductType	The name of the product type. This value must match the ProductType value on the ProductTypes and ProductTypeAttributes sheets.	Any string.
Type	The type of the attribute.	A string matching one of the following: `Property`, `Option`, `Extra` The attribute type you specify must be enabled for the attribute. For example, if you set this Type to `Property`, the IsProperty column on the Attributes sheet must have a value of `Yes`.
VocabularyValue	The value the customer sees for the attribute, in the language specified by VocabularyValueLocaleCode. This value does not have to match a description from the AttributeValues sheet, but any new values you define here will only apply to this ProductType.	Any string. If empty, this value is inherited from values specified on the AttributeCode in the master catalog. You might see an entry on export of “Inherited from Base. Do not add values here.”

CategoriesContent

Corresponding REST API Resource: commerce/catalog/admin/categories Required With: NA This template contains localized category and SEO content for locales other than the default master catalog locale. For more information about this catalog structure, see the Multi-Locale Catalogs documentation.

Column Name	Description	Valid Values
CatalogName	The name of the catalog this category is mapped to. You can define catalogs on the ProductCatalog sheet.	A string matching any valid catalog name.
CategoryCode	The unique, alphanumeric identifier for the category. You use the CategoryCode to map categories to catalogs, discounts, and other categories. Note: This code does not have to map to the ID that the system generates for categories created in Admin. This code must simply be unique to the category and must match across all sheets that refer to the category.	A string or number. The value cannot contain spaces or special characters. You can use a hyphen (-) to separate string phrases.
ContentLocaleCode	The locale code that you are localizing this content into.	An ISO locale code. for example, `en-US`.
CategoryName	The name of the category, in the language specified by the ContentLocaleCode.	Any string.
MetaTagTitle	Maps to the HTML meta title tag. While most search engines place little value on this tag, most themes inject the value of the meta title tag into the HTML title tag. The HTML title tag is used by search engines and browsers to display the title of the page, and is critical to SEO. Search engines place very high importance on the correlation between a page’s title tag and its content.	Any string.
MetaTagDescription	Maps to the HTML meta description tag, which is used by search engines to summarize the content of the page.	Any string.
PageTitle	By default, this value is not used by the system. However, your theme developer has access to this value through a Hypr variable, so with minor theme changes, you can expose a different page title on your storefront than the title you supply for the meta title.	Any string.
CategoryDescription	The description of the category.	Any string.
MetaTagKeyWords	Maps to the HTML meta keywords tag, which is used to tell search engines what the page is about. From an SEO-perspective, search engines place little value on this tag, but the search implementation uses these keywords to help construct search results for pages on your storefront.	Any string.
SEOUrl	The default URL structure for products is `yourSite.com/{slug}/p/{productCode}` and for categories is `yourSite.com/{slug}/c/{categoryId}`. The slug (or SEO-friendly URL) gives you the ability to add a meaningful component to the URL structure in order to boost search results.	Any string.

CategoryImages

Corresponding REST API Resource: commerce/catalog/admin/categories Required With: NA Category images are the images associated to a product category. Images display with the category on the storefront depending on how you set up your theme. Each image includes a name, label, alt text, and other properties.

Column Name	Description	Valid Values
CatalogName	The name of the catalog of the category the image is mapped to. You can define catalogs on the ProductCatalog sheet.	A string matching any valid catalog name.
CategoryCode	The unique, alphanumeric identifier for the category the image is mapped to. You use the CategoryCode to map categories to catalogs, discounts, and other categories. Note: This code does not have to map to the ID that the system generates for categories created in Admin. This code must simply be unique to the category and must match across all sheets that refer to the category.	A string or number. The value cannot contain spaces or special characters. You can use a hyphen (-) to separate string phrases.
AltText	The text to display when a shopper hovers over an image or when an image does not render. This field is also useful for including SEO keywords.	Any string.
ImageLabel	The title of an image that can display on your storefront, depending on your theme.	Any string.
ImageName	The name of an image as it displays in Admin (for example, in File Manager). This name is not exposed to shoppers.	Any string.
LocaleCode	The locale code used to decide the language in which to display content.	An ISO locale code. for example, `en-US`.
Order	A number that determines what order images display in if they are assigned to the same category.	Any number. Must be unique for images in the same category.

Products

Corresponding REST API Resource: commerce/catalog/admin/products Required With: ProductCatalog, ProductOptions, ProductExtras, ProductBundles, ProductImages, ProductPropertyLocale, ProductOptionsLocale, ProductContent Once you have created attributes, product types, and categories, you can add products to your store. Do not try to add products to your store before building out the catalog infrastructure that the previous tabs describe. Your products will be missing required data and the import will not work. However, once your catalog infrastructure is set, you can fill out just the product-related sheets when you are adding or updating product data. This template contains product content for the default master catalog locale. To define localized product and SEO content used for other locales in multi-locale catalog setups, use the ProductContent sheet. When you export Products, the Import-Export Application provides a Filters pane that allows you to filter which products to export based on catalog, product name, product type, price range, and other properties.

Column Name	Description	Valid Values
MasterCatalogName	The name of the master catalog that includes the product. Products are defined on the master catalog level. After you define a product in the master catalog, you can use the ProductCatalog sheet to add it to sub-catalogs.	A string matching the name of the master catalog as it appears at Settings > System Administration > Catalog and Site Structure in Admin.
ProductCode	The unique identifier for the product.	Any number that is unique among all product codes in the master catalog. Character limit: 3-30.
CategoryCodes	A list of categories the product belongs to, specified using the relevant category codes.	Any list of strings composed of valid category codes, separated by a comma. For example, `CategoryA, Category B, Category C`.
ContentFullProductDescription	The full description to display on the details page for the product.	Any string. HTML tags are supported.
Cost	The cost of the product to the merchant.	Any decimal value.
DistributorPartNumber	The distributor’s part number for the product.	Any string.
FulfillmentTypes	The fulfillment types supported for shipping the product to customers.	A string matching one of the following: `DirectShip`, `InStorePickup`, `Digital` If multiple fulfillment types are supported, use an ampersand (&) to include additional types. For example: `DirectShip & InStorePickup`
IsTaxable	Specifies whether the product is subject to taxation. The default is `No`.	A Boolean value, specified as `Yes` or `No`.
ManageStock	Specifies whether to track inventory levels for the product. If you want to manage stock (recommended), you can use the LocationInventory sheet to set inventory levels for the product.	A Boolean value, specified as `Yes` or `No`.
ManufacturerPartNumber	The manufacturer’s part number for the product.	Any string.
MAP	The MAP, or minimum advertised price for the product, as specified by the product supplier. If MAP pricing is in effect, this value overrides all other prices you specify for the product. However, you can still apply a discount to a product with MAP pricing.	Any decimal value.
MAPEffectiveStartDate	The effective start date for MAP pricing. The system ignores the MAP value if this date is in the future.	A date and time in UTC format. If this value is empty and the MAPEffectiveEndDate is set and has not yet passed, the MAP price applies.
MAPEffectiveEndDate	The effective end date for MAP pricing. The system ignores the MAP value if this date has passed.	A date and time in UTC format. If MAPEffectiveStartDate is specified and this value is empty, the MAP price applies indefinitely.
MSRP	The manufacturers suggested retail price for the product.	Any decimal value.
OutOfStockBehavior	If ManageStock is `Yes`, specifies the action to take if the product is out of stock. You can display an out-of-stock message to the customer, allow the customer to back-order the product, or hide the product from the storefront.	A string matching one of the following: `DisplayMessage` (Default), `HideProduct`, `AllowBackorder`
PackageHeight	The height of the product when packaged, in imperial units (feet and inches). This value is used to calculate shipping costs.	Any decimal value.
PackageLength	The length of the product when packaged, in imperial units (feet and inches). This value is used to calculate shipping costs.	Any decimal value.
PackageWeight	The weight of the product when packaged, in imperial units (pounds and ounces). This value is used to calculate shipping costs.	Any decimal value.
PackageWidth	The width of the product when packaged, in imperial units (feet and inches). This value is used to calculate shipping costs.	Any decimal value.
Price	The unit price for the product if no sale or discount is applied.	Any decimal value.
ProductName	The name the customer sees for the product.	Any string.
ProductShortDescription	A short (260 characters) description for the product. This value is typically used when the product is displayed in a list of search results.	Any string. Character limit: 260. HTML tags are supported, and are not counted in the description character limit.
ProductType	The name of the product type associated with the product.	Any string that is a valid product type name. This value should match a ProductType on the ProductTypes sheet.
ProductUsage	The product usage type this product supports.	A string matching one of the following: `Standard`, `Configurable`, `Bundle`, `Component` The usage type you specify must be enabled for the product type on the ProductTypes sheet.
RestrictDiscount	Specifies whether discounts are restricted on the product. If `Yes`, the system cannot apply any discounts to the product.	A Boolean value, specified as `Yes` or `No`.
RestrictDiscountEndDate	If RestrictDiscount is `Yes`, specifies the end date for the restriction.	A date and time in UTC format. If RestrictDiscountStartDate is specified and this value is empty, the restriction applies indefinitely.
RestrictDiscountStartDate	If RestrictDiscount is `Yes`, specifies the start date for the restriction.	A date and time in UTC format. If this value is empty and the RestrictedDiscountEndDate is set and has not yet passed, the restriction applies.
SalePrice	The sale price for the product. If set, this value overrides the Price.	Any decimal value.
SEOFriendlyURL	The default URL structure for products is `yourSite.com/{slug}/p/{productCode}` and for categories is `yourSite.com/{slug}/c/{categoryId}`. The slug (or SEO-friendly URL) gives you the ability to add a meaningful component to the URL structure in order to boost search results.	Any string.
SEOMetaTagDescription	Maps to the HTML meta description tag, which is used by search engines to summarize the content of the page.	Any string.
SEOMetaTagKeywords	Maps to the HTML meta keywords tag, which is used to tell search engines what the page is about. From an SEO-perspective, search engines place little value on this tag, but the search implementation uses these keywords to help construct search results for pages on your storefront.	Any string.
SEOMetaTagTitle	Maps to the HTML meta title tag. While most search engines place little value on this tag, most themes inject the value of the meta title tag into the HTML title tag. The HTML title tag is used by search engines and browsers to display the title of the page, and is critical to SEO. Search engines place very high importance on the correlation between a page’s title tag and its content.	Any string.
UPC	The universal product code (UPC) for the product.	Any string. A valid UPC must be unique across all sales channels.
VariationPricingMethod	Specifies the pricing method for variations associated with the product, either relative to the base product through a delta, or by providing a explicit, fixed value for the variation.	One of two string values: `Delta` or `Fixed`.

ProductPropertyLocale

Corresponding REST API Resource: commerce/catalog/admin/products Required With: Products, ProductCatalog, ProductOptions, ProductExtras, ProductBundles, ProductImages, ProductOptionsLocale This sheet allows you to specify different product property values across locales.

Column Name	Description	Valid Values
MasterCatalogName	The name of the master catalog that includes the product property.	A string matching any valid master catalog name.
ProductCode	The unique identifier for the product the property is mapped to.	Any number that is unique among all product codes in the master catalog. This value must match the ProductCode in the master catalog, or on Products sheet. Character limit: 3-30.
Attribute Name	The name of the attribute as it appears to customers. For example: `Size` This value corresponds to the Attribute Label in Admin. If you are creating a new attribute, this value is used for the Administration Name that Admin users see.	Any string. The string must be unique to a single attribute in the master catalog.
AttributeCode	The unique identifier of the attribute as used by the system.	Any string that is a valid attribute code.
Value	The actual value for the attribute. This is not the string that a customer sees, but rather the value as it appears in the Value column of the Values table for the attribute in Admin. This value must be unique within the vocabulary for a single attribute and match the DataType of the attribute. If an attribute has multiple values, each Value is specified on a separate row in this sheet.	A string or number. The value cannot contain spaces or special characters. You can use a hyphen (-) to escape spaces or characters.
[ Locale ]	This sheet will include a series of columns for all relevant locales, such as en-US and fr-CA. The values within this column will be the localized label of the attribute.	Any string or number.

ProductCatalog

Corresponding REST API Resource: commerce/catalog/admin/products Required With: Products, ProductOptions, ProductExtras, ProductBundles, ProductImages, ProductPropertyLocale, ProductOptionsLocale This sheet maps product codes to catalogs within a master catalog. The ProductCode must match the product definition in the master catalog, or as specified on the Products sheet. All other data can differ from the master catalog. For example, in a specific sub-catalog, a product could belong to different categories or have different prices.

Column Name	Description	Valid Values
MasterCatalogName	The name of the master catalog that includes the product. Products are defined on the master catalog level. After you define a product in the master catalog, you can use the ProductCatalog sheet to add it to sub-catalogs.	A string matching the name of the master catalog as it appears at Settings > System Administration > Catalog and Site Structure in Admin.
CatalogName	The name of the catalog that includes the product. To add a product to multiple catalogs, create a new row for each catalog.	A string matching any valid catalog name. This should be a sub-catalog. Products are mapped to a master catalog when they are created, or on the Products sheet.
ProductCode	The unique identifier for the product.	Any number that is unique among all product codes in the master catalog. This value must match the ProductCode in the master catalog, or on Products sheet. Character limit: 3-30.
CategoryCodes	A list of categories the product belongs to, specfied using the relevant category codes.	Any list of strings composed of valid category codes, separated by a comma. For example, `CategoryA, Category B, Category C`.
IsActive	Specifies whether the product is active in the catalog. If `No`, the product is hidden from customers on the storefront.	A Boolean value, specified as `Yes` or `No`.
MAP	The MAP, or minimum advertised price for the product, as specified by the product supplier. If MAP pricing is in effect, this value overrides all other prices you specify for the product. However, you can still apply a discount to a product with MAP pricing.	Any decimal value. This value overrides the MAP on the Products sheet.
MAPEffectiveEndDate	The effective end date for MAP pricing. The system ignores the MAP value if this date has passed.	A date and time in UTC format. If MAPEffectiveStartDate is specified and this value is empty, the MAP price applies indefinitely. This value overrides the MAPEffectiveEndDate on the Products sheet.
MAPEffectiveStartDate	The effective start date for MAP pricing. The system ignores the MAP value if this date is in the future.	A date and time in UTC format. If this value is empty and the MAPEffectiveEndDate is set and has not yet passed, the MAP price applies. This value overrides the MAPEffectiveStartDate on the Products sheet.
MSRP	The manufacturers suggested retail price for the product.	Any decimal value. This value overrides the MSRP on the Products sheet.
IsPriceOverridden	Specifies that the price overrides the default master catalog price.	A Boolean value, specified as `Yes` or `No`.
IsContentOverridden	Specifies that the content overrides the default master catalog content.	A Boolean value, specified as `Yes` or `No`.
IsSEOOverridden	Specifies that the SEO data overrides the default master catalog SEO data.	A Boolean value, specified as `Yes` or `No`.
DateFirstAvailableInCatalog	The date the product either becomes or became first available in the catalog.	A string matching a `Date` or `DateTime`.
Price	The unit price for the product if no sale or discount is applied.	Any decimal value. This value overrides the Price on the Products sheet.
SalePrice	The sale price for the product. If set, this value overrides the Price.	Any decimal value. This value overrides the SalePrice on the Products sheet.

ProductBundles

Corresponding REST API Resource: commerce/catalog/admin/products Required With: Products, ProductCatalog, ProductOptions, ProductExtras, ProductImages, ProductPropertyLocale, ProductOptionsLocale This sheet defines products that are bundles, or collections of other products.

Column Name	Description	Valid Values
MasterCatalogName	The name of the master catalog that includes the product. Products are defined on the master catalog level. After you define a product in the master catalog, you can use the ProductCatalog sheet to add it to sub-catalogs.	A string matching the name of the master catalog as it appears at Settings > System Administration > Catalog and Site Structure in Admin.
ProductCode	The unique identifier for the product bundle. This is the code for the bundle itself, not for individual products in the bundle.	Any number that is unique among all product codes in the master catalog. This value must match the ProductCode in the master catalog, or on the Products sheet. Character limit: 3-30.
Code	The unique identifier for a product within the bundle. If the bundle contains multiple products, each component product Code is specified on a separate row in this sheet.	Any number that is unique among all product codes in the master catalog. This value must match a ProductCode in the master catalog, or on the Products sheet.
Name	The name of the bundle as it appears to customers on the storefront.	Any string.
Quantity	The quantity of the component product (specified by Code) that the bundle includes. For example, a phone bundle might include two chargers.	Any integer. The default is `1`.

ProductOptions

Corresponding REST API Resource: commerce/catalog/admin/products Required With: Products, ProductCatalog, ProductExtras, ProductBundles, ProductImages, ProductPropertyLocale, ProductOptionsLocale The sheet defines the options, such as different sizes or colors, that a customer can select for a product. Every product option creates a variation of the base product. Note that you must upload all possible combinations of a configurable product when updating values on variants, even if all possible variants are not enabled. In addition to the columns described in the following table, the ProductOptions sheet includes columns for all the attributes you create that can be options on a product (IsOption is Yes on the Attributes sheet).

Column Name	Description	Valid Values
MasterCatalogName	The name of the master catalog that includes the product.	A string matching the name of the master catalog as it appears at Settings > System Administration > Catalog and Site Structure in Admin.
ProductCode	The unique identifier for the base product.	Any number that is unique among all product codes in the master catalog. This value must match the ProductCode in the master catalog, or on the Products sheet. Character limit: 3-30.
VariationCode	The unique identifier for the variation of the product that includes this option.	Any string. For simplicity, this string is typically created by appending a hyphen and number to the ProductCode. For example, ProductCode `133188` can have a VariationCode of `133188-1`. Note: If you add a new option list to a product, you must create new variation codes for the product. For example, if you have a VariationCode that maps to a shirt in size Small, and you add an additional option from a different option list to indicate the shirt is also Blue, you must create a new VariationCode to represent the Small and Blue variation.
DistPartNo	The distributor’s part number for this specific product option.	Any string.
Enabled	Specifies whether the option is enabled for the product. If `No`, the option does not appear for customers to select. The default is `No`.	A Boolean value, specified as `Yes` or `No`. As a best practice, set this option to `No` only if a product option is permanently unavailable. Enable ManageStock on the Products sheet to handle a temporary inventory shortage.
ExtraCost	The additional cost the supplier charges for this option.	Any decimal value. This value has no impact on the price of the product.
ExtraPrice	The amount added to the base product price or sale price for this option. For example, you might charge an extra $5.00 for an unusual size.	Any decimal value.
ExtraWeight	The amount this option adds to the base package weight, in imperial units (pounds and ounces). This value is used to calculate shipping costs.	Any decimal value.
FixedListPrice	If the product is in Explicit pricing mode, this is the list price of the option.	Any decimal value. This value has no impact on the price of the product.
FixedSalePrice	If the product is in Explicit pricing mode, this is the sale price of the option.	Any decimal value. This value has no impact on the price of the product.
FixedWeight	If the product is in Explicit pricing mode, this is the weight of the option.	Any decimal value.
FulfillmentTypes	The fulfillment types supported for this option. This value overrides the fulfillment types on the base product.	A string matching one of the following: `DirectShip`, `InStorePickup`, `Digital` If multiple fulfillment types are supported, use an ampersand (&) to include additional types. For example: `DirectShip & InStorePickup`
MfgPartNo	The manufacturer’s part number for this specific product option.	Any string.
UPC	The universal product code (UPC) for this specific product option.	Any string. A valid UPC must be unique across all sales channels.

ProductExtras

Corresponding REST API Resource: commerce/catalog/admin/products Required With: Products, ProductCatalog, ProductOptions, ProductBundles, ProductImages, ProductPropertyLocale, ProductOptionsLocale This sheet defines the extras, such as monograms, warranties, and so on, that a customer can add to a product. Each product code can have multiple extras.

Column Name	Description	Valid Values
AttributeCode	The unique code for the attribute that defines the extra.	Any string. To be a valid extra, the attribute this code identifies must be enabled as an extra, or have IsExtra set to `Yes` on the Attributes sheet.
MasterCatalogName	The name of the master catalog that includes the product.	A string matching the name of the master catalog as it appears at Settings > System Administration > Catalog and Site Structure in Admin.
ProductCode	The unique identifier for the product.	Any number that is unique among all product codes in the master catalog. This value must match the ProductCode in the master catalog, or on the Products sheet. Character limit: 3-30.
Defaulted	Specifies whether the value for the extra is selected by default. If `Yes`, the customer cannot specify the value for the extra.	A Boolean value, specified as `Yes` or `No`.
MultiSelect	Specifies whether the customer can select more than one value from a predefined list for this extra.	A Boolean value, specified as `Yes` or `No`. For `Yes` to be valid, the attribute that defines the extra must have an InputType of `List`.
Quantity	Specifies a quantity of extras that the customer can select. For example, if a lamp is available with extra lamp shades, you can specify how many shades the customer can add to their order.	Any integer.
RequiredByShopper	Specifies whether the customer must select or specify the extra to purchase the product. For example, if you are selling a monogrammed towel, you can require the customer to enter the monogram. The default is `No`.	A Boolean value, specified as `Yes` or `No`.
Value	The value for the extra. This value must be a valid Value for the AttributeCode, as defined on the AttributeValues sheet.	A string or number. The value cannot contain spaces or special characters. You can use a hyphen (-) to escape spaces or characters.

ProductOptionLocalization

Column Name	Description	Valid Values
MasterCatalogName	The name of the master catalog that includes the product.	A string matching the name of the master catalog as it appears at Settings > System Administration > Catalog and Site Structure in Admin.
ProductCode	The unique identifier for the base product.	Any number that is unique among all product codes in the master catalog. This value must match the ProductCode in the master catalog, or on the Products sheet. Character limit: 3-30.
VariationCode	The unique identifier for the variation of the product that includes this option.	Any string. For simplicity, this string is typically created by appending a hyphen and number to the ProductCode. For example, ProductCode `133188` can have a VariationCode of `133188-1`. Note: If you add a new option list to a product, you must create new variation codes for the product. For example, if you have a VariationCode that maps to a shirt in size Small, and you add an additional option from a different option list to indicate the shirt is also Blue, you must create a new VariationCode to represent the Small and Blue variation.
Currency	The currency in which to show the price of the product.	Any three-character ISO currency code. For example, `USD`.
Extra Credit Value	The additional credit value for this digital gift card option in the locale.	Any decimal value.
Extra MSRP	The amount added to the MSRP price for this option in this locale.	Any decimal value.
Extra Price	The amount added to the base product price or sale price for this option in this locale.	Any decimal value.
Fixed List Price	The fixed list price of the product in this locale.	Any decimal value.
Fixed Sale Price	The fixed sale price of the product in this locale.	Any decimal value.

ProductImages

Corresponding REST API Resource: commerce/catalog/storefront/products Required With: Products, ProductCatalog, ProductOptions, ProductExtras, ProductBundles, ProductPropertyLocale, ProductOptionsLocale This sheet maps images and videos to product codes so you can use the media on the product pages of your storefront. A single product code can have multiple images and videos associated with it. For import operations, this sheet handles file-mapping only. Use the Images sheet to upload actual image files to the CMS.

Column Name	Description	Valid Values
MasterCatalogName	The name of the master catalog that includes the product.	A string matching the name of the master catalog as it appears at Settings > System Administration > Catalog and Site Structure in Admin.
ProductCode	The unique identifier for the product.	Any number that is unique among all product codes in the master catalog. This value must match the ProductCode in the master catalog, or on the Products sheet. Character limit: 3-30.
AltText	The plain text that appears when the customer hovers over the file, or that appears in place of the file if the file does not load.	Any alphanumeric string. This string should not include any special characters or HTML.
CmsId	The unique identifier for the file in your CMS.	Any string.
ImageUrl	The full URL path to an image file.	Any string that is a valid, accessible URL.
ImageLabel	The label for the image that appears on the storefront, in the language specified by the LocaleCode.	Any string.
Name	The filename, including type extension, of the image or video.	Any string that matches a valid image or video filename.
Sequence	For products with multiple images or videos, specifies where in the order or all image/video files the one in this row appears on the product page.	Any integer.
VideoUrl	The full URL path to an accessible video file. Note: You can only associate external videos, as you cannot upload video files to the CMS.	Any string that is a valid, accessible URL.
LocaleCode	The locale code that this image is used in.	Any string that is a valid locale (such as en-US).
ProductImageGroupId	The unique identifier for an image group that this file belongs to. This is currently export-only.	Any string.
ProductImageGroupTagFqn	The fully-qualified name of a tag for the image group tag, such as tenant~rom. This is currently export-only.	Any string.
ProductImageGroupTagValue	The value of the image group’s tag. This is currently export-only.	Any string.

LocationTypes

Corresponding REST API Resource: commerce/catalog/admin/locationtypes Required With: NA This sheet associates product codes with location types, which you use to manage the types of locations your tenant maintains, such as warehouses, physical storefronts, and kiosks.

Column Name	Description	Valid Values
LocationTypeCode	The unique identifier for the location type.	Any string that is a valid location type code for your tenant.
LocationTypeName	The name of the location type as it appears in Admin.	Any string.

Locations

Corresponding REST API Resource: commerce/catalog/admin/locations Required With: NA This sheet manages physical locations associated with a tenant, so you can specify the relevant addresses, shipment types, and inventory settings for each location.

Column Name	Description	Valid Values
LocationCode	The unique identifier for the location.	Any string that is a valid location code for your tenant.
LocationTypes	The location types that the location supports.	A list of strings of valid location types, separated by commas. For example, `Warehouse, Kiosk, RetailStore`.
Address1	Physical or mailing address line one. Usually includes the street number and street name or it could be a P.O. Box.	Any string up to 200 characters in length.
Address2	Physical or mailing address line two. Usually supplements the main street address with apartment, floor, suite, building, or unit information.	Any string up to 200 characters in length.
Address3	Physical or mailing address line three, if needed.	Any string up to 200 characters in length.
Address4	Physical or mailing address line four, if needed.	Any string up to 200 characters in length.
Address Type	The type of address.	Either `Commercial` or `Residential`.
AllowFulfillmentWithNoStock	Specifies whether you can fulfill an order when inventory is less than the quantity requested in the order.	A Boolean value, specified as `Yes` or `No`. For this value to take effect, you must set `SupportsInventory` to `Yes`.
CityOrTown	The city or town for the location address.	Any string.
CountryCode	The 2-letter geographic code representing the country for the physical or mailing address.	Currently limited to `US`.
Description	The description of the location as it appears to Admin users.	Any string.
Fax	The fax number associated with the location.	A formatted fax number, such as `512-555-5555`.
FulfillmentTypes	The fulfillment types supported at this location.	A string matching one of the following: `DirectShip`, `InStorePickup`, `Digital` If multiple fulfillment types are supported, use an ampersand (&) to include additional types. For example: `DirectShip & InStorePickup`
Hours of operation - Friday	The Friday business hours for the location.	Any string that describes your operating hours. For example, `8a-3p`, `10:30 AM - 7:30 PM`, or `Closed`.
Hours of operation - Monday	The Monday business hours for the location.	Any string that describes your operating hours. For example, `8a-3p`, `10:30 AM - 7:30 PM`, or `Closed`.
Hours of operation - Saturday	The Saturday business hours for the location.	Any string that describes your operating hours. For example, `8a-3p`, `10:30 AM - 7:30 PM`, or `Closed`.
Hours of operation - Sunday	The Sunday business hours for the location.	Any string that describes your operating hours. For example, `8a-3p`, `10:30 AM - 7:30 PM`, or `Closed`.
Hours of operation - Thursday	The Thursday business hours for the location.	Any string that describes your operating hours. For example, `8a-3p`, `10:30 AM - 7:30 PM`, or `Closed`.
Hours of operation - Tuesday	The Tuesday business hours for the location.	Any string that describes your operating hours. For example, `8a-3p`, `10:30 AM - 7:30 PM`, or `Closed`.
Hours of operation - Wednesday	The Wednesday business hours for the location.	Any string that describes your operating hours. For example, `8a-3p`, `10:30 AM - 7:30 PM`, or `Closed`.
Last Modified Date	The last time the location was updated.	A date in UTC format.
Latitude	The location latitude in degrees.	A decimal number representing the latitude.
Longitude	The location longitude in degrees.	A decimal number representing the longitude.
Name	The name of the location, used for identification purposes, as it appears to Admin users.	Any string.
Notes	General comments associated with the location that are only visible to Admin users.	Any string.
Phone	The phone number associated with the location.	A formatted phone number, such as `512-555-5555`.
PostalOrZipCode	The zip or postal code of the location address.	A number representing the zip or postal code.
Shipping Contact OrganizationOrCompany	The company name used to assemble contact details for the location.	Any string.
Shipping Contact Email	The email used to assemble contact details for the location.	Any string.
Shipping Contact FirstName	The first name used to assemble contact details for the location.	Any string.
Shipping Contact LastNameOrSurname	The last name used to assemble contact details for the location.	Any string.
Shipping Contact MiddleNameOrInitial	The middle name or initial used to assemble contact details for the location.	Any string.
Shipping Contact PhoneNumber	The phone number used to assemble contact details for the location.	Any string.
StateOrProvince	The state or province of the location address.	Any string.
Status	Specifies whether the location is enabled.	Either `Active` or `Disabled`.
SupportsInventory	Specifies whether the location maintains product inventory. If thel location supports the direct ship fulfillment type, it must also support inventory.	A Boolean value, specified as `Yes` or `No`.
Tags	A list of tags associated with the location.	Any string.

LocationGroup

Corresponding REST API Resource: commerce/catalog/admin/locationgroups This sheet describes location groups on a per-location basis.

Column Name	Description	Valid Values
LocationGroupCode	The unique identifier for the location group.	Any string.
Name	The name of the location group.	Any string.
LocationCodes	A list of unique identifiers for each location that belongs to the group.	Strings that are valid location codes.
SiteIds	A list of unique identifiers for each site that this location group is used within.	Strings that are valid Site IDs.
Last Modified Date	The last time the location was updated.	A date in UTC format.

LocationGroupConfiguration

Corresponding REST API Resource: commerce/catalog/admin/locationgroupconfiguration This sheet describes location group configurations on a per-location basis.

Column Name	Description	Valid Values
LocationGroupCode	The unique identifier for the location group.	Any string that is a valid location group.
Customer Failed To Pickup After Action	The behavior that should be taken to handle a shipment that has not been picked up by the customer after a deadline.	A string that is a valid after-action in location group configurations, such as “Customer Care.”
Customer Failed To Pickup Deadline	The number of days without pickup at which point after-actions are performed for a BOPIS shipment.	Any integer.
Send Customer Pickup Reminder	The length of time at which point a reminder is sent to the customer after a shipment has begun awaiting Customer Pickup.	A string that is a valid options in location group configurations, such as “2 days”
Default Carrier	The default shipping carrier used by locations in this group.	A string that matches a valid shipping carrier.
Print Return Label	Indicates whether return labels are printed alongside shipping labels or not.	A Boolean value, specified as `Yes` or `No`.
Default Printer Type	The type of printer that shipping labels are printed on by default.	A string for a valid printer type such as “Laser.”
Last Modified Date	The last time the location was updated.	A date in UTC format.

LocationGroupConfigurationBoxType

Corresponding REST API Resource: commerce/catalog/admin/locationgroupconfiguration This sheet describes location group box type configurations on a per-location basis.

Column Name	Description	Valid Values
LocationGroupCode	The unique identifier for the location group.	Any string that is a valid location group.
Name	The name of the box type.	Any string.
Height	The height of the package dimensions.	Any decimal.
Length	The length of the package dimensions.	Any decimal.
Width	The width of the package dimensions.	Any decimal.

LocationGroupConfigurationCarrier

Corresponding REST API Resource: commerce/catalog/admin/locationgroupconfiguration Required With: NA This sheet describes location group carrier configurations on a per-location basis.

Column Name	Description	Valid Values
LocationGroupCode	The unique identifier for the location group.	Any string that is a valid location group.
SiteId	A unique identifiers for the site that this location group is being configured for.	Any string that is a valid Site Id.
CarrierType	The carrier type being configured.	Any string that is a valid carrier.
isEnabled	Indicates whether this carrier is enabled for the location group or not.	A Boolean value, specified as `Yes` or `No`.
Enable Smart Post	Indicates whether to enable Smart Post for this carrier or not.	A Boolean value, specified as `Yes` or `No`.
Express 1 Day Default	The service type that this carrier uses as its default 1 Day shipping option.	Any string that is a valid shipping method code.
Express 2 Day Default	The service type that this carrier uses as its default 2 Day shipping option.	Any string that is a valid shipping method code.
Express 3 Day Default	The service type that this carrier uses as its default 3 Day shipping option.	Any string that is a valid shipping method code.
Return Label Shipping Method	The type of shipping method that is associated with return labels.	Any string that is a valid shipping method code.
Shipping Methods	All shipping methods supported by this carrier.	A list of strings that are valid shipping method codes.
Standard Default	The service type that this carrier uses as its default standard shipping option.	Any string that is a valid shipping method code.

LocationInventory

Corresponding REST API Resource: commerce/catalog/admin/locationinventory Required With: NA This sheet describes inventory levels on a per-location basis. Locations can be either warehouses or brick and mortar businesses with stock on-hand. This sheet associates product codes and quantities with the locations. You cannot use this sheet to create locations. Use the Locations sheet before you try to import new or updated inventory.

Column Name	Description	Valid Values
MasterCatalogName	The name of the master catalog that includes the product.	A string matching the name of the master catalog as it appears at Settings > System Administration > Catalog and Site Structure in Admin.
ProductCode	The unique identifier for the product.	Any number that is unique among all product codes in the master catalog. This value must match the ProductCode in the master catalog, or on the Products sheet. The product also must have ManageStock set to `Yes` on the Products sheet. Character limit: 3-30.
LocationCode	The unique identifier for the location that has the inventory. You specify this code when you create the location.	Any string that is a valid location code for your tenant.
ParentProductCode	The unique identifier for the parent product, if applicable.	Any string that is a valid product code. Character limit: 3-30.
StockAvailable	The quantity of stock of the ProductCode that is available at this location. This value may differ from the StockOnHand if orders are pending. This value is read-only, and is determined based on the number of pending product reservations.	Any integer. (Read-Only)
StockOnBackOrder	The quantity of stock of the ProductCode that is on back order (or reserved) at this location. This value is read-only, and is determined based on the number of pending product reservations.	Any integer. (Read-Only)
StockOnHand	The quantity of stock of the ProductCode that is on-hand and available at this location.	Any integer.
StockUpdateOption	Specifies whether the stock numbers are updated when purchases complete or new inventory is received.	A Boolean value, specified as `Yes` or `No`.

Images

Corresponding REST API Resources: commerce/catalog/storefront/products, commerce/catalog/storefront/categories, content/documentlists/documents Required With: NA This sheet describes all the image files that exist in the database for your tenant. You can use this sheet independent of other sheets to upload new images to your tenant. Use the ProductImages and Categories sheets to associate images with specific products or categories. Because images can be large files, uploading them can add significant time to an import operation. If you are updating products and know that you do not need to add or change media, clear this sheet prior to importing the file.

Column Name	Description	Valid Values
MasterCatalogName	The name of the master catalog that includes the product or category with which the image is associated.	A string matching the name of the master catalog as it appears at Settings > System Administration > Catalog and Site Structure in Admin.
Id	The document identifier for the image in the CMS. You do not need to provide this value for imports unless you are moving an existing image from one tenant to another and you want the image to retain the same ID.	A 32 character, case-insensitive, alphanumeric string. You can specify the ID as 32 sequential characters or as groups separated by dashes in the format 8-4-4-4-12. For example: `bba0a1a885e2413bb097ceacf7bac366` or `bba0a1a8-85e2-413b-b097-ceacf7bac366`.
Path	The URL for the image file. For export operations, this is the file location in the CMS. For import operations, this can be any URL that is accessible, such as a Dropbox URL.	Any string that is a valid, accessible URL.
Name	The filename, including type extension, of the image.	Any string that matches a valid image filename.
Tags	Tags associated with the image. These tags appear in the File Manager in `Admin`. You can use them to group and filter your files in Admin.	Any string. You can use commas to separate multiple tags. For example: `shoes, wedges`

​Access the Tools

​Supported File Formats

​Template Key

​Sheets

​Attributes

​AttributeValues

​ProductContent

​ProductTypes

​ProductTypeAttributes

​ProductTypeAttributeValues

​CategoriesContent

​Categories

​CategoryImages

​Products

​ProductPropertyLocale

​ProductCatalog

​ProductBundles

​ProductOptions

​ProductExtras

​ProductOptionLocalization

​ProductImages

​LocationTypes

​Locations

​LocationGroup

​LocationGroupConfiguration

​LocationGroupConfigurationBoxType

​LocationGroupConfigurationCarrier

​LocationInventory

​Images