How to Map Merchant SKUs with Store SKUs? (Summary)

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 Relation: The mapping relation 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 Relation

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.

💡 Note: When the product status is Deleted, the mapping relations for all store SKUs under this product will be automatically expired.
 

3. How to Create a Mapping Relation

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.

• On SKU Mapping - By Merchant SKU page

• On SKU Mapping - By Product page

You can manually map the merchant SKU for a single product or perform batch mapping (including importing spreadsheets to create mapping relations, quickly mapping the current merchant SKU for Unmapped Products, or generating new merchant SKUs for the selected products).
 

1) Quickly Mapping merchant SKU


2) Import to Create Mapping



Method 2: Create on the Merchant SKU Page

💡 You can map the store SKUs when manually creating merchant SKUs on Merchant SKU page. Please refer to this article: Steps to Add Merchant SKUs

After the merchant SKU is created, you can set / edit mapping relations between merchant SKU and store SKU on Merchant SKU page.

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

Notes
1)  English letters are not case-sensitive.
2) 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.