Syntha Lab RU

Sales by SKU and day

Sales and returns by SKU, store or channel and date; price and discount separate.

Core data exchange 8 columns 2 example rows

Download CSV ↓

What the template is for

Brand history, the SKU report, carryover, forecast and season results.

What one row is
one row = SKU × store or channel × day

Columns

ColumnCodeTypeRequiredValidation rule
DatedateDateyesdate YYYY-MM-DD, not in the future
SKU codeskuTextyesa value from the reference book
Store or channelstoreTextyesa value from the reference book
Sold, pcsqtyIntegeryesan integer not below 0
Returned, pcsretIntegernoan integer not below 0
List price excl. VATlistNumberyesa number not below 0
Sale price excl. VATpaidNumberyesa number not below 0
Stage (BS, IS, AS, SO)stageList valuenoBS, IS, AS or SO; names may differ in your company

Example rows

DateSKU codeStore or channelSold, pcsReturned, pcsList price excl. VATSale price excl. VATStage (BS, IS, AS, SO)
2026-11-12A100-BLK-MST07305,2005,200BS
2026-11-12A100-BLK-LST07115,2004,160IS

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

Note

Keep the list price and the sale price separately: otherwise the discount cannot be recovered. All amounts excl. VAT.

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 →