AI Automation

AI Merchandise Planning: Optimize Assortment, Allocation, and Markdown

Girard AI Team·March 22, 2027·10 min read
merchandise planningassortment optimizationmarkdown strategyretail analyticsinventory managementdemand forecasting

The High Stakes of Merchandise Planning

Merchandise planning is the backbone of retail profitability. Decide to stock too much of the wrong product, and you face markdowns that erode margin. Stock too little of the right product, and you lose sales and disappoint customers. Allocate inventory to the wrong stores or channels, and you simultaneously have surplus in one location and stockouts in another.

The stakes are enormous. McKinsey estimates that poor assortment decisions cost retailers 5 to 10 percent of total revenue annually. The National Retail Federation reports that overstocks and out-of-stocks together cost the global retail industry $1.75 trillion per year. For a retailer doing $100 million in revenue, even a 3 percent improvement in planning accuracy translates to $3 million in recovered margin.

**AI merchandise planning for retail** brings the analytical power of machine learning to these high-stakes decisions. By processing vast datasets—historical sales, trend signals, competitive intelligence, weather patterns, economic indicators, and customer behavior—AI generates demand forecasts, assortment recommendations, allocation plans, and markdown strategies that consistently outperform human planners working with spreadsheets and intuition.

The Three Pillars of AI Merchandise Planning

Pillar 1: Assortment Optimization

Assortment optimization answers the fundamental question: which products should you carry, in which variations, and in what quantities? Traditional assortment planning relies heavily on merchant intuition, vendor relationships, and historical sales data. AI augments this process with data-driven insights that capture signals humans miss.

#### Demand Forecasting at the SKU Level

AI models forecast demand for every SKU in your catalog, accounting for seasonality, trend cycles, promotional calendars, price sensitivity, cannibalization effects (when a new product steals sales from an existing one), and halo effects (when a popular product drives traffic that benefits adjacent products).

These forecasts operate at multiple time horizons: long-range (6 to 12 months) for seasonal buying decisions, medium-range (4 to 8 weeks) for replenishment planning, and short-range (1 to 2 weeks) for agile adjustments. The models update continuously as new data arrives, making the forecast more accurate as the season progresses.

#### New Product Forecasting

One of the hardest challenges in merchandise planning is predicting demand for products with no sales history. AI addresses this through attribute-based forecasting: the model analyzes the new product's attributes (category, price point, brand, material, style, color) and matches them against historical performance of similar products.

For example, if you are introducing a new line of organic cotton t-shirts at the $35 price point, the model draws on the sales trajectories of other organic cotton basics, other $35 t-shirts, and other items from the same brand to generate a demand forecast with quantified uncertainty bounds.

#### Assortment Breadth and Depth

AI helps you determine the optimal balance between assortment breadth (number of distinct products) and depth (inventory quantity per product). Too much breadth spreads capital thin and increases complexity. Too much depth in a narrow assortment misses opportunities and concentrates risk.

The model evaluates trade-offs: adding a new product creates incremental sales but cannibalizes some existing products and adds inventory carrying costs. Removing an underperforming product frees capital but may lose a customer segment. AI quantifies these trade-offs and recommends the assortment that maximizes total margin.

Pillar 2: Allocation Optimization

Once you have decided what to carry, you must decide where to put it. For omnichannel retailers with physical stores, warehouses, and e-commerce fulfillment centers, allocation determines which locations receive which products in which quantities.

#### Location-Level Demand Modeling

AI models demand at the individual store or fulfillment-center level, capturing local factors that aggregate models miss:

  • **Demographics:** A store in a college town has different demand patterns than one in a suburban family neighborhood.
  • **Climate:** A store in Miami needs different seasonal inventory than one in Minneapolis.
  • **Competitive proximity:** A store near a competitor's location may see different demand for overlapping categories.
  • **Local events:** Concerts, festivals, and sports events create temporary demand spikes that store-level models can capture.

#### Initial Allocation

For new product launches and seasonal buys, AI generates initial allocation plans that distribute inventory across locations based on predicted local demand. These plans account for minimum presentation quantities (the amount needed to create an effective display), replenishment lead times, and local size curves (the distribution of sizes demanded at each location).

Getting initial allocation right is critical because rebalancing inventory between stores after the fact is expensive and slow. AI reduces the need for transfers by placing inventory more accurately from the start.

#### In-Season Rebalancing

Despite the best initial allocation, demand rarely matches predictions perfectly. AI monitors real-time sell-through at every location and recommends inter-store transfers when inventory is misallocated. A product selling out rapidly at Store A while sitting on shelves at Store B triggers a transfer recommendation, along with a cost-benefit analysis (transfer cost versus incremental margin captured).

Pillar 3: Markdown Optimization

Every retailer faces the markdown decision: when to discount aging inventory, by how much, and in what sequence. Markdowns that are too aggressive destroy margin; markdowns that are too conservative leave dead stock on the shelf.

#### Price Elasticity Modeling

AI estimates the price elasticity of demand for each product—how much a price reduction will increase unit sales. Elasticity varies by product, customer segment, competitive context, and time within the selling season. A 20-percent markdown in October might generate a very different sales response than the same markdown in December.

The model also accounts for cross-elasticity: how discounting one product affects demand for related products. Marking down a basic black t-shirt might reduce full-price sales of a similar navy t-shirt—a cannibalization effect the markdown plan must consider.

#### Optimal Markdown Cadence

AI determines the optimal markdown schedule—the timing and depth of each successive discount—to maximize total revenue over the remaining selling period. This is a constrained optimization problem: inventory must be cleared by a target date, markdown cadences must follow certain patterns (no raising prices after a markdown, maintaining a minimum time between reductions), and the total markdown budget may be capped.

Dynamic programming and reinforcement learning approaches solve this problem efficiently, often finding markdown strategies that recover 5 to 15 percent more revenue from aged inventory compared to rule-based approaches. This concept connects directly to [AI dynamic pricing strategies](/blog/ai-dynamic-pricing-strategies), which handle real-time price optimization across the full product lifecycle.

#### Channel-Specific Markdown Strategies

For omnichannel retailers, markdowns should be coordinated across channels. A product might be full-price on the brand's website while marked down on a marketplace to clear excess marketplace-allocated inventory. Or a store markdown might be deeper than the online markdown to address store-specific overstock.

AI orchestrates these channel-specific decisions while maintaining pricing coherence and avoiding customer confusion.

Implementing AI Merchandise Planning

Data Requirements

Effective AI merchandise planning requires:

  • **Historical sales data:** At least two to three years of SKU-level, location-level sales data with timestamps. More data generally yields better forecasts.
  • **Product attribute data:** Category, brand, material, color, size, price tier, and style attributes for every SKU.
  • **Inventory data:** Current inventory positions by location, including on-order and in-transit quantities.
  • **Price and promotion history:** Every price change and promotional event, with start and end dates.
  • **External data:** Weather data, economic indicators, competitive pricing, and local event calendars enhance forecast accuracy.

If your data infrastructure is fragmented, begin with data consolidation. The Girard AI platform includes data connectors for major retail systems (Shopify, Magento, NetSuite, SAP) that automate the extraction and normalization of planning-relevant data.

Organizational Change Management

AI merchandise planning requires a shift in planner roles. Instead of building forecasts in spreadsheets, planners become curators and editors of AI-generated plans. They review model recommendations, inject qualitative knowledge the model cannot capture (vendor negotiations, brand partnerships, competitive intelligence), and make final decisions.

This transition can be uncomfortable for experienced planners who take pride in their intuition. Address this by demonstrating the model's accuracy relative to historical manual plans, giving planners override authority, and celebrating cases where planner judgment plus AI insight outperforms either alone.

Phased Rollout

Deploy AI planning in phases:

1. **Shadow mode:** Run AI forecasts alongside existing manual processes for two to three months. Compare accuracy. Build confidence. 2. **Pilot categories:** Apply AI-generated plans to two to three product categories. Measure performance against control categories using manual planning. 3. **Broad deployment:** Expand to all categories, with planners reviewing and approving AI recommendations before execution. 4. **Closed-loop automation:** For mature, well-understood categories, allow the system to execute allocation and markdown decisions automatically, with planners focusing on exceptions and strategic decisions.

Technology Architecture

A production AI merchandise planning system includes:

  • **Data warehouse:** Centralized storage for all planning-relevant data, updated daily or in real time.
  • **Feature engineering pipeline:** Automated transformation of raw data into model features (rolling averages, seasonal indices, trend indicators).
  • **Model training and serving infrastructure:** Scheduled model retraining and real-time prediction serving.
  • **Planning workbench:** A user interface where planners review forecasts, edit recommendations, run what-if scenarios, and approve plans.
  • **Integration layer:** APIs connecting the planning system to your ERP, POS, and e-commerce platforms for plan execution.

Case Study: A Multi-Brand Fashion Retailer

A fashion retailer operating 120 stores and a growing e-commerce channel was losing $8 million annually to markdowns on overstocked inventory while simultaneously leaving an estimated $5 million in sales on the table due to stockouts.

After implementing AI merchandise planning:

  • **Forecast accuracy improved by 32 percent** at the SKU-store-week level, measured by weighted absolute percentage error (WAPE).
  • **Markdown rates decreased by 18 percent** because initial buys and allocations were better aligned with demand.
  • **Stockout rate decreased by 25 percent** because the system identified fast-moving products earlier and triggered replenishment sooner.
  • **Gross margin improved by 2.3 percentage points**, translating to $4.6 million in incremental annual profit.
  • **Planner productivity increased by 40 percent** as planners spent less time on data manipulation and more on strategic decision-making.

Advanced Capabilities

Trend Detection from External Signals

AI can ingest signals from social media trending topics, fashion week coverage, influencer content, and search query trends to detect emerging demand before it appears in sales data. A spike in Instagram posts featuring a particular color or style signals demand that smart assortment planning can capture weeks ahead of competitors.

Sustainability-Optimized Planning

Overproduction is a major environmental issue in retail, particularly fashion. AI planning that more accurately matches supply to demand reduces waste, unsold inventory, and the environmental cost of markdowns and liquidation. Some retailers now include sustainability metrics alongside financial metrics in their planning KPIs.

Scenario Planning and What-If Analysis

AI planning systems enable rapid scenario testing: what if we add 50 new SKUs? What if a key supplier delays shipment by two weeks? What if a competitor launches an aggressive promotion? Planners can simulate these scenarios and develop contingency plans before events occur, replacing reactive firefighting with proactive strategy.

This aligns with the broader strategic planning capabilities discussed in our [complete guide to AI automation in business](/blog/complete-guide-ai-automation-business).

Transform Your Merchandise Planning

The difference between retailers that thrive and those that struggle often comes down to how well they plan their merchandise. AI gives you the analytical precision to stock the right products, in the right quantities, at the right locations, at the right time—and to clear what does not sell at the optimal price.

The technology is proven, the ROI is compelling, and the competitive window is open. Retailers that adopt AI planning now will compound their advantage with every season of improved data and model refinement.

[Optimize your merchandise planning with Girard AI](/sign-up) and start making every inventory dollar work harder, or [talk to our retail strategy team](/contact-sales) to assess your planning maturity and build a roadmap for AI-powered merchandising.

Ready to automate with AI?

Deploy AI agents and workflows in minutes. Start free.

Start Free Trial