Develop > Controller layer > Integrate with back-end systems and external applications > Controller commands

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.

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

Related concepts

Outbound messaging system

Related reference

Update_WCS_ProductPrice message

Update_NC_ProductPrice message

Product Price Update message

+

Search Tips   |   Advanced Search