Price list input file

Use the Pricelist.csv input file to load price lists into a store so that they can be managed in the Catalog Filter and Pricing tool.

For a sample that uses this input file, see Sample: Loading price list data.

The following definitions are for loading only price lists. For more information about the data that you need to include in an input file to load prices into a price list, see Offer price list input file.

UniqueId

(Optional, String) The unique identifier of the price list. When there is a data mapping for price list unique ID in the price list data load configuration file, then the unique ID is required in the CSV file.

Name

(Optional String) The name of the price list. This name displays in the Price List - List page of the Catalog Filter and Pricing tool. This name also displays in price rules and price equations in which the price list is used. When you are loading a new price list, include the price list name. When you load updates for a price list, you can provide a value for either the Name or the Unique ID, or both. If both of them are provided in the CSV file, the Unique ID is used to load. If neither of them are provided in the CSV file, the default price list name for the store is used.

Description

(Optional, String) The text that explains what the price list contains and how the price list is used.

Precedence

(Optional, Double) The value that determines which price list takes precedence when more than one price list is effective at a particular time. The system uses the trading position container with the highest precedence value. If this column is null from the input file, then it is set to the default value of 0.0. The value maps to the OFFER.PRECEDENCE database column.

Note: The Precedence value is not used with price rules. For price rules, if you want to include multiple price lists within a price rule, you must use condition branches in the Catalog Filter and Pricing tool. When you use condition branches to add multiple price lists, the conditions determine the priority of the price lists. The precedence value for the price lists is ignored. If you do not use price rules and more than one price list (trading position container) can apply, the system uses the price list with the highest precedence.

Type

(Optional, String) The price list (Trading Position Container) type. You can set one of the following values:

S: Standard price list, which contains the base prices for products in a store catalog.
C: Custom price list, which specifies the customized prices for a list of products. If you want to create a custom price list, you need to edit the StoreCreationWizardRB.properties file and uncomment the line "priceListType=c".
E: External price list, which is imported from an external system. The price list specifies the customized prices for a list of products. When you use an external price list instead of a custom price list, only price list updates need to be passed to the server. The entire price list definition does not need to be passed to the server unlike custom price lists.

Delete

(String) Indicates whether to delete the price list. The value 0 means do not delete. The value 1 means delete.