17 read min
TL;DR Assortment planning is the discipline of deciding which products to offer, in which stores, at what depth, and at what point in the season. Get it right and you protect margin, reduce waste, and keep customers coming back. Get it wrong and you face stockouts on one side and expensive markdowns on the other. Most retailers face both problems at the same time. This guide explains why — and what changes that.
Globally, more than $758 billion sits locked up in unsold retail inventory, according to The Retail Exec. At the same time, stockouts generate an estimated $1 trillion in lost sales every year worldwide. Sixty-nine percent of shoppers who encounter an out-of-stock item buy from a competitor rather than wait.
Those two numbers tell the same story from opposite ends. Retailers simultaneously hold too much of the wrong product and too little of the right one. The root cause is the same in both cases: assortment decisions made too early, on too little granular data, with plans that cannot adapt when conditions change mid-season.
Assortment planning is the discipline that closes that gap. It determines which products to offer, in which locations, at what depth, and at what moment in the season — aligning the product mix with real customer demand rather than with last year's plan or a buyer's instinct.
The stakes are rising. SKU proliferation has multiplied the decision space. Omnichannel retail means the same product must perform across physical stores, e-commerce, and wholesale simultaneously. And tariff volatility has added a new layer of risk. In a 2025 consumer survey by o9 Solutions, 45% of respondents said tariffs could prevent them from purchasing what they need during the holiday season — linking geopolitical disruption directly to assortment availability and revenue risk.
This guide explains what assortment planning covers, why traditional approaches can no longer keep pace, and what the retailers doing it well are doing differently.
What Assortment Planning Actually Means
IAssortment planning is the process of deciding which products to offer, where to offer them, in what quantities, and when — aligned to financial targets, local customer demand, and available store space.
It sounds straightforward. In practice, it is one of the most complex decisions in retail. A single assortment decision spans product attributes, store clusters, size curves, rate-of-sale forecasts, margin targets, and supplier lead times — all at once. A retailer managing 500 stores, 10 categories, and 200 active styles per category makes millions of interdependent decisions each season. All under time pressure. All with imperfect data.
The cost of getting those decisions wrong is concrete. Overstock drives markdowns. Over 40% of fashion goods end up sold at a discount, with reductions ranging from 30 to 70% to clear seasonal stock. Stockouts drive customers to competitors. Both outcomes destroy margin. Assortment planning is the mechanism for avoiding them — and the reason it has moved from a back-office planning function to a boardroom priority.
The Two Problems Every Assortment Plan Must Solve
Every assortment plan must solve two problems simultaneously: enough of the right products to capture demand, and no excess inventory on products that do not sell.
Most retailers struggle with both at the same time. The company running out of a best-selling size in one market is typically sitting on weeks of overstock in a slow-moving style at another location. The root cause is a planning process that treats all stores as interchangeable, leans on historical data that no longer reflects current demand, and produces static plans that cannot adapt when conditions shift mid-season.
The financial consequences compound quickly. A stockout does not just lose one sale. When 69% of those customers immediately buy elsewhere, every replenishment failure carries a direct revenue cost. An overstocked product requires markdowns that erode margin, occupies warehouse and floor space, and ties up working capital that could go to better-performing lines.
Getting the balance right — at store level, by size, by channel, by week — is what separates a well-executed assortment from an expensive one.
How the End-to-End Assortment Planning Process Works
Effective assortment planning runs as a continuous loop from pre-season strategy through in-season execution. Each stage builds on the one before it.
Merchandise Financial Planning (MFP) sets the top-down financial framework: sales targets, margin goals, and inventory budgets by category and season. These targets flow into the assortment process as the financial guardrails every subsequent decision must respect.
Options Strategy translates those financial targets into product-level decisions. How many distinct styles should the assortment carry? How deep should the buy go on each? Planners determine the width and depth of the assortment by product attribute group, using rate-of-sale data and store cluster logic to identify the optimal number of options per cluster.
Line Planning takes the Options Strategy and builds it into an actual product lineup. It combines carryovers, new introductions, and placeholder styles into a cohesive seasonal plan. Planners identify top performers using historical data, define placeholders for styles not yet confirmed, and reconcile sales and margin expectations throughout. In apparel and footwear, this process typically begins 12 to 18 months ahead of the season.
Range Planning assigns products from the Line Plan to store clusters and individual locations based on local demand patterns, rate-of-sale expectations, and space constraints. This is where a uniform plan becomes a localized one. The right product goes to the right store, not the same product to every store.
The Buy Plan converts the Range Plan into purchase orders. It determines what to buy, how much, when, and by channel — accounting for minimum order quantities, lead times, and phased delivery schedules. For fashion categories with long offshore lead times, the Buy Plan is where strategic intent becomes a binding financial commitment.
In-Season Management monitors performance once sales begin. Using real-time sales, stock, and intake data (tracked through WSSI — Weekly Sales, Stock, and Intake planning), it flags exceptions, identifies root causes, and drives corrective actions. When a category underperforms, the platform surfaces the issue, diagnoses the cause, and recommends a response — whether canceling receipts, adjusting allocations, or accelerating markdowns.
All six stages need to run on the same data model. When they do not — when MFP targets live in one system, line plans in another, and in-season performance in a third — the connections break down. The plan diverges from execution, and the losses follow.
Why Traditional Assortment Planning Is Failing
Traditional assortment planning was built for a simpler retail environment. Fewer channels, longer product lifecycles, and more predictable demand meant that seasonal plans developed months in advance could hold reasonably well. That environment no longer exists.
SKU proliferation has multiplied the decision space. More styles, more sizes, more channels, and more markets mean more combinations to plan and more ways to get the balance wrong. Human judgment alone cannot scale across the complexity modern assortment planning demands.
Uniform distribution strategies send the same assortment to every store. They should not. A store in a warm-weather market and a store serving cold-climate customers have fundamentally different demand profiles. A flagship in a dense urban area and an outlet in a suburban mall serve customers with different preferences and price sensitivities. Sending the same product mix to both leaves money on the table in both directions.
Disconnected pre-season and in-season workflows mean even a well-constructed plan cannot adapt when conditions change. When a style underperforms in week three of a season, teams typically discover it in a reporting tool, debate the cause across a series of meetings, and agree on a response two weeks later. By then, the lowest-cost intervention window has closed.
Sixty-eight percent of retailers now plan to apply AI-based technologies for assortment planning, according to recent industry data. That level of adoption intent reflects widespread recognition that spreadsheet-based processes and intuition-led decisions can no longer keep pace with the speed and complexity of modern retail.
How AI Is Transforming Assortment Planning
AI changes assortment planning in three fundamental ways: it improves demand forecasts, it enables localization at scale, and it accelerates in-season response.
Better forecasts start with rate-of-sale modeling. AI-powered platforms use historical performance, product attributes, store characteristics, and external signals — including foot traffic data, demographic patterns, and consumer trend indicators — to forecast how each product will sell in each location. That accuracy feeds directly into buy quantities and option counts, reducing both stockouts and overstock simultaneously.
Localization at scale is where AI delivers some of its most tangible retail value. Manually tailoring assortments across hundreds of store clusters exceeds the capacity of any planning team. AI-driven store clustering groups locations based on shared sales patterns, demographics, available space, and store format. Products then match to clusters automatically, with planners reviewing and adjusting rather than building from scratch. Eighty-one percent of customers expect personalized retail experiences, and AI-driven localization is the mechanism that delivers that personalization at the assortment level.
In-season agility comes from exception-driven workflows. Rather than reviewing every product's performance every week, AI-powered platforms identify the exceptions that matter — a style running ahead of forecast in one cluster, a category falling behind plan in a key channel — and surface the root cause alongside a recommended action. Planners act on what needs their attention. The system handles the rest.
The results from retailers adopting this approach are concrete. According to o9 Solutions, implementations have delivered up to 5% sales uplift, a 30% reduction in excess inventory, a 3 to 4% increase in gross margin, and a 25 to 40% improvement in full-price sell-through. Planner productivity improves by 20 to 30% as automation handles the repetitive tasks that currently consume most of a planning team's working hours.
Why Pre-Season and In-Season Planning Must Connect
Most retailers treat pre-season planning and in-season management as separate processes, often on different systems with different teams. That separation is costly.
A pre-season plan built on strong data still reflects conditions as they existed months before the season opened. Consumer preferences shift. Competitor promotions change the demand landscape. A delayed shipment disrupts the launch window. Any of these can make the original plan obsolete within weeks of the season starting.
When in-season management runs on a separate system, the response is slow. Planners manually reconcile what was planned against what is actually selling, identify the gaps, and build the case for a corrective action in a system not designed for it. By the time anyone approves a response, weeks of margin sit on the table.
The right architecture connects both in a single environment. Pre-season targets, rate-of-sale forecasts, and option counts flow directly into in-season tracking. When actuals diverge from plan, the platform flags the exception, traces it to a root cause, and recommends a time-phased action aligned to where that product sits in its lifecycle. Planners see the issue, understand the cause, and act — without switching between tools or rebuilding the analysis from scratch.
What to Look for in an Assortment Planning Platform
The strongest assortment planning platforms connect financial planning, product selection, store ranging, buying, and in-season management in a single environment, with AI generating the recommendations and planners making the final calls.
Five capabilities define platforms that deliver sustained value:
Financial integration with MFP means top-down targets flow directly into assortment decisions at the product attribute level. Every buy decision traces back to a financial target. Variances surface immediately rather than at end-of-season review.
AI-powered store clustering and localization groups stores by actual demand patterns and assigns products accordingly. Planners configure the clustering logic and review the output. The system generates optimal assignments automatically at a scale no manual process can match.
Automated ranging and buy planning converts the assortment strategy into executable purchase orders, accounting for minimum order quantities, lead times, size curves, and phased delivery schedules. For categories with long offshore lead times, this accuracy determines whether a season launches on time or not.
Exception-driven in-season management surfaces performance gaps as they emerge, identifies root causes, and recommends corrective actions aligned to the product lifecycle. Planners focus on the decisions that need human judgment. Everything routine runs automatically.
A unified data model across merchandising, finance, and supply chain keeps assortment decisions, inventory positions, and financial targets in sync throughout the season. Disconnected systems create the gaps that produce both stockouts and excess. A single data model removes them.
Assortment planning has always been one of the highest-leverage decisions in retail. What has changed is the speed at which those decisions need to be made, the number of variables they must account for, and the financial cost of getting them wrong. Static plans and spreadsheet-based workflows cannot meet that challenge. Platforms that connect financial intent, demand intelligence, and in-season agility in a single environment can.
About the authors
Ahana Das Sharma
Senior Product Marketing Manager
Ahana Das Sharma is a Senior Product Manager and Marketer for Retail Merchandise Planning at o9 Solutions, with over a decade of experience in B2B SaaS for retail. With a career spanning fashion merchandising, buying, and supply chain SaaS, she brings a unique blend of design thinking and retail expertise to her work. Ahana holds a Master’s degree from Domus Academy, Milan, and is based in Bangalore and enjoys pottery, spending time with her daughter, walking her dog, and practicing yoga in her free time.
