File format for uploading price list data

The load file that you use to upload a price list must follow a specific format so that the data loads correctly into the WebSphere Commerce database tables. A sample CSV file is provided.

The following screen capture shows the data that is contained in a sample CSV file for price list data (the following image is split into two rows to improve readability):

In the CSV file:

The first row must contain the keyword Offer.
The second row must contain the column headings.
The remaining rows contain price list data for each catalog entry.

The keyword and column headers are case-sensitive.

After you create your CSV file, you can upload the file into WebSphere Commerce with the Catalog Filter and Pricing tool. An administrator can also use the Data Load utility to load price list data into WebSphere Commerce. When the utility finishes loading the data, the price list becomes available within the Catalog Filter and Pricing tool.

Note: When you are loading offers into a price list, you can include multiple offers for each catalog entry. For example, to load weekly prices for a catalog entry. Each price entry for a catalog entry must have a different identifier value to distinguish the multiple prices for each catalog entry. For example, if you are loading weekly catalog entry prices, set the identifier value to represent the week. You can set the identifier for the week that includes January 1 to have the identifier value '1' to indicate that the price is for the first week of the year. These identifiers ensure that a different offer exists for each price for the catalog entry. If there are not different identifier values, each price overwrites the previous price that has the same identifier for the same catalog entry. When you are loading multiple prices for a catalog entry, ensure that you also schedule the start and end dates so that each price follows one after the other.

Price list object keyword and column definitions

All price list uploads must use the object keyword Offer. You can download a sample CSV file here:

Offer.csv

The following are column definitions for price list CSV files:

PriceListUniqueId: (Optional, String) The identifier of the price list. When there is a data mapping for price list UniqueID in the price list data load configuration file, then the uniqueID is mandatory in the CSV file.
PriceListName: (Optional, String) The name of the price list that contains this offer. When you load an offer, you can provide either the PriceListName or the PriceListUniqueId, or both. If both of them are provided in the CSV file, the PriceListUniqueId is used to load. If neither of them are provided in the CSV file, the store's default price list name is used to load.
CatentryUniqueId: (Optional, String) The unique identifier of the catalog entry that this offer is for. When you load an offer, you must provide either the CatentryPartNumber or CatentryUniqueID. If both of them are provided in CSV file, the CatentryUniqueID is used to load. If neither of them are provided in the CSV file, the offer does not load.
CatentryPartNumber: (Optional, String) The part number of the catalog entry that this offer is for. When you load an offer, you must provide either the CatentryPartNumber or CatentryUniqueID. If both of them are provided in CSV file, the CatentryUniqueID is used to load. If neither of them are provided in the CSV file, the offer does not load.
Identifier: (Optional, Double) The number that uniquely identifies the offer when the value for the column is combined with unique catalog entry ID and price list ID values for the offer.
Precedence: (Optional, Double) When more than one offer is effective at a particular time, the one with the highest precedence is used. If the precedence value is not provided in the CSV file, the default value of 0.0 is used.
StartDate: (Optional, Timestamp) The start of the time range during which this offer is effective. Use this format: yyyy-mm-dd hh:mm:ss.millis
EndDate: (Optional, Timestamp) The end of the time range during which this offer is effective. Use this format: yyyy-mm-dd hh:mm:ss.millis
QuantityUnitIdentifier: (Optional, String) The unit of measure for Minimum Quantity and Maximum Quantity.
MinimumQuantity: (Optional, Double) The minimum quantity that can be purchased in a single order under this offer.
MaximumQuantity: (Optional, Double) The maximum quantity that can be purchased in a single order under this offer.
LastUpdate: (Optional, Timestamp) The last time that the offer is updated. Use the format yyyy-mm-dd hh:mm:ss.millis
Description: (Optional, String) The description for this offer.
PriceInUSD: (Optional, Decimal) The price in US Dollars.
PriceInBRL: (Optional, Decimal) The price in Brazilian Reais.
PriceInCAD: (Optional, Decimal) The price in Canadian dollars.
PriceInCNY: (Optional, Decimal) The price in Chinese Yuan Renminbi.
PriceInEUR: (Optional, Decimal) The price in Euros.
PriceInJPY: (Optional, Decimal) The price in Japanese Yen.
PriceInKRW: (Optional, Decimal) The price in (South) Korean Won.
PriceInTWD: (Optional, Decimal) The price in Taiwanese New Dollars.
Delete: (String) Indicates whether to delete this offer. The value 0 means do not delete. The value 1 means delete.