html_common_help_banner

  • html_title_nav_help_faqs

    • Role - Warehousing

    • BigSeller Inventory -- To achieve the inventory synchronization across platform

    • Introduction to Push Inventory

    • Steps to Use Inventory Management Function

    • Steps to Add a Merchant SKU

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

    • Introduction to Push Record

    • How to add a push rule for inventory push?

    • How to Add Multiple Variations

    • Steps to Add a Combination SKU

    • How to add a push rule? (Multi-Warehouse Store)

    • Introduction to Merchant SKU Page

    • How to push inventory manually?

    • Print SKU Label from Bigseller

    • Introduction to Stock Count

    • Introduction to Shelves

    • How to add Shelves?

    • How to delete and clear shelves?

    • Introduction to Inventory List

    • How to export the merchant SKUs on inventory list page?

    • How to manual stock in?

    • How to manual stock out?

    • Introduction to Inventory Transfer

    • Introduction to Move Feature [New]

    • How to map merchant SKU (on SKU Mapping page)?

    • Introduction to Warehouse Area

    • How to add a warehouse

    • How to increase or decrease inventory

    • How to set alert stock for merchant SKU?

    • How to bulk update Merchant SKU information

    • Introduction to Promotion Reserved Inventory

    • How to bulk update the cost of Merchant SKU?

    • Introduction to Merchant SKU Category

    • How to put a Merchant SKU into warehouses?

    • Introduction to Warehouse Pick & Store Zoning (One SKU Multiple Shelves)

    • Inventory Restock Using BigSeller APP

    • Picking Area with One SKU Multiple Shelves

    • How to reserve inventory for Shopee promotion?

    • How to reserve inventory for Lazada promotion?

    • How to reserve inventory for TikTok promotion?

    • How to reserve inventory for Tokopedia promotion?

    • How to edit reserved inventory？

    • How to receive transferred items?

    • How does “Scan to Receive” work?

    • How to manually stock in via PDA?

    • How to manually stock out via PDA?

    • Introduction to Unstored Inventory Management

    • How to set SKU mapping rules?

    • Common Failure Reasons for Inventory Push

    • Introduction to Distribution Products

    • How to import merchant SKUs for Promo Reserved Stock?

    • How to set/update the merchant SKU image?

    • How to map Tokopedia multiple warehouse?

M_Help_Centerhtml_title_nav_help_faqsInventory

How to set SKU mapping rules?

copy_url_title

Products can be matched to the same merchant SKU by ignoring some prefixes and suffixes by setting SKU Mapping Rules. And when you add mapping for a new store SKU, it will map with the merchant SKU that mapped with the same old store SKU.

Step 1: go to setting > Inventory Settings > SKU Mapping Rules > Set the mapping rule





1. Ignore Prefix:
  • SKU: AAQ-03 > Ignore Prefix "A" > AQ-03
  • SKU: AAQ-03 > Ignore First "2" characters > Q-03

2. Ignore Suffix
  • SKU: AAQ-03 > Ignore Suffix "-03" > AAQ
  • SKU: AAQ-03 > Ignore Last "1" characters > AAQ-0

3. When Ignore Prefix/Suffix is selected, you can also:
  • Input the fixed delimiter (e.g. &)
  • Set which occurrence of the delimiter to use (e.g. 1st, 2nd, etc.)


 
Example:
Original string: Red&001&xxs&Shopee
Fixed delimiter: &
Use the 1st delimiter.

If Ignore Suffix is selected:
Starting from the right, find the 1st delimiter (&) → after xxs
→ Remove everything after that
→ Result: Red&001&xxs

If Ignore Prefix is selected:
Starting from the left, find the 1st delimiter (&) → after Red
→ Remove everything before that
→ Result: 001&xxs&Shopee

4. Ignore Characters:
  • SKU: AQBQABHEAB4 > Ignore "AB" > AQBQHE4
  • SKU: AQBQABHEAB4 > Ignore "AB" and "HE" > AQBQ4
5. Replace Characters
  • SKU: AAQ-03 > Replace "AQ" with"BE" > ABE-03
Set one rule of the four above, BigSeller will automatically ignore the spaces before and after the SKU for mapping;The unmapped store SKUs will be ignored or replaced according to the mapping rules, and then automatically mapped with the merchant SKUs (not case sensitive).

5. Test rules: you can test the rule by entering a store SKU.



6. Change Log: You could check the change history here.


Step 2: Save the Setting



Step 3: If you created a new store SKU which is the same as other store SKUs, you can enable this icon to map with the same merchant SKU.

When you add mapping for a new store SKU, it will map with the merchant SKU that mapped with the same old store SKU. For example:
  • Store A, store SKU: SKU001 is mapped with merchant SKU: ABCD
  • Store B, store SKU: SKU001, then also map with merchant SKU: ABCD



After enabling these rules, you can auto map SKUs on the SKU Mapping list.

html_blog_comm_feedback_tips7