Administer > Overview of administering a WebSphere Commerce site > Administration Console > Scheduler > Jobs > Use an external system of record
Configure a store to allow updates from an external system of record
WebSphere Commerce manages ATP inventory as it is received at a fulfillment center, when adjustments are performed, and when orders are processed and released to fulfillment. An external system of record generally manages the flow of materials into and out of a fulfillment center.
To use an external system of record to maintain the current inventory levels for a store, the store must be configured properly, and inventory levels must be periodically updated using an external feed.
To use an external system of record for ATP-enabled stores, set the FFMCENTER.INVENTORYOPFLAGS to 1 to implement order tracking in fulfillment before you start releasing orders to fulfillment. The default is 0.
Procedure
- Open the DB2 Command Center ( Start > Programs >IBM DB2 > Command Line Tools > Command Center).
- Type the following information in the script window:
connect to developmentDB user dbuser using dbpassword; update FFMCENTER set INVENTORYOPFLAGS = 1 where FFMCENTER_ID = FFMCENTER_ID;
- Open the Oracle SQL Plus command window ( Start > Programs > Oracle > Application Development > SQL Plus).
- In the SQL Plus window, issue the following SQL statement:
update FFMCENTER set INVENTORYOPFLAGS = 1 where FFMCENTER_ID = FFMCENTER_ID;
- Start WebSphere Commerce Test Server.
- Open a browser and type the following URL: http://localhost/webapp/wcs/admin/servlet/db.jsp.
- In the input box, enter the following SQL statement:
update FFMCENTER set INVENTORYOPFLAGS = 1 where FFMCENTER_ID = FFMCENTER_ID;