Assortment planning is the discipline of choosing what to sell, where, when, and in what quantity—and aligning those choices with financial targets and fulfillment constraints. High-performing teams use live data (not spreadsheets alone), localize by cluster, balance evergreen vs. seasonal, and iterate in-season using clear KPIs (sell-through, GMROI, WOS, stockout rate). The payoff: higher margins, fewer stockouts, faster turns, and a smoother path from cart to doorstep.
What is assortment planning?
Assortment planning is a repeatable, data-driven process that determines:
- Selection & variations: categories, SKUs, sizes, colors, price points.
- Placement: by channel, region, store cluster, or fulfillment node.
- Timing & depth: when to land, how deep to buy, when to exit.
- Financial alignment: top-down targets (sales, margin, inventory) and bottom-up buys that actually fit cash and capacity.
Done well, it ensures the right product, right place, right time—and a fulfillment plan that keeps promises without bloating inventory.
Why it matters (and what goes wrong without it)
- Revenue & loyalty: Customers find what they want (and adjacent items they’ll add to cart).
- Margin protection: Less fire-sale discounting; more full-price sell-through.
- Inventory efficiency: Higher turns, lower carrying cost, fewer write-offs.
- Operational clarity: Clear rules for replenishment, safety stock, and network allocation.
Common failure modes: SKU sprawl, obsolete stock, chronic stockouts, mismatched node capacity, and “Excel drift” (teams reconciling sheets instead of serving customers).
Assortment models (choose with intent)
- Wide assortment: Many categories, shallow depth per category (generalists).
- Deep assortment: Few categories, deep variety within each (specialists).
- Narrow assortment: Tight, curated selection (boutiques, DTC focus).
- Scrambled assortment: Extensions beyond your core (test for cannibalization).
- Localized assortment: Mix tailored by region/cluster (climate, culture, demand).
- Mass-market: Wide and deep (requires strong planning + serious ops).
Tip: codify product hierarchies (good/better/best), so price anchoring and trade-up paths are intentional.
The modern assortment planning process (8 steps)
- Set objectives & guardrails
Define margin, revenue, cash, inventory turns, working-capital caps, and space limits. Align on pricing & promo posture. - Segment demand & cluster locations
Build clusters by climate, affluence, channel behavior, and category affinity. Use store/region clusters for retail and node clusters for ecommerce. - Architect the assortment
Balance evergreen (NOS) and seasonal; define attribute breadth (variety) and depth (variation). Bake in cross-merchandising pairs/sets. - Translate to capacity & constraints
Check shelf/planogram space, warehouse slotting, labor windows, vendor MOQs, lead times, and freight class. If it doesn’t fit ops, it’s not a plan. - Forecast & buy
Use historicals + demand signals (seasonality, events, launches). Set safety stock and reorder points by node; stage buys to reduce risk. - Price, promo, & presentation
Rules for regular/sale price ladders, bundles, and recommendations (“often bought with”). Ensure images/attributes support conversion. - Allocate & replenish
Initial allocation by cluster and node; dynamic reallocation as sell-through diverges. Enable inter-node transfers when economically rational. - Monitor & adapt in-season
Weekly OTB, SKU rationalization, markdown cadence, and fast rebuys on winners. Hold post-mortems and roll insights forward.
Data you need (and the KPIs that matter)
Inputs
- Historical sales & returns (by channel/node), lead times, vendor fill rates.
- Customer & market signals (climate, holidays, trends, search behavior).
- Capacity: shelf space, warehouse slots, labor throughput, cut-off times.
- Unit economics: landed cost, freight, storage, pick/pack, last-mile.
Core KPIs & quick formulas
- Sell-through % = Units sold ÷ (Units sold + On-hand)
- Inventory turnover = COGS ÷ Avg. inventory at cost
- GMROI = Gross margin dollars ÷ Avg. inventory at cost
- Weeks of Supply (WOS) = On-hand units ÷ Avg. weekly sales
- Stockout rate = Out-of-stock hours ÷ Available hours
- Deadstock % = Units with 0 sales for X days ÷ Total units
Track by SKU x node x channel to see true winners/laggards.
Evergreen vs. seasonal: getting the balance right
- Start with a portfolio view (e.g., 60–80% evergreen, 20–40% seasonal/specials), then tune by category.
- Promote seasonal winners into evergreen only after multiple cycles prove repeatability.
- Use test-and-learn drops (small buys, short windows) before scaling depth.
Omnichannel, localization & market-basket thinking
- Keep a consistent core across channels; localize the tail.
- Use market basket analysis to pair complements (attach rate drives AOV).
- Support BOPIS/ship-from-store with node-level visibility and service-level SLAs.
From spreadsheets to systems (what “good” looks like)
Move beyond brittle spreadsheets to connected planning. Look for:
- Centralized item/attribute data (PIM), real-time inventory (OMS/WMS), and seamless ERP integration.
- AI-assisted demand forecasting at SKU x node x week.
- Localized recommendations, constraint-aware plans (space, budget, MOQs).
- Scenario planning (“what if winter starts 2 weeks late?”).
- In-season automation: reorder alerts, transfer suggestions, markdown triggers.
The Selery Fulfillment POV: where planning meets delivery
Great assortments fail when the network can’t support them. Here’s how Selery keeps plans executable:
- Intelligent inventory placement
Distribute stock across our network to reduce shipping zones and hit delivery promises, based on order-destination heatmaps and service levels. - Node-level forecasting & safety stock
We help set reorder points per node using your lead times and demand variability, so top sellers don’t stock out on your fastest lanes. - Slotting & labor efficiency
Fast movers get prime slots for shorter pick paths; bundles and cross-merch pairs are co-located to speed fulfillment and lift attach rates. - Dynamic reallocation
Near-real-time performance monitoring enables inter-node transfers or targeted replenishment when sell-through diverges by region. - Returns & reverse logistics
Rapid triage and restock of resalable items protect margins and shorten the cash loop; damaged/unsellable flows are handled cleanly. - Clean data, clear decisions
SKU-level visibility, automated reorder notifications, and distribution recommendations inside your dashboard—so planning and operations stay in lockstep.
A practical timeline you can reuse
- T-24 to T-16 weeks (Pre-season)
- Set objectives, budgets, constraints; cluster locations; draft assortment architecture.
- T-16 to T-8 weeks
- Confirm vendors/MOQs; finalize buys; model allocations; book inbound capacity.
- T-8 to T-0
- Receive, QA, slot; enrich content; stage launch; confirm safety stock & ROPs.
- In-season (Weekly)
- OTB reviews; reallocate/transfer; markdown underperformers; rebuy winners.
- Post-season (T+2 weeks)
- Lessons learned: attribute-level winners, depth mistakes, capacity pinch points.
Assortment optimization tips (field-tested)
- Tighten the tail: Kill SKUs with low margin, low velocity, and high handling cost.
- Bundle complements: Pre-pack or virtual-bundle to raise AOV and speed picks.
- Guardrails for depth: Cap initial buys on new SKUs; scale only after signal.
- Localize with purpose: 70–80% shared core; 20–30% localized tail by cluster.
- Automate the boring stuff: Reorders, transfer suggestions, and exception alerts.
- Instrument everything: If you can’t measure it weekly, you can’t manage it.
Checklist: launch-ready assortment planning
- Objectives, budgets, and constraints documented
- Clusters defined (store & node), with localization rules
- Evergreen/seasonal mix and depth targets by category
- Cross-merchandising pairs and bundles defined
- Forecasts at SKU × node × week; safety stock/ROP set
- Vendor MOQs/lead times captured; inbound booked
- Allocation plan approved; slotting map ready
- KPI dashboard live (sell-through, GMROI, WOS, stockout, deadstock)
- In-season playbook for rebuys, transfers, markdowns
- Post-season retro scheduled with owners & actions
Ready to make your assortment plan executable?
Selery Fulfillment helps brands translate great planning into great delivery—through smarter inventory placement, node-level forecasting, efficient pick/pack, and fast, reliable shipping. If you’d like, I can tailor this article with a short Selery case vignette and add CTAs aligned to your services pages.