Two products with the same display name can be different items at the pick location. Size, color, pack quantity and product version should survive the journey from the storefront to the warehouse record.
GS1's GTIN Management Standard addresses when trade-item changes require a new identifier. A warehouse also needs a practical crosswalk between the seller's SKU, the supplier reference and any external product identifier.
Test the confusing variants together
Use a crosswalk with the merchant SKU, supplier reference, relevant product identifier, size, color and unit of sale. Add a pack photograph where it helps an operator distinguish near-identical variants. Keep commercial descriptions separate from the unique lookup key.
Choose a test pair such as a single pack and a two-pack of the same item. Scan both, inspect the returned record and import a small test order for each. The warehouse result should identify the intended stock and unit quantity.
Estimate the mapping task
The following figures are deliberate assumptions for a worksheet. Suppose 60 variants need two minutes of initial mapping each, followed by 15 sample checks taking four minutes each. At US$21 per labor hour, the model is (60 × 2 + 15 × 4) ÷ 60 × $21 = $63. Six corrections taking three minutes each add $6.30, bringing the task to $69.30.
This is no claim about the time required for a real catalog. Complex products may need a different process, and the example excludes software subscriptions and external identifier licensing.
Keep product identity consistent across dispatch plans
| Stock use | Mapping requirement | Error to catch |
|---|---|---|
| Direct customer parcel | Order variant resolves to the intended saleable unit | A two-pack is picked as one single item |
| Marketplace replenishment | Product identity matches the merchant's current destination preparation instruction | A correct internal SKU carries the wrong external label |
| Wholesale or pallet consolidation | Carton contents retain a line-level variant record | Several sizes disappear into one generic product line |
If a supplier changes a code, confirm whether this is a reference change or a product change before updating the map. Withdraw the superseded working crosswalk and keep its effective period as history. The final acceptance check should use real item records and scans, while avoiding any claim that a warehouse lookup alone verifies the legitimacy of an external product identifier.
Sources and verification links
Operational rules can change. Check the linked primary sources and confirm shipment-specific requirements before booking.