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

Related reference
Back-end integration legacy messages