Update_NC_ProductPrice message
The Update_NC_ProductPrice message is an inbound message that contains price information for a product. A back-end application generates this message and sends it to the WebSphere Commerce inbound message queue, where the WebSphere Commerce system receives the message. The system then invokes the ProductOfferPriceUpdate command which updates the OFFERPRICE table with the new price information.
The Update_NC_ProductPrice message uses the XML message format and follows Update_NC_ProductPrice_10.dtd.
The format and the source of the XML element values are described in the following table. For a description of the database column, follow the link to its associated table. All fields are optional unless otherwise noted. For database fields of type INT, the message element should be CHAR (12).
| Level | XML Element | Comment | Table Name | Column Name |
|---|---|---|---|---|
| 1 | ProductNumber ByMerchant | Mandatory | CATENTRY | PARTNUMBER |
| 2 | MerchantID | Mandatory | CATENTRY | MEMBER_ID |
| 3 | PriceGroupInfo | N/A | N/A | |
| 3.1 | Precedence | OFFER | PRECEDENCE | |
| 3.2 | Requisitioner GroupID | OFFER | TRADEPOSCN_ID | |
| 4 | Currency | Mandatory | OFFERPRICE | CURRENCY |
| 5 | ItemUnitPrice | OFFERPRICE | PRICE | |
| 6 | Start Timestamp | OFFER | STARTDATE | |
| 7 | End Timestamp | OFFER | ENDDATE | |
| 8 | PriceCustom Field | N/A | N/A | |
| 9 | UserData | N/A | N/A |