Start with the Sales Data You Already Own
Begin with each SKU’s own completed sales history, not a market benchmark or an assumed growth rate. Separate units ordered, delivered units, cancelled orders, returned units and saleable stock returned to inventory. For revenue forecasting, ORVX calculates realised revenue from delivered orders only and excludes returned or cancelled orders; it also reports return rate by units and refund value against revenue.
Mark promotions, price changes, bundles and product launches in the history. A shampoo selling 20 units during a promotion and 10 units in comparable non-promotional periods should not automatically be forecast at 20. Keep the promotional result visible, then compare it with the SKU’s normal periods. Treat a stockout differently again: zero sales while unavailable is missing demand, not evidence that demand fell.
Recalculate the mix when products are added, discontinued or bundled. Forecast the SKU first, then check whether collection totals still make sense; a new conditioner may replace some demand for an older one rather than add to it. ORVX can show product- and collection-level profitability, inventory position, dead stock and remaining stock value. Use the inventory reorder calculator with those observed figures, and record which periods were excluded and why.
| History signal | Treatment |
|---|---|
| Returns or cancellations | Separate them from delivered sales and identify whether returned units are saleable. |
| Promotion or price change | Flag the period; do not assume the uplift repeats. |
| Stockout | Mark unavailable days so zero sales is not treated as zero demand. |
| Product mix change | Reforecast affected SKUs and check collection-level substitution. |
Choose the Right Reorder Measure
No single measure answers every stock decision. Separate the point that triggers a purchase from the quantity ordered, then choose the measure that matches the SKU’s demand pattern and cash constraints.
Use the inventory reorder calculator to test the calculation, but keep the decision tied to each product’s own sales and stock position.
| Measure | What it is for | When to act |
|---|---|---|
| Reorder point | A trigger based on expected demand before the next delivery arrives, plus any buffer you choose. | Act when inventory position reaches or is forecast to cross the point. Use it for routine replenishment of steady sellers. |
| Minimum stock | A hard floor intended to prevent stock falling below an acceptable level. | Act when projected stock approaches the floor. Use it for hero products, essentials or SKUs where a stockout is particularly costly. |
| Days of cover | Current available units divided by average daily unit sales. | Act when cover falls below the number of days needed to replenish. Use it when sales rates change quickly or when comparing products with different sales volumes. |
| Economic order quantity (EOQ) | An order-size calculation balancing ordering costs against inventory-holding costs. | Use it to set quantity after deciding to buy; do not treat it as the reorder trigger. Adjust for cash limits, supplier minimums and practical pack sizes. |
Worked example with sample numbers
This example is illustrative. It uses sample numbers for a haircare store selling in the UK. They are made up to show the method, they are not a benchmark, and your own figures will differ.
Formula: Reorder point = daily units x (lead time + safety days).
| Input | Value |
|---|---|
| Units sold per day | 16 |
| Supplier lead time in days | 26 |
| Safety cover in days | 8 |
| Reorder at | 16 x (26 + 8) = 544 units |
| Cash tied up at cost | £3913.16 |
Run the same sum with your own numbers in the free calculator, or browse guides for sellers in the UK and more haircare guides.
General information only: tax, duty and import rules change and depend on your situation, so check with an accountant or the official source before acting.
Eligible Shopify stores can see these numbers for their own store through the Founding 10,000 offer.
Lead Time and Safety Stock for UK Orders
For UK haircare orders, lead time runs from purchase order to sellable stock. Record supplier processing or production, freight, applicable customs clearance and warehouse receiving separately; dispatch is not check-in. Set reorder point as expected demand during total lead time plus safety stock.
Use the SKU’s selected demand measure in the unit used by lead-time records. Average lead time suits routine planning; use a longer observed lead time where delays risk stockout or delivery history varies materially. Do not replace supplier evidence with a generic UK assumption.
Safety stock protects against faster demand and slower deliveries. Increase it when either causes shortages; reduce it when unused and cash is tied up. Review after changes to suppliers, freight routes, order frequency or sales patterns. Test the calculation with the inventory reorder calculator.
How to Read the Worked Reorder Example
Read left to right: demand during lead time is units sold while a replacement travels and becomes sellable: 8 units daily × 10 days = 80 units, not order quantity. Add 24 safety-stock units: reorder point = 80 + 24 = 104. When inventory position reaches 104 units or fewer, it triggers review or ordering, not purchase quantity. For changed figures, verify matching demand unit and period, the full supplier-to-sellable lead time, no double-counted unusually high sales, and that inventory position includes sellable stock, units on order and committed units. Test recent demand, delayed delivery and slow sales with the free reorder calculator. ORVX reports inventory position, dead stock and remaining stock value, so the trigger is read alongside stock tying up cash.
What Haircare Stock Costs to Hold
The purchase invoice is only the first cost of holding haircare stock. Cash tied up equals unit cost multiplied by sellable quantity: 100 bottles at £6 is £600 unavailable for wages, marketing or other purchases. Add recurring storage and insurance, expected damage, and the cost of units that expire, become obsolete or need discounting. Financing also has a cost: if £600 is funded by borrowing, apply the agreed rate and holding period; if it is your own cash, compare the return you could have earned elsewhere.
Use purchase cash when deciding whether you can afford a buy. Use storage, insurance and financing when comparing a small frequent order with a larger one. Use damage and expiry assumptions when setting a maximum stock level, particularly for products with short usable lives. The table separates the inputs so a £48 monthly carrying cost is not hidden inside the £600 stock value.
| SKU | Unit cost (£) | Quantity | Stock value (£) | Storage (£/month) | Insurance (£/month) | Damage/expiry (£/month) | Finance (£/month) |
|---|---|---|---|---|---|---|---|
| Shampoo | 6.00 | 100 | 600.00 | 18 | 3 | 12 | 15 |
| Treatment | 9.00 | 50 | 450.00 | 14 | 2 | 8 | 10 |
Planning for UK Seasonal Peaks
Build the seasonal forecast from comparable weeks: 70 weekly shampoo units in September versus 120 during last year’s November promotion means 50 extra units weekly, or 200 across four weeks, less sellable stock held or due. Mark promotions, launches, payday activity and ad increases, comparing each with the closest past event.
Work backwards from stock availability, allowing for supplier processing, transit, delivery checks and buffer. For a 1 November promotion and 10 October supplier cut-off, ordering later may mean a smaller campaign, substitute SKU or stockout. Record decisions by product, as lead times and minimum order quantities differ.
Keep the extra 50 units temporary unless comparable, non-promotional weeks remain above the 70-unit baseline. A sustained change can reset the baseline; one campaign should alter the order plan, not permanently inflate the reorder trigger.
A practical inventory plan links each reorder decision to the store’s own sales, realistic UK lead times and the cash cost of carrying stock. Review the inputs when demand, suppliers or seasonal plans change, and use the measure that matches the decision rather than relying on a single stock rule.
Sources
- VAT registration: when to register (GOV.UK (HM Revenue & Customs), checked 26 October 2026).
How this page was made: drafted with AI from a brief, then checked by automated rules for arithmetic, sources and duplication. The sample numbers were calculated, not reported.