Stock to sales ratio: what it measures and how to read your own number
The stock to sales ratio formula with a worked example, how to read high vs low readings, and a method to set your own benchmark from 3 months of data.
InventoryX is in development and not available today. ClearStock is the live Shopify app.
The stock to sales ratio is your average inventory value divided by your net sales for the same period: stock to sales ratio = average inventory at cost ÷ net sales (or at retail ÷ retail sales). A store holding $40,000 of inventory while selling $20,000 a month has a ratio of 2.0 — two months of sales sitting on the shelf. It's the inverse of how many times your inventory "pays for itself" in a period, which is why it's one of the core ratios in the retail method of inventory planning.
The most common variant in retail practice uses beginning-of-month inventory ÷ sales for that month, evaluated month by month. Either way, the ratio answers one question: how much stock am I carrying per dollar of sales I'm actually making?
Worked example
Three months from a home-goods Shopify store (all figures at cost for inventory, net sales at retail):
| Month | Beginning inventory (cost) | Net sales | Ratio |
|---|---|---|---|
| July | $52,000 | $21,000 | 2.48 |
| August | $58,000 | $19,500 | 2.97 |
| September | $63,000 | $26,000 | 2.42 |
Read what happened in August: the ratio jumped to 2.97 not because sales collapsed (they dipped slightly) but because inventory grew — a $6,000 restock landed on a soft month. In September, a strong sales month pulled the ratio back down even though inventory kept growing. This is the ratio's value and its trap in one table: it moves whenever inventory and sales move out of step, and you have to look at which one moved to know whether it's good news or bad.
How to read the number
- Ratio too high = cash on shelves. Inventory is growing faster than sales. Money that could fund your next buy is sitting in slow SKUs. Persistently climbing ratios are the earliest spreadsheet-visible sign of slow-moving stock building up.
- Ratio too low = running out of stock. You're selling from a thin base — great turnover, but the next bestseller to go out of stock costs you days of sales at full velocity. Below roughly your replenishment cycle's needs, a low ratio is fragility, not efficiency. Days of cover per SKU is the metric that catches this at the SKU level (days of cover explained).
- Ratio moving with no decision behind it = drift. The most common pattern in spreadsheet-run stores: nobody decided to add stock; a series of individual reorder decisions compounded.
Why there's no honest benchmark number
You'll find "a good stock to sales ratio is 1.5" or similar figures across retail blogs. Treat all of them as assumptions, not data. The ratio varies enormously by category and margin structure:
- Grocery and consumables run low ratios by nature — high turn, thin margin.
- Furniture and seasonal apparel run high ratios by nature — long sell-through, high margin per unit.
- A store mixing both (most Shopify stores) has no single number that describes it.
What "good" actually means: your ratio should be stable at a level that funds your replenishment cycle without excess. That's a number only your own data can give you. Here's the method to set your baseline:
- Pull beginning inventory and net sales for your last 3 months (Shopify's inventory and sales reports cover both).
- Compute the ratio for each month.
- Answer two questions: (a) Did you go out of stock on anything important in those months? If yes, your ratio was too low — your floor is higher than you thought. (b) Did you end any month thinking "why is there so much stock"? If yes, too high.
- Your target band is between those two failure points. Write it down: e.g., "1.8–2.4, based on Jul–Sep." Review quarterly.
That's the whole benchmark exercise. Three months of your own data beats any published average, because the published average isn't running your catalog.
Stock to sales vs. turnover vs. sell-through
These three get conflated constantly. They measure different things:
| Metric | Formula | Question it answers | Grain |
|---|---|---|---|
| Stock to sales ratio | avg inventory ÷ net sales (or beginning inventory ÷ monthly sales) | How much stock do I carry per dollar of sales? | Store or category, monthly |
| Inventory turnover | COGS ÷ average inventory | How many times did my inventory sell through this year? | Store or category, annualized |
| Sell-through rate | units sold ÷ units received (over a period) | How much of a specific buy did I sell? | SKU or receipt level |
They're mathematically related — stock to sales ratio is essentially the monthly-grain cousin of turnover's inverse — but they fail differently. Sell-through rate catches a bad buy at the receipt level within weeks. Stock to sales catches capital-level drift at the store level over months. A healthy store-level ratio can hide five dead SKUs, and five perfect sell-throughs can't stop a store-level ratio from climbing. You want both, and the rest of the standard set is in our inventory KPI guide.
Where it fits in a monthly routine
The stock to sales ratio is a planning-input metric, not an alarm metric. Its natural home is the first step of a monthly planning cadence: check the ratio before you set the month's buying budget, because it tells you whether you're over- or under-invested in inventory before you decide how much to buy. The full sequence — review, forecast, budget, buy — is laid out in our inventory planning process, and the budgeting step is open-to-buy math that the ratio feeds directly.
One practical caution: compute it per category, not just store-wide, as soon as you can. A store-wide ratio of 2.2 that's really a 1.2 on consumables and a 4.0 on seasonal décor tells you the décor buy is the problem — the blended number tells you nothing actionable.
Common questions
What is the stock to sales ratio formula? Stock to sales ratio = average inventory ÷ net sales for the same period, with both sides at cost or both at retail. The common retail-method variant uses beginning-of-month inventory ÷ that month's sales. Example: $50,000 beginning inventory against $25,000 monthly sales = 2.0, meaning two months of sales are currently sitting in stock.
What is a good stock to sales ratio? There's no universal number — the right ratio depends on your category, margins, and replenishment lead times, and any published benchmark is an assumption rather than data. Set your own baseline: compute the ratio for your last three months, mark where you went out of stock (too low) and where stock piled up (too high), and target the band between them.
Is the stock to sales ratio the same as inventory turnover? No. Turnover is COGS ÷ average inventory, usually annualized — how many times your stock sold through in a year. The stock to sales ratio is the monthly-grain view of roughly the same relationship from the inventory side. Turnover is for annual reporting and negotiation; the ratio is for month-to-month buying control.
Where do I get the numbers to calculate it in Shopify? Net sales come from Shopify's sales reports; inventory value requires on-hand quantities times cost per item. Shopify shows on-hand units natively but doesn't compute a stock-to-sales ratio for you, so export both, multiply quantities by cost per item in a spreadsheet, and divide. Compute it per category once the store-wide number is routine.
Should the ratio use inventory at cost or at retail? Either, as long as both sides of the division match — cost inventory against COGS-based sales, or retail inventory against retail sales. Cost-based is more common in planning because it measures actual cash tied up. Mixing them (retail inventory ÷ cost sales) inflates the ratio by your markup factor and makes trend lines meaningless.
Next step
Compute your store-wide ratio for the last three months, then per category for your two largest. Write down your target band and the date — that number becomes the input to next month's buying budget, and the full monthly routine it belongs to is in the inventory planning process guide.