Price Lists Template

The Price Lists template for the import/export tools describes price lists you have defined for specific customer segments. You can use price lists to offer specific pricing to authenticated customers who belong to specific customer segments.

Price Lists template file content with example data.

Access the Tools

With the Mozu Import-Export Application installed and enabled, go to Main > Catalog > Price Lists in Kibo eCommerce Admin. On the Price Lists page, click the Import/Export extension to the left of the Create New Price List button:

The Pricelists Import/Export button on the Price Lists page

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 Support.

Information Provided for Each Sheet of the Template
Corresponding REST API ResourceEvery 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 NameThe name of the column in the sheet.
DescriptionA description of the data a column contains.
Valid ValuesLists valid values for the column.

Sheets

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 NameDescriptionValid Values
Master Catalog NameThe 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 NameThe name of the price list.Any string. The maximum length is 100 characters.
PriceList CodeThe 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 ByThe unique identifier of the user that created the price list.A 32-character GUID. This value is system-created and read-only.
Default for SitesA 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.
DescriptionThe description of the price list.Any string. The maximum length is 300 characters.
EnabledSpecifies whether the price list is currently enabled.A Boolean value, specified as Yes or No. The default is Yes.
Filtered In StorefrontSpecifies 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 SitesA 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 SegmentsThe 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 CodeIf 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 RankSpecifies 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.
ResolvableSpecifies 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 SitesSpecifies 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 SitesIf 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 NameDescriptionValid Values
Currency CodeThe currency in which to show the price of the product.Any three-character ISO currency code. For example, USD.
Master Catalog NameThe 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 CodeThe 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 CodeThe 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 DateThe 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.
CostIf Cost Mode is Overridden, specifies the value to use for the product cost in the price list.Any decimal.
Cost ModeSpecifies the mode used to determine the cost for the product in the price list.A string matching one of the following:
  • UseCatalog—Use the cost from the product entry in the master catalog.
  • Overridden—Override the cost from the product entry with the cost specified in the Cost field.
The default is UseCatalog.
Created ByThe unique identifier of the user that created the price list entry.A 32-character GUID. This value is system-created and read-only.
Discounts RestrictedIf 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 ModeSpecifies whether to use the default catalog setting for discount restriction, or to override the default catalog setting.Either UseCatalog or Overriden.
DiscountsRestricted EndDateIf 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 StartDateIf 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 DateThe 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 VariationSpecifies whether the product in the price list entry is a product variant.A Boolean value, either Yes or No.
MapIf Map Mode is Overridden, specifies the value to use for the product MAP price in the price list.Any decimal.
Map EndDateThe 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 ModeSpecifies the mode used to determine the MAP pricing for the product in the price list.A string matching one of the following:
  • UseCatalog—Use the MAP pricing from the product entry in the master catalog.
  • Overridden—Override the MAP pricing from the product entry with the price specified in the Map field.
The default is UseCatalog.
Map StartDateThe 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.
MsrpIf Msrp Mode is Overridden, specifies the value to use for the product MSRP in the price list.Any decimal.
Msrp ModeSpecifies the mode used to determine the MSRP for the product in the price list.A string matching one of the following:
  • UseCatalog—Use the MSRP from the product entry in the master catalog.
  • Overridden—Override the MSRP from the product entry with the MSRP specified in the Msrp field.
The default is UseCatalog.
Option SummaryShows a summary of the price list entry to help Admin users distinguish product variants.Any string (Read-only).
PriceList Entry ModeSpecifies 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—The entry is a simple entry. Simple entries just map a product to a price.
  • Bulk—The entry is a bulk pricing entry. Bulk entries take the quantity of product ordered into account when determining the price to apply.
The default is Simple.
Product NameThe 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 NameDescriptionValid Values
Currency CodeThe currency to use for all product prices (list, sale, MSRP, and so on).Any three-character ISO currency code. For example, USD.
Master Catalog NameThe 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 QuantityThe minimum quantity of the product a customer must purchase to get the special pricing.Any integer. The default is 1.
PriceList CodeThe 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 CodeThe 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 DateThe 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.
ListPriceIf ListPrice Mode is Overridden, specifies the value to use for the list price in the price list.Any decimal.
ListPrice ModeSpecifies the mode used to determine the list price for the product in the price list.A string matching one of the following:
  • UseCatalog—Use the price from the product entry in the master catalog.
  • Overridden—Override the price from the product entry with the price specified in the ListPrice field.
The default is UseCatalog.
SalePriceIf SalePrice Mode is Overridden, specifies the value to use for the sale price in the price list.Any decimal.
SalePriceModeSpecifies the mode used to determine the sale price for the product in the price list.A string matching one of the following:
  • UseCatalog—Use the sale price from the product entry in the master catalog.
  • Overridden—Override the sale price from the product entry with the price specified in the SalePrice field.
The default is 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 NameDescriptionValid Values
AttributeFQNThe 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 CodeThe currency to use for the extra price.Any three-character ISO currency code. For example, USD.
Master Catalog NameThe 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.
PriceSpecifies the overridden price to use for the extra.Any integer value, such as 1 or 3.
PriceList CodeThe 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 CodeThe 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 DateThe 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.
ValueThe 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 CodeThe 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 NameThe name of the attribute in the master catalog.Any string.
Display ValueThe display value of the extra as it appears on your storefront to shoppers.Any string.