Holiday Inventory Planning for Small Retailers (With Template)

Holiday inventory planning comes down to three numbers per product: how many you sold last season, how long your supplier takes to restock you, and how much safety stock you need for surprises. This guide shows small retailers how to forecast from last year’s sales, set reorder points with a simple formula, fix stockouts and overstock fast, and run the whole thing from a one-page template.

Why Holiday Inventory Is Harder Than the Rest of the Year

For many small retailers, November and December carry a big share of annual revenue in a short window. That compresses everything. A stockout in March costs you a week of sales; a stockout on December 12 can cost you the rest of the season, because reorders may not arrive in time. Overstock is just as painful: seasonal goods lose value fast after Christmas, and cash tied up in boxes is cash you cannot spend on January rent.

The calendar also shifts. In 2026, Thanksgiving falls on Thursday, November 26, so the shopping window between Black Friday (November 27) and Christmas (Friday, December 25) is four weeks. Christmas on a Friday means last-minute shoppers get a full Thursday, plus the weekend before. If last year’s dates fell differently, line your history up by “weeks before Christmas” and “Black Friday week”, not by calendar date.

Your 2026 holiday inventory timeline

When	What to do
Early November	Finish forecast, confirm supplier dates and peak lead times, place main orders for A items.
Mid-November	Receive and price stock; start weekly sell-through checks.
Nov 26-30	Thanksgiving, Black Friday, Small Business Saturday (Nov 28) and Cyber Monday. Check A-item stock daily.
Early December	Last reorders for A items based on your last-reorder dates; push lagging items.
Mid-December	Switch to substitutes and gift cards for anything sold out; stop promising delivery dates you cannot meet.
Dec 26 onward	Start planned markdowns and returns.
Early January	Physical count, season review, update template.

Step 1: Pull Last Year’s Numbers the Right Way

Export unit sales by SKU, by week, from your POS or ecommerce platform (Shopify, Square, Lightspeed, Clover and most others can do this) for October through January of last year. Units matter more than dollars, because prices change.

Then clean the data:

• Mark stockout weeks. If an item sold out on December 10, your sales history shows what you had, not what customers wanted. Estimate lost demand by using the item’s sales rate before it ran out.
• Flag one-off spikes. A local news mention, a viral post, or one big corporate order should not be treated as normal demand.
• Remove discontinued items, and find a comparable product for new ones (for example, a new candle scent can borrow the history of last year’s similar scent).
• Note promotions. If you ran 30% off last Black Friday and will not this year, expect fewer units that week.

Step 2: Turn History Into a Forecast

A simple forecast that you actually use beats a complex one you abandon. For each A and B item:

1. Start with last year’s season units (adjusted for stockouts).
2. Apply your trend. Compare this year’s September and October sales to last year’s for the same item or category. If you are up 10%, use roughly 1.10 as a multiplier. If the trend is unclear, stick near 1.0.
3. Adjust for known changes: price increases, new marketing, a new sales channel, a competitor closing nearby.
4. Spread the total across weeks using last year’s weekly pattern. If 22% of an item’s season sales happened in Black Friday week last year, plan for a similar share.

Worked example (illustrative): A gift shop in Portland sold 300 units of a ceramic mug set from November through December last year, but sold out on December 14. Before selling out it averaged 8 units a day, and the store was open 10 more selling days before Christmas, so roughly 80 sales were lost. Adjusted demand: 380. Fall sales are running 5% ahead of last year, so the forecast is 380 x 1.05 = about 400 units for the season.

Step 3: Sort Products With ABC Analysis

You cannot plan 600 SKUs with the same care. ABC analysis sorts them by how much revenue they bring:

Class	Typical share of SKUs	Typical share of revenue	How to manage
A	About 10-20%	About 70-80%	Forecast weekly, check stock daily in peak weeks, carry more safety stock, lock in supplier dates early.
B	About 20-30%	About 15-20%	Forecast monthly, check weekly, moderate safety stock.
C	About 50-70%	About 5-10%	Order once, little or no safety stock, accept occasional stockouts.

These shares are rules of thumb; your own split will vary. The point is to put your planning time where the money is.

Step 4: Set Reorder Points and Safety Stock

A reorder point (ROP) is the stock level that should trigger a new order, so the new stock arrives just before you run out.

Reorder point = (average daily unit sales x lead time in days) + safety stock

Lead time is the full time from placing an order to having goods on the shelf: supplier processing, shipping and your own receiving and pricing. During the holidays, carriers and suppliers are busy, so use your longest recent lead time, not the average.

A simple safety stock formula

Safety stock = (maximum daily sales x maximum lead time) – (average daily sales x average lead time)

It is not the most precise method, but it is easy to calculate with data most small shops already have.

Worked example (illustrative)

• Average daily sales in peak weeks: 8 units
• Maximum daily sales (a busy Saturday): 14 units
• Average lead time: 7 days; maximum lead time in peak season: 12 days
• Safety stock = (14 x 12) – (8 x 7) = 168 – 56 = 112 units
• Reorder point = (8 x 12) + 112 = 208 units

When stock of this item falls to about 208, reorder. If that seems like a lot of stock to hold, that is the real cost of a slow, unpredictable supplier. Shortening lead time, for example by using a domestic supplier, cuts the safety stock you need.

The last-reorder date

For every A item, work backward from the date you need the last restock on shelves. If your final useful delivery date is December 15 and peak lead time is 12 days, your last reorder must go out by about December 3. After that date, what you have is what you will sell. Write it on the calendar.

Step 5: Build Your One-Page Inventory Plan

Here is a template you can copy into a spreadsheet. One row per A and B item.

Column	What goes in it
SKU / product	Name and code
Class	A, B or C
Last season units (adjusted)	Including lost sales from stockouts
Trend multiplier	For example 1.05
Forecast units	Last season x multiplier, plus known changes
On hand + on order	Current stock and confirmed open orders
Units to buy	Forecast + safety stock – on hand – on order
Lead time (peak)	Days
Reorder point	Formula above
Last reorder date	Final delivery date minus peak lead time
Markdown plan	For example, 25% off Dec 26, 50% off Jan 10
Owner	Who watches this item

Before you buy, check margins. Holiday discounts and free-shipping offers can quietly wipe out profit on some items. A quick pass through a profit margin calculator for your top sellers, at both full and discounted prices, tells you which items can afford a promotion.

Fixing Stockouts and Overstock Mid-Season

When something sells out

Even with good planning, something will sell out. Act within a day:

1. Call the supplier first. Ask what they can ship now, even partial quantities, and whether expedited freight is possible. Compare the extra cost with the margin you would lose.
2. Offer a substitute. Move a similar product to the spot where the sold-out item was and train staff to suggest it.
3. Take backorders or preorders only if you are confident of the delivery date. Be honest about timing; a gift that arrives after Christmas creates an angry customer.
4. Sell gift cards as a fallback for shoppers who wanted the sold-out item.
5. Update your website immediately so online customers do not order what you cannot ship.
6. Note it for next year. Record the sell-out date and daily sales rate so next year’s forecast starts higher.

When something is not selling

Check sell-through weekly from mid-November: units sold divided by units received. If an item has sold under 30% of its stock by the first week of December while similar items are at 50% or more, it is lagging.

• Move it before the markdown season. Give it a better display spot, bundle it with a best seller, or feature it in an email or social post.
• Cancel or reduce open orders for lagging items while you still can.
• Use it as a gift-with-purchase above a spend threshold, which raises average order value.
• Plan markdowns in steps: a modest discount after Christmas, deeper in mid-January. Seasonal items (Christmas-themed) need faster, deeper cuts than evergreen items that can go back on the shelf in spring.
• Return or swap if your supplier allows it; some will trade unsold stock for spring orders.
• Donate genuinely unsellable goods. Ask a tax professional how donations of inventory are treated for your business.

Count, Record and Learn in January

A year-end physical count matters for more than restocking. Your ending inventory value affects your cost of goods sold, which affects your taxable income. IRS Publication 538 explains accounting periods, methods and inventories, and the SBA’s guide to managing your business finances covers the bookkeeping basics. Tax rules change, so confirm your method with your accountant.

Then spend one hour on a season review while it is fresh:

• Which items sold out, and when?
• Which items had the most left over?
• Which suppliers missed dates?
• How close was your forecast to actual sales for A items?
• What would you buy more or less of next year?

Save the answers next to your template. Next year’s plan starts from here.

If you are launching something new for the season

New products have no history, so forecast them conservatively and reorder fast if they take off. If you announce a new holiday line to local media, our guide to writing a press release and these announcement examples can help, but make sure you can actually fulfill the demand a story might bring before it runs.

Frequently Asked Questions

How much extra inventory should I order for the holidays?

There is no single percentage. Start from last year’s adjusted unit sales per item, apply your current sales trend, and add safety stock based on how variable your sales and supplier lead times are.

What is a good sell-through rate for holiday stock?

It depends on the product and margin, but many retailers aim to sell most seasonal-themed stock by Christmas. Compare items against each other each week; the laggards are the ones to act on.

Should I use inventory software or a spreadsheet?

A spreadsheet is fine for a few hundred SKUs if you update it weekly. Once you sell across several channels or locations, inventory software that syncs stock levels prevents overselling online.

How do I forecast a product I have never sold?

Borrow history from the closest similar item, cut it by a margin of caution, order a smaller first batch and line up a fast reorder with the supplier.

When should I place my last holiday reorder?

Work backward: the date you need stock on shelves minus your longest peak-season lead time. For many shops this lands in the first week of December.

Is Small Business Saturday worth planning stock around?

For many local shops, yes. In 2026 it falls on November 28. Check your own sales for that day last year and plan A-item stock accordingly.

This Week’s To-Do

Export last year’s weekly unit sales, tag your top 20 items as A, and fill in the template for just those 20. Call each of their suppliers and ask for honest peak-season lead times. That alone protects most of your holiday revenue, and you can add the B items next week.