Shopify inventory forecasting: what a forecasting dashboard should show
Shopify's inventory reports describe the past. A forecasting dashboard tells you what to order, from whom and when. The formula, the data it needs, the traps that break forecasts, and what to put on the screen.
The short answer
- Reorder point = average daily sales × vendor lead time in days + safety stock.
- Days of cover = units in stock ÷ average daily sales.
- Days when a product was out of stock should be left out of its sales velocity, or the forecast understates demand.
- By default a Shopify app can read only the last 60 days of orders. Forecasts that compare against last year's festive season need the read_all_orders scope.
- A custom Shopify dashboard costs ₹1,20,000 to ₹5,00,000 to build, or $2,000 to $8,000 for international brands, on Tanuj Rajput's published pricing.
Want this done rather than explained? a Shopify developer in Delhi NCR
A Shopify inventory forecasting dashboard should tell you three things for every product: how many days of stock you have left, when to reorder, and how much to order from which vendor. The core formula is simple: reorder when stock falls to average daily sales × vendor lead time + safety stock. Shopify's own reports give you the sales half. The vendor half, and the judgement calls, have to come from you.
The maths is the easy part. Most forecasts go wrong because of the data that goes into them, so that's most of this post.
Why Shopify's inventory reports aren't a forecast
Shopify's built-in reports describe the past: what you have on hand and how fast it sold. A purchase order needs things Shopify doesn't store, such as how long each vendor takes to deliver, the minimum they'll ship and how much buffer you want for a late truck. Shopify also can't tell you whether a slow week was low demand or a product that was sold out.
The formula, with a worked example
Two numbers do most of the work:
- Days of cover = units in stock ÷ average daily sales
- Reorder point = average daily sales × vendor lead time in days + safety stock
Take a product that sells 6 units a day. The vendor takes 20 days from order to sellable stock, and you want 10 days of safety stock.
- Reorder point = 6 × 20 + 6 × 10 = 180 units
- With 300 units on hand, days of cover = 300 ÷ 6 = 50 days, and you're fine
- At 180 units, you place the order. If the vendor ships in cases of 48, round the order quantity up to a multiple of 48.
The traps that break forecasts
These are where forecasts go quietly wrong:
- Sold-out days. A product that sold zero units for a week because it was out of stock didn't have zero demand. Leave out-of-stock days out of its average, or the forecast tells you to order less of your best sellers.
- Seasonality. A Diwali month can sell several normal months' worth. Forecasting November from September's pace leaves you short. You need last year's numbers for the same weeks.
- Short history. By default, a Shopify app can read only the last 60 days of orders. Year-on-year forecasts need the
read_all_orderspermission and a one-time backfill of older orders. - New products. With no history, any forecast is a guess. Start from a manual estimate and label it as one.
- Variants versus vendor SKUs. You sell sizes and colours. Your vendor may sell you cases of mixed sizes. Forecast at the variant level, order at the level the vendor ships.
- Bundles. A bundle sale uses up its component products. If the dashboard only counts the bundle, the components run out without warning.
- Several locations. Stock in the wrong warehouse doesn't help. Forecast by location if you ship from more than one.
- Marketplace sales. If you also sell on Amazon or Flipkart from the same stock, Shopify's numbers show only part of the demand.
What a forecasting dashboard should show
One screen, opened weekly, that answers what to do:
- Reorder now. Products at or below their reorder point, grouped by vendor, with suggested quantities rounded to case size.
- Running low. Products whose days of cover are shorter than their vendor's lead time plus a week.
- Overstocked and dead stock. Products with far more cover than you need, and products that haven't sold in your chosen number of days, with the cash each one holds at cost price.
- Stock-outs this week. What sold out, and roughly how many sales you missed at its normal pace.
- Forecast confidence. A clear label on products with too little history to trust.
- Purchase orders. The reorder list turned into a sheet each vendor can fill in.
Every number a founder might question should explain itself. In the dashboard I built for a D2C brand, each forecast figure has a small ⓘ explainer in plain language, written for the founders rather than for an analyst.
What I built for a D2C brand
BrandDesk is the merchandising dashboard I built for a D2C brand with about 2,000 products and more than 100,000 orders. Its inventory side does stock forecasting in plain language, with an explainer next to the numbers. It turns merchandising suggestions into purchase-order sheets: vendors get a CSV, fill it in and send it back. It also shows dead stock with the cash it holds. Margins use cost prices imported from the brand's accounting software, which stay in the dashboard and never reach Shopify. Unknown values show as unknown, never as zero.
It reads the store through read-only access and Shopify webhooks, so it can't change stock levels or anything else in Shopify. The custom dashboard page has the full feature list.
App or custom dashboard?
| Your setup | Better fit |
|---|---|
| One warehouse, standard vendors, under a few hundred products | An inventory planning app from the App Store |
| Vendors with their own order formats, minimums and case packs | Custom dashboard |
| You need margin from real cost prices kept in accounting | Custom dashboard |
| Stock shared with Amazon, Flipkart or quick commerce | Custom dashboard, fed by each channel's data |
| You want the forecast inside a weekly founder report | Custom dashboard |
The broader comparison of a custom dashboard and an analytics app covers where each one stops, beyond inventory.
What it costs
A custom Shopify dashboard costs ₹1,20,000 to ₹5,00,000 for Indian brands, or $2,000 to $8,000 for international brands, on my published pricing. Most take 45 to 60 days. The ₹40,000 or $750 scoping sprint builds one working report on your real data first, and that report is often the reorder list. The fee is credited to the build.
What I'd do
Gather three facts for your top 20 products before buying any tool:
- units sold per day while in stock
- each vendor's lead time
- each vendor's minimum order
If that fits in a spreadsheet you can keep current, you may not need software yet. If it doesn't, or you're already missing stock on your best sellers, see custom dashboard pricing or start a brief with that list.
Related reads
- Custom Shopify dashboard vs an analytics app
- Shopify analytics apps for Indian D2C brands, compared
- Diwali and festive readiness for Shopify stores in India
- Shopify app development cost in India (2026)
Sources
FAQ
Frequently asked questions
Does Shopify have inventory forecasting built in?
Shopify's built-in inventory reports show stock on hand and how fast products sold. They don't hold your vendor lead times, minimum order quantities or safety stock rules, so they can't tell you how much to order from each vendor and when. That's the gap a forecasting app or a custom dashboard fills.How do you calculate a reorder point for a Shopify product?
Multiply average daily sales by the vendor's lead time in days, then add safety stock. If a product sells 6 units a day, the vendor takes 20 days and you keep 10 days of safety stock, the reorder point is 6 × 20 plus 6 × 10, which is 180 units.How much sales history do I need to forecast inventory?
At least 60 to 90 days for a steady product, and a full year if your sales are seasonal, such as a Diwali peak. A Shopify app can read only the last 60 days of orders by default, so year-on-year forecasts need the read_all_orders permission and a one-time backfill of older orders.How do you forecast stock for a new product with no sales history?
You can't forecast it from its own sales yet. Start from a manual estimate, such as the sales of a similar product at launch, and switch to the product's real sales velocity once it has a few weeks of history. A good dashboard labels these products clearly instead of showing a confident number.Should I use an inventory forecasting app or a custom dashboard?
Use an app if you have a simple setup: one warehouse, standard vendors and no special rules. Build a custom dashboard when you need vendor rules, purchase orders in your vendors' formats, real margins from your accounting software or forecasts across several sales channels.How much does a custom inventory forecasting dashboard cost?
A custom Shopify dashboard costs ₹1,20,000 to ₹5,00,000 for Indian brands, or $2,000 to $8,000 for international brands, on my published pricing. A ₹40,000 or $750 scoping sprint builds one working report on your real data first, and the fee is credited to the build.
Revision history· 1 entry
November 11, 2026
First published.
Last updated November 11, 2026
