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.