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