CatalogEntryOfferPrice

Use the CatalogEntryOfferPrice keyword to load a catalog entry offer price into the WebSphere Commerce database.

Previously, you could load this data only in CSV formatted files. We can now load information in a CSV or XML formatted input file. Your input file must contain CSV column or XML element names and definitions that specify the characteristics of the business object type we are loading into the database.

CSV column and XML element definitions

PartNumber

(String) The part number of the catalog entry that this offer is defined for. When we are loading an offer, the CatalogEntryUniqueId or PartNumber is required. If both of them are provided in CSV file, the CatalogEntryUniqueId is used to load. The part number for a catalog entry displays in Management Center as the value for the catalog entry Code property.

CatalogEntryUniqueId

(String) The unique identifier for the catalog entry.

Price

(Decimal) The offer price of this catalog entry in the currency specified.

CurrencyCode

(String) The currency that is specified for the offer price. This code is a currency code that follows ISO 4217 standards.

Precedence

(Integer) The precedence of the offer. When more than one offer is effective at a particular time, the offer with the highest precedence is used.

StartDate

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

EndDate

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

MinimumQuantity

(Decimal) The minimum quantity that can be purchased in a single order under this offer.

MaximumQuantity

(Decimal) The maximum quantity that can be purchased in a single order under this offer.

QuantityUnit

(String) The unit of measurement for MinimumQuantity and MaximumQuantity. Default is 'C62'. C62 is the UN/CEFACT code that represents 'one'.

Description

(String) The language-specific description of the offer.

Language

(Integer) The language for language-specific fields (Description). For example:

• -1 for English.

• -2 for French.

Delete

(String) A flag that indicates whether to delete. Specify 1 to delete the row.

ListPrice

(Decimal) The list price of this catalog entry in the currency specified.