A base article number can be shared by several finishes and pack sizes. I preserved its leading zeros and encoded the approved article, finish and pack quantity in the variant SKU. For example, the same Charcoal article has distinct identifiers for a single item and a six-unit pack.
Records requiring clarification
Two rows describe a case without a confirmed number of units. One row conflicts with the approved article map. Those three rows stay in the workbook's review sheet, with the original lines available for follow-up.
Result
The Excel workbook tracks all 48 inputs, and a companion CSV contains the 45 released variants. The release protects the link between the sales unit, the item identifier and the price.


Approved identifiers distinguish a single item from a six-unit pack of the same finish.
0 likes · 0 views · Nov 17, 2026
Validated 48 variants across twelve products against approved SKUs, colours and packs. The export releases 45 rows and records three exceptions.