1. Definition

• Merchant SKU: Created in BigSeller's Merchant SKU list, merchant SKU is used to create and maintain the basic information of the product, including product image, model, color, size, weight, etc.
• Store SKU: The SKU entered when listing the product, 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 matching 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 function, 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
Steps: [Inventory - SKU Mapping - Create Mapping Relationship]



Method 2: Create on the Merchant SKU Page
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
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
① Generate Merchant SKU with one click: For the products whose Store SKUs are filled out in a standardized manner and without duplication, the system will automatically generate merchant SKU and complete the mapping. It will take effect on subsequent new orders. (The steps are shown in the following image.)

• Quickly Mapping Merchant SKU
• Generate Merchant SKU (You can generate for selected products or all products)

② 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.