Anyone whose supplier prices move · Imports into nouz
Price list with effective dates
A price list with effective dates records what each product costs and sells for and from which day that applies. Adding a new row rather than editing the old one keeps a price history, so an order placed in March is still priced with March's cost when you look at it in June.
The file
nouz-price-list.csv · 7 columns · one example row
The effective date is the entire point of the file. A single cost field holds one number, so the day a supplier raises a price, every order the store has ever taken silently gets more expensive, and last quarter's margins change while you are looking at them. A dated row prices the days from that date forward and leaves the ones before it exactly as they were.
That rule has a name in this product, effective dating, and it is enforced rather than encouraged: saving a new cost closes the previous one the day before and opens a new one. The file mirrors it, which is why the correct way to record a price rise here is a new row rather than an edit.
The source column matters more than it looks. A cost taken from a supplier invoice is a fact; one copied from a catalogue is an estimate; one landed with freight and duty is a different number again, and usually about a fifth higher, as the landed cost calculator shows. Recording which kind each row is stops three sorts of number being averaged into one.
How to use it
- 01One row per SKU per price, with the day it took effect.
- 02When a price changes, add a row rather than editing the old one.
- 03Enter unit costs landed where you can: supplier price plus freight, duty and inbound handling.
- 04Keep sell_price_gross as the price customers actually pay, VAT included, with the rate beside it.
- 05Import into nouz to price every historical order at the cost that was true on its own day.
What is inside
| Row | sku | product | unit_cost | sell_price_gross | vat_rate | effective_from | source |
|---|---|---|---|---|---|---|---|
| 1 | AW-TEE-BLK-M | Essential tee, black, M | 18.50 | 49.00 | 0.19 | 2026-08-01 | supplier invoice |
| 2 | |||||||
| 3 |
Every column, explained
| sku | Your own variant code, exactly as your shop has it. |
|---|---|
| product | A human-readable name, for your own sanity. |
| unit_cost | What one unit costs you, landed where possible. Line 17 of the statement. |
| sell_price_gross | The shelf price including VAT, as the customer pays it. |
| vat_rate | As a decimal: 0.19 for 19%. |
| effective_from | The first day this row applies. Everything before it keeps the previous row. |
| source | Where the cost came from: supplier invoice, catalogue, landed calculation. |