A small retailer sold out of two bestsellers before Christmas last year.
This year, the order quantities kept growing until a different risk appeared:
"How do you decide what's enough without accidentally turning your back room into a warehouse until February?"
That is the real Q4 inventory problem.
It is not choosing between being optimistic and being cautious. It is deciding which products deserve protection from a stockout, which purchases can wait for more evidence, and which leftovers would damage cash, space and margin if the forecast is wrong.
The safest Q4 plan is not one giant order.
It is a set of smaller decisions made according to the cost of being wrong.
Source discussion:
https://www.reddit.com/r/InventoryManagement/comments/1vqvrx8/anyone_else_scared_of_underordering_for_q4/
The two mistakes do not cost the same for every product
Underordering can mean:
- lost sales during the few weeks when demand is strongest
- customers switching to an available alternative
- repeated emergency orders and extra freight
- a bestseller disappearing when there is no supplier capacity left
- staff spending the peak explaining empty shelves
Overordering can mean:
- cash tied up before the busiest trading weeks
- a back room that cannot support normal receiving and fulfilment
- January markdowns that remove the expected margin
- products ageing, expiring or becoming less relevant
- less budget for a product that proves itself during the season
But those costs are not symmetrical across the range.
A proven, high-margin item with an eight-week lead time and no second production run may be expensive to underorder. Once it is gone, the sale cannot be recovered.
A low-margin item that can be replenished in seven days may be expensive to overorder. The retailer can wait for more evidence without accepting much stockout risk.
This is why copying one growth percentage across every SKU creates false confidence. The same buffer can be too small for one product and reckless for another.
Build one decision card for every meaningful Q4 SKU
Do not begin with the supplier's cart total. Begin with a short evidence card for each product or tightly related product group.
1. Comparable seasonal demand
Use the most comparable period available.
Check:
- units sold during the previous Q4 or relevant event
- weeks when the product was actually available
- promotions, price changes or unusual events
- returns and cancellations
- whether a stockout suppressed the recorded sales
- whether channels or locations have changed since last year
If a product sold out on 10 December, the recorded December sales are not the full demand. They are the demand the available stock allowed the business to capture.
For a new product, replace certainty with a range. Use a small test, related-category evidence, customer interest, supplier flexibility and a clear maximum exposure. Do not turn a guess into a precise-looking forecast.
2. Sellable stock and confirmed inbound
Separate what is available from what merely exists in a record.
Count:
- sellable stock now
- stock reserved for existing orders
- damaged or quarantined units
- confirmed purchase orders
- stock in transit
- stock discussed with a supplier but not ordered
An informal supplier promise is not confirmed inbound. A delivered carton is not sellable until it has been received and checked.
3. Supplier lead time and flexibility
Record more than the average delivery time.
Ask:
- What is the final order date for peak-season delivery?
- Can the supplier replenish during Q4?
- Is the product made in one seasonal run?
- What is the minimum order or case size?
- Can delivery be split into stages?
- How often has the supplier been late?
- Is there a credible substitute supplier?
Lead time determines how long a wrong decision remains wrong.
Current inventory-planning guidance from Shopify makes the same connection: supplier lead time informs reorder points and safety stock, while storage, ordering cost and regular monitoring shape the wider plan.
Reference:
https://www.shopify.com/uk/blog/inventory-planning
4. Cash, margin and space exposure
For each planned purchase, calculate the commitment the business must carry before the sale arrives.
Record:
- landed purchase cost
- expected selling margin
- deposit and payment dates
- storage or handling requirement
- likely markdown or disposal cost
- how long cash may remain tied up after the peak
The sales forecast may look attractive while the cash calendar is impossible. A purchase order can be commercially sensible and still leave too little working capital for payroll, rent, freight or a faster-moving opportunity.
5. The exit if demand is weaker
Every seasonal purchase needs an exit route before the order is placed.
Possible exits include:
- continuing to sell the product after Christmas
- transferring it to another location
- bundling it with a stronger product
- returning it to the supplier where terms permit
- using planned markdown stages
- holding it for the next relevant season
If the only exit is a deep January discount, include that margin in the decision now.
Put products into four Q4 order groups
Once the cards are complete, stop treating the range as one forecast.
Group 1: protect availability
These products normally have:
- strong comparable demand
- healthy margin
- long or inflexible lead time
- a high cost of stocking out
- a credible post-season selling route
They deserve the strongest initial commitment and a deliberate safety buffer.
The buffer still needs a limit. Proven demand is not unlimited demand, and last year's winner can be affected by price, competition, customer behaviour or a changed assortment.
Group 2: stage the commitment
These products have reasonable demand confidence but more replenishment flexibility.
The retailer may place an initial order, keep budget available and define a second-order trigger. For example:
`Release the second order when two weeks of sales are above the base case and remaining stock cover falls below supplier lead time plus the agreed buffer.`
This group prevents the first order from consuming every pound and every shelf before current-season evidence arrives.
Group 3: test cautiously
These are new, trend-sensitive or highly seasonal products without dependable history.
Use:
- smaller opening quantities
- supplier samples or test cases
- preorders where suitable
- customer-interest evidence
- short review windows
- a fixed maximum cash exposure
The objective is not to avoid new products. It is to buy information without making the first test responsible for the whole Q4 plan.
Group 4: avoid or clear before the peak
Some products should not compete for Q4 cash or space.
Examples include:
- existing aged stock with weak demand
- products with poor margin after expected markdowns
- duplicate variants that split demand
- items with unreliable records
- stock that blocks space needed for proven seasonal lines
Resolve those issues before new seasonal deliveries arrive.
Use three demand cases, not one perfect forecast
A single forecast invites an argument about whether the number is right.
Three cases make the decision visible:
1. Downside case: demand is weaker than expected.
2. Base case: the most defensible current expectation.
3. Upside case: demand is stronger, but still plausible.
For each case, calculate:
- expected units sold
- ending stock
- likely stockout date
- cash committed
- storage used
- expected full-price and markdown margin
Then ask two questions:
1. Which case can the business survive?
2. Which products can be corrected during the season if reality moves away from the base case?
This is more useful than pretending one number has removed uncertainty.
Keep part of the plan deliberately uncommitted
An empty portion of the budget is not failed planning. It is an option.
Reserve some combination of:
- purchasing cash
- supplier capacity
- storage space
- staff time for receiving
- promotional budget
Use that reserve when actual sales, supplier performance or customer interest provides better evidence.
The exact reserve depends on the business. What matters is deciding it before the first order absorbs everything.
Set the review schedule before Q4 becomes busy
A Q4 plan should say when it will be challenged.
Useful checkpoints include:
- when the supplier confirms production
- when the first shipment leaves
- after receiving and counting the first delivery
- after the first seven or fourteen selling days
- before the final replenishment cut-off
- immediately after a promotion or unexpected demand spike
Track a small set of measures:
- sell-through by SKU
- weeks or days of supply
- stockout days
- supplier lead-time changes
- open and confirmed inbound
- cash still committed to unsold seasonal stock
- storage capacity used
- markdown exposure
Current Shopify guidance defines weeks of supply as on-hand stock divided by average weekly units sold and notes that the appropriate buffer depends on product, industry and lead time.
Reference:
https://www.shopify.com/uk/blog/inventory-planning
Connect planning to the in-season stock decision
This Q4 plan decides what to commit before the peak.
Once trading begins, each product still needs a recurring action:
- reorder
- hold
- investigate
- discount
The companion guide explains that weekly decision:
https://ezycarto.com/blog/reorder-hold-or-discount-stock-decision-guide
The two jobs are connected but different. Pre-season planning allocates risk and budget. In-season review reacts to real stock, demand and supplier evidence.
Where EzyCarto fits
Seasonal planning is only as trustworthy as the records underneath it.
EzyCarto's current public scope includes connected product and stock records, supplier information, purchase orders, receiving, warehouse and location visibility, stock movement, reports and analytics. Those records can help a retailer assemble the evidence needed for a Q4 review.
EzyCarto does not currently claim to produce an automatic seasonal forecast or make the purchase decision for the retailer.
The useful role of the system is to reduce the time spent reconstructing what is sellable, what has sold, what is inbound, where stock sits and what changed. The retailer still decides the demand cases, acceptable exposure, supplier assumptions and final quantity.
Explore EzyCarto Supply Chain:
https://ezycarto.com/supply-chain
Q4 order review checklist
Before approving the seasonal order, confirm that the team can answer:
1. Which prior period is genuinely comparable?
2. Did a previous stockout hide unmet demand?
3. What stock is sellable now?
4. What inbound stock is confirmed rather than assumed?
5. What is the realistic supplier lead time during the peak?
6. Which products can be replenished after Q4 starts?
7. Which stockouts would be most expensive and impossible to recover?
8. Which leftovers would tie up the most cash, space or margin?
9. What is the downside, base and upside case for each important group?
10. How much budget and space will remain uncommitted?
11. What event releases the contingency order?
12. What is the exit route for every seasonal product?
13. Who reviews the plan, and on which dates?
The objective is not to predict Christmas perfectly.
It is to make sure one uncertain forecast cannot turn into one oversized bet.
Sources
- Retailer Q4 ordering discussion:
https://www.reddit.com/r/InventoryManagement/comments/1vqvrx8/anyone_else_scared_of_underordering_for_q4/
- Current Q4 stockout and overstock discussion:
https://www.reddit.com/r/AmazonFBAonline/comments/1vta1n6/my_q4_inventory_planning_mistakes_from_last_year/
- Shopify UK inventory planning:
https://www.shopify.com/uk/blog/inventory-planning
- Shopify reorder-point guide:
https://www.shopify.com/blog/reorder-point
- Lightspeed seasonality forecasting context:
https://www.lightspeedhq.com/news/lightspeed-unveils-seasonality-forecasting-to-help-retailers-increase-profit-and-reduce-days-out-of-stock/