Configuring 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. If you want 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.

About this task

To use an external system of record for ATP-enabled stores, you must set the FFMCENTER.INVENTORYOPFLAGS to 1 to implement order tracking in fulfillment before you start releasing orders to fulfillment. The default is 0.

Procedure

  • DB2Open the DB2 Command Center ( Start > Programs >IBM DB2 > Command Line Tools > Command Center).
    1. 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;
      
  • OracleOpen the Oracle SQL Plus command window ( Start > Programs > Oracle > Application Development > SQL Plus).
    1. In the SQL Plus window, issue the following SQL statement:
      update FFMCENTER set INVENTORYOPFLAGS = 1 where FFMCENTER_ID = FFMCENTER_ID;
      
  • Apache Derby Start WebSphere Commerce Test Server.
    1. Open a browser and type the following URL: http://localhost/webapp/wcs/admin/servlet/db.jsp.
    2. In the input box, enter the following SQL statement:
      update FFMCENTER set INVENTORYOPFLAGS = 1 where FFMCENTER_ID = FFMCENTER_ID;