Black Friday stock planning: how much to buy without running out of cash in January

How to size Black Friday and Christmas stock for a Shopify brand, plan the cash behind it, and avoid the January squeeze of slow sales, returns and leftover stock.

Illustration for Black Friday stock planning: how much to buy without running out of cash in January

Black Friday is the week most ecommerce brands plan hardest for sales and least for cash. The stock is paid for in September and October, the revenue comes in late November and December, and the bills that follow land in January and February when sales are at their slowest. Getting the quantity right is half the job. Funding it is the other half.

Start from last year, then adjust

Pull your sales by SKU for the Black Friday week and the following four weeks last year. Then adjust for three things:

  • Growth. If the store is running 30% ahead of last year in September and October, that is a reasonable starting uplift.
  • Discount depth. A deeper discount than last year usually means more units, at lower margin.
  • Ad budget. If you are spending twice as much on ads, expect more volume, but not twice as much.

If you have no history, use your best recent month and multiply carefully. Brands commonly sell somewhere between two and four times a normal week during Black Friday week, but the range is wide and your own data beats any benchmark.

Size the order by SKU, not by total

A total budget hides the real risk. Split the catalogue:

GroupApproach
Hero products, top 10 to 20% of SKUsPlan for your high case. Stockouts here cost the most.
Steady sellersPlan for your expected case.
Slow or new linesPlan for your low case, or do not discount them at all.

For each SKU, work out units for the peak period, add safety stock, then subtract what you already hold and what is on order. How much stock to order walks through that calculation, and safety stock formula covers the buffer.

Check the lead times now

If a supplier needs eight weeks, the order for Black Friday week had to go in by late September. For a top-up order that arrives in time for the Christmas shipping cut-off, check the real lead time today and work backwards. Freight and factories are busier in Q4, so expect delays rather than hoping for none.

Plan the cash month by month

Lay the stock spend against expected revenue in a simple monthly view:

MonthCash outCash in
SeptemberDeposits on peak stockNormal sales
OctoberBalance payments, freightNormal sales
NovemberAd spend, top-up ordersBlack Friday sales
DecemberAd spendChristmas sales
JanuaryQ4 bills, returns refunds, spring depositsSlow sales

The pinch points are usually October, when stock is paid for and not yet sold, and January, when refunds go out, ad bills arrive and the spring range needs deposits. For UK brands the October to December VAT bill then lands in early February. VAT and cash flow covers how to plan for it.

The January squeeze

The most common Black Friday mistake is not running out. It is buying too much of the wrong lines, then starting January with a full warehouse and an empty bank account.

Three things help:

  • Agree a cut-off date. Any top-up order after it has to be justified by real sales, not hope.
  • Track sell-through daily during peak week. If a line is behind plan by the Sunday, stop advertising it and push the lines that are selling.
  • Plan for returns. Peak season return rates are usually higher than the rest of the year. Hold back cash for refunds rather than treating all December revenue as yours.

Whatever is left in January becomes the slow stock you have to clear. Dead stock covers what to do with it.

Where Cushion fits

Cushion puts the peak season stock plan and the cash forecast in one view, so you can see what the order you are about to place does to your balance in October and January before you place it. It connects read-only to Shopify, Xero and QuickBooks. Join the waitlist for early access.

FAQs

When should I place Black Friday stock orders?

Work back from the date you need stock sellable, using your real lead time plus a buffer for Q4 delays. For many overseas suppliers that means August or September.

How much more should I order for Black Friday?

Start from last year's sales by SKU for the same weeks, then adjust for growth, discount depth and ad budget. Plan heroes at your high case and slow lines at your low case.

What if I run out during Black Friday week?

Turn off ads on that product, offer a back-in-stock signup and push a close alternative. A stockout on one hero is cheaper than over-ordering every line to avoid it.

Filed underInventory PlanningCash FlowShopify
Rory McLaughlan
Written by

Rory McLaughlan

Runs a Shopify store selling mystery football shirt boxes across the UK, EU and US. Built Cushion after years of joining up a cashflow sheet, a stock sheet and a sales forecast in his head every Sunday night.

See whether the next reorder leaves enough cash

Cushion puts your cashflow, stock and sales forecast on one screen, with read-only connections to your store, your books and your bank.