1. Definition

• Merchant SKU: The code used to manage products in the warehouse.
• Store SKU: The code used to manage products in your store, such as Shopee's item number, Lazada's Seller SKU
• Mapping Relationship: The mapping relationship between the merchant SKU and the store SKU is used to achieve the automatic deduction of inventory by the system.

2. Why Should We Create Mapping Relationship

Only by creating a mpping relationship between the merchant SKU and the store SKU, the system will know which store this product is sold in. If you enable the inventory feature, when you process an order in BigSeller, the system will automatically deduct the inventory quantity of the corresponding merchant SKU in the inventory list and synchronize the inventory of the merchant SKU to the online store in real time.

3. How to Create a Mapping Relationship
Method 1: Create on the SKU Mapping Page
💡 The SKU mapping page is displayed in store SKU dimensions. You can filter the unmapped store SKUs quickly.
Steps: [Inventory > SKU Mapping > Create Mapping Relationship]



Method 2: Create on the Merchant SKU Page
💡 The Merchant SKU page is displayed in merchant SKU dimensions. You can map with store SKUs from different stores.
Steps：[Inventory - Merchant SKU - SKU Mapping]

• Map one by one.  Please refer to How to Add Mapping Relationship?
• Map in bulk. Please refer to Import to Bulk Match Store SKUs with Merchant SKUs via Excel

Method 3: Create on the Order Details Page
💡 This method is suitable for temporarily modifying the mapping of individual orders due to out of stock or exchange goods.
Steps : [Processing Order - Order Details - Create Mapping Relationship]

If you are creating/changing the mapping relationship in the In Process Order list, you can choose to take effect on the current order or the subsequent new orders.
Please refer to How to Change or Add Mapping for the Order Items?

Method 4: Auto Mapping (Matching with the same name)
💡 When the name of the Store SKU is the same as that of the Merchant SKU, they will be mapped automatically when you click "Auto Mapping".

Note: ① English letters are not case-sensitive; ② If the store SKU has been matched, it will not be matched again.



When you have listed the same product multiple times in a store, and add prefixes and suffixes for these SKUs for differentiation. These listed products can be matched to the same merchant SKU by ignoring some prefixes and suffixes through set SKU mapping rules.

Method 5: Automatically Create Mapping Relationships
① After the inventory function is enabled, if the store SKU is consistent with the created merchant SKU, the system will automatically create a mapping relationship when synchronizing the order. It will take effect on current orders and subsequent new orders.