Fragrance Seasonal Sales Planning in the UK: Cash, Stock and Ads

Reading Your Own Seasonal Pattern

Group completed orders by week or month and compare like periods across years. Record order count, delivered revenue, gross margin, refund value, return rate and acquisition cost. Exclude cancelled orders from order and revenue totals; assign returns to the period in which they affect reporting.

Use the measure that reveals the pattern: 80 to 120 orders signals demand; £4,000 to £5,000 revenue may not if average order value or margin fell. £5,000 at 60% gross margin produces £3,000 gross profit; £5,500 at 45% produces £2,475. Add advertising cost to test contribution versus low-margin sales.

ORVX connects Shopify orders, products and customers with advertising accounts, calculates realised revenue from delivered orders, and reports product, collection and customer profitability, return rate by units, refund value against revenue and consistent trading currency. Compare MER (total ad spend against store revenue) with attributed ROAS (revenue assigned to ads): blended efficiency versus channel or campaign analysis.

Choose the Measure That Fits the Decision

Choose the measure according to the decision, not the easiest number to report. Units are useful for judging demand, sell-through and return patterns. Revenue shows the size of sales, but discounts, cancellations and returns can make it a poor guide to what the shop keeps. Contribution margin is the stronger measure for deciding whether a product, collection or promotion is economically worth repeating. Cash movement answers a different question: whether payments from customers arrive in time to cover stock, wages, tax and suppliers. Customer acquisition cost (CAC) should guide prospecting decisions, but only alongside the profit generated by those customers and their repeat behaviour.

For illustration only, 100 discounted bottles may produce more units but less contribution than 60 full-price bottles. ORVX calculates realised revenue from delivered orders, derives profit and margins from product costs, and reports contribution after advertising, including by product and collection. It also shows customer profitability and repeat behaviour, so CAC is not judged in isolation.

Planning Stock Before the Peak

Use completed-order history to identify peak products. Map supplier lead times, minimum orders and delivery reliability to required stock dates. Opening stock is inventory available then; reorder point is the level at which a new order covers lead-time demand. Calculate by product, not store-wide.

Keep visible the mix: core fragrances, seasonal lines, gift sets and slower variants differ in sales rates, margins and replenishment constraints. Use units for availability and sell-through, revenue for sales value at risk, and gross profit or contribution after advertising to allocate scarce stock and cash. High revenue may still be poor capital use when product cost, returns or advertising reduce contribution.

Cash committed is units on hand × unit cost: 20 bottles at £18 tie up £360 before selling costs. ORVX reports remaining stock value, dead stock and inventory position; its inventory reorder calculator tests arithmetic without creating a stock target or placing an order.

Allocating Ad Budget Across the Year

Allocate by calendar, product/collection and channel: increase spend where completed-order contribution is stronger, stock is available and contribution profitable; hold stable periods, proven capacity-limited lines or uncertain small samples; reduce or stop where contribution repeatedly weakens, returns or excess stock are high, or thresholds fail. Use attributed ROAS for credited channel performance and MER for total advertising efficiency. Contribution, not revenue, is the guardrail: £60 less £24 product cost and £18 advertising leaves £18 (30%). ORVX reports contribution after advertising and profitability by product and collection from delivered-order results, excluding cancellations and returns.

Keeping the Cash Plan Current

Keep the plan as a dated schedule, not a single peak total. Add each stock invoice on its actual payment date, including deposits, balances and supplier credit terms. A large purchase may be profitable over the season but still create a cash gap before customer payments arrive.

Record expected sales receipts by settlement date rather than order date. Then update them with actual receipts as the peak approaches. Keep advertising spend and fulfilment costs on the dates they leave the account; include per-order pick, pack, delivery and any fixed peak surcharges.

Refunds need their own line. Record both the expected timing and the value, then revise the plan when refunds are issued. This is separate from profitability: ORVX calculates realised revenue from delivered orders only and excludes returned or cancelled orders, while reporting return rate by units and refund value against revenue.

Review the cash schedule weekly against ORVX product and collection profitability. Its cost model shows gross and net profit, contribution after advertising and remaining stock value; those measures explain whether a cash-heavy purchase is supporting profitable sales or tying money up in slow stock. The cash plan decides when money is available to pay.

What to Review After the Peak

After the main return window, compare forecast with delivered sales: revenue and units for variance, sell-through against stock bought, and gross margin for economic value. Review products and collections separately to expose slow gift sets or low-margin promotions. ORVX calculates realised revenue from delivered orders, derives gross profit and margin from its product cost model, and reports remaining/dead stock and stock value.

Review MER (total revenue against ad spend) and attributed ROAS (campaign revenue): use MER for budget decisions and ROAS for campaign investigation. Check unit returns and refund value against revenue; reconcile supplier payments, ad charges, refunds and closing cash by date. Make each finding a specific next-plan change.

• Scale: demand and margin held, sell-through was strong, and ad efficiency met target.
• Reduce or test: forecast error, rising returns, or sales only after heavy discounting.
• Fix economics or stop: tied-up stock, negative contribution after advertising, or unsafe cash timing. Record evidence and review against the next period’s actuals.

A seasonal plan should connect the decisions rather than treat sales, stock, cash and advertising as separate reports. Use your own order history to identify the periods that matter, choose the measure suited to each decision, and update the plan as actual results replace assumptions. The worked example should be read as a demonstration of that process: follow how each input changes the stock, cash or advertising decision, then replace the example figures with your store’s records.