Inventory is cash sitting on a shelf. Too little and you lose sales and customers to "out of stock". Too much and your money is stuck in boxes while bills come due. Large retailers use expensive software; small shops can get most of the benefit with a simple habit.
Do a full count once. Every product, every variant (size, colour). Record it in your online shop or a spreadsheet with these columns: product, variant, SKU, quantity, cost price, sale price, supplier, lead time.
From then on, stock updates automatically when you sell online. For in-person sales, record them the same day — a point-of-sale app linked to your shop does this for you.
| Group | What it is | How to manage |
|---|---|---|
| A | The ~20% of products bringing ~80% of revenue | Never run out. Check weekly. |
| B | Steady middle sellers | Check every two weeks. |
| C | Slow sellers | Order small quantities; consider discontinuing. |
A reorder point is the stock level at which you order more. Simple formula:
Reorder point = (average daily sales × supplier lead time in days) + safety stock
If you sell 4 a day, the supplier takes 10 days, and you keep 10 as safety stock: 4 × 10 + 10 = 50. When stock hits 50, order. Set a low-stock alert at that number so the system tells you.
Look at last year's sales for the same months. Order seasonal stock early, but in two waves — a first order for the expected volume and a smaller top-up once you see how the season starts.
Once or twice a year, plus spot-checks of A items monthly. Differences reveal theft, damage or recording mistakes.
A spreadsheet works up to around 100 products. Beyond that, use your shop platform's inventory features.
Volnyn's shop tracks stock per variant, sends low-stock alerts and its AI spreadsheet can calculate reorder points for you. Start free at volnyn.com.