Sales by SKU and day
Sales and returns by SKU, store or channel and date; price and discount separate.
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
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| Date | date | Date | yes | date YYYY-MM-DD, not in the future |
| SKU code | sku | Text | yes | a value from the reference book |
| Store or channel | store | Text | yes | a value from the reference book |
| Sold, pcs | qty | Integer | yes | an integer not below 0 |
| Returned, pcs | ret | Integer | no | an integer not below 0 |
| List price excl. VAT | list | Number | yes | a number not below 0 |
| Sale price excl. VAT | paid | Number | yes | a number not below 0 |
| Stage (BS, IS, AS, SO) | stage | List value | no | BS, IS, AS or SO; names may differ in your company |
Example rows
| Date | SKU code | Store or channel | Sold, pcs | Returned, pcs | List price excl. VAT | Sale price excl. VAT | Stage (BS, IS, AS, SO) |
|---|---|---|---|---|---|---|---|
| 2026-11-12 | A100-BLK-M | ST07 | 3 | 0 | 5,200 | 5,200 | BS |
| 2026-11-12 | A100-BLK-L | ST07 | 1 | 1 | 5,200 | 4,160 | IS |
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
- Season sell-through pace and leftover risk
- ABC analysis of the range
- Discounted receipts: share, depth and the ticket with a discount versus full price
- Category roles: traffic driver, profit core, image
- Sales forecast: method, horizon, error
- Price, markup and margin
- Open-to-buy (OTB) for the season
- Store indicators: ticket, conversion, space, staff
Documents that need this data
- Sales plan
- LFL and comparable sales (4-5-4 calendar)
- Store KPI pack: traffic, conversion, ticket, revenue per m², payroll and shrinkage
- Accessories: bags, leather goods, belts, headwear, scarves, jewelry
- Accessories line economics: bags, jewelry, hats and belts
- AI in fashion and analytics: where to apply it, where not, how to check the result, which data are needed and which errors occur. A memo and a checklist
- AI in fashion analytics and content: what can be computed, limits, risks
- Bayesian estimates of conversion and buyout: small samples, prior distributions, shrinkage and comparison with the frequentist approach
- Business plan of a brand and a retailer: sections, assumptions, presenting to an investor and a bank
- Brand platform and positioning
- Budget: P&L, cash, purchase, marketing, payroll and CAPEX budgets
- Budgeting methods: rolling forecast, ZBB, what-if scenarios