7 columnsCSV
Anyone whose supplier prices move
Price list with effective dates
What this file is
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.
What is inside
One header row, one filled example.
A price history rather than a price list: every row carries the day it took effect, so a cost rise prices the orders that came after it and leaves the ones before it alone.
Rows 1 and 2 are the file. Click any cell to read it; the foot of the sheet says what its column is for.
A2AW-TEE-BLK-M
| Row | A | B | C | D | E | F | G | H | I |
|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | product | unit_cost | sell_price_gross | vat_rate | effective_from | source | ||
| 2 | AW-TEE-BLK-M | Essential tee, black, M | 18.50 | 49.00 | 0.19 | 2026-08-01 | supplier invoice | ||
| 3 | |||||||||
| 4 | |||||||||
| 5 | |||||||||
| 6 | |||||||||
| 7 |
nouz-price-list
A · skuYour own variant code, exactly as your shop has it.
Every column, explained.
In the order they sit in the file. Point at one and it is outlined in the sheet.
Behind the file
Why it is built this way.
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.
In nouz
Where prices and costs meet in nouz.
On the Products page, each variant's unit cost sits beside its sales price, and the margin per unit follows. Sales prices come from Shopify; costs are yours, each from the day it starts.
More templates
More free files, same format.
Anyone with a 3PL or carrier contract
Shipping rate card
Zone by weight bracket, the way carriers actually bill.
5 columnsCSV
5 columnsCSV
Your daily P&L, without the spreadsheet.
nouz works out your real profit every night, after product costs, shipping, payment fees, ad spend and running costs, and sends it to your inbox each morning.
Your trialToday
14 days of nouz, every feature€0,00
Card needed to startNone
Access to your storeRead-only
Due today€0,00