Inventory-to-Sales Ratio: Formula, Shopify Example, and What to Do Next
Inventory-to-sales ratio is average inventory value divided by net sales for the same period. A lower ratio means you need less capital tied up in stock to generate a dollar of revenue. A higher ratio means more cash is sitting on shelves relative to what's selling.
For most established ecommerce businesses, a healthy ratio falls between 0.167 and 0.25, according to Flieber's inventory guide. Ratios above roughly 0.35 to 0.40 usually flag overstock risk; ratios below 0.12 to 0.15 usually flag stockout risk. Treat these ranges as diagnostics, not fixed targets: the same source is explicit that a ratio inside the range can still be unhealthy, and a ratio outside it can still be strategic once you factor in category, growth stage, seasonality, and supplier lead times.
The inventory-to-sales ratio formula
The formula is:
Inventory-to-Sales Ratio = Average Inventory Value / Net Sales
Average inventory value is the mean value of stock held during the period (typically beginning inventory plus ending inventory, divided by two). Net sales is total revenue for that same window, after returns and discounts. Both figures need to cover identical dates, or the ratio is meaningless.
Some analysts substitute cost of goods sold for net sales in the denominator, since inventory is recorded at cost, not at retail price, according to Investing.com's academy. Net sales is the more common choice in ecommerce reporting because it's what most Shopify dashboards already surface without extra bookkeeping.
A worked Shopify SKU example
Store-wide averages hide the SKUs actually causing the problem. Run the ratio at the product level instead. Here's a 30-day example across three SKUs in the same store, each selling at the same price and volume.
| SKU | Units sold (30 days) | Net sales | Avg. inventory value | I/S ratio |
|---|---|---|---|---|
| Ceramic Mug A | 500 | $10,000 | $2,500 | 0.25 |
| Ceramic Mug B | 500 | $10,000 | $5,000 | 0.50 |
| Ceramic Mug C | 500 | $10,000 | $1,250 | 0.125 |
SKU A sits in the healthy 0.167-0.25 range. SKU B is overstocked: it needed twice the capital tied up in inventory to generate the same $10,000 in sales, which usually means slower turns, higher carrying cost, and cash that could be funding a reorder on a faster mover instead.
SKU C looks the most efficient on paper, but check the inventory pattern behind it. If it started the month at 500 units and ended at zero, the low ratio reflects a stockout, not a healthy operation. A single ratio number can look identical for a well-run SKU and a broken one; you have to check what's behind it before you act.
What a high ratio means: slow stock and cash tied up
A ratio above roughly 0.35 to 0.40 usually signals too much capital locked in inventory relative to what's selling. That capital could be funding ads, a reorder on a bestseller, or new product development instead of sitting on a shelf. A higher ratio isn't automatically a problem, though: rapid growth, a seasonal buy ahead of a peak period, or a long supplier lead time can all justify carrying more stock than the general benchmark suggests.
A rising ratio over consecutive months is often a precursor to markdowns, since businesses eventually have to discount to clear stock that isn't moving, per Investing.com. Common causes on Shopify stores:
- Reorder quantities set from gut feel rather than recent sell-through data
- A promotion or ad campaign that underperformed after the stock was already purchased
- Seasonal buys that missed their window
- A SKU that used to sell but has been quietly declining for months
What a low ratio means: stockout and missed-sales risk
A ratio below roughly 0.12 to 0.15 often signals chronic understocking rather than genuine efficiency. The number looks good because less capital is tied up, but the SKU may not be able to meet the demand that exists.
The benchmarks describe what's typical for an established, steady-state business, not a rule that fits every category or stage. A ratio outside the range can still be the right call once you account for growth, seasonality, or lead time.
This matters for Shopify merchants specifically because ad spend can keep flowing to a product page even after it's out of stock, unless your ad platform or product feed rules are set up to detect and exclude unavailable items. When that happens, traffic and clicks continue while orders stop. The gap between what could have sold and what did sell often doesn't show up in a sales report, because a stockout leaves no transaction behind.
- Repeat customers can't reorder a product they bought before
- Paid traffic can be sent to unavailable inventory if the campaign isn't paused or filtered, inflating cost per acquisition
- Forecasting models trained on sales data can quietly underestimate true demand, since the stockout period looks like a demand drop
How to use the ratio alongside sell-through and days of stock
The inventory-to-sales ratio answers one question: how much capital is tied up relative to revenue. It doesn't tell you how fast that capital is moving or how many days of cover remain. Pair it with two other numbers before deciding what to do.
| Metric | What it answers | Where to find it |
|---|---|---|
| Inventory-to-sales ratio | How much capital is tied up per dollar of sales | Inventory value ÷ net sales, calculated per SKU |
| Sell-through rate | What percentage of stock actually sold in the period | Shopify's Products by sell-through rate report |
| Days of inventory remaining | How many days until a SKU runs out at current velocity | Shopify's Inventory remaining per product report |
Shopify's built-in sell-through rate report divides quantity sold by quantity sold plus quantity still in stock, and its days-of-inventory-remaining report divides ending quantity by average daily sales over the last 28 days. Neither report calculates the inventory-to-sales ratio directly, but combined with your own inventory value figures, they tell you whether a ratio is a capital problem, a velocity problem, or both.
A demand forecast adds the forward-looking piece: whether current velocity is about to accelerate (a launch, a seasonal spike) or fade. See our guide to ecommerce demand forecasting for how to build that into a reorder decision instead of reacting to the ratio after the fact.
How often to review the ratio by product and collection
Review inventory-to-sales at the SKU level weekly for anything in your top revenue tier, and at least monthly for the rest of the catalog. A store-wide average calculated once a quarter will not catch a bestseller quietly drifting toward a stockout, or a slow mover quietly absorbing more cash every reorder cycle.
Group the review by how much revenue each SKU actually contributes, not alphabetically or by category. An ABC analysis ranks products by revenue share so your A-grade bestsellers get checked weekly, while C-grade long-tail items get a lighter monthly pass. That matches review frequency to where the cash and the risk actually sit.
At the collection level, a blended ratio across dozens of SKUs hides exactly the problem it's meant to reveal: one overstocked hero item and one stocked-out companion product can average out to a number that looks perfectly normal. Review collections by pulling the individual SKU ratios behind the average, not the average itself.
The action checklist: reorder, discount, bundle, promote, or pause
Once you know which SKUs are pulling the ratio out of range, match the action to the cause instead of applying one fix store-wide.
- Ratio too high, sales steady: run a discount or bundle to clear the excess before it becomes dead stock. Pairing a slow mover with a fast one in a bundle moves both without a straight price cut.
- Ratio too high, sales declining: pause future purchase orders for that SKU and route ad spend elsewhere until the ratio normalizes.
- Ratio too low, demand strong: reorder immediately and check lead time against current days of stock remaining before setting the new order quantity.
- Ratio too low, sales flat or unclear: check whether the low ratio is masking a stockout period before assuming the SKU is efficient.
- Ratio in range but collection underperforming: the issue isn't inventory, it's placement or merchandising. Move on to conversion and exposure metrics instead of buying more stock.
For the reorder-point math itself, our Shopify reorder formula guide covers how to set the trigger point using lead time and daily sales velocity, so you reorder before the stockout, not after the ratio flags it.
Running this checklist manually across a full catalog every week takes real discipline, and it's easy to let it slide after a few cycles once other priorities crowd it out. Pull the average inventory value and net sales for each SKU into one sheet, calculate the ratio, and flag anything outside your range for review, on a fixed schedule rather than whenever there's time. Continuous stock intelligence tooling that watches inventory levels and sales velocity and surfaces stockout risk early can take some of that manual pull off your plate, even though calculating the inventory-to-sales ratio itself is still a spreadsheet exercise you run on top of it. Combine it with a broader inventory management system so reorder points and stockout alerts stay in one view instead of scattered across exports.
Set a standing reminder to pull this SKU-level view every Monday for your top revenue tier. Making that check a habit can help catch overstock and stockout drift before it turns into a missed sale or a markdown.