What Is Days of Inventory on Hand?
Days of inventory on hand (DOH), also known as Days Sales of Inventory (DSI), measures how many days your current inventory will last based on your average daily sales rate. It reveals the efficiency of your inventory management by indicating how quickly you convert inventory into sales. For Shopify store owners, DOH is a critical metric for preventing stockouts, avoiding excess holding costs, and maintaining healthy cash flow.
A lower DOH generally suggests efficient inventory movement, while a higher DOH can signal slow-moving stock or overstocking, tying up valuable capital. Understanding your DOH helps you pinpoint optimal reorder points and assess whether your current stock levels align with demand.
Inventory Management Formulas
The Days of Inventory on Hand Calculator uses several key formulas to provide a holistic view of your inventory health:
Days of Inventory on Hand (DOH)
DOH = Current Inventory Value ÷ Daily COGS
OR
DOH = Current Units on Hand ÷ Average Daily Units Sold
*Example: If you have 3,200 units and sell 65 units/day, your DOH is 49.2 days.*
**Lead Time Coverage**
Lead Time Coverage (x) = Days of Inventory on Hand ÷ Supplier Lead Time (in days)
This ratio tells you how many times your current inventory can cover your supplier's lead time. A value of 1x means your current stock exactly matches your lead time.
**Cash Conversion Cycle (CCC)**
CCC = Days Sales of Inventory (DSI) + Days Sales Outstanding (DSO) - Days Payable Outstanding (DPO)
* **DSI (Days Sales of Inventory):** This is equivalent to your DOH.
* **DSO (Days Sales Outstanding):** For most Shopify stores, this is very low (0-3 days) as payments are typically instant.
* **DPO (Days Payable Outstanding):** This represents the average number of days it takes for you to pay your suppliers, based on your payment terms.
---
## How to Use This Calculator
This calculator provides real-time insights into your inventory and cash flow. Follow these steps to get started:
1. **Enter your `currentInventory`**: This is the total cost value of all inventory currently on hand.
2. **Input your `dailyCogs`**: Your average daily cost of goods sold. If you know your monthly COGS, divide by 30; for annual, divide by 365.
3. **Provide your `avgDailyUnits`**: The average number of units you sell each day.
4. **Specify your `currentUnits`**: The total count of individual units you have in stock.
5. **Enter your `unitCost`**: The cost to you for a single unit of your product (COGS per unit).
6. **Add `leadTimeDays`**: The number of days it takes for your supplier to manufacture and deliver a new order to your warehouse or fulfillment center. This is crucial for determining if your current stock covers the next reorder cycle.
7. **Input `paymentTermsDays`**: Your agreed-upon payment terms with suppliers (e.g., Net 30, meaning you have 30 days to pay after receiving goods). This is used in the Cash Conversion Cycle calculation.
8. **Enter `receivablesDays`**: The average number of days it takes customers to pay you. For most direct-to-consumer (DTC) Shopify stores, this will be 0-3 days due to instant payment processing.
9. **Optional: `holdingCostPct`**: Your estimated annual holding cost as a percentage of your inventory value (e.g., 20%). This can help contextualize the cost of excess inventory. Use our [Inventory Carrying Cost Calculator](/tools/inventory-carrying-cost-calculator) for a detailed breakdown.
10. **Optional: `sellingPrice`**: The average price your customers pay per unit.
> Hover over the **?** icon next to each field for a detailed explanation of what to enter.
---
## Step-by-Step Example: Organic Cotton T-Shirts
Let's say your Shopify store, "EcoWear," sells organic cotton t-shirts. You want to assess your current inventory position.
Here are your key figures:
* **Current Units on Hand (`currentUnits`)**: **1,500** t-shirts
* **Unit Cost (COGS) (`unitCost`)**: **$12.00** per t-shirt
* **Current Inventory Value (`currentInventory`)**: 1,500 units × $12.00/unit = **$18,000**
* **Average Daily Units Sold (`avgDailyUnits`)**: **50** t-shirts/day
* **Daily COGS (`dailyCogs`)**: 50 units/day × $12.00/unit = **$600**
* **Supplier Lead Time (`leadTimeDays`)**: **21** days
* **Supplier Payment Terms (`paymentTermsDays`)**: **30** days (Net 30)
* **Customer Receivables (`receivablesDays`)**: **1** day (instant payment via Shopify Payments)
* **Annual Holding Cost (`holdingCostPct`)**: **20%**
* **Average Selling Price (`sellingPrice`)**: **$30.00**
Using these inputs, the calculator yields:
| Metric | Calculation | Result |
| :----------------------- | :----------------------------------------------------------------------------------------------------------------------------------------------- | :-------- |
| **Days of Inventory on Hand (DOH)** | 1,500 units ÷ 50 units/day | **30 days** |
| **Lead Time Coverage** | 30 days (DOH) ÷ 21 days (Lead Time) | **1.43x** |
| **Cash Conversion Cycle (CCC)** | 30 (DSI) + 1 (DSO) - 30 (DPO) | **1 day** |
In this scenario, EcoWear has **30 days** of inventory. This stock covers their **21-day lead time by 1.43 times**, meaning they have a small buffer to receive the next order before running out. Crucially, their cash conversion cycle is **1 day**, indicating that capital is tied up for a minimal period, just barely longer than they receive payment from customers relative to when they pay suppliers.
---
## Mastering Inventory Velocity for Shopify Growth
Sales velocity directly determines how fast your inventory depletes. For Shopify stores, understanding this dynamic is paramount because e-commerce sales can fluctuate rapidly due to marketing campaigns, viral trends, or seasonal spikes. Your days of inventory on hand is not a static number; it's highly sensitive to changes in demand.
If EcoWear's t-shirt sales suddenly increased by 50% (e.g., during a flash sale or influencer mention), their average daily units sold would jump from 50 to **75** t-shirts. With 1,500 units on hand, their DOH would drop from 30 days to:
1,500 units ÷ 75 units/day = **20 days**
This new DOH (20 days) is *less* than their 21-day supplier lead time. In this heightened demand scenario, EcoWear would face a stockout before their next order arrived, losing potential sales and customer trust. The velocity sensitivity table in this calculator allows you to model these scenarios, showing you DOH at various demand levels so you can plan for demand spikes, assess risks, and adjust your [reorder point calculator](/tools/reorder-point-calculator) settings accordingly.
---
## Industry Benchmarks for Days of Inventory on Hand
What constitutes a "good" DOH varies significantly across industries and business models. The ideal DOH generally aligns with your lead time plus a strategic buffer.
| Industry/Product Type | Typical DOH Range | Key Considerations for Shopify |
| :-------------------- | :---------------- | :----------------------------------------------------------------------------- |
| **Fast Fashion/Apparel** | 30-45 days | High turnover, short product lifecycles, often requires quick reordering. |
| **Electronics/Tech** | 45-60 days | Moderate turnover, higher unit cost, balance stock with new model releases. |
| **Health & Beauty** | 40-75 days | Shelf-life concerns, ingredient sourcing, subscription potential. |
| **Home Goods/Furniture** | 60-90+ days | Bulkier items, longer lead times common, higher holding costs. |
| **Handmade/Artisan** | 10-30 days | Small batches, make-to-order can keep DOH low, often higher margins. |
| **Luxury Goods** | 90-180+ days | High perceived value, exclusivity, slower turnover, high carrying costs. |
A good rule of thumb for most Shopify stores is to aim for a DOH that equals your lead time plus 1-2 weeks of safety stock buffer. For example, with a 14-day lead time, targeting 21-42 days of inventory is generally healthy. Carrying DOH significantly under your lead time risks stockouts, while exceeding 2x your lead time ties up too much working capital. If you find yourself frequently with excess stock, consider using our [Dead Stock Identifier](/tools/dead-stock-identifier) to pinpoint problematic SKUs.
---
## 7 Strategies to Optimize Your Inventory Days on Hand
Reducing your DOH frees up working capital and lowers [inventory carrying costs](/tools/inventory-carrying-cost-calculator). Here are seven actionable strategies for Shopify merchants:
1. **Negotiate Shorter Lead Times:** Work with your suppliers to reduce the time it takes from placing an order to receiving it. Even a few days shaved off your lead time can significantly reduce the DOH needed to cover your next reorder cycle. Explore sourcing from multiple suppliers or local options to diversify and speed up fulfillment.
2. **Improve Demand Forecasting:** Utilize Shopify Analytics, sales history reports, and integrate forecasting apps to predict demand more accurately. Better forecasts mean you order closer to actual need, minimizing both overstocking and stockouts. For instance, Shopify's built-in reports for "Product sales" and "Sales by channel" can reveal trends.
3. **Implement Just-In-Time (JIT) Principles:** Where feasible, order smaller quantities more frequently. This reduces the total DOH by keeping less stock on hand. While not always practical for international sourcing, it's effective for local suppliers or products with stable, predictable demand.
4. **Accelerate Slow-Moving Inventory:** Identify products with high DOH. Run targeted promotions, create bundles (e.g., using Shopify's native Discounts or app integrations), or strategically markdown items to convert them into cash faster. Our [ABC Inventory Analysis Tool](/tools/abc-inventory-analysis) can help prioritize which products to focus on.
5. **Utilize Dropshipping for Niche/High-Variance Items:** For products with unpredictable demand or very high unit costs, consider a dropshipping model. This eliminates the need to carry inventory, effectively achieving a DOH of zero for those items. You can use Shopify apps to integrate dropshipping suppliers seamlessly.
6. **Optimize Payment Terms (DPO):** Negotiate longer payment terms with your suppliers (e.g., Net 60 instead of Net 30). While this doesn't directly reduce DOH, it *does* significantly improve your Cash Conversion Cycle by allowing you to sell inventory and collect cash before you have to pay for it, freeing up capital.
7. **Set Dynamic Reorder Points:** Instead of fixed reorder points, use a system that accounts for fluctuating sales velocity and lead times. Tools like our [Reorder Point Calculator](/tools/reorder-point-calculator) help you determine optimal reorder points and safety stock levels, ensuring you restock exactly when needed.
Reducing DOH by just 20 days on $48,000 worth of inventory (e.g., from 60 to 40 days) can free up **$16,000** in working capital, ready to be reinvested in marketing, new products, or operational improvements.
---
## Frequently Asked Questions
### What is days of inventory on hand (DOH)?
Days of inventory on hand (DOH) measures how many days your current inventory will last given your average daily sales rate. It's calculated by dividing your current inventory value by your daily cost of goods sold, or current units by daily units sold. DOH helps Shopify owners understand their inventory efficiency and plan reorders effectively.
### What is a good number of days of inventory on hand?
The ideal DOH depends on your supplier lead time and industry. A good benchmark is to have DOH equal to your lead time plus an additional 1-2 weeks of safety stock. For example, if your lead time is 14 days, aiming for 21-42 days of inventory provides a healthy buffer without tying up excessive capital.
### What is the cash conversion cycle?
The cash conversion cycle (CCC) measures the number of days your cash is tied up in your operations, from purchasing inventory to collecting payment from customers. For Shopify DTC businesses, it's calculated as Days Sales of Inventory (DOH) + Days Sales Outstanding (typically 0-3 days) - Days Payable Outstanding (your supplier payment terms). A negative CCC indicates you collect cash before paying suppliers, which is highly advantageous.
### How does sales velocity affect days on hand?
Sales velocity directly impacts how quickly your inventory depletes. An increase in sales velocity (e.g., during a successful marketing campaign or peak season) will reduce your DOH, potentially leading to stockouts if not anticipated. This calculator's velocity sensitivity table helps you model how DOH changes under different sales scenarios, ensuring you can cover lead times even during demand spikes.
### How do I reduce days of inventory on hand?
To reduce DOH, you can implement several strategies: negotiate shorter supplier lead times, improve demand forecasting accuracy, adopt a just-in-time inventory approach by ordering smaller quantities more frequently, and accelerate the sale of slow-moving items through promotions. Additionally, consider dropshipping for certain products to eliminate carrying inventory entirely.
---
## About This Calculator
This Days of Inventory on Hand Calculator was specifically developed by [Luis Dev Studio](/about-us) for Shopify merchants. It integrates crucial e-commerce metrics like lead time, payment terms, and velocity sensitivity to provide a comprehensive view of your inventory and cash conversion cycle, updating results instantly.
Need specialized assistance with your Shopify inventory management or operations? [Contact us for help](/contact) with custom solutions.