Administer > Manage WebSphere Commerce features > Overview of inventory sharing for Extended Sites stores (non-ATP)


Configure 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 Asset store. See Manage inventory for Asset stores.

  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. Insert a new record 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);
    

    If you configured inventory sharing, you can only load inventory to a related 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


Results


+

Search Tips   |   Advanced Search