Develop > Controller layer > Integrate with back-end systems and external applications > Integration XML messages > Back-end integration messages

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.


Related reference

Back-end integration legacy messages