The inventory levels supplied by an external system of record can be used to update inventory in WebSphere Commerce. Since the values supplied by a system of record reflect the inventory levels available after stock has been shipped to customers, it is recommended that the updates be performed after shipment confirmation.
To update the inventory levels, update the RECEIPT table, and set the correct value for QTYONHAND:
update RECEIPT set QTYONHAND = QTYONHAND where VERSIONSPC_ID = VERSIONSPC_ID and STORE_ID = STORE_ID and FFMCENTER_ID = FFMCENTER_ID
Alternatively, if you know the RECEIPT_ID of the row you want to update:
update RECEIPT set QTYONHAND = QTYONHAND where RECEIPT_ID = RECEIPT_ID
Related concepts
Related tasks
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.