Reference > Data load utility CSV column definitions
Catalog entry offer price
Use the CatalogEntryOfferPrice keyword to load a catalog entry offer price into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
CSV file column definitions
- PartNumber
- (String) The part number of the catalog entry that this offer is defined for. When loading an offer, the CatalogEntryUniqueId or PartNumber is mandatory. If both of them are provided in CSV file, the CatalogEntryUniqueId is used to load.
- 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 specified for the offer price. This is a currency code as per ISO 4217 standards. For a list of ISO currency codes, see ISO currency codes.
- 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. The default value is 'C62'. C62 is the UN/CEFACT code that represents 'one'.
- Description
- (String) The description of the offer. This field is language-sensitive.
- Language
- (Integer) The language for language-sensitive fields (Description). For example: -1 for English, -2 for French.
- Delete
- (String) Indicates whether to delete. If you are performing a delete operation, specify this column. A value of "1" indicates that the row should be deleted.