Syntha Lab RU

Product master data

One row per SKU: style, color, size and code. The base for stock, sales and marking.

Core data exchange 15 columns 2 example rows

Download CSV ↓

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

ColumnCodeTypeRequiredValidation rule
SKU codeskuTextyesunique in the file
GTIN barcodegtinGTIN barcodeyes8, 12, 13 or 14 digits, a valid check digit
Style SKUarticleTextyesnot empty; one SKU for all sizes and colors of a style
Main colorcolourList valueyesa value from the reference book
SizesizeList valueyesa value from the reference book
CategorycategoryList valueyesa value from the reference book
Season codeseasonList valueyesa value from the reference book
Customs code (HS)hsTextnoa value from the reference book
CompositioncompTextyesa value from the reference book
Gender and age groupgenderList valueyesa value from the reference book
Unit cost excl. VATcostNumberyesa number not below 0
Price excl. VATpriceNumberyesa number not below 0
Predecessor style (carryover)carryTextnoempty if the style is new; otherwise the SKU of the earlier style
Supplier codesupplierTextyesa value from the reference book
Updated onupdatedDateyesdate YYYY-MM-DD, not in the future

Example rows

SKU codeGTIN barcodeStyle SKUMain colorSizeCategorySeason codeCustoms code (HS)CompositionGender and age groupUnit cost excl. VATPrice excl. VATPredecessor style (carryover)Supplier codeUpdated on
A100-BLK-M4601234567893A100BLKMCOATAW26WO70PA30W-ADT1,8005,200S012026-11-01
A100-BLK-L4601234567909A100BLKLCOATAW26WO70PA30W-ADT1,8005,200S012026-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

Documents that need this data

Download CSV ↓ Open interactively →