html_common_help_banner

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

1. Definition

1. Merchant SKU: The code used to manage products in the warehouse.
2. Store SKU: The code used to manage products in your store, such as Shopee's item number, Lazada's Seller SKU
3. 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.


💡 Notes:

  • To facilitate SKU mapping and improve inventory management, it is recommended to use the same store SKU name for identical products across all stores.
  • 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 enabling Auto Create Merchant SKUs, BigSeller will do the following automatically:

1. Automatically identify the unmapped Store SKUs in orders, and automatically create Merchant SKUs same as Store SKUs.
2. The new created Merchant SKUs will use the stock of Store SKUs as the initial stock by default.
3. Automatically create mapping with Merchant SKUs for Store SKUs that have no mapping relations.


 

html_blog_comm_feedback_tips7