E-Commerce Inventory & Cash Flow Guide: The Math Behind Profitable Product Businesses

Part 1: The E-Commerce Cash Flow Problem

Why Product Businesses Die

Software businesses fail from not finding customers. Product businesses often fail from finding too many customers.

The mechanics: you buy inventory (cash out), sell it (cash in), then do it again at larger scale. The problem: the time between cash out and cash in grows as you scale, and traditional financing can't always keep pace.

Classic failure scenario:

• Month 1: Buy $50,000 inventory, sell $60,000 (good margin)
• Month 2: Order $100,000 inventory (need more to meet demand)
• Month 3: $60,000 of that inventory arrives; $40,000 delayed by supplier
• Month 4: $40,000 arrives; customer orders exceed current stock
• Meanwhile: Shopify payment holds for 7 days, PayPal holds $15K, you owe suppliers $30K in 15 days

The numbers add up to insolvency despite a profitable business. Cash flow, not profit, determines survival.

The Working Capital Cycle

Every product business runs a working capital cycle:

Cash → Inventory → Sales → Cash (+ margin)

The length of this cycle determines how much working capital you need:

Cash Conversion Cycle (CCC) = DIO + DSO - DPO

Where:

• DIO (Days Inventory Outstanding): How long inventory sits before selling. At 6x annual turnover: 61 days
• DSO (Days Sales Outstanding): How long after a sale until you receive cash. DTC with instant payment: 2-5 days. Wholesale: 30-60 days
• DPO (Days Payable Outstanding): How long you can wait to pay suppliers. Net 30: 30 days

Example — DTC e-commerce brand:

• DIO: 60 days
• DSO: 3 days (Shopify instant payout)
• DPO: 30 days (supplier net 30)
• CCC = 60 + 3 - 30 = 33 days

This means the business needs to finance 33 days of inventory at any given time. At $100K/month in sales with 50% COGS: you need ~$55,000 in cash/financing to sustain operations.

Example — Wholesale + DTC brand:

• DIO: 60 days
• DSO: 45 days (mix of instant DTC + net 30-60 wholesale)
• DPO: 30 days
• CCC = 60 + 45 - 30 = 75 days

Now you need to finance 75 days of inventory. Same revenue, same margin, but 2.3x more working capital needed. Adding wholesale without planning for this destroys many brands.

Part 2: Inventory Turnover Deep Dive

Calculating and Interpreting Turnover

Inventory Turnover = Annual COGS ÷ Average Inventory Value

Average Inventory = (Beginning Inventory + Ending Inventory) / 2

Example:

• Annual COGS: $720,000
• Beginning inventory (Jan 1): $120,000
• Ending inventory (Dec 31): $80,000
• Average inventory: $100,000
• Turnover: 7.2x

Days Inventory Outstanding (DIO): 365 / 7.2 = 51 days

You're holding an average of 51 days of inventory.

Category Benchmarks

Why turnover varies by category:

• Perishables and fashion must turn fast (obsolescence risk)
• Jewelry and collectibles can sit longer (appreciation potential)
• Commodity goods need high turnover to compensate for low margins

The Turnover-Margin Relationship

Low-margin businesses need high turnover to survive. High-margin businesses can tolerate lower turnover.

GMROI (Gross Margin Return on Inventory Investment):

GMROI = (Gross Profit / Average Inventory) × 100

A healthy GMROI is 200%+ (you make $2 in gross profit for every $1 of average inventory you carry).

Example:

• Gross margin: 45%
• Inventory turnover: 6x
• GMROI = 45% × 6 = 270% ✓

If your gross margin is 25% (lower-margin category):

• You need turnover of 8x to achieve the same GMROI
• GMROI = 25% × 8 = 200% (minimum viable)

Part 3: Open-to-Buy Planning

What Open-to-Buy Is and Why It Matters

Open-to-Buy (OTB) is a purchasing budget that prevents over-buying. It's the most important financial control in a product business and the one most ignored by founders.

OTB Formula:

OTB = Planned Sales + Planned End-of-Month Inventory - Beginning-of-Month Inventory - On-Order Inventory

Example for April:

• Planned April sales: $80,000 at cost (COGS)
• Planned April 30 ending inventory: $90,000
• April 1 beginning inventory: $75,000
• Inventory already on order for April: $30,000

OTB = $80,000 + $90,000 - $75,000 - $30,000 = $65,000

You have $65,000 left to spend on new inventory orders this month while maintaining your targets.

Building a 6-Month OTB Plan

The process:

Step 1: Forecast monthly sales (COGS) Use last year's data adjusted for expected growth. Seasonality matters — if you do 30% of annual revenue in Q4, your OTB plan must reflect that.

Step 2: Set target ending inventory for each month Target: lead time + safety stock. If your supplier takes 45 days and you want 15 days safety stock: 60 days of forward inventory at end of month.

At $80,000/month in COGS: 60/30 × $80,000 = $160,000 target ending inventory.

Step 3: Calculate OTB each month Roll forward: ending inventory becomes next month's beginning inventory.

Step 4: Enforce the budget The hardest part. Good deals, supplier minimums, and buying opportunistically all feel logical in the moment. Breaking the OTB plan creates excess inventory, which becomes a holding cost problem.

Part 4: Reorder Points and Safety Stock

The Reorder Point Formula

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

Where:

• Lead time: Days from order placement to inventory receipt (include transit and any customs clearance)
• Safety stock: Buffer against demand spikes and supply delays

Example:

• Product A sells 25 units/day average
• Lead time: 30 days
• Safety stock: 7 days of sales
• Reorder Point = (25 × 30) + (25 × 7) = 750 + 175 = 925 units

When your inventory drops to 925 units, place a reorder.

Calculating Safety Stock

Conservative formula:

Safety Stock = (Maximum daily sales - Average daily sales) × Lead time

If you sell 25/day average but have seen 45/day spikes, and lead time is 30 days: Safety Stock = (45 - 25) × 30 = 600 units

This is the inventory buffer against a worst-case demand spike during a full lead time cycle.

Right-sizing safety stock by product tier:

Over-safeying slow movers destroys working capital. Under-safeying fast movers destroys revenue. Right-sizing by tier is the optimization.

Part 5: Financing Inventory Growth

The Financing Toolkit

Self-financing: The goal. Grow slowly, reinvest profits. Works at low growth rates (20-40% YoY). Breaks down when demand exceeds your ability to finance inventory.

Business credit cards: Fast, flexible, expensive (20-29% APR if carried). Use only for short-term gaps (invoices paid in 30 days). Never carry balance longer than supplier payment terms.

Supplier terms (Net 30/60/90): The cheapest financing. Pay later = more time for cash to work. Negotiate: new suppliers default to Net 15 or COD; established suppliers will offer Net 30-60 after 3-6 months of good payment history. Net 60 on a $100K order is effectively a $16,500 interest-free loan at 10% cost of capital.

Purchase Order financing: Lender pays your supplier for an approved PO, you repay after receiving and selling the goods. Cost: 1-6% of PO value (expensive but enables growth without equity dilution). Best for: large, verifiable POs from credible retailers.

Inventory financing / revolving credit: Asset-based line of credit where inventory is collateral. Typical: 50-70% advance rate on inventory value. $200K inventory = $100-140K available credit line. Cost: prime + 2-5%.

Revenue-based financing (RBF): Advance against future revenue, repaid as percentage of daily sales. Shopify Capital, Clearco, Pipe. Cost: factor rates of 1.05-1.35 (pay back $1.05-1.35 for every $1 borrowed). Fast, no dilution, no credit check — but expensive for large amounts.

Equity: Raise venture capital or angel investment. No repayment required but gives up ownership. Only makes sense for high-growth businesses with clear path to large exit.

When to Use Each Source

Part 6: Reducing Dead Stock

The Markdown Strategy

Dead stock (unsold inventory sitting >90 days) costs you in storage, capital, and eventually, markdowns. Proactive markdown beats reactive clearance.

The 30/60/90 day rule:

• Aged 30 days without sale: 10% discount
• Aged 60 days: 20% discount
• Aged 90 days: 30-40% discount
• Aged 120 days: sell at cost to reclaim capital

This feels aggressive. It is. The alternative: holding inventory at full price hoping it sells, accumulating holding costs (20-30% annually), and eventually marking down further when you're desperate.

Alternative Clearance Channels

• Bundle with fast movers: Pair a slow-moving SKU with a top-seller as a bundle. Combines perceived value with inventory clearance.
• B-grade / seconds sales: For minor defects or packaging issues, price at 50-60% and sell via secondary marketplace.
• Wholesale to liquidators: Typically 10-30 cents on the dollar but immediate cash. Last resort.
• Charitable donation: Write off at cost value; no cash return but simplifies logistics and provides goodwill.

The goal: never let slow movers become dead movers. Catch them early and act decisively.

Use our Inventory Turnover Calculator to benchmark your turnover, calculate your holding costs, and identify which SKUs are draining working capital.