Shopify Inventory Reports: What They Show, What They Miss

Shopify's inventory reporting shows you a snapshot. It tells you what's on the shelf right now, broken down by location and variant. It's backward-looking by design. You can see what moved yesterday. You can't see when it's about to run out, whether you ordered the right quantity, or whether you should have discontinued it six months ago. For stores running on thin margins or pushing high volume, that distinction between "where we are" and "what happens next" is the difference between optimization and chaos.

The native inventory reports-the standard quantity-on-hand view, the ABC analysis tool, and the month-end value snapshot-are genuinely useful for understanding the basic shape of your stock. They answer the question Shopify expects every merchant to ask: "How much do I have?" But they don't answer the questions that separate good operators from broke ones: "Am I about to stockout? Do I have too much of the slow stuff? Should I lower prices on this SKU or kill it?"

Here's what Shopify's inventory stack actually shows, the three critical gaps you'll hit if you're serious about unit economics, and what you need to build on top to stop guessing.

What Shopify inventory reports actually show.

Quantity on hand by location and variant. This is the core report. It shows your current inventory level across your warehouse locations, broken down by product and variant. Shopify updates this in real-time as orders come in. If you have ten locations, you see the ten counts. If you have 500 variants, you see 500 rows. The data is reliable. The scope is narrow. It's a point-in-time view of what exists right now.

ABC analysis by movement. Shopify categorizes your inventory into three buckets: A (high volume, high value), B (medium), and C (slow-moving). The system counts orders over the past 90 days and puts each SKU into a category based on volume. This is useful for a quick reality check-it surfaces your dead stock and your stars. But the analysis is backward-looking only. It doesn't forecast what comes next. It doesn't account for seasonality. It doesn't know that you just launched a paid campaign that's about to double demand for Category A items. You get a historical ranking. You don't get a signal.

Month-end inventory value. Shopify calculates the total value of your on-hand inventory based on your cost per unit. If you've set cost-of-goods in your product settings, you see a bottom-line inventory asset value. It's useful for balance sheet accounting. It's not useful for operational decisions. You don't know which SKUs are tying up cash, whether aging inventory is becoming a liability, or where to focus liquidation efforts.

Three gaps that force you to build on top.

Gap 1: No lead-time awareness. Shopify doesn't know how long it takes to get new inventory from your supplier. You set reorder points manually, in your head, based on intuition. A typical manual reorder process looks like this: you eye the inventory count, you remember that supplier lead time is 18 days, you do quick math, you place an order. Or you don't. You run out of your best-seller instead. This costs money. Here's a real example: you have a product that sells 50 units per day. Your supplier lead time is 21 days. You need (50 units/day × 21 days) + safety stock = 1,050 units + 200 units safety = 1,250 units minimum. If your count drops below that, you order. Shopify's report shows you 800 units in stock. You see "green" and keep moving. Three weeks later you're out of stock and losing $2,500 per day in revenue. The manual approach is 80% good. The automated approach with lead-time awareness is 95% good. That five-percentage-point difference costs you stockouts.

Gap 2: No sell-through velocity signal. Shopify shows you inventory levels. It doesn't show you whether that inventory is moving or dying. A slow-moving product with 300 units on hand is a different problem than a fast-moving product with 100 units. One is dead capital. One is a stockout risk. Shopify's ABC analysis is a historical ranking. You need a real-time signal: "Is this SKU moving faster, slower, or at the same pace as last month?" If a product that normally sells 20 units per day suddenly sells 40, that's a signal to order more. If a product that normally sells 30 per day suddenly sells 10, that's a signal to discount, consolidate, or kill it. Without velocity trending, you're flying on an outdated map. Sentinel monitors inventory movement continuously so you see the pattern breaks that matter.

Gap 3: No margin-per-unit visibility. Shopify calculates inventory value by cost. It doesn't calculate margin-per-unit. You have a product that cost $12 to acquire, sells for $49, and carries $7 in fulfillment, packaging, and holding costs per unit. Gross margin is $49 - $12 - $7 = $30 per unit. But if you factor in the ad spend it took to sell it-say $8 CAC amortized per unit-your true contribution margin is $22. Now you have 500 units in stock worth $7,500 at cost, showing as a $15,000 asset on your balance sheet (500 × $30 gross margin). But if sell-through slows by 20%, that capital becomes a problem. You need to see inventory value ranked by contribution margin, not just cost. That tells you which slow-moving SKUs are killing you and which are still profitable enough to be worth holding.

What you need to build on top.

Three signals fix all three gaps. They're not exotic. Most ecommerce operators build these manually in spreadsheets. The better ones wire them into dashboards. The smart ones let a tool like Sentinel handle the calculation.

Signal 1: Days of inventory remaining. Calculate (current inventory ÷ average daily sales rate) - lead time. If the result is positive, you're safe. If it's negative, you're about to stockout. Update this daily. Set alerts for when it crosses zero. This is the single most important inventory metric for preventing revenue loss. It forces you to separate "I have some stock" from "I have enough stock."

Signal 2: Sell-through velocity and trend. Track units sold per day over the last 7, 14, and 30 days. Compare each SKU's current velocity to its historical average. If it's trending up, you're gaining momentum and should order more. If it's trending down, demand is softening. You need to decide: discount to clear, hold for seasonal rebound, or discontinue. This converts the ABC analysis from a historical ranking into a real-time change signal.

Signal 3: Contribution margin by SKU. Build a simple sheet that joins your Shopify order data to your COGS (from whatever system you use), calculates the fulfillment cost per unit, allocates ad spend per unit sold, and spits out contribution margin. Rank your slow-moving inventory by this metric. If an SKU has slow velocity and low contribution margin, it's a discontinuation candidate. If it has slow velocity and high contribution margin, it might be worth holding or liquidating at a discount. Without this signal, you're making inventory decisions on revenue and cost, not on profitability.

If you're building this in a spreadsheet, you're spending two hours per week on updates and calculations. If you're connecting a BI tool, you're spending two to four weeks on setup. If you're using Sentinel, it's ninety minutes to connect your Shopify store, and the signals start flowing into your dashboard the next morning. You choose based on what your time is worth and how much you're willing to automate versus how much you'll do manually.

How to know if you need this.

If you're running under $250k in annual revenue, Shopify's native inventory reports are probably enough. You're not carrying enough SKUs for the gaps to bite hard. Your stockouts don't cost six figures. Your dead stock is a rounding error.

If you're between $250k and $1M, you're at the inflection point. Stockouts are starting to hurt. Dead stock is tying up capital. You've probably felt all three gaps by now. The payoff for fixing them is visible-a 10% reduction in stockouts is $20-50k in incremental revenue. A 15% reduction in dead stock is $5-15k in freed capital. The investment is worth it.

If you're above $1M, you need all three signals automated. Manual spreadsheets are a liability. You're losing precision, creating single points of failure, and wasting time on calculations that should be continuous. At that scale, paying for a tool or hiring someone to wire the signals into your infrastructure is not a cost. It's ROI protection.

Shopify's inventory reporting is honest about what it is: a view of what you have. It's not pretending to be a forecasting system. But most operators mistake "honest" for "enough," and they pay for it in stockouts and dead stock. If you're serious about inventory optimization, you need to add the three signals-lead-time aware reorder points, sell-through velocity trending, and contribution margin visibility. Build them yourself or use a tool that does. But don't fly on Shopify's inventory snapshot alone. It will cost you.