Develop > Controller layer > Integrate with back-end systems and external applications > Controller commands
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.
Related concepts
Related reference
Update_WCS_ProductPrice message