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 Kibo eCommerce tenant, import contacts before you import products.
As you work with this file, you will enter information about a single product across multiple sheets. Kibo eCommerce uses a combination of IDs, codes, names, and catalog information to make the proper data connections. For example, most sheets require a ProductCode to bind the data the sheet contains to the correct product.
Alternative: Postman Runner
For information about how to use Postman Runner to update products, product attributes, and sort product type attribute values instead of the Import/Export tool, see the following video tutorials:
- Using Postman Runner with Kibo APIs
- Postman Product Attribute Runner
- Using Postman to Sort Product Type Attribute Values
Access the Tools
With the Kibo eCommerce Import-Export Application installed and enabled, go to Main > Catalog > Import/Export in Kibo eCommerce 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. Some values are not required for an import, but are required Kibo eCommerce data. For example, you do not have to specify a customer's FirstName every time you modify the customer account, but all customer accounts require a FirstName when they are created. If you have questions or concerns specific to your data, please contact your integration partner or Kibo eCommerce Support.
| Information Provided for Each Sheet of the Template | |
|---|---|
| Corresponding REST API Resource | Every column in a sheet corresponds to a property in the Kibo eCommerce 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 in Kibo eCommerce 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 Kibo eCommerce 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 Kibo eCommerce Import/Export Tool only processes attributes with a namespace of Tenant. If you want to edit attributes in another namespace, you must use the Kibo eCommerce 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: SizeThis value corresponds to the Attribute Label in Admin. If you are creating a new attribute, Kibo eCommerce also uses this value 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:
YesNo must have a DataType of Bool.Product is only valid for an InputType of List. |
| Description | A text description for the attribute. This description is not exposed to customers or in Admin, and is typically left empty. | Any string. |
| Description | The description of the attribute as it appears in Admin. Depending on your theme, you can also make this description visible to customers on your storefront. | 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:
|
| 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. In Kibo eCommerce, 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. |
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:
|
| 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 in Kibo eCommerce 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 Kibo eCommerce 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 Kibo eCommerce Import/Export Tool only processes attributes with a namespace of Tenant. If you want to edit attributes in another namespace, you must use the Kibo eCommerce 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. |
ProductTypes
Corresponding REST API Resource: commerce/catalog/admin/attributedefinition/producttypes
Required With: ProductTypeAttributes, ProductTypeAttributeValues
In Kibo eCommerce, 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 in Kibo eCommerce 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:
|
| 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
In Kibo eCommerce, 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 Kibo eCommerce 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 in Kibo eCommerce 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, 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. |
| 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, 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." |
Categories
Corresponding REST API Resource: commerce/catalog/admin/categories
Required With: NA
Product categories group similar items so that you can display them together in sections on your site. Categories help you create faceted navigation for your customers. For example, Women's Apparel can be its own category as well as a parent category of Shirts, Pants, and Dresses. Categories map to catalogs, and you can define them on the master catalog or only on a specific sub-catalog. A single product can belong to multiple categories.
| 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 Kibo eCommerce 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. |
| CategoryDescription | The description of the category as it appears in Admin. Depending on your theme, you can also make this description visible to customers on your storefront. | Any string. |
| CategoryId | The unique, numeric identifier for the category. | Any number. This value must be unique among all categories on your site. |
| CategoryName | The name of the category. If IsDisplayed is Yes, this is the name that appears to customers on the storefront. | Any string. |
| CategoryType | The type of the category. | A string matching one of the following:
Note: You cannot change the CategoryType of an existing category. |
| Expression | The expression that controls the product membership of the dynamic category. This column only applies when CategoryType is DynamicPreComputed or DynamicRealTime. | A string that is a valid dynamic category expression. |
| IsDisplayed | Specifies whether the category is visible to customers on the storefront. | A Boolean value, specified as Yes or No. |
| MetaTagDescription | Maps to the HTML meta description tag, which is used by search engines to summarize the content of the page. | 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 Kibo eCommerce search implementation uses these keywords to help construct search results for pages on your storefront. | Any string. |
| MetaTagTitle | Maps to the HTML meta title tag. While most search engines place little value on this tag, most Kibo eCommerce 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. |
| PageTitle | By default, this value is not used by Kibo eCommerce. 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. |
| ParentCategoryCode | The category code that identifies the parent category of this category. If the category has multiple parents, create a new row to define each parent/child relationship, and ensure that all other values match between the rows. | A number that matches a valid category code. |
| 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. |
| Sequence | The order in which categories display on the storefront. This helps you order your top-level categories in navigation, and order how child categories display within a parent category. | Any number. Must be unique for categories on the same node. |
Category Images
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 Kibo eCommerce 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. |
| Locale Code | The locale code used to decide the language in which to display content. | An ISO locale code. for example, en-US.Currently, en-US is the only supported value. |
| 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
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.
When you export Products, the Kibo eCommerce 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. You use this code throughout Kibo eCommerce to refer to the product. | Any number that is unique among all product codes in the master catalog. |
| 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 |
| IsTaxable | Specifies whether the product is subject to taxation. The default is No. | A Boolean value, specified as Yes or No. |
| ManageStock | Specifies whether Kibo eCommerce tracks 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. Kibo eCommerce 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. Kibo eCommerce 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 Kibo eCommerce takes 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:
|
| 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, 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. |
| 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:
|
| 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 Kibo eCommerce 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 Kibo eCommerce 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. You use this code throughout Kibo eCommerce to refer to 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. |
| Attribute Name | The name of the attribute as it appears to customers. For example: SizeThis value corresponds to the Attribute Label in Admin. If you are creating a new attribute, Kibo eCommerce also uses this value for the Administration Name that Admin users see. | Any string. The string must be unique to a single attribute in the master catalog. |
| 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. |
ProductCatalog
Corresponding REST API Resource: commerce/catalog/admin/products
Required With: Products, ProductOptions, ProductExtras, ProductBundles, ProductImages, ProductPropertyLocale, ProductOptionsLocale
This sheet maps products to catalogs within a master catalog. The ProductCode and ProductName 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, have different prices and costs, use different SEO content, and so on.
| Column Name | Description | Valid Values |
|---|---|---|
| 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. |
| 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. |
| 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. |
| ContentFullProductDescription | The full description to display on the details page for the product. | Any string. HTML tags are supported. |
| 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. Kibo eCommerce 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. Kibo eCommerce 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. |
| 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. |
| ProductCode | The unique identifier for the product. You use this code throughout Kibo eCommerce to refer to 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. |
| ProductName | The name of the product. | Any string. This value must match the ProductName in the master catalog, or on Products sheet. |
| ProductShortDescription | A short 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. |
| 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. |
| 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 Kibo eCommerce 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 Kibo eCommerce 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. |
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. |
| 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. You use this code throughout Kibo eCommerce to refer to 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. |
| 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 |
| 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. You use this code throughout Kibo eCommerce to refer to 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. |
| 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. |
ProductOptionsLocale
Corresponding REST API Resource: commerce/catalog/admin/products
Required With: Products, ProductCatalog, ProductExtras, ProductBundles, ProductImages, ProductPropertyLocale
The sheet defines how options may differ across different locales.
| 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. You use this code throughout Kibo eCommerce to refer to 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. |
| 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. |
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 Kibo eCommerce 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. You use this code throughout Kibo eCommerce to refer to 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. |
| 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. |
| 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 a video file at a location accessible by Kibo eCommerce. Note: You can only associate external videos with Kibo eCommerce products. You cannot upload video files to the Kibo eCommerce CMS. | Any string that is a valid URL accessible by Kibo eCommerce. |
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 |
| 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. |
LocationInventory
Corresponding REST API Resource: commerce/catalog/admin/locationinventory
Required With: NA
This sheet describes inventory levels on a per-location basis. Locations in Kibo eCommerce 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. You use this code throughout Kibo eCommerce to refer to 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. |
| 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. |
| 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 Kibo eCommerce 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 Kibo eCommerce 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. |
| ImageUrl | The URL for the image file. For export operations, this is the file location in the Kibo eCommerce CMS. For import operations, this can be any URL that is accessible to Kibo eCommerce, such as a Dropbox URL. | Any string that is a valid URL accessible by Kibo eCommerce. |
| 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 |
Pricelists
Corresponding REST API Resource: commerce/catalog/admin/pricelists
This sheet describes high-level details about pricelists, such as which customer segments they apply to, what sites they are valid for, and whether they have parent lists. On import operations, use this sheet to create new price lists.
| Column Name | Description | Valid Values |
|---|---|---|
| Master Catalog Name | The name of the master catalog that includes the price list. | A string matching the name of the master catalog as it appears at System > Structure > Catalogs in Admin. |
| Price List Name | The name of the price list. | Any string. The maximum length is 100 characters. |
| PriceList Code | The code that uniquely identifies the price list in the master catalog. | Any string that is a valid price list code. Codes can be a maximum of 50 characters, and can contain only alphanumeric characters, hyphens, and underscores. |
| Created By | The unique identifier of the user that created the price list. | A 32-character GUID. This value is system-created and read-only. |
| Default for Sites | A list of sites for which you want the price list the default. The default price list will be in effect on a site if the resolution logic does not return any applicable price lists for the shopper, for example, if the shopper does not belong to any applicable customer segments. | A list of integers that are valid site IDs. Use commas to separate multiple site IDs. |
| Description | The description of the price list. | Any string. The maximum length is 300 characters. |
| Enabled | Specifies whether the price list is currently enabled. | A Boolean value, specified as Yes or No. The default is Yes. |
| Filtered In Storefront | Specifies whether to only display products in the storefront that have valid price list entries. If Yes, customers that belong to price lists will not see any products that do not have price list entries. | A Boolean value, specified as Yes or No. The default is No. |
| Indexed Sites | A list of sites for which you want the price list indexed. | A list of integers that are valid site IDs. Use commas to separate multiple site IDs. |
| Mapped Customer Segments | The list of customer segments associated with this price list, specified by segment code. | A list of strings that are valid customer segment codes. Use commas to separate multiple codes. |
| Parent PriceList Code | If the list has a parent list, the PriceList Code for the parent. | Any string that is a valid price list code. Codes can be a maximum of 50 characters, and can contain only alphanumeric characters, hyphens, and underscores. |
| Resolution Rank | Specifies the priority of the price list for situations when a customer segment maps to more than one price list. For example, a list with a Resolution Rank of 1 applies over a list with a Resolution Rank of 3. | Any integer. Warning: Be sure to use a unique Resolution Rank for every price list. Setting multiple price lists to the same Resolution Rank can cause unpredictable behavior. |
| Resolvable | Specifies whether customer segments can resolve to this price list. If no segments should ever resolve to this price list, such as if it is simply a parent for other price lists, you can improve performance by setting this value to No.For example, you might have a "B2B" price list that has sub-lists for each specific business partner. Logged in partners should resolve to their own price list, not to the master "B2B" list. In this situation, the partner lists are resolvable, but B2B is not. | A Boolean value, specified as Yes or No. The default is Yes. |
| Valid For All Sites | Specifies whether the price list is valid for all sites on your tenant. If No, you must specify Valid Sites. | A Boolean value, specified as Yes or No. The default is Yes. |
| Valid Sites | If Valid For All Sites is No, the site IDs for the sites on which the price list is valid. | A list of integers that are valid site IDs. Use commas to separate multiple site IDs. |
PricelistEntries
Corresponding REST API Resource: commerce/catalog/admin/pricelists/entries
This sheet describes price list entries. An entry ties a product in the master catalog to a price list in the same master catalog. To set a price list price, you must create an entry on this sheet and then specify the price for the entry on the PricelistEntryPrices sheet.
On import operations, use this sheet to add entries to a price list.
| Column Name | Description | Valid Values |
|---|---|---|
| Currency Code | The currency in which to show the price of the product. | Any three-character ISO currency code. For example, USD. |
| Master Catalog Name | The name of the master catalog that includes the price list and the product. | A string matching the name of the master catalog as it appears at System > Structure > Catalogs in Admin. |
| PriceList Code | The code that uniquely identifies the price list in the master catalog. | Any string that is a valid price list code. Codes can be a maximum of 50 characters, and can contain only alphanumeric characters, hyphens, and underscores. |
| Product Code | The code that uniquely identifies the product in the master catalog. | Any string that is a valid product code. Codes can be a maximum of 50 characters, and can contain only alphanumeric characters, hyphens, and underscores. |
| Start Date | The effective start date for the product to begin appearing in the price list. | A date and time in UTC format. If this value is empty and the End Date is set and has not yet passed, the product appears in the price list. |
| Cost | If Cost Mode is Overridden, specifies the value to use for the product cost in the price list. | Any decimal. |
| Cost Mode | Specifies the mode used to determine the cost for the product in the price list. | A string matching one of the following:
UseCatalog. |
| Created By | The unique identifier of the user that created the price list entry. | A 32-character GUID. This value is system-created and read-only. |
| Discounts Restricted | If Yes, specifies to restrict the use of discounts on the product when it appears as part of the price list. If the price list price is already discounted from the normal product price, you can use this field to prevent shoppers from applying additional discounts to the price list price. | A Boolean value, specified as Yes or No. The default is No |
| Discounts Restricted Mode | Specifies whether to use the default catalog setting for discount restriction, or to override the default catalog setting. | Either UseCatalog or Overriden. |
| DiscountsRestricted EndDate | If Discounts Restricted is Yes, specifies the end date for the restriction. | A date and time in UTC format. If DiscountsRestricted StartDate is specified and this value is empty, the restriction applies indefinitely. |
| DiscountsRestricted StartDate | If Discounts Restricted is Yes, specifies the start date for the restriction. | A date and time in UTC format. If this value is empty and the DiscountsRestricted EndDate is set and has not yet passed, the restriction applies. |
| End Date | The effective end date for the product's inclusion in the price list. | A date and time in UTC format. If this value is empty and no other limiting condition has been met, the product appears in the price list indefinitely. |
| Is Variation | Specifies whether the product in the price list entry is a product variant. | A Boolean value, either Yes or No. |
| Map | If Map Mode is Overridden, specifies the value to use for the product MAP price in the price list. | Any decimal. |
| Map EndDate | The effective end date for MAP pricing. Kibo eCommerce ignores the MAP value if this date has passed. | A date and time in UTC format. If Map StartDate is specified and this value is empty, the MAP price applies indefinitely. |
| Map Mode | Specifies the mode used to determine the MAP pricing for the product in the price list. | A string matching one of the following:
UseCatalog. |
| Map StartDate | The effective start date for MAP pricing. Kibo eCommerce 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 Map EndDate is set and has not yet passed, the MAP price applies. |
| Msrp | If Msrp Mode is Overridden, specifies the value to use for the product MSRP in the price list. | Any decimal. |
| Msrp Mode | Specifies the mode used to determine the MSRP for the product in the price list. | A string matching one of the following:
UseCatalog. |
| Option Summary | Shows a summary of the price list entry to help Admin users distinguish product variants. | Any string (Read-only). |
| PriceList Entry Mode | Specifies whether the current entry is a simple entry or a bulk pricing entry. If Bulk, you must specify a Minimum Quantity on the PricelistEntryPrices tab. | A string matching one of the following:
Simple. |
| Product Name | The name of the product as it appears in the master catalog and on the storefront. | Any string. |
PricelistEntryPrices
Corresponding REST API Resource: commerce/catalog/admin/pricelists/entries
This sheet describes prices to associate with various price list entries. On import operations, use this sheet to define the prices that appear for products in a price list.
| Column Name | Description | Valid Values |
|---|---|---|
| Currency Code | The currency to use for all product prices (list, sale, MSRP, and so on). | Any three-character ISO currency code. For example, USD. |
| Master Catalog Name | The name of the master catalog that includes the price list. | A string matching the name of the master catalog as it appears at System > Structure > Catalogs in Admin. |
| Minimum Quantity | The minimum quantity of the product a customer must purchase to get th. | Any integer. The default is 1. |
| PriceList Code | The code that uniquely identifies the price list in the master catalog. | Any string that is a valid price list code. Codes can be a maximum of 50 characters, and can contain only alphanumeric characters, hyphens, and underscores. |
| Product Code | The code that uniquely identifies the product in the master catalog. | Any string that is a valid product code. Codes can be a maximum of 50 characters, and can contain only alphanumeric characters, hyphens, and underscores. |
| Start Date | The effective start date for the product to begin appearing in the price list. | A date and time in UTC format. If this value is empty and the End Date is set and has not yet passed, the product appears in the price list. |
| ListPrice | If ListPrice Mode is Overridden, specifies the value to use for the list price in the price list. | Any decimal. |
| ListPrice Mode | Specifies the mode used to determine the list price for the product in the price list. | A string matching one of the following:
UseCatalog. |
| SalePrice | If SalePrice Mode is Overridden, specifies the value to use for the sale price in the price list. | Any decimal. |
| SalePriceMode | Specifies the mode used to determine the sale price for the product in the price list. | A string matching one of the following:
UseCatalog. |
PricelistEntryExtras
Corresponding REST API Resource: commerce/catalog/admin/pricelists/entries
This sheet describes extras to associate with various price list entries. On import operations, use this sheet to define the extras that appear for products in a price list.
| Column Name | Description | Valid Values |
|---|---|---|
| AttributeFQN | The fully qualified name (FQN) of the attribute in the master catalog. Usually a combination of tenant and the Attribute Code, for example tenant~optional-mount. | Any string. The string must be unique to a single attribute in the master catalog. |
| Currency Code | The currency to use for the extra price. | Any three-character ISO currency code. For example, USD. |
| Master Catalog Name | The name of the master catalog that includes the price list. | A string matching the name of the master catalog as it appears at System > Structure > Catalogs in Admin. |
| Price | Specifies the overridden price to use for the extra. | Any integer value, such as 1 or 3. |
| PriceList Code | The code that uniquely identifies the price list in the master catalog. | Any string that is a valid price list code. Codes can be a maximum of 50 characters, and can contain only alphanumeric characters, hyphens, and underscores. |
| Product Code | The code that uniquely identifies the product in the master catalog. | Any string that is a valid product code. Codes can be a maximum of 50 characters, and can contain only alphanumeric characters, hyphens, and underscores. |
| Start Date | The effective start date for the extra to begin appearing in the price list. | A date and time in UTC format. If this value is empty and the End Date is set and has not yet passed, the product appears in the price list. |
| 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. |
| Attribute Code | The unique code that identifies the attribute in the master catalog. | Any string. The string must be unique to a single attribute in the master catalog. |
| Attribute Name | The name of the attribute in the master catalog. | Any string. |
| Display Value | The display value of the extra as it appears on your storefront to shoppers. | Any string. |
SortDefinition
Corresponding REST API Resource: commerce/catalog/admin/productsortdefinitions
This sheet describes a sort definition to apply to the products in each category. On import operations, use this sheet to define the sorting that will be applied to the catalog.
| Column Name | Description | Valid Values |
|---|---|---|
| Catalog Name | The name of the catalog that this sort definition will be applied to. | A string matching the name of the catalog as it appears in Admin. |
| Category Code | A unique identifier for the relevant category within the catalog. | A string matching the code used in Admin. |
| Sort Definition ID | System or user-provided ID for the sort definition. | An integer matching the ID of the definition in Admin. |
| Sort Definition Name | A name for the sort definition being applied. | A string matching the name of the definition as it appears in Admin. |
| Start Date | The Start Date when the sort definition becomes active. | A DateTime-formatted value. |
| End Date | Optional end date for a product sort definition. | A DateTime-formatted value. |
| Primary Attribute | The name of the main attribute associated with these products. | Any string. |
| Primary Direction | Represents a product that is positioned out of its normal sort position. It can be boosted to the top of the list, positioned exactly or buried at the bottom. | A string, either "ASC" or "DESC." |
| Secondary Attribute | The name of a supporting attribute associated with these products. | Any string. |
| Secondary Direction | Represents a product that is positioned out of its normal sort position. It can be boosted to the top of the list, positioned exactly or buried at the bottom. | A string, either "ASC" or "DESC." |
ProductSortDefinition
Corresponding REST API Resource: commerce/catalog/admin/productsortdefinitions
This sheet describes product sort definitions with rankings to organize products in the category. On import operations, use this sheet to define the ranking position that will be applied to the products.
| Column Name | Description | Valid Values |
|---|---|---|
| Catalog Name | The name of the catalog that the product being ranked belongs to. | A string matching the name of the catalog as it appears in Admin. |
| Category Code | A unique identifier for the relevant category within the catalog. | A string matching the code used in Admin. |
| Sort Definition ID | The unique identifier of the sort definition being applied to the catalog. | An integer matching the ID of the definition in Admin. |
| Product Code | The unique, user-defined product code of a product, used throughout to reference and associate to a product. | A string matching the code used in Admin. |
| Position | The ranking of the line item in the sorted list of all category products. | An integer, 1 to 50 if the product is ranked and -1 if the product isn't ranked. |
| Locked | Denotes whether the product is locked in its rank or not. If locked, its ranking cannot be changed. See Visual Merchandising for more information. | A boolean value, 0 for false and 1 for true. |