SKU Mapping Sequence

There are seven attributes of a SKU mapping:

store	store SKU	store product ID	store product name	warehouse SKU	qty	warehouse
optional	conditionally required	conditionally required	optional	required	required	optional

warehouse SKU and qty are always required.

One of store SKU and store product ID must be provided.

store product name is purely optional and only for reference purposes.

Example order:

store	store SKU	product ID	quantity
store_A	store_sku_1	product_id_1	2

Assume store_A is bound with the warehouse W_A. EzOM adopts the following flow to determine which warehouse SKU.

1. Look for SKU mapping using store SKU, store and warehouse, i.e. store=store_A, store SKU = store_sku_1, warehouse=W_A

2. If not found, EzOM will continue to search using store product ID, i.e.

   store=store_A, store product ID = product_id_1, warehouse=W_A

3. If still not found, EzOM relaxes the condition on store, i.e.

   store SKU = store_sku_1, warehouse=W_A or store product ID = product_id_1, warehouse=W_A

4. If still not found, EzOM relaxes the condition on warehouse but keep the condition on store, i.e.

   store=store_A, store SKU = store_sku_1 or store product ID = product_id_1

5. If still not found, EzOM further relaxes the conditions on both warehouse and store, i.e.

   store SKU = store_sku_1 or store product ID = product_id_1

6. If any SKU mapping(s) were found in the these steps, the matching warehouse SKU and quantity will be used to decide what needs to be sent from the warehouse. In this example, if the following SKU mapping is found

   warehouse SKU	qty
   w_sku_A	3

   Then EzOM will add 2*3 = 6 items of w_sku_A to the outbound consignment

For combo orders, all matching SKU mappings found using the same criteria will be used. For example, if the following SKU mappings are found

warehouse SKU	qty
w_sku_A	3
w_sku_B	1

Then EzOM will add 6 items of w_sku_A and 2 items of w_sku_B to the outbound consignment.