Inventory Turnover Diagnostic Checklist
Run through this checklist to identify the scope and cause of your slow turnover. Each item you check points to a specific section of this guide for the fix.
- Inventory turnover below 4x per year: You are turning inventory too slowly. Calculate your rate using the formula in the next section.
- More than 20% of SKUs have not sold in 90 days: You have significant dead stock that needs to be cleared or discontinued.
- You have more than 3 months of supply on hand: Over-ordering is tying up cash. Reduce order quantities and increase order frequency.
- Too many variants per product: Offering 8 colors and 5 sizes per product (40 SKUs) dilutes demand across too many options. Consider limiting to your best-performing variants.
- Seasonal products still in stock post-season: You need better seasonal planning and clearance timing. Mark down seasonal items 3-4 weeks before the season ends, not after.
- Storage costs are increasing: Growing storage costs with flat or declining sales is a clear sign of inventory buildup. This needs immediate attention.
- Cash flow feels tight despite decent sales: Excess inventory is the most common cause of cash flow problems in ecommerce. Your money is sitting on shelves instead of in your bank account.
- You regularly mark down products more than 30%: Large markdowns indicate you are consistently over-ordering or misjudging demand. Your forecasting process needs an overhaul.
How to Calculate Your Inventory Turnover Rate
Inventory turnover rate tells you how many times you sell through and replace your inventory in a given period. The formula is straightforward:
Inventory Turnover = Cost of Goods Sold / Average Inventory Value
To calculate average inventory, add your beginning inventory value and ending inventory value for the period, then divide by 2. Use COGS (not revenue) because inventory is valued at cost, not selling price.
| Product Category | Target Turnover (per year) | Days of Supply Target |
|---|---|---|
| Fashion / Apparel | 6-12x | 30-60 days |
| Beauty / Skincare | 6-10x | 35-60 days |
| Electronics / Gadgets | 5-8x | 45-75 days |
| Home Goods / Decor | 4-6x | 60-90 days |
| Specialty / Niche | 3-5x | 75-120 days |
In Shopify, go to Analytics and then Reports to find your sales by product and inventory snapshot reports. Export these to a spreadsheet and calculate turnover per SKU. You will likely find that 20% of your products have excellent turnover while the bottom 20% have barely moved.
Identifying and Clearing Dead Stock
Dead stock is inventory that has not sold in 90+ days. It is the biggest drag on turnover and cash flow. Here is how to identify it and decide what to do with each item.
Step 1: Run an aging report. Export your inventory from Shopify and add a column for "days since last sale" for each SKU. Sort by this column descending. Every SKU with 90+ days since last sale is dead stock. SKUs at 60-90 days are at risk.
Step 2: Categorize each dead stock item. For each item, determine which category it falls into: seasonal (will sell again in the right season), trend-dependent (the trend has passed), overstock (good product, just ordered too much), or truly dead (no demand exists). Each category requires a different strategy.
Step 3: Take action based on category. Seasonal items should be stored cheaply until next season if storage costs allow, or sold at 30-40% off to clear them. Overstock should be promoted aggressively (see the promotions section below). Trend-dependent and truly dead items should be liquidated as quickly as possible, even at a loss, because the cash they free up has more value than the inventory sitting unsold.
Step 4: Set a dead stock deadline. Create a rule: any product that has not sold in 120 days gets automatically flagged for clearance action. Do not hold inventory hoping it will eventually sell. The carrying cost (storage, insurance, opportunity cost of tied-up cash) typically equals 20-30% of the inventory value per year.
Product Bundling to Move Slow Inventory
Bundling pairs slow-moving products with popular items, exposing the slow mover to high-traffic product pages and giving customers a reason to add it to their order.
Complementary bundles: Pair the slow-moving product with a best-seller that it naturally complements. A slow-selling phone stand bundles perfectly with a best-selling phone case. Use EA Upsell & Cross-Sell to display the bundle offer when customers add the popular item to cart.
Value bundles: Create a bundle of 3-5 slow-moving items at a significant discount versus buying individually. Position it as a "starter kit" or "essentials pack." The perception of value drives purchases even for items the customer would not have bought individually.
Buy one, get one: For products with low marginal cost, a BOGO deal moves twice the inventory volume while feeling like a great deal to the customer. Even if your margin per unit drops, you are converting dead stock into cash and freeing up storage space.
Free gift with purchase: Use EA Auto Free Gift & Rewards Bar to offer slow-moving inventory as a free gift when customers reach a spending threshold. This moves dead stock while simultaneously increasing average order value on active products. The "free gift" has a positive margin because you already paid for the inventory and it was not selling anyway.
Strategic Promotions for Slow Inventory
Promotions can accelerate turnover, but they must be strategic. Blanket discounts across your entire store hurt margins on products that sell fine at full price. Target promotions specifically at slow-moving inventory.
Flash sales with urgency: Run a 48-72 hour flash sale on dead stock items. Use EA Countdown Timer to create genuine urgency with a ticking countdown. Flash sales generate impulse purchases and create a sense of scarcity that regular discounting does not. Promote the flash sale through your email list and social channels.
Tiered clearance pricing: Start with a modest discount (20% off) for the first two weeks. If the product has not moved, increase to 30%, then 40%. This captures customers willing to buy at a smaller discount before deepening the markdown. Set clear timelines for each tier so you do not get stuck at a partial discount that fails to move the product.
Announce clearance events: Use EA Announcement Bar to highlight your clearance section to every visitor. Many customers love finding deals on clearance items, but they need to know the clearance exists. A persistent announcement bar drives traffic to your clearance collection without disrupting the shopping experience for full-price buyers.
Email-exclusive deals: Send clearance offers exclusively to your email list. These customers already know and trust your brand, making them more likely to buy. Use EA Email Popup & Spin Wheel to continuously grow your email list so you have a larger audience for these promotions.
Better Demand Forecasting
The root cause of slow turnover is ordering more than you can sell. Better demand forecasting prevents the problem before it starts.
Use historical sales data: The best predictor of future sales is past sales data, adjusted for growth trends. If a product sold 100 units per month last year and your store is growing at 20% year over year, forecast 120 units per month. Do not forecast based on hope or best-case scenarios.
Account for seasonality: Most products have seasonal patterns. Analyze your monthly sales by product to identify peaks and valleys. Order more before peak months and less before slow months. A product that sells 200 units in December and 50 units in February should not have the same reorder quantity year-round.
Start small with new products: New products are the highest risk for dead stock because you have no sales history. Order the minimum viable quantity (enough for 30-45 days of estimated sales) and reorder quickly if demand materializes. It is far better to temporarily sell out of a new product and reorder than to be stuck with 6 months of inventory for something that does not sell.
Track sell-through rate weekly: Sell-through rate is the percentage of received inventory that has sold in a given period. Track this weekly for every product. A product with a sell-through rate below 40% after 30 days is underperforming and should trigger a promotional response before it becomes dead stock.
Smarter Ordering Practices
How and when you order inventory directly impacts turnover. These ordering practices keep inventory lean without sacrificing availability.
Reduce order quantities, increase frequency: Instead of ordering 500 units every 3 months, order 200 units every 6 weeks. Smaller, more frequent orders keep inventory fresh, reduce carrying costs, and allow you to adjust quickly when demand shifts. Yes, per-unit costs may be slightly higher, but the savings on dead stock and carrying costs more than compensate.
Set reorder points based on lead time: Calculate your reorder point as: daily sales rate multiplied by supplier lead time (in days) plus a safety stock buffer of 20-30%. When inventory hits this level, reorder. This prevents both stockouts and over-ordering.
Limit variants: Every additional color, size, or style you offer multiplies the number of SKUs you must manage and stock. If a product has 8 colors but 3 colors account for 80% of sales, consider dropping the bottom 5 colors. Fewer variants means higher turnover per SKU and less dead stock risk.
Consider dropshipping for unproven products: Test new products via dropshipping before committing to inventory purchases. You will accept lower margins during the test phase in exchange for zero inventory risk. Once a product proves demand, switch to inventory-based fulfillment for better margins.
Online Merchandising for Faster Turns
Sometimes slow turnover is not a demand problem but a visibility problem. Products that are hard to find on your store cannot sell regardless of demand.
Feature slow movers on high-traffic pages: Your homepage and collection pages drive the most traffic. Place slow-moving products in prominent positions on these pages temporarily. A product buried on page 3 of a collection gets almost no views. Moving it to position 2-5 on the first page can dramatically increase visibility and sales.
Cross-sell on product pages: Use EA Upsell & Cross-Sell to show slow-moving items as "frequently bought together" recommendations on your best-selling product pages. This puts the slow mover in front of your highest-intent traffic.
Improve product page SEO: Slow-moving products may have poor organic traffic due to weak SEO. Optimize product titles, descriptions, and meta tags with keywords that customers actually search for. Even small improvements in organic visibility can move inventory that has been stagnant.
Create curated collections: Build collections like "Under $25," "Staff Picks," or "Trending This Week" that feature slow-moving products alongside popular ones. Curated collections provide fresh browsing experiences and expose customers to products they might not find through normal navigation.
Before and After: Realistic Turnover Improvement
| Metric | Before | After (90 days) | Change |
|---|---|---|---|
| Inventory Turnover Rate | 2.4x/year | 4.8x/year | +100% |
| Dead Stock (90+ days) | 34% of SKUs | 12% of SKUs | -65% |
| Cash Tied in Inventory | $48,000 | $28,000 | -42% |
| Monthly Storage Costs | $1,200 | $680 | -43% |
| Average Markdown % | 35% | 18% | -49% |
Recommended EasyApps Tools
- EA Upsell & Cross-Sell — Bundle slow movers with best sellers and show cross-sell recommendations
- EA Countdown Timer — Create urgency for flash sales to move dead stock quickly
- EA Auto Free Gift & Rewards Bar — Offer slow inventory as free gifts to clear stock while increasing AOV
- EA Announcement Bar — Highlight clearance sections and inventory-moving promotions
- EA Email Popup & Spin Wheel — Build email list for targeted clearance and flash sale promotions
Start Moving Slow Inventory Today
Bundle slow movers with best sellers and run flash sales with countdown timers to free up cash flow. Both tools are free to install.
Frequently Asked Questions
What is a good inventory turnover rate for a Shopify store?
A healthy rate is 4-8 times per year. Fashion should be 6-12x, electronics 5-8x, home goods 4-6x. Below 2x indicates a serious dead stock problem tying up cash.
How do I calculate inventory turnover rate on Shopify?
Divide your annual COGS by your average inventory value. If COGS is $120,000 and average inventory is $30,000, your turnover is 4x. Use Shopify Analytics inventory reports to get these numbers.
What causes slow inventory turnover on Shopify?
Over-ordering, too many product variants, poor product visibility, seasonal items held past their peak, and not running promotions to clear aging stock. Most stores have a combination of these issues.
How do I clear dead stock on my Shopify store?
Run flash sales with countdown timers, bundle slow movers with popular items, offer them as free gifts with qualifying purchases, sell to liquidation services, or donate for tax write-offs. Act quickly as carrying costs erode value over time.
How does inventory turnover affect profitability?
Faster turnover frees cash for best sellers, reduces 20-30% annual carrying costs, and prevents deep markdowns. A store with 6x turnover generates significantly more profit per dollar of inventory investment than one with 2x.