To plan Black Friday inventory, forecast unit demand for the full promotion window, add a safety buffer, then subtract sellable stock and confirmed inbound units. Do this SKU by SKU. A single store-wide growth percentage can leave bestsellers empty while slow products trap cash.
The timing matters in 2026. Adobe’s September 28 holiday forecast expects U.S. online spending to reach $275.1 billion from November 1 through December 31, up 6.7% year over year. It also forecasts $47.5 billion during Cyber Week and says October online spending is accelerating. These are market-level forecasts, not a promise that every seller or product will grow at the same rate.
This guide gives small online sellers a practical Black Friday inventory formula, three demand scenarios and a purchase-order checklist. Use the free Inventory Reorder Point Calculator to turn your chosen daily sales rate, supplier lead time and safety-stock cover into a reorder trigger.
The Black Friday inventory formula
Start with four numbers for each SKU:
- Forecast demand: the units you expect to sell during the promotion and fulfilment window.
- Safety stock: extra units held for stronger demand, late replenishment or inventory errors.
- Sellable stock on hand: units physically available after damaged, returned, reserved and sample stock are removed.
- Confirmed inbound stock: purchase orders with a realistic arrival date before the product is needed.
Order quantity = forecast demand + safety stock − sellable stock on hand − confirmed inbound stock
If the result is zero or negative, you do not need another order for that scenario. Do not round a negative result into a speculative purchase. Instead, check whether the excess stock should be included in the promotion or preserved for December.
Step 1: Build a clean daily-sales baseline
Use recent unit sales, not revenue. Discounts can raise unit volume while reducing revenue per order, so a revenue-only forecast can hide the number of items you must pack.
A useful baseline is:
Baseline daily units = comparable units sold ÷ comparable selling days
Choose a comparable period with normal availability and no major stockout. If a listing was unavailable for six days, remove those days rather than treating zero sales as ordinary demand. Also separate variants: a medium black shirt and a large blue shirt cannot fulfil each other’s orders.
Review your sell-through rate before increasing the forecast. A product that moved only 20% of its available stock during the last promotion should not automatically receive the same growth multiplier as a proven bestseller.
Step 2: Create three demand scenarios
No public holiday forecast can predict your exact SKU demand. Build a range from your own store data:
| Scenario | How to set it | Use it for |
|---|---|---|
| Conservative | Recent daily units plus only the uplift already supported by traffic, email or marketplace data | Slow movers, new listings and cash-constrained buys |
| Base | Last comparable promotion adjusted for this year’s price, audience and promotion length | Your operating purchase plan |
| Stretch | A deliberately higher case that tests what happens if a bestseller materially exceeds plan | Backup stock, supplier capacity and stop-sale rules |
For each scenario:
Forecast demand = baseline daily units × expected demand factor × promotion days
The demand factor must come from evidence you can explain: last year’s BFCM units, a recent launch, email-list growth, ad budget, marketplace traffic or confirmed wholesale orders. Do not copy Adobe’s 6.7% market forecast into every SKU. Adobe covers U.S. ecommerce overall, while your product mix, price and channel can behave very differently.
Step 3: Add safety stock without buying blindly
Safety stock is a buffer, not a second forecast. Add more when supplier lead time varies, a stockout would damage marketplace rank, the item is a gift-season bestseller or a replacement shipment would arrive after Cyber Week.
A simple seasonal method is:
Safety-stock units = forecast daily units × buffer days
For a more detailed method using maximum demand and maximum lead time, see the safety stock formula guide. Reduce the buffer for dated, personalised, bulky or trend-sensitive inventory where leftover stock has a high cost.
Shopify’s current 2026 BFCM guidance recommends using historical sales, purchasing safety stock, setting low-stock alerts and configuring automated reorder points. That is a useful operating framework, but your buffer still needs to reflect your own lead time and risk.
Worked example: how many units should you order?
Assume a seller is planning a ten-day promotion for one proven SKU:
- Normal daily sales: 10 units
- Base-case demand factor: 1.8
- Promotion window: 10 days
- Safety buffer: 5 days at the forecast rate
- Sellable stock on hand: 160 units
- Confirmed inbound stock arriving before launch: 40 units
First calculate forecast daily sales:
10 × 1.8 = 18 units per day
Then calculate promotion demand:
18 × 10 = 180 units
Safety stock is:
18 × 5 = 90 units
The suggested order quantity is:
180 + 90 − 160 − 40 = 70 units
Seventy units is the base-case gap, not an automatic purchase order. The seller should still check the supplier’s minimum order, arrival date, unit cost, storage cost and likely value of leftovers. Run the conservative and stretch scenarios beside it before committing cash.
Step 4: Reset the reorder point for peak demand
A reorder point answers when to order, not how much to buy. Shopify’s 2026 inventory guidance defines it as average daily sales multiplied by supplier lead time, plus safety stock. For Q4, use the forecast peak-period daily rate rather than a quiet annual average.
Reorder point = forecast daily units × supplier lead-time days + safety-stock units
Enter peak daily units, actual supplier lead time, safety-stock days and current stock in the reorder point calculator. Recalculate after a major promotion starts; real sales velocity is more useful than a forecast once several days of clean order data exist.
Step 5: Rank SKUs before allocating cash
Put every SKU into one of four groups:
- Proven winners: high sell-through, acceptable margin and dependable replenishment. Protect these first.
- Traffic products: popular entry-price products that support bundles or larger baskets. Stock them only if the full order remains profitable.
- Unproven products: new or lightly tested listings. Use smaller buys, preorder limits or a conservative scenario.
- Slow stock: products with weak sell-through or ageing inventory. Sell existing units before ordering more.
Use inventory turnover to spot cash tied up in slow stock. Maintain unique variant identifiers with the SKU-number guide so sales, stock and purchase orders match.
Protect margin as well as availability
A product can sell out and still lose money. Before increasing inventory, test the planned discount, marketplace fees, ad spend, pick-and-pack cost, shipping subsidy and likely return cost. The Black Friday discount guide shows how to set a margin floor before publishing a deal.
Amazon sellers should also include peak fulfilment and storage costs. The current Amazon FBA holiday peak-fee guide explains why a higher unit forecast does not automatically create a better contribution margin.
A two-week inventory control plan
- Every day: check overselling, cancellations and stockouts on campaign SKUs.
- Every two to three days: compare actual unit velocity with the conservative, base and stretch cases.
- At the reorder trigger: confirm lead time and delivery capacity again before placing the order.
- When actual sales fall below plan: pause reorders before increasing discounts.
- When actual sales exceed the stretch case: protect customer promises with quantity limits, updated dispatch times or a controlled stop-sale point.
- After Cyber Monday: recalculate December demand instead of carrying the BFCM rate forward unchanged.
Black Friday inventory checklist
- Count sellable stock by SKU and variant.
- Remove damaged, reserved and unavailable units.
- Confirm inbound quantities and realistic arrival dates.
- Calculate recent daily unit sales without stockout days.
- Build conservative, base and stretch demand cases.
- Add a risk-based safety buffer.
- Subtract on-hand and confirmed inbound stock.
- Check cash, margin, storage and leftover-stock risk.
- Reset reorder alerts using peak-period demand.
- Assign an owner to monitor actual sales during the event.
Frequently asked questions
How much extra inventory should I buy for Black Friday?
There is no safe universal percentage. Forecast each SKU from comparable unit sales, promotion length and a justified demand factor, then add safety stock and subtract sellable on-hand and confirmed inbound units.
Should I use last year’s Black Friday sales?
Yes, when the product, price, channel and promotion are comparable. Adjust for stockouts, changed ad spend, audience growth, discontinued variants and a different number of selling days.
What if I have no Black Friday history?
Use recent normal sales, results from a smaller promotion and a conservative scenario. Keep the first order smaller, arrange rapid replenishment where possible and set a stop-sale point before customer promises become risky.
Does a reorder point tell me how many units to order?
No. A reorder point is the stock level that triggers action. The order quantity depends on forecast demand, target cover, current stock, inbound units, supplier minimums and cash limits.
Should incoming purchase orders count as available stock?
Count only confirmed units that are likely to arrive, be checked and become sellable before they are needed. Treat unconfirmed production or a tight customs schedule as risk, not guaranteed inventory.
When should I update the forecast?
Update it when price, promotion dates, ad budget, supplier lead time or stock availability changes. During BFCM, compare actual sales with all three scenarios every two to three days.