CHENGBRIDGE / BUYER GUIDE

SKU and Product Variant Mapping for a China Warehouse

Warehousing & Consolidation

Give every orderable variant an unambiguous internal SKU and a plain-language description that identifies the stock someone must receive or pick. Keep the supplier item number, internal SKU and any applicable GTIN in separate fields. Define what one unit means, then check that the receiving brief and fulfillment order file use the same identifiers and quantities.

Define what makes each variant distinct

Start with what the buyer expects to receive. If colour, size, finish or pack quantity changes the item ordered, capture that difference in the product master. Give each orderable combination its own record, with enough detail for someone handling the goods to distinguish it from similar stock. For example, in an illustrative case with blue and red versions of the same product, put the colour in each description even if both records have photos.

Read each description alongside the supplier’s packing information. If the description names a difference that the people receiving the goods cannot identify, agree on which physical marking distinguishes the variants before stock moves. Record the agreed distinction in the mapping so the same information can be used when preparing orders.

Give each identifier its own field

Use the supplier item number to reference the supplier’s product information and the internal SKU to identify the variant in your stock and order records. Matching text across fields does not establish that two records refer to the same product. If a supplier code is reused, use the variant description and the agreed physical distinction to establish which internal SKU applies.

Keep a separate field for the GTIN where one applies. Copying an internal SKU into that field does not create a GTIN. GS1 explains that product variations need their own GTINs within its identification system. When standard identifiers are required, consult the applicable rules. GS1 guidance on GTINs for sizes and colours

State what each quantity counts

Specify whether a quantity counts an individual item, a pair, a set or a carton. Record how the sellable unit relates to the supplier’s packaging, so someone reading a received quantity can tell what it represents in terms of orderable stock. Where the supplier packs several sellable units together, state how many are in that package. Where the sellable unit is a set, list the components and quantities that make up one set.

For a set with several components, record whether it arrives assembled. If it needs preparation, identify that as a separate task and agree on its scope before processing the goods. The mapping should give receiving and order preparation the same basis for interpreting a quantity of one.

Use sample records to resolve mismatches before receiving

Ask the parties handling stock to review a small set of product master records against the supplier’s packing information and the intended order instructions. Look for duplicate internal SKUs, missing variant descriptions and reused supplier codes. For each issue, identify the affected record, document what has been confirmed and assign a person to resolve the open decision before stock movements start.

The examples below are illustrative data problems. They do not describe reported customer incidents.

Illustrative mismatch What can go wrong Decision to record
Two colours share a supplier code. The code alone leaves receiving unable to identify the selling variant. Record the physical marking that distinguishes each colour and the internal SKU it maps to.
A set is recorded as one individual item. Received quantities and order quantities can refer to different units. Specify the components and quantities in one sellable set and how the supplier packs them.
An old SKU is given a new meaning. Open orders or remaining stock may still refer to the original item. Keep the original meaning while those references are active and document how the items stay distinguishable.

A spreadsheet can serve as the working list. Agree with the people using it on how the approved mapping will be exchanged, and keep the current instructions and decision history together.

Use the approved mapping for receiving and picking

Compare the receiving brief with the picking data using the approved mapping. For each variant reviewed, confirm that the receiving information identifies the physical goods and that the order instruction points to the same internal SKU and sellable unit. Resolve any difference before the mapping is used to process stock. Warehouse receiving brief · Fulfillment order file

Use the mapping to identify the item and quantity to pick. Keep packing materials and label placement in the separate work instruction. Packing work instruction

Keep the master current as variants change

Assign an owner and version to the product master. When a variant is discontinued, preserve the SKU’s meaning while remaining stock or open orders still refer to it. Record approved changes in the decision history and communicate the current version to the people receiving stock and preparing orders so both work from the same instructions.

ChengBridge can discuss inventory coordination and order preparation. Share your SKU list and any unresolved variant questions, and confirm the requirements and service scope for your specific goods before making arrangements. This general buyer guidance was prepared for ChengBridge and implies no particular warehouse software or integration. Inventory coordination · Order preparation · Share your SKU list and variant questions

PUT THE GUIDE INTO PRACTICE

Tell us what your next order needs.

Share the product, quantities, destination and support you need. We will discuss a suitable service scope.

Scroll to top