ProductListPriceUpdate command

The ProductListPriceUpdate command is used to update product price information for the Update_WCS_ProductPrice XML message. The command is used to update information in the WebSphere Commerce database regarding the listed price of a product.

Parameter values

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.

listPrice

The product list price used to update the LISTPRICE table.

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>
<ListPriceInfo>
<ProductNumberByMerchant>PART-I312200001</ProductNumberByMerchant>
<MerchantID>0</MerchantID>
<Currency>CAD</Currency>
<ItemUnitPrice>999.89</ItemUnitPrice>
</ListPriceInfo>
</DataArea>
</Update_WCS_ProductPrice>

Behavior

• The command updates a record in the LISTPRICE table.

• The partNumber, together with memberId are used to get the catalog entry key (CATENTRY_ID in table CATENTRY).

• If the catalog entry matches an existing one in the LISTPRICE table, but the currency type does not match a currency type for any record for that catalog entry, a new record is created in the LISTPRICE table. This allows us to specify prices in different currencies for the same catalog entry.

Exception Conditions

• The currency parameter is empty.

• The catalog entry cannot be found using the memberId, which owns the store along with the partNumber.

Related concepts
Outbound messaging system

Related reference
Update_WCS_ProductPrice message
Product Price Update message