Why barcode and SKU mapping is the first checkpoint of a China fulfillment warehouse
When an overseas company purchases from multiple Chinese suppliers at the same time, goods arrive at the China fulfillment warehouse one after another under different numbering systems: suppliers have their own material numbers, internal batch numbers may be affixed to factory outer cartons, and the sales platform requires yet another set of barcodes. If these numbers are not correctly mapped to the same internal SKU during receiving, subsequent inventory organization, picking and packing, and international shipping will all suffer from wrong shipments, missing items, or inventory mismatches. This guide is intended for overseas companies, brands, and e-commerce sellers purchasing from multiple suppliers in China, explaining how to establish an executable mapping method during the receiving stage at a China warehouse.
First distinguish the four types of numbers to avoid conflating them
The root cause of much mapping confusion is treating numbers with different purposes as the same thing. Before receiving goods, it is recommended to first define the following four types of numbers separately:
- Supplier number：The material number, item number, or batch number used by the factory or supplier itself, usually printed on the outer carton label or accompanying documents.
- Internal SKU: The unique product code managed by your own company, which is the core primary key for inventory and orders—one SKU corresponds to one sellable unit.
- Sales platform barcode: The barcode or product identifier used by Amazon, eBay, Shopify, or other channels, used to match with orders after outbound.
- Warehouse identifier: The bin location or label number used on the shelves at the China warehouse, used for picking and locating, usually generated by the warehouse side.
Each of the four types of codes serves its own purpose, and the role of the mapping table is to link them together, so that any party seeing any one code can find the corresponding product.
What fields should the mapping table include
The mapping table doesn't need a complex system—a clearly structured spreadsheet is enough to support receiving and outbound. It's recommended to include at least the following fields:
| Field | Description | Provided by |
|---|---|---|
| Internal SKU | Unique primary key, cannot be duplicated | Customer |
| Product name and specifications | Distinguishing attributes such as color, size, capacity, etc. | Customer |
| Supplier name | Which factory or supplier it corresponds to | Customer |
| Supplier number | Factory material number or item number | Customer / Supplier |
| Sales platform barcode | Channel barcode or product identifier | Customer |
| Outer box labeling requirements | Content to be printed or affixed on the outer box | Customer |
| Warehouse identifier | Storage location or shelf number | Warehouse |
| Notes | Batch, expiry date, special packaging, etc. | Both parties |
Once the fields are determined, it is recommended to update them whenever a new supplier or SKU is added, rather than waiting until the goods arrive at the warehouse to enter them on the fly.
Mapping verification steps during the receiving stage
After the goods arrive at the China warehouse, you can check them in the following order to reduce rework:
- Verify the arrival list against the pre-alert: Confirm which supplier this batch of goods belongs to and which internal SKUs it corresponds to.
- Read outer box markings: Record the supplier number, quantity, and batch information on the outer box.
- Opening and spot-check inspection: Check the product's appearance, quantity, and specifications against the basic quality inspection requirements, and take photos for records.
- Matching mapping table: Match the outer box number with the supplier number in the mapping table to find the internal SKU.
- Handling Unmatched Items: If the outer box number cannot be found in the mapping table, isolate and record it first, wait for customer confirmation, and do not assign it to a SKU on your own.
- Relabeling and Identification: Replace the product or outer box with internal SKU labels or platform barcodes as requested by the customer; the content and placement of the new labels must be agreed upon in advance.
- Warehousing Registration: Write the internal SKU, quantity, and storage location into the inventory record to complete the mapping loop.
Common exceptions and how to handle them
The most error-prone issues during mapping are missing or conflicting numbers. Below are several typical scenarios and recommended actions:
- The outer box has no number at all: Photograph and record the outer box and its contents, hold off on warehousing, and ask the customer or supplier to provide the number before confirming.
- The same supplier code corresponds to multiple internal SKUs: This indicates the supplier code granularity is insufficient. The customer needs to split or add specification distinguishing items.
- One internal SKU corresponds to multiple supplier codes: This is normal. The mapping table should allow one-to-many relationships and note the source supplier in the remarks.
- Platform barcode does not match internal SKU: Use the internal SKU as the primary reference, and the platform barcode as the corresponding outbound field, to avoid the inventory primary key being affected by channel changes.
- Label is blurry or falls off after replacement: Re-label and record, then verify again before outbound.
All exceptions should be documented with photos and written records as a basis for subsequent communication with suppliers or customers.
Precautions for relabeling and repackaging
Label replacement is a key part of mapping implementation. Customers need to specify in advance: whether the label replacement applies to the product itself or the outer box, the label content and size, the placement position, and whether the original label needs to be covered. If repackaging is involved, the inner packaging, cushioning materials, and sealing requirements must also be specified. The warehouse will execute according to the agreement and take photos for confirmation upon completion. Please note that any replacement involving brand logos, compliance labels, or certification information should be based on the destination country's official requirements and the brand owner's authorization. The warehouse does not make compliance judgments on your behalf. Involvingcustoms clearanceand taxes, readers should check the latest official requirements of the destination country's customs or tax authority.
Turn the mapping table into a long-term maintainable asset
Mapping is not a one-time task. As suppliers increase, SKUs iterate and channels change, the mapping table needs ongoing maintenance. It is recommended to assign a dedicated person to handle updates and to confirm the version with the warehouse before each large batch arrival. For businesses that purchase from multiple suppliers in China and need to consolidate goods in China before shipping to Europe and other markets, a stable barcode and SKU mapping is the foundation for inventory accuracy and smooth outbound. To learn about the specific operational arrangements for receiving, relabeling, warehousing, and picking and packing, see /warehouse-fulfillment/, or submit product and order requirements through /contact/ Talk to us about your product structure and numbering system.
