ProductInventoryUpdate command

The ProductInventoryUpdate command is used to update product inventory for the Update_NC_ProductInventory message, Update_WCS_ProductInventory message, or Product Quantity Update message.

Parameter values

catEntryId
WebSphere Commerce catalog entry as defined in the CATENTRY_ID column in INVENTORY table. If the catalog entry is empty, then the combination of the part number and the member id which owns both the store and the catalog will be used to get the catalog entry.
partNumber
The part number of the catalog entry as defined in the PARTNUMBER column of CATENTRY table. Together with the member id which owns the catalog, it is used to get the key catEntryId in the table CATENTRY, if the catEntryId parameter is empty.
storeId
The store id that references column STORE_ID in the table INVENTORY. Together with catalog entry and the default fulfillment center, this is a key to the row in the table INVENTORY.
inventoryQuantity
The quantity as defined in the QUANTITY column in table INVENTORY.
fulfillmentCenterID
The fulfillment center id that references column FFMCENTER_ID in the table INVENTORY. This a key to the FFMCENTER database table.

Behavior

  • The command updates a record in the INVENTORY table.
  • The store id (which references STORE_ID in the INVENTORY table) is mandatory.
  • The catEntryId and the storeId are used to update a row in the INVENTORY table.
  • If the catEntryId is not present, then the storeId (STORE_ID) is used to obtain the member id (which references MEMBER_ID in the CATENTRY table). The member id must be the same as the owner of the catalog. The member id (MEMBER_ID), along with the partNumber (which references PARTNUMBER in the CATENTRY table) are used to obtain the catEntryId. The catEntryId, along with the store id and the default fulfillment center id for that catalog entry are used to update a row in the INVENTORY table.
  • If the row in the table INVENTORY does not exist, an error will occur.

Exception conditions

The command generates an entry in the error log if the following exceptions are encountered:

  • The storeId does not exist.
  • The catEntryId cannot be found using the member id which owns the store along with the partNumber.
  • The catEntryId, along with storeId and default fulfillment center id, cannot find a matching row in table INVENTORY.