Offer price list input file

Use the Offer.csv input file to load a list of offer prices into a store so that they can be managed in the Catalog Filter and Pricing tool. The offer price is the price at which a store offers catalog entries for purchase. The offer price is the actual price customers must pay, before taxes, discounts, and shipping.

For a sample that uses this type of input file, see Sample: Loading offer price data into price lists.

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

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.
When you load offer prices into a price list, the load operation populates data into the following database tables:
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 required in the CSV file.
PriceListName

(Optional, String) The name of the price list that contains the offer prices. When you load offer prices, 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 the offer price 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.

If you are using a Data Load utility scheduled job to retrieve and load price data from IBM Omni-Channel Merchandising into a price list, do not include the CatentryUniqueId column in your input file. This value is unique to HCL Commerce and is ignored by the Data Load utility when the data from IBM Omni-Channel Merchandising is being loaded into WebSphere Commerce.

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.

If you are using a Data Load utility scheduled job to retrieve and load price data from IBM Omni-Channel Merchandising into a price list, you must include the CatentryPartNumber column in your input file. The Data Load utility uses this value to resolve the unique ID for the catalog entries when the data from IBM Omni-Channel Merchandising is being loaded into HCL Commerce.

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. Maps to the OFFER.IDENTIFIER database column.

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

(Optional, Timestamp) The start of the time range during which this offer is effective. Use the format: yyyy-mm-dd hh:mm:ss.millis

EndDate

(Optional, Timestamp) The end of the time range during which this offer is effective. Use the 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 the offer.

PriceIncurrency
(Optional, Decimal) The offer price for a specific currency. Replace currency with the appropriate currency code. For example, PriceInUSD, PriceInBRL, PriceInCAD.
Delete

(Optional, String) Indicates whether to delete an offer price. The value 0 means do not delete. The value 1 means delete.