COD Demand Planning: Forecast Inventory With 30% Returns

COD demand planning requires different math than prepaid stores use. Standard inventory forecasting assumes most orders stick — you sell 100 units, 100 units leave your warehouse, maybe 5 come back. For COD merchants, that assumption is dangerously wrong.

According to Unicommerce's ShipWay data, roughly 26% of cash-on-delivery orders get returned compared to less than 2% for prepaid. In some regions and product categories, RTO rates hit 35-40%. When a quarter to a third of your shipments bounce back, every inventory decision you make using standard formulas breaks — your reorder points, your safety stock, your cash flow projections, all of it.

Most inventory guides ignore this. They treat returns as a minor variable. For COD merchants, returns aren't a variable — they're a core operating parameter that changes how you buy, store, and plan.

Why Standard Demand Forecasting Fails for COD Stores

A prepaid store selling 1,000 units per month can forecast next month's demand based on order history, seasonality, and growth trends. Their sell-through rate sits around 95-98%.

A COD store selling 1,000 units per month actually delivers somewhere between 650 and 750 of them. The other 250-350 units ship out, fail delivery, and come back — eating double shipping costs, tying up inventory for 7-21 days during transit, and arriving back in varying condition.

This creates three problems standard forecasting doesn't account for:

• Ghost inventory: Units that are technically "sold" but are sitting in a courier's reverse logistics pipeline. You can't sell them. You can't count them. They're in limbo.
• Unpredictable restock timing: Returned units don't arrive on a schedule. Some come back in 5 days, some in 3 weeks. You can't plan around them the way you plan around supplier lead times.
• Condition variance: Not every returned unit is resellable. Damaged packaging, opened products, and quality degradation mean your effective return-to-shelf rate is lower than your return rate suggests.

Calculate Your True Sell-Through Rate by Product Category

Before you forecast anything, you need one number: your actual sell-through rate per product category. Not your store-wide average — category-level data, because RTO rates vary dramatically by product type.

The formula is simple:

True Sell-Through Rate = (Orders Placed - RTO Orders) / Orders Placed

Run this calculation for each product category over the last 90 days. You'll likely find patterns. Fashion and apparel typically see higher RTO rates than electronics or consumables. High-ticket items often have lower RTO than impulse purchases under $15.

Once you have category-level sell-through rates, you can build forecasts that reflect reality. If your phone cases have a 72% sell-through and your screen protectors have an 85% sell-through, those two products need completely different reorder quantities even if they sell at similar volumes.

Adjust Your Reorder Point Formula for RTO

The standard reorder point formula is:

Reorder Point = (Average Daily Sales x Lead Time) + Safety Stock

For COD, you need a modified version:

COD Reorder Point = (Average Daily Sales x Lead Time) / Sell-Through Rate + Safety Stock

Dividing by the sell-through rate inflates your reorder point to account for the units you'll ship but never actually sell. If you sell 10 units per day with a 14-day lead time and a 70% sell-through rate, your base reorder calculation goes from 140 units (standard) to 200 units (COD-adjusted).

That extra 60 units covers the orders that will ship, fail, and need to be replaced by fresh stock before the returns make it back to your shelf.

Build a Return-Adjusted Safety Stock Buffer

Safety stock protects against demand spikes and supplier delays. For COD merchants, it also needs to protect against RTO variability — because your return rate isn't constant.

Track your weekly RTO rate over the past 12 weeks. Calculate the standard deviation. Your safety stock should account for the worst-case return scenario, not the average one.

A practical approach:

1. Take your average weekly RTO rate (e.g., 28%)
2. Find the highest RTO week in the past 12 weeks (e.g., 38%)
3. Use the gap (10 percentage points) to size your buffer
4. Multiply your average weekly shipments by that gap — that's your RTO safety stock

If you ship 200 units per week and your RTO swings between 28% and 38%, you need an extra 20 units of safety stock just to cover return variability. That's on top of your regular demand-based safety stock.

During peak seasons and sale events, RTO rates typically spike. Indian ecommerce brands see average RTO rates of 20-25% normally, but rates can jump to 40% during high-volume periods. Double your RTO safety buffer during these windows.

Account for Return-to-Shelf Time in Your Planning Cycle

A returned unit isn't immediately available for resale. It needs to travel back through reverse logistics, get inspected, and be re-shelved. This return-to-shelf cycle typically takes 7-21 days depending on your courier and warehouse operations.

Factor this into your planning by tracking two separate inventory pools:

• Available inventory: Units on your shelf, ready to ship today
• In-transit returns: Units in the reverse pipeline that will eventually become available

Don't count in-transit returns as available stock when making reorder decisions. They're unreliable — timing varies, and a percentage will arrive damaged or unsellable. A conservative approach: assume only 80-85% of returned units will be resellable, and assume they'll take the maximum return window (not the average) to arrive.

If you use Shopify's inventory system, tag returned orders separately so you can track the reverse pipeline without mixing it into your available count. For general Shopify inventory forecasting tactics, the same principle applies — but COD stores need the additional RTO layer on top.

Reduce the Return Variable Instead of Just Planning Around It

Better forecasting helps you manage high RTO rates. But the highest-impact move is shrinking the return rate itself, which makes every other planning decision easier.

Merchants who introduce partial prepayment — collecting a deposit at checkout with the remainder due on delivery — report 20-40% lower return-to-origin rates within 60 days. A small deposit filters out impulse orders and no-shows before they ever enter your logistics pipeline.

OTP verification at order placement has a similar effect. When customers confirm their phone number before the order is created, fake and duplicate orders drop significantly. EasySell offers both partial payments and OTP verification on COD order forms, which directly reduces the RTO rate you're planning around.

Every percentage point you shave off your RTO rate compounds across your entire operation — less safety stock needed, shorter cash cycles, fewer damaged returns, and more accurate forecasts.

How Often Should You Review Your COD Demand Planning?

COD demand planning isn't a set-it-and-forget-it calculation. Your RTO rates shift with seasons, marketing channels, product mix changes, and even courier performance.

Build a monthly review that tracks:

• RTO rate by product category (is it trending up or down?)
• Average return-to-shelf time (is your reverse logistics getting faster or slower?)
• Resellable return percentage (are more units coming back damaged?)
• Forecast accuracy vs. actuals (did you over-order or under-order last month?)

Each of these inputs feeds back into your reorder point and safety stock calculations. A 5-point RTO improvement in one category might mean you can cut buffer stock by 15-20% — freeing up cash you can put into faster-moving products.

Start with the one calculation that matters most: your category-level sell-through rate. Pull 90 days of order and return data, run the math, and compare it to what your current reorder points assume. The gap between those two numbers is exactly how much inventory you're wasting every month.