Administer > Overview of administering a WebSphere Commerce site > Administration Console > Scheduler > Jobs > Use an external system of record


Update inventory levels from an external system of record

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