Update_NC_ProductInventory message
The Update_NC_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 HCL Commerce inbound message queue, where the HCL Commerce system receives the message. HCL Commerce updates the INVENTORY table with the new inventory information.
The Update_NC_ProductInventory message uses the XML message format and follows Update_NC_ProductInventory_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. 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 |
---|---|---|---|---|
1 | ProductNumber ByMerchant | Mandatory | INVENTORY | CATENTRY_ID |
2 | MerchantID | Mandatory | INVENTORY | STORE_ID |
3 | Quantity | Mandatory | INVENTORY | QUANTITY |
4 | UserData | N/A | N/A |
Behavior:
- The HCL 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.