Most ecommerce merchants obsess over revenue. Fewer pay attention to the capital sitting silently in their warehouse, losing value every day.
Inventory overstock is one of the most expensive problems in ecommerce — and one of the least visible. Your platform shows you stock levels. It shows you units sold. What it doesn't show you is how much money is trapped in products that aren't moving fast enough.
The four hidden costs of overstocking
When you order too much inventory, the sticker price is only the beginning. The real cost compounds across four dimensions.
1. Tied-up capital
Every unit sitting in your warehouse is cash you can't use elsewhere. That capital could be funding ad spend on a proven campaign, purchasing more of your best-seller, or simply earning interest.
Here's what this looks like in practice: Your Body Lotion Set has 340 units on hand — 567 days of supply at current velocity. That's $11,560 in capital trapped in a 12% margin product. Even if you eventually sell every unit, the opportunity cost of locking that capital away for 18+ months is enormous.
2. Storage costs
Warehouse space isn't free. Whether you're paying for 3PL storage, Amazon FBA long-term fees, or your own facility, every unit takes up space that has a monthly cost. Products with hundreds of days of supply are renting shelf space at a rate that often exceeds their margin.
3. Markdown risk
Fashion, seasonal goods, and trending products lose value over time. The longer inventory sits, the more likely you'll need to discount it to move it. A product you bought at $34 per unit with a planned 45% margin might end up selling at 15% off — or worse, at cost — just to clear space.
4. Opportunity cost
This is the one nobody calculates. While your capital is locked in 567 days of body lotion, your best-selling Vitamin C Serum has 12 units left — 1.8 days of supply. A stockout on that product means lost revenue on a high-margin item, disappointed customers, and damaged search rankings if you're selling on marketplaces.
Overstocking one product and understocking another isn't just an inventory problem. It's a capital allocation failure.
Why stock levels alone are meaningless
Most ecommerce platforms — Shopify, WooCommerce, Magento — show you a simple number: units in stock. Some will flag items as "low stock" when they drop below a threshold you set manually.
This tells you almost nothing useful. 200 units of a product that sells 3 per day is very different from 200 units of a product that sells 40 per day. The first has over two months of supply. The second will be gone in five days.
The metric that matters is days-of-supply — how many days your current inventory will last at the current sell-through rate.
Days-of-supply transforms a flat stock number into actionable intelligence:
- Under 7 days: Reorder urgently or risk a stockout
- 7-30 days: Healthy range for most products; monitor velocity
- 30-90 days: Acceptable for slow-moving or seasonal items; watch trends
- 90-180 days: Overstocked; consider reducing future orders
- 180+ days: Capital at risk; evaluate markdowns or discontinuation
Without this calculation, you're flying blind. You might feel comfortable seeing "340 units" on a shelf — until you realize that's a year and a half of supply.
Dead stock vs. slow-movers: know the difference
Not all slow inventory is the same, and treating it uniformly leads to bad decisions.
Dead stock is inventory with zero or near-zero sales velocity over a meaningful period (typically 90 days). These products aren't coming back. They need aggressive markdowns, bundle deals, or write-offs. Every day they sit on the shelf, they cost you money with no realistic prospect of return.
Slow-movers are products that sell, just not quickly. A candle set that moves 2 units per week isn't dead — it's slow. With 100 units on hand, you have about a year of supply. That's likely too much, but the product doesn't need to be discontinued. It needs a right-sized reorder strategy and possibly a promotional push to increase velocity.
The distinction matters because the action is different:
| Category | Velocity | Action |
|---|---|---|
| Dead stock | 0 units / 90 days | Markdown aggressively, bundle, or write off |
| Slow-mover | Low but consistent | Reduce reorder quantity, promote, or reposition |
| Healthy | Steady, predictable | Maintain current reorder cadence |
| Fast-mover | High, accelerating | Increase reorder quantity, secure supply |
Most merchants don't segment their inventory this way because their tools don't make it easy. They see a flat list of products with stock counts and maybe a "units sold" column. Turning that into a prioritized action plan requires spreadsheet work that rarely gets done.
Measuring what matters: capital at risk
Days-of-supply tells you time. But you also need to understand money.
Capital at risk is the dollar value of inventory that exceeds a healthy supply threshold. If you define "healthy" as 60 days of supply, then every unit beyond that threshold represents capital that's at risk of depreciation, markdowns, or write-offs.
Consider this breakdown for a hypothetical store:
- Vitamin C Serum: 12 units, 1.8 days of supply, $0 at risk (understocked)
- Hydrating Face Mask: 85 units, 28 days of supply, $0 at risk (healthy)
- Charcoal Cleanser: 220 units, 142 days of supply, $3,400 at risk
- Body Lotion Set: 340 units, 567 days of supply, $9,180 at risk
- Holiday Gift Box (seasonal): 175 units, 1,200+ days of supply, $6,125 at risk
Total capital at risk: $18,705 — and that's in a store doing $30,000/month in revenue. That's more than half a month's revenue locked in products that aren't earning their keep.
How Spark by MishiPay approaches inventory intelligence
Traditional analytics platforms show you a stock report. Spark by MishiPay calculates the metrics that actually drive decisions.
When you connect your store, the platform automatically computes:
- Days-of-supply per SKU based on trailing sales velocity, adjusted for trends
- Capital at risk across your entire catalog, broken down by product and category
- Reorder urgency scoring that flags products approaching stockout based on current velocity and typical lead times
- Dead stock identification using 90-day velocity analysis
- Margin-weighted prioritization so you focus on the products where overstock (or understock) hurts the most
You don't need to build a spreadsheet or configure a dashboard. Ask a question like "Which products have more than 90 days of supply?" and get an instant, sorted answer with capital impact calculated.
Or go deeper: "What's my total capital at risk in products with margins below 15%?" The AI cross-references inventory data with margin analysis to surface the intersection — overstocked, low-margin products — that represents your biggest drag on profitability.
An actionable inventory health framework
If you want to start scoring your inventory health today, here's a framework you can apply regardless of your platform.
Step 1: Calculate days-of-supply for every SKU. Divide current stock by average daily sales over the last 30-60 days. If daily sales are zero, flag it as dead stock.
Step 2: Segment into four buckets. Use the thresholds above (under 7, 7-90, 90-180, 180+). Count the number of SKUs and total capital in each bucket.
Step 3: Calculate capital at risk. For every SKU above your healthy threshold (e.g., 60 days), multiply the excess units by your cost-per-unit. Sum this across your catalog.
Step 4: Prioritize by margin impact. Overstocked, low-margin products are the most dangerous. They tie up capital with minimal return even when they do sell. Rank by (capital at risk / margin percentage) to find your worst offenders.
Step 5: Set reorder rules. For each bucket, define a reorder policy. Fast-movers get automatic reorders at a safety stock threshold. Slow-movers get reduced order quantities. Dead stock gets no reorders and a markdown plan.
This framework turns a static inventory list into a dynamic capital management tool. The merchants who run this analysis consistently — not once a quarter, but weekly — are the ones who maintain healthy margins as they scale.
Stop managing stock. Start managing capital.
Inventory management in ecommerce isn't really about counting units. It's about deploying capital efficiently. Every dollar in your warehouse is a dollar that isn't working for you elsewhere.
The difference between a store with 35% margins and one with 22% margins often isn't pricing or product selection. It's how well they manage the capital cycle — buying the right amount, at the right time, for the right products.
Your data already contains the signals. You just need the right analysis to surface them.