Configuring WebSphere Commerce for order and inventory processing

Configure WebSphere Commerce for order and inventory processing by updating the database schema.

Procedure

  1. Start one of the following servers:
    • Start the WebSphere Commerce server.
    • WebSphere Commerce DeveloperStart the WebSphere Commerce Developer and start the WebSphere Commerce test server.
  2. Run the following SQL statements to use Sterling Order Management for inventory and order processing: 
    
UPDATE STORE SET INVENTORYSYSTEM=-5 WHERE STORE_ID IN (SELECT STOREENT_ID FROM STOREENT WHERE IDENTIFIER='Store_Identifier' );
UPDATE STORECONF SET VALUE='Y' WHERE NAME='is_ext_order_system' AND STOREENT_ID =0 ;
    Where:
    Store_Identifier
    Is the value of your store identifier, for example, Aurora for your consumer direct store.
  3. Add the necessary rows to the following database tables for inventory:
    Insert the following into the INVCNF table: 
    INSERT INTO INVCNF (INVCNF_ID,IDENTIFIER,DESCRIPTION,PRECEDENCE,FLAGS,
THRESHOLDQUANTITY,CHEXPABOVETHRES,CHEXPBELOWTHRES,CACHEPRIORITY,FALLBACKINVSTAT,FALLBACKAVAILTIME,FALLBACKINVOFFSET,QUANTITYMEASURE) values 
(1,'Sample','Sample Configuration', 0,30,5,null,0,0,'UAVL',null,null,'C62');

    INSERT INTO INVCNFREL (INVCNFREL_ID,INVCNF_ID,CATENTRY_ID,STORE_ID,STLOC_ID)VALUES (1,1,null,null,null)
    Where:
    • The following tables are updated:
      WebSphere Commerce database tables
      Table name Description
      INVCNF Represents Distributed Order Management inventory cache configurations.
      INVCNFREL Represents the relationship of an item and/or location with an inventory configuration.
    • The sample configuration shown is applied to all items and all locations. The sample configuration enables the database cache, fetches inventory availability from the order management system when cached quantity is below 5, decrements the cached inventory availability after submitting the order, and updates it with information retrieved from the order management system.
    • If you have physical store locations, a FLAGS value of 4 is recommended for the INVCNF table. Otherwise, the above sample value is set to 30.
    • If the INVCNF table is empty or if there is no record for the current store, insert records into the INVCNF and INVCNFREL tables to setup inventory configuration and apply it to items and locations. Update the values in the INVCNF table to suit your business needs.