ProductOfferPriceUpdate command

The ProductOfferPriceUpdate command is used to update product price information for the Update_WCS_ProductPrice, Update_NC_ProductPrice, and Product Price Update messages.

Parameter values

offerId
The reference number that identifies the offer.
partNumber
The part number of the catalog entry as defined in the PARTNUMBER column of CATENTRY table.
memberId
The reference number that identifies the owner of the catalog entry.
catEntryId
The catalog entry offered for sale.
currency
Required: The ISO 4217 currency type in which the price is expressed.
offerPrice
The offer price to be used for this update.
precedence
The precedence to be used for this update.
tradingPositionContainerId
The TradingPositionContainer of which the offer is a part.
startDateTime
The start of the time range during which the Offer is effective.
endDateTime
The end of the time range during which the Offer is effective.
minimumQuantity
The minimum quantity that can be purchased in a single order under this offer.
maximumQuantity
The maximum quantity that can be purchased in a single order under this offer.
quantityUnit
The unit of measure for minimumQuantity and maximumQuantity.

Example


<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE Update_WCS_ProductPrice SYSTEM
'Update_WCS_ProductPrice_20.dtd'>
<Update_WCS_ProductPrice version='2.0'>
<ControlArea>
<Verb value='Update'></Verb>
<Noun value='WCS_ProductPrice'></Noun>
</ControlArea>
<DataArea>
<OfferPriceInfo>
<ProductNumberByMerchant>PART-I312200001</ProductNumberByMerchant>
<MerchantID>0</MerchantID>
<Precedence>1</Precedence>
<Currency>CAD</Currency>
<ItemUnitPrice>999.89</ItemUnitPrice>
<StartTimeStamp>20021209</StartTimeStamp>
<EndTimeStamp>2002-12-10</EndTimeStamp>
<MinimumQuantity>5</MinimumQuantity>
<MaximumQuantity>10</MaximumQuantity>
<Published>2</Published>
<PriceCustomField>Custom field</PriceCustomField>
</OfferPriceInfo>
</DataArea>
</Update_WCS_ProductPrice>

Behavior

  • The command updates a record in the OFFERPRICE table.
  • The process by which the primary key is determined varies slightly, depending on the format of the inbound message that executed the command. For a description of how the primary key is determined, refer to the specific inbound message.
  • If the precedence (PRECEDENCE) is not specified, then the ProductOfferPriceUpdate command locates all previous records that match the values that are given without the precedence. The maximum of these values is taken and incremented by one. If a previous record does not exist, then the precedence value is set to 1. A new row is inserted in the table OFFERPRICE with the new precedence value. The precedence value must be less than10>. If the maximum value is reached, then the new update is rejected.

Exception Conditions

  • The currency parameter is empty.
  • The offerId parameter value cannot be found in the OFFERPRICE table.
  • The catalog entry cannot be found using the memberId, which owns the store along with the partNumber.
  • The tradingPositionContainerId parameter value cannot be found in the OFFER table for the matching offerId.
  • The precedence parameter value exceeds the maximum value. The precedence must be less than 10>.