E-commerce Inventory Turnover Calculator
Calculate your inventory turnover ratio and days to sell inventory. Enter COGS and average inventory value to benchmark performance.
Calculate your sell-through rate to measure how quickly inventory sells. Enter units sold and total inventory to evaluate product performance.
| Markdown | Sale Price | Clearance Revenue | Clearance P/L | Total Gross Profit |
|---|---|---|---|---|
| Full Price | $35.00 | $8,750.00 | $5,750.00 | $23,000.00 |
| 10% Off | $31.50 | $7,875.00 | $4,875.00 | $22,125.00 |
| 20% Off | $28.00 | $7,000.00 | $4,000.00 | $21,250.00 |
| 30% Off | $24.50 | $6,125.00 | $3,125.00 | $20,375.00 |
| 50% Off | $17.50 | $4,375.00 | $1,375.00 | $18,625.00 |
| Category | Target STR | vs. Yours | Notes |
|---|---|---|---|
| Fashion / Apparel | 80% | -5% | High seasonality |
| Electronics | 65% | +10% | Moderate, lifecycle-driven |
| Grocery | 95% | -20% | Perishable, must sell fast |
| Home & Garden | 55% | +20% | Seasonal spikes |
| Health & Beauty | 70% | +5% | Replenishment driven |
| Toys / Games | 60% | +15% | Holiday-heavy |
| Books / Media | 45% | +30% | Long-tail demand |
Sell-through rate measures the percentage of inventory that has been sold during a specific period relative to the amount received or available. It is one of the most important KPIs for e-commerce and retail businesses because it directly reflects demand accuracy and inventory efficiency.
A high sell-through rate means your products are moving quickly, reducing storage costs and minimizing the risk of obsolescence. A low sell-through rate suggests overstocking, poor product-market fit, or ineffective marketing.
This calculator helps you evaluate individual product or category performance by comparing units sold to total available inventory. Track sell-through weekly or monthly to identify trends and make data-driven replenishment decisions.
Sell-through rate gives you a clear picture of product demand. It helps you decide which products to reorder, which to discount, and which to discontinue. Tracking this metric consistently prevents both stockouts and overstock situations.
Sell-Through Rate = Units Sold / (Units Sold + Ending Inventory) ร 100
Alternatively: Sell-Through Rate = Units Sold / Units Received ร 100Result: Sell-Through Rate: 75.0%
With 750 units sold and 250 remaining: Total available = 750 + 250 = 1,000. Sell-through = 750 / 1,000 ร 100 = 75%. This is above the 80th percentile benchmark for most e-commerce categories, indicating strong demand.
Different product categories have very different sell-through expectations. Grocery and consumables might target 95%+ sell-through. Fashion and apparel aim for 60โ80% before markdowns. Electronics and durable goods may consider 40โ60% acceptable. Always compare within your category.
Sell-through rate directly informs reorder decisions. Products with consistently high sell-through should be reordered in larger quantities with shorter intervals. Products with declining sell-through need investigation โ is it seasonal, competitive, or a quality issue?
Plan your markdown strategy around sell-through milestones. If a product hits 50% sell-through by mid-season, it's on track. Below 30% may need a 20โ30% discount. Below 15% might require clearance pricing or bundling to recover costs.
Last updated:
A good sell-through rate depends on the product category and time period. Generally, 20โ40% monthly is average, 40โ60% is good, and above 60% is excellent. Fashion and seasonal items should target higher rates to avoid end-of-season markdowns.
Weekly tracking is ideal for fast-moving products and during promotional periods. Monthly calculation works well for standard inventory reviews. Always compare against the same period length for accurate trend analysis.
Sell-through rate measures the percentage of available inventory sold in a period. Inventory turnover measures how many times total inventory is sold and replaced over a year. Sell-through is better for individual product analysis; turnover is better for overall business health.
Start with marketing โ boost visibility through ads, email campaigns, or social media. If demand exists but conversion is low, review your product listing quality. If the product simply lacks demand, consider markdowns, bundles, or discontinuation.
Both methods are valid. Units received is used when you want to measure performance against a specific purchase order. Total available (sold + remaining) is more common for ongoing inventory management because it accounts for carryover stock.
Standard sell-through does not account for returns. For a more accurate picture, subtract returned units from your sold count. This gives you a net sell-through rate that reflects actual customer retention of products.
Calculate your inventory turnover ratio and days to sell inventory. Enter COGS and average inventory value to benchmark performance.
Calculate product sales velocity to rank SKU performance. Enter units sold and time period to identify fast and slow movers in your catalog.
Calculate days of inventory outstanding (DOI/DSI) to measure how long stock sits before selling using inventory and COGS.