Syntha Lab RU

Stock snapshot

Stock by SKU and location on a date: warehouse, store, in transit.

Core data exchange 7 columns 2 example rows

Download CSV ↓

What the template is for

Daily reconciliation of ERP, warehouse and platforms; stock-in-weeks calculation.

What one row is
one row = SKU × location × date

Columns

ColumnCodeTypeRequiredValidation rule
Stock datedateDateyesdate YYYY-MM-DD, not in the future
SKU codeskuTextyesa value from the reference book
Location codelocTextyesa value from the reference book
On hand, pcsqtyIntegeryesan integer not below 0
Reserved, pcsresIntegernoan integer not above on hand
In transit, pcstransitIntegernoan integer not below 0
Unit costcostNumberyesa number not below 0

Example rows

Stock dateSKU codeLocation codeOn hand, pcsReserved, pcsIn transit, pcsUnit cost
2026-11-13A100-BLK-MWH11201001,800
2026-11-13A100-BLK-MST0760241,800

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

Note

Row key: date, SKU and location together. Two snapshots for one date from the same source are a duplicate.

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 →