Inventory Management Basics: How to Avoid Stockouts and Overstock

Updated March 2026 · By the StoreCalcs Team

Inventory is cash sitting on shelves. Too much ties up capital and incurs storage costs. Too little means stockouts that lose sales and tank your marketplace rankings. Finding the right balance requires understanding your demand patterns, lead times, and the true cost of both overstock and understock. This guide teaches the fundamental inventory management concepts every e-commerce seller needs, from reorder point calculations to demand forecasting techniques that work at any scale.

The True Cost of Inventory

Inventory carrying cost is the total cost of holding unsold inventory, including storage fees, capital cost (interest or opportunity cost on money tied up in inventory), insurance, shrinkage (theft, damage, obsolescence), and handling. For most e-commerce businesses, annual carrying cost is 20-30% of the inventory value. A seller holding $50,000 in inventory pays $10,000-$15,000 annually just to store it.

Stockout cost is harder to quantify but equally real. Each stockout loses the immediate sale (revenue minus cost), may lose the customer permanently (lifetime value impact), reduces marketplace rankings (Amazon penalizes stockouts in search position), and creates urgency that leads to expensive expedited restocking. For a product selling $50/day, a 7-day stockout costs $350 in direct sales plus potentially weeks of reduced organic ranking.

Reorder Points: When to Restock

The reorder point is the inventory level at which you should place a new order. The formula is: reorder point = (average daily sales x lead time in days) + safety stock. If you sell 10 units per day and your supplier takes 14 days to deliver, your base reorder point is 140 units. Add safety stock (more on this below) and you might reorder at 180 units.

Calculate reorder points for every SKU individually. A product with a 30-day lead time from overseas needs a much higher reorder point than one with a 5-day lead time from a domestic supplier. Review and update reorder points quarterly as sales velocity and lead times change. Seasonal products need dynamic reorder points that increase before peak season and decrease after.

• Average daily sales: total units sold in the last 30-90 days divided by days
• Lead time: days from placing order to receiving inventory (include shipping and inspection)
• Safety stock: buffer for demand variability and supply delays
• Reorder point = (daily sales x lead time) + safety stock
• Review quarterly and adjust for seasonal patterns

Safety Stock: Your Buffer Against Uncertainty

Safety stock is extra inventory held above the basic reorder point to protect against demand spikes and supply delays. The amount of safety stock depends on how variable your sales and lead times are. A product with consistent daily sales of 8-12 units needs less safety stock than one that swings between 3 and 25 units per day.

A practical formula for safety stock is: (maximum daily sales x maximum lead time) minus (average daily sales x average lead time). If your max daily sales are 15, max lead time is 18 days, average daily sales are 10, and average lead time is 14 days, safety stock = (15 x 18) - (10 x 14) = 270 - 140 = 130 units. This seems high, but it covers the worst-case scenario of peak demand coinciding with a delayed shipment.

Demand Forecasting for E-Commerce

Simple demand forecasting uses historical sales data to predict future demand. The moving average method takes the average of the last 30, 60, or 90 days of sales as the daily forecast. Weighted moving averages give more importance to recent data. Seasonal indexing adjusts the base forecast by monthly factors — if December sales are historically 2x the annual average, multiply the base forecast by 2.0 for December.

Track forecast accuracy by comparing predicted sales to actual sales each month. If your forecast consistently overestimates (leading to overstock), reduce the forecast or use a shorter moving average window. If it underestimates (leading to stockouts), increase safety stock or use a longer window that captures demand trends. Perfect forecasting is impossible — the goal is to be consistently close, not exactly right.

ABC Analysis: Prioritizing Inventory Attention

ABC analysis categorizes products by their revenue contribution. A-items (top 20% of SKUs, typically 80% of revenue) deserve the most inventory management attention — optimize reorder points, maintain safety stock, and monitor daily. B-items (next 30% of SKUs, 15% of revenue) need regular but less frequent attention. C-items (bottom 50% of SKUs, 5% of revenue) can be managed with simpler rules and less safety stock.

Apply different strategies to each category. For A-items, maintain higher service levels (lower stockout probability), negotiate better supplier terms based on volume, and consider keeping backup suppliers. For C-items, consider whether they are worth stocking at all — a slow-moving item that ties up shelf space and capital may be better sourced on-demand or dropped from the catalog.

Inventory Management Tools and Systems

At low volume (under 100 SKUs), a spreadsheet with reorder points, current stock levels, and order tracking works adequately. At medium volume (100-1,000 SKUs), dedicated inventory management software (Cin7, Ordoro, SkuVault) adds automation, multi-channel syncing, and purchase order management. At high volume, enterprise systems or ERP integration becomes necessary for efficiency.

Regardless of tools, conduct physical inventory counts regularly. Cycle counting (counting a portion of inventory each day) is less disruptive than full annual counts and catches discrepancies sooner. Reconcile physical counts against system records monthly. Shrinkage (the gap between recorded and actual inventory) above 2% indicates a process problem — theft, receiving errors, or data entry mistakes — that needs investigation.