Open to Buy Planning for Ecommerce Brands

Open to Buy Planning for Ecommerce Brands

The $800K Inventory Trap That Starves Growing Brands

A $4M ecommerce brand growing at 40% year-over-year should be celebrating. Instead, they're staring at $800K in inventory sitting in a 3PL while their supplier needs a $200K deposit for next season's production run. The cash isn't there. It's locked in last season's overstock that nobody thought to mark down six months ago.

This scenario plays out constantly. Most ecommerce brands have no formal inventory budget. They buy reactively. When sales spike, they panic-order. When cash is flush after a strong quarter, they over-order. When a supplier offers an early-pay discount, they grab it without checking whether the warehouse can absorb another 5,000 units.

The result is a brand that looks healthy on the P&L but is chronically short on cash. Revenue grows while free cash flow shrinks. The founder blames the ad spend. The ops lead blames the supplier MOQs. Nobody blames the inventory buying process because there isn't one.

This is the core dysfunction: buying inventory on feel instead of a budget. If your CAC is working and revenue is climbing, the instinct is to buy more stock. More SKUs, more depth per SKU, more safety stock "just in case." The math seems reasonable until you realize that a $4M brand carrying 90 days of inventory instead of 45 has an extra $500K trapped in product that could be funding marketing, hiring, or product development.

Overstocking traps cash while stockouts kill revenue. Both problems stem from the same root: no buying discipline. The brand has a marketing budget, an ad spend budget, a payroll budget, but no inventory purchase budget tied to actual demand.

Retail has solved this problem for decades. The discipline is called Open-to-Buy planning. And most ecommerce operators dismiss it as a retail relic, something for department stores and buyers with clipboards. That dismissal is costing them six figures in trapped working capital every year.

**The Inventory Cash Lock System**: OTB Planning for Product Brands

The Inventory Cash Lock System: OTB Planning for Product Brands

Open-to-Buy is one of the oldest disciplines in merchandising, and I've adapted it for ecommerce operators as The Inventory Cash Lock System. The formula at its core is deceptively simple:

Planned Sales + Planned End Inventory - Current Inventory = Budget to Buy

That's it. Every dollar you spend on inventory flows through this equation. If the equation says your buying budget for April is $80K, you spend $80K. Not $120K because your supplier offered a bulk discount. Not $50K because cash feels tight. Eighty thousand dollars, calculated from actual demand data.

The system works because it forces three conversations that most ecommerce brands never have:

First, what will we actually sell? Not hope to sell. Not what the sales plan says on an optimistic day. A grounded, category-level forecast built from the last 12 months of data, adjusted for seasonality and known growth drivers.

Second, how much inventory do we need at the end of each month? This is where most brands have a complete blind spot. They think about what to buy but never define how much stock they want left over. Setting an ending inventory target, typically 30-45 days of supply, creates the constraint that prevents overbuying.

Third, what do we already have? Current inventory on hand plus anything in transit minus committed sales. This number is often higher than operators expect because it includes slow-moving stock they've mentally written off but never actually cleared.

When you subtract your current inventory position from the sum of planned sales and planned end inventory, you get your Open-to-Buy budget. The number might be smaller than you'd like. That's the point. The Inventory Cash Lock System prevents you from spending cash you don't have on inventory you don't need.

I've deployed this across multiple product brands between $2M and $10M, and the pattern is consistent: the first time founders see their OTB budget calculated properly, they discover they've been overbuying by 20-40% in at least two product categories. The excess wasn't visible because revenue was growing fast enough to absorb some of the bloat. But the cash impact was real.

Phase 1: Build Your Baseline (Days 1-30)

The first month is about data collection and framework setup. You're not changing any buying behavior yet. You're building the infrastructure to make informed decisions.

Week 1: Inventory audit by category. Pull every SKU from your system. Group them by product category, not by supplier or by the random tags someone set up in Shopify three years ago. For each category, calculate: current units on hand, current cost value, last 90 days of sell-through rate, and days of supply remaining at current velocity. If you're using a tool like Inventory Planner, this data is available in reports. If not, export from Shopify and build a spreadsheet. This takes a competent ops person about four hours.

Week 2: Sales forecast by category. Build a 12-month rolling forecast at the category level. Start with last year's actuals by month, then adjust for three factors: known growth rate (use the last six months' trend, not the annual average), planned marketing changes (new channels, budget increases, major campaigns), and seasonality. If Q4 was 35% of last year's revenue, assume roughly the same weighting unless something specific has changed. Don't forecast at the SKU level yet. Category-level precision is enough for OTB planning, and SKU-level forecasting at this stage creates false accuracy.

Week 3: Set ending inventory targets. For each category and each month, calculate your target ending inventory. The standard starting point is 30-45 days of cover. If your category has a 60-day lead time from supplier to shelf, you'll need closer to 45 days. If lead time is 14 days (domestic supplier, no customization), you can run leaner at 30 days. Write these targets down. They become the constraint that governs every purchase order.

Week 4: Calculate your first OTB budget. For each category and each upcoming month, apply the formula: Planned Sales + Planned End Inventory - Current Inventory = OTB Budget. You'll likely discover two things. First, some categories are already overstocked, which means your OTB budget for those is zero or negative. That's not a bug. It means you need to sell through existing stock before buying more. Second, some categories are underfunded, particularly fast-moving ones where you've been stockout-prone. The Inventory Cash Lock System makes these imbalances visible for the first time.

Create a simple dashboard or spreadsheet with columns for: category, month, planned sales, planned end inventory, beginning inventory, OTB budget. This becomes your buying bible.

Phase 2: Execute and Refine (Month 2-6)

With the framework built, month two is when behavior changes. Every purchase order now runs through the OTB budget before approval.

Month 2: Purchase order discipline. From this point forward, no purchase order gets placed without checking the OTB budget for that category and that month. If a supplier offers a deal on 10,000 units but your OTB says you should buy 6,000, you buy 6,000. The discount on the extra 4,000 units is not free money. It's money trapped in inventory that won't sell for another 90 days. Your ops lead or whoever places orders needs to understand this trade-off clearly. Print the OTB budget and pin it next to their desk if you have to.

Month 2-3: Address the overstock. Those categories where OTB came back zero or negative? Build a liquidation plan. Options, in order of margin preservation: bundle slow movers with fast sellers, run a flash sale at 20-30% off to your email list only (protects brand perception on the main site), sell through a secondary channel (Amazon, marketplace, or outlet), and as a last resort, donate for a tax write-off. The goal is to convert dead inventory to cash within 60 days. Every dollar recovered goes back into the OTB budget for categories that need it.

Month 2-3: Supplier communication. Share your OTB plan with your top three suppliers. This is not optional. Suppliers who understand your buying cadence can plan production runs, offer better lead times, and sometimes negotiate pricing based on predictable order volumes. Frame it as partnership: "We're moving to planned buying cycles. Here's our projected order schedule for the next six months." Most suppliers respond positively because predictable demand is worth more to them than sporadic large orders. You also gain negotiating power. When a supplier sees that you've planned $300K of purchases across six months, they're more likely to offer payment terms (net 60 instead of net 30) or volume breaks. That cash flow benefit compounds quickly across multiple suppliers.

Month 3-4: Refine the forecast. Your initial 12-month forecast was a starting point. Now you have real data flowing. Compare each month's actual sales against your forecast and calculate the variance. If you're consistently over-forecasting a category by 15%, adjust. If a category is outperforming, increase the forecast and the corresponding OTB budget. Monthly reforecasting is what keeps the system alive. A forecast that sits untouched in a spreadsheet for six months is worthless.

Month 4-6: Category-level profitability. Now that you have clean inventory data and disciplined buying, layer in gross margin by category. Some categories turn fast but carry thin margins. Others turn slowly but carry high margins. Your OTB process should weight buying budget toward categories that generate the most gross margin dollars per dollar of inventory invested. This metric, often called GMROI (Gross Margin Return on Inventory), becomes your strategic buying guide. A category with 60% gross margin and 8x annual turns deserves a bigger share of your buying budget than one with 40% margin and 4x turns, even if the second category has higher absolute revenue.

Ongoing: Monthly OTB review. Block 90 minutes on the last Friday of each month. Review actual vs. planned sales by category, recalculate OTB budgets for the next three months, flag any categories that are trending toward overstock or stockout, and approve the next month's purchase orders against the updated OTB. This meeting replaces ad hoc buying decisions with a structured process. It takes less time than the supplier calls and emergency reorders it prevents.

The New North Star: Cash-to-Stock Ratio

Stop measuring inventory health by total units on hand or total inventory value. Both numbers are misleading in isolation. A $500K inventory position is great if you're selling $250K per month. It's a crisis if you're selling $80K per month.

The metric that matters is your Cash-to-Stock Ratio: the relationship between the cash tied up in inventory and the cash that inventory generates each month. Calculate it as: Monthly Revenue / Average Inventory Cost at Retail. Healthy ecommerce brands at the $2M-$10M level should target a monthly Cash-to-Stock Ratio between 0.8 and 1.2, meaning your inventory investment roughly equals one month's revenue.

Below 0.8 means you're carrying too much stock relative to sales velocity. Your cash is trapped. Above 1.2 means you might be running too lean, risking stockouts during demand spikes. Both conditions are visible in the OTB plan before they become problems.

The Inventory Cash Lock System gives you something most ecommerce brands lack: the ability to make proactive buying decisions instead of reactive ones. You see the overstock forming three months before it arrives. You see the stockout risk building two months before your best seller goes to zero.

Brands that run disciplined OTB planning consistently free up 15-25% of their working capital within the first two quarters. That's not a theoretical number. It's the predictable outcome of replacing gut-feel buying with a formula that accounts for planned sales, ending inventory targets, and current stock levels.

For a $4M brand, 15-25% of working capital freed up translates to $150K-$250K that was previously locked in slow-moving stock. That's enough to fund a new product launch, hire a key team member, or build two months of marketing runway. The brands that win at scale aren't the ones spending the most on ads. They're the ones whose cash cycle moves fast enough to fund growth from operations instead of debt.

Your inventory is almost always your biggest asset and your biggest cash drain. OTB discipline forces you to treat buying like what it is: a budgeted expense with a defined ceiling, not an open-ended bet on future demand. Start with the audit. Build the forecast. Set the targets. Calculate your OTB. Then let the math, not your instinct, decide what to buy.