HCL Commerce Enterprise

Configuring inventory sharing for extended sites store

You can configure non-ATP inventory sharing for an extended sites store by configuring the store relationship and fulfillment centers for that extended site store.

Procedure

  1. Add global fulfillment centers to the Catalog Asset store. See Enabling Fulfillment Centers and Find Inventory menus.
  2. Configure a store relationship for the Extended Sites store. Insert a new record in the STOREREL table by using the following SQL statement:
    INSERT INTO STOREREL(STRELTYP_ID, RELATEDSTORE_ID, STORE_ID 
                           SEQUENCE, STATE)
       VALUES(-13,@asset_store_id_1,@esite_store_id_1,@store_sequence_1,
                           @store_state_1);
  3. Configure a fulfillment center for the Extended Sites store. Delete previously existing records in the SHPARRANGE table. Insert two records in the SHPARRANGE table by using the following SQL statement:
    INSERT INTO SHPARRANGE(SHPARRANGE_ID,STORE_ID,FFMCENTER_ID,
                             PRECEDENCE,FLAGS)
       VALUES(@shparrange_id_1, @esite_store_id_1, @global_ffmcenter_id_1,
                           @store_precedence_1, @store_flags_1);
       VALUES(@shparrange_id_2, @asset_store_id, @global_ffmcenter_id_1,
                           @store_precedence_1, @store_flags_1);
    Note:
    • If you configured inventory sharing, you can only load inventory to a related Catalog Asset store (step two) and any configured fulfillment center (steps one and three). It is unsupported to load inventory to extended sites store with the arranged fulfillment center in this condition
    • The SHPJCRULE table and the TAXJCRULE table might need to update the ffmcenter_id, if there is no store level inventory and the charges are not different between the old and the new fulfillment center.

Results

  • The Catalog Asset store can manage a fulfillment center on HCL Commerce Accelerator
  • The Catalog Asset store can manage inventory for each fulfillment center on HCL Commerce Accelerator
  • The Extended Sites store can share non-ATP inventory data from the Catalog Asset store