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
- Add global fulfillment centers to the Catalog Asset store.
See Enabling
Fulfillment Centers and Find Inventory menus.
- 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);
- 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 WebSphere
Commerce Accelerator
- The Catalog Asset store can manage inventory for each fulfillment
center on WebSphere Commerce Accelerator
- The Extended Sites store can share non-ATP inventory data from
the Catalog Asset store