Demand planning for Shopify brands

Shopify gives you something that used to require an enterprise data team: a clean, complete record of every unit you've ever sold, by product, by day, going back as far as your store has existed.

Most Shopify brands use that data to look backward. Revenue last month. Best-selling products last quarter. Year-over-year comparison.

Almost none of them use it to look forward.

That gap — between the data you have and the planning you're doing with it — is where stockouts happen. Where cash gets tied up in the wrong inventory. Where a Black Friday that went better than expected turns into a January spent apologizing to customers on a waitlist.

This is a solvable problem. And unlike most demand planning challenges, Shopify brands are better positioned to solve it than almost anyone — because the data foundation is already there.

The problems Shopify brands run into first

The out of stock notification.

You know the one. A customer tries to buy something, gets the out of stock message, and either waits or goes elsewhere. Most Shopify brands treat this as a fulfillment problem — reorder faster, hold more safety stock, set up back-in-stock alerts. It's actually a planning problem. The out of stock happened because the demand plan didn't see it coming far enough in advance to act on it.

The overstock problem.

The flip side. You ordered confidently, demand came in softer than expected, and now you're holding more inventory than you can move at full price. Every discount you run to clear it is margin you didn't plan to give up. Every month it sits is cash that isn't available for the next purchase order.

The cash timing problem.

Shopify brands live on cash cycles. Revenue comes in. Inventory goes out the door. Then you need to reorder — which requires cash — before the revenue from those sales has fully come in. Without a forward demand plan, that timing is managed by feel. Which works until it doesn't.

The Black Friday problem

For most Shopify brands, Q4 is the plan. BFCM weekend alone can represent 20 to 30 percent of annual revenue. And unlike a retail brand that ships to a retailer DC in advance, a Shopify brand needs to have every unit physically on hand before the sale starts.

The planning window for BFCM is longer than most brands realize.

If your lead time is 60 days and you're manufacturing overseas, the inventory you'll sell in November needs to be ordered by September — at the latest. The demand plan that determines how much to order needs to be built before that. Which means you're forecasting November demand in August based on whatever information you have then.

What that requires:

• Last year's BFCM actuals by SKU
• A realistic view of how much your business has grown since then
• An honest look at which SKUs are growing, flat, or declining in velocity
• A specific plan for which products you're promoting and at what discount

Most Shopify brands approach BFCM with a rough revenue target and an optimistic inventory build. A demand plan breaks that down to: this SKU, this many units, ordered by this date. The difference between those two approaches shows up in fill rate and margin — two numbers that matter more during peak season than any other time of year.

The influencer problem

A creator with a large following posts about your product. Traffic spikes. Conversion spikes. And within 48 hours you're out of stock on the SKU they featured.

This is the scenario every Shopify brand celebrates when it happens and regrets immediately after. The lost sales during the halo period — the days and weeks when the post is still driving traffic — are real and largely unrecoverable. Customers who click through to an out of stock page don't reliably come back.

You can't fully predict an organic viral moment. But you can build a response plan into your demand planning process:

Identify your highest-risk SKUs. Which products are most likely to be featured? Which have the highest page views relative to their current inventory level? These are candidates for a slightly higher buffer stock.

Know your emergency lead time. If a SKU spikes unexpectedly, how fast can your supplier turn around a rush order? What does it cost? Having that number in advance means you can make the call in hours rather than spending two days figuring out if it's even possible.

Build the scenario into your plan. A demand plan doesn't have to be one number. A base case and an upside case — with the upside case triggering a specific response — is a reasonable way to hold optionality without over-investing in inventory you might not need.

When you add a wholesale or retail channel

This is where most Shopify brands' planning breaks entirely.

DTC on Shopify is forgiving. You can see demand in real time, you control your own inventory, and you can make adjustments quickly. A wholesale or retail account works differently. You're committing to inventory months in advance. You're shipping to a retailer's timeline, not your own. And your visibility into what's actually selling through — versus what the retailer has ordered — drops significantly.

The specific planning changes you need to make when you add wholesale:

Separate your demand by channel. Your Shopify velocity and your retail velocity are different numbers with different patterns. Blending them into one forecast obscures both.

Adjust your lead time assumptions. DTC inventory can arrive at your 3PL and ship to a customer within days. Retail inventory needs to be at the retailer's DC by a specific date, often with weeks of handling time built in. Your planning horizon gets longer.

Build a retailer-specific buffer. You don't have real-time visibility into your retail channel the way you do on Shopify. That uncertainty should be reflected in how much buffer you hold for retail commitments versus DTC.

How to use your Shopify data to build a demand plan

Your Shopify analytics are the starting point. Here's what to pull and what to do with it.

Export your unit sales by SKU by month for the last 24 months. Not revenue — units. This is the foundation of the statistical forecast. Shopify makes this straightforward to export. The key is using units, not dollars, for every calculation that follows.

Look for three things in the data:

One — trend. Is each SKU growing, flat, or declining over the last six months? A simple visual of the monthly units will show you this clearly.

Two — seasonality. Are there months that are reliably higher or lower than average? For most Shopify brands, November and December are obvious. But there may be other patterns — a product that spikes in summer, a gift SKU that moves in February — that are worth baking into the plan.

Three — velocity relative to inventory. Take your current on-hand stock and divide it by your average monthly sales. That's your months of supply. Any SKU below two months of supply with a 60-day lead time is already in the danger zone.

From those three inputs, build a 6-month forward forecast by SKU. Apply a weighted average of your recent monthly sales, adjusted for any seasonal patterns you identified. This doesn't need to be a complex statistical model — a weighted average of the last four months, skewed toward more recent performance, will get you most of the way there.

Add your lead times and reorder points. For each SKU: when does inventory need to be ordered to arrive before you run out? That date is the most actionable output of the whole exercise.

When Shopify's native tools aren't enough

Shopify's built-in inventory management is fine for tracking what you have. It's not built for forward planning.

If you're managing fewer than 30 SKUs across one or two channels, a well-built spreadsheet that references your Shopify export data is sufficient and faster to set up than any app integration.

When you start needing more — multi-location inventory, automatic reorder suggestions, channel-level forecasting — there are tools built for Shopify brands specifically. The right tool depends on your SKU count, your channels, and how much of the planning you want automated versus managed manually.

The more important question is usually not which tool to use but whether your forecasting logic is right in the first place. A tool built on flawed assumptions produces bad recommendations faster than a spreadsheet does. Get the logic right before you automate it.

The practical starting point

You don't need new software to start planning better. You need two things: your Shopify unit sales data exported to a spreadsheet, and a lead time for each SKU.

With those two inputs you can calculate — today, in about an hour — which SKUs are likely to run out before your next shipment arrives, and which ones are overstocked relative to current velocity.

That one hour of work is the difference between a reactive reorder and a planned one. At scale, it's the difference between a profitable Q4 and a Q4 that looked great in revenue and quietly destroyed your margins.

If you'd like help building a demand plan from your Shopify data — or if you're heading into a wholesale or retail transition and want to make sure your planning is ready for it — we're happy to take a look.