Days of supply by store
Days of supply is how many days a store's current stock of an item will last if it keeps selling at its recent rate. Calculate it for each SKU in each store, not for the chain as a whole.
One SKU, five stores
Chain-level numbers average out exactly the stockouts you're trying to catch. The average below is taken over the last 28 days.
| Store | On hand | Sold in last 28 days | Avg / day | Days of supply |
|---|---|---|---|---|
| Downtown | 6 | 42 | 1.5 | 4 |
| Mall | 40 | 14 | 0.5 | 80 |
| Eastside | 12 | 28 | 1.0 | 12 |
| Airport | 0 | 22 | 0.8 | 0 (out) |
| Westfield | 9 | 0 | 0 | no recent sales |
| Chain total | 67 | 106 | 3.8 | ~18 |
The chain total says about 18 days, which looks fine. Store by store, Airport is already out, Downtown has 4 days left, Mall holds 80 days and Westfield hasn't sold one in four weeks.
The fix may be a transfer from Mall and Westfield, not a new order.
Choosing the averaging window
- 28 days (four full weeks) is a common default. Each weekday shows up the same number of times.
- Shorter (7–14 days) reacts faster to trends, but one busy weekend can swing it.
- Longer (60–90 days) is steadier but slow to notice a change. Use it for slow sellers.
- Leave out days the item was out of stock when you calculate the average. Otherwise a stockout makes demand look lower than it is, and the next stockout gets worse.
What's a “good” number?
It depends on your category and how long a reorder takes to arrive. As a rough reference, published industry figures put specialty retail at around 60–70 days of stock on hand, and grocery much lower. A useful rule for each store:
Flag an item when days of supply < supplier lead time + days until the next delivery or transfer.
If your supplier takes 10 days and a store shows 6 days of supply, that store runs out before new stock arrives. A transfer from another store may be the only way to avoid it.
Zero sales, new items, negative stock
| Situation | What to do |
|---|---|
| Zero sales in the window | Days of supply is undefined. Don't call it “infinite”. Flag it as slow or dead stock instead. |
| New item (sold for fewer days than the window) | Average over the days it has actually been on sale, and mark the figure as an estimate. |
| On hand is negative | Usually a receiving or counting error. Fix the count first. Treat it as 0 for days of supply. |
| Strong seasonality | Use the same period last year, or a short window, and say which one you used. |
| Promotions | Promo days inflate the average. Leave them out or note them. |
Doing it in a spreadsheet
- Export on-hand quantity by location and SKU.
- Export units sold by location and SKU for your window.
- Divide sold by the number of days in the window to get the daily average. Then divide on-hand by that average.
- Sort ascending. Separate out zero-sales rows.
- Repeat every morning.
Shopify's built-in “Days of inventory remaining” report and Square's sell-through report (Retail Plus) cover steps 1–3. You still have to compare stores and look for transfers yourself.
Doing it with Floorwalk
Floorwalk calculates days of supply for every SKU in every store from your Shopify POS or Square data (synced hourly), or from CSV for any other POS. Every morning it:
- ranks the items closest to running out across all stores, by the sales you'd lose,
- shows which stores have spare units of the same SKU, and suggests a transfer with a unit count,
- flags dead stock separately instead of mixing it into the days-of-supply list.
How Floorwalk calculates it: the average covers the last 28 days at that store. Stock below zero counts as zero. For an item that is out of stock now, Floorwalk uses the higher of its last-28-day rate and its rate in the 28 days before it ran out. Out-of-stock days earlier in the window are not yet removed, so an item that sold out and was restocked can show a lower rate than its real demand.
What it doesn't do: it doesn't create purchase orders or transfers, and it never changes stock in your POS. It's read-only. Plans run from $149/month for up to 5 stores, with a 14-day free trial.
Days of supply: questions
What is the formula for days of supply?+
Days of supply = units on hand ÷ average units sold per day. Calculate it for each SKU in each store, using a fixed window such as the last 28 days for the daily average.
Why calculate days of supply by store instead of for the whole chain?+
A chain total averages out the stockouts you're trying to catch. One store can be out of an item while another holds 80 days of it, and the chain total still looks healthy.
What if an item had zero sales?+
Days of supply is undefined when nothing sold in the window. Don't treat it as infinite; flag the item as slow or dead stock instead.
What is a good days of supply number?+
It depends on your category and how long a reorder takes to arrive. Flag an item when its days of supply is lower than the supplier lead time plus the days until the next delivery or transfer.
How does Floorwalk calculate days of supply?+
Units available (on hand minus reserved, never below zero) divided by average daily units sold at that store over the last 28 days. Items with no sales in that window are reported as no-sales or slow-moving stock instead of getting a days-of-supply figure.
See days of supply for every store and SKU.
Book a 30-minute walkthrough, or explore the live demo with a full year of sample data from a 30-store chain.