Product master data
One row per SKU: style, color, size and code. The base for stock, sales and marking.
What the template is for
Loading a new collection and reconciling reference books between systems.
- What one row is
- one row = one SKU (style, color, size)
Columns
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| SKU code | sku | Text | yes | unique in the file |
| GTIN barcode | gtin | GTIN barcode | yes | 8, 12, 13 or 14 digits, a valid check digit |
| Style SKU | article | Text | yes | not empty; one SKU for all sizes and colors of a style |
| Main color | colour | List value | yes | a value from the reference book |
| Size | size | List value | yes | a value from the reference book |
| Category | category | List value | yes | a value from the reference book |
| Season code | season | List value | yes | a value from the reference book |
| Customs code (HS) | hs | Text | no | a value from the reference book |
| Composition | comp | Text | yes | a value from the reference book |
| Gender and age group | gender | List value | yes | a value from the reference book |
| Unit cost excl. VAT | cost | Number | yes | a number not below 0 |
| Price excl. VAT | price | Number | yes | a number not below 0 |
| Predecessor style (carryover) | carry | Text | no | empty if the style is new; otherwise the SKU of the earlier style |
| Supplier code | supplier | Text | yes | a value from the reference book |
| Updated on | updated | Date | yes | date YYYY-MM-DD, not in the future |
Example rows
| SKU code | GTIN barcode | Style SKU | Main color | Size | Category | Season code | Customs code (HS) | Composition | Gender and age group | Unit cost excl. VAT | Price excl. VAT | Predecessor style (carryover) | Supplier code | Updated on |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A100-BLK-M | 4601234567893 | A100 | BLK | M | COAT | AW26 | WO70PA30 | W-ADT | 1,800 | 5,200 | S01 | 2026-11-01 | ||
| A100-BLK-L | 4601234567909 | A100 | BLK | L | COAT | AW26 | WO70PA30 | W-ADT | 1,800 | 5,200 | S01 | 2026-11-01 |
The example data is illustrative: an exercise, replace it with your own.
Note
Take the season code in the form AW26 from the season reference. Validate the GTIN check digit in code. For marked product groups the description and codes follow the Chestny Znak rules: check them in the current text.
How to open the file
The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.
Calculations that use these fields
- Unit cost from the bill of materials
- ABC-XYZ matrix: a SKU’s contribution to sales and demand stability
- Size curve: how to split a buy across sizes
- Category roles: traffic driver, profit core, image
- Price, markup and margin
- Season calendar counted back from the shelf date
- Price position among competitors
- Season matrix: product season × sales month and stock against the window
Documents that need this data
- Assortment matrix and assortment plan
- Tech pack (product technical dossier)
- Collection calendar (critical path) and lead time
- Accessories: bags, leather goods, belts, headwear, scarves, jewelry
- Accessories line economics: bags, jewelry, hats and belts
- AI in fashion analytics and content: what can be computed, limits, risks
- Business plan of a brand and a retailer: sections, assumptions, presenting to an investor and a bank
- Brand platform: a one-page working template and a readiness checklist
- Brand platform and positioning
- Certification, declaration and marking: TR CU 007/2011, 017/2011, Chestny Znak, EPR, voluntary standards
- Production and content: shoot budget and calendar
- Systems and data: 1C and ERP, PIM and MDM, BI, integrations (e-document exchange, marking, marketplace API), cost of ownership and data quality