Syntha Lab RU

Assortment matrix (SKU: role, price, cost, sizes)

One row per style: category, role, price and cost excl. VAT, size range, colors and the buy plan in units.

Layouts for documents 12 columns 5 example rows

Download CSV ↓

What the template is for

Building the collection matrix before buying and checking margin by role.

What one row is
one row = a style (SKU)

Columns

ColumnCodeTypeRequiredValidation rule
Style SKUarticleTextyesunique in the file
NamenameTextyesnot empty
CategorycategoryList valueyesa value from the category reference
RoleroleList valueyestraffic, core, image or review
Price excl. VATpriceNumberyesa number not below 0
Unit cost excl. VATcostNumberyesa number not below 0
Gross margin, %gmNumberyescalculated: (price − cost) ÷ price × 100
Size rangesizesTextyesrange limits: 36-41, S-XXL, 80-128
Number of colorscoloursIntegeryesan integer not below 1
Buy plan, unitsunitsIntegeryesan integer not below 0
Planning typeplantypeList valueyesseasonal or carryover: for carryover the stock is subtracted from the budget, for seasonal it is not
Supplier codesupplierTextyesa value from the supplier reference

Example rows

Style SKUNameCategoryRolePrice excl. VATUnit cost excl. VATGross margin, %Size rangeNumber of colorsBuy plan, unitsPlanning typeSupplier code
W-COAT-01Wool coatcoatcore12,9004,9006240-523420carryoverS01
W-DRS-07Midi dressdressimage8,9002,8506840-504360seasonalS02
W-TEE-12Basic teeteetraffic1,99064067.8XS-XL61,800seasonalS02
M-JKT-03Padded jacketjacketcore10,9004,10062.4S-XXL2520carryoverS01
K-OVR-05Kids overalloverallreview3,4901,25064.280-1283600seasonalS03

The example data is illustrative: an exercise, replace it with your own.

Note

Take the split of units by size from the templates “Footwear size run 36–41” and “Kids size run 80–164”. Give the role “review” to styles with sales and margin below average. The example data is illustrative: an exercise, not a norm or an industry benchmark.

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 →