Update_WCS_ProductInventory message

Update_WCS_ProductInventory message

The Update_WCS_ProductInventory message is an inbound message that contains inventory 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. WebSphere Commerce updates the INVENTORY table with the new inventory information.
The Update_WCS_ProductInventory message uses the XML message format and follows Update_WCS_ProductInventory_20.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. Fields are optional unless otherwise noted. The tag value length in the XML message for database fields of type INT, BIGINT and DOUBLE should be CHAR (10), CHAR(19), and CHAR(16) respectively.

Level XML Element Comment Table Name Column Name Note
1 ProductNumber ByMerchant Mandatory (see note) INVENTORY CATENTRY_ID Mandatory only when ProductSKU is not used. This attribute should not be used when ProductSKU is used.
2 MerchantID Mandatory INVENTORY STORE_ID
3 Quantity Mandatory INVENTORY QUANTITY
4 UserData N/A N/A
5 FulfillmentCenterID INVENTORY FFMCENTER_ID
6 ProductSKU Mandatory (see note) CATENTRY PARTNUMBER Mandatory only when ProductNumberByMerchant is not used. This attribute should not be used when ProductNumberByMerchant is used.

Behavior:

The WebSphere Commerce product reference number (which references CATENTRY_ID in the INVENTORY table) and the merchant reference number (STORE_ID) are used to update a row in the INVENTORY table.
If the row in the table INVENTORY does not exist, an exception occurs.

Related reference
Back-end integration legacy messages

Level	XML Element	Comment	Table Name	Column Name	Note
1	ProductNumber ByMerchant	Mandatory (see note)	INVENTORY	CATENTRY_ID	Mandatory only when ProductSKU is not used. This attribute should not be used when ProductSKU is used.
2	MerchantID	Mandatory	INVENTORY	STORE_ID
3	Quantity	Mandatory	INVENTORY	QUANTITY
4	UserData		N/A	N/A
5	FulfillmentCenterID		INVENTORY	FFMCENTER_ID
6	ProductSKU	Mandatory (see note)	CATENTRY	PARTNUMBER	Mandatory only when ProductNumberByMerchant is not used. This attribute should not be used when ProductNumberByMerchant is used.