Range Planning and Assortment Management in Retail

Assortment management is the retail job of choosing the right products, variants, and inventory depth for each store or channel at the right time. Done well, it improves sell-through, stock turn, margin, and customer satisfaction. Done badly, it creates stockouts on items people want, overstocks on slow movers, extra markdowns, and cash tied up in the wrong inventory. The same logic applies whether you run a large chain or a tighter specialty range. A studio retail corner, for example, may only carry socks, towels, bottles, and caps, but it still has to decide which styles belong, how many colours or sizes to offer, and how deep to buy each one. If you are building custom merch for pilates studios with PilatesGoods, those choices matter just as much as the design itself.

Why the wrong product mix costs more than you think

A retailer can hit a sales target and still have a weak assortment underneath it. Maybe overall revenue looks fine, but one store ran out of core sizes while another sat on slow colours. Maybe ecommerce sold a hero product well, but the rest of the range only moved after discounts. In both cases, the top line hides a product-mix problem.

The cost shows up later. Shoppers leave when the right variant is missing. Excess stock turns into markdowns. Allocation and replenishment teams spend time fixing avoidable imbalances. Cash gets trapped in inventory that does not earn its space. The right answer also changes by format and channel. Physical stores cannot carry endless choice, while ecommerce can show more variety but still needs disciplined depth and clean navigation. That is why assortment management is not just a buying task. It directly shapes margin, cash flow, and the customer experience.

Get these assortment terms straight first

Retail format changes the assortment job

The demand signals to check before you buy

• Sales history and sell-through rate show which products consistently earn a place in the range and which ones stall once the launch period ends.
• Velocity and weeks of supply help you see both sides of the risk: items that are likely to stock out and items that are soaking up too much inventory.
• Margin contribution matters as much as unit sales. A high-volume item with weak margin may deserve less space than a steadier, more profitable one.
• Variant-level patterns are essential. Average product performance can hide the fact that one size, colour, or style drives most of the demand while other variants drag the line down.
• Basket data and bundle behaviour reveal what sells together. That can support better cross-merchandising without automatically widening the range.
• Customer signals add context to the numbers. Reviews, surveys, search behaviour, staff feedback, and observed purchase drivers often explain why demand is moving.
• Stable signals and fast-changing signals should not carry the same weight. Long-running patterns should anchor core assortment decisions, while short-term spikes should influence tests, not replace basics.

Start with the shopper, the store mission, and the goal

Before choosing products, choose the goal. Are you trying to grow revenue, protect margin, improve stock turn, lift service level, or sharpen brand positioning? Then define the target shopper and the mission of the store or channel. A convenience mission needs dependable core items. A discovery-led or premium mission can support more newness. Seasonal missions shift faster still. When a business grows quickly, ad hoc assortment choices become riskier because products enter the range without a clear role.

Build the range around categories, roles, and real buying behaviour

Managing assortments works better when categories are built around how people actually shop. Start with category roles: core products, trend items, add-ons, and impulse purchases, then compare that mix against the yoga and pilates accessories that sell most. That keeps decisions intentional instead of turning the range into a list of whatever suppliers offer or internal teams happen to request.

Next, map the buying logic. Shoppers do not usually decide from a spreadsheet of SKUs. They filter by need and attributes. In a small merch line, someone might choose product type first, then rise or style, then colour, then branding details. That decision tree shows which options deserve space and which ones can be trimmed.

Basket data adds another layer. If bottles sell alongside towels, or socks regularly sell with small add-ons, those products may deserve to sit together in-store and online as part of effective retail upselling techniques. The point is not to keep expanding the assortment. It is to make every item earn its place in the range.

Localise by store cluster, season, region, and channel

Localisation helps retailers stay relevant without rebuilding the assortment one store at a time. A common approach is store clustering: group locations with similar demand, size, shopper profile, or seasonal patterns, then plan for the cluster instead of each individual store. That keeps planning scalable.

A base range creates consistency. Localised products then adjust for climate, region, events, store size, or channel behaviour. It helps to separate product logic from location logic. Assortment groups define what the business could offer. Store clusters decide where each part of that offer should go.

The danger is over-localising. If every store gets a unique range, buying, allocation, replenishment, and reporting become much harder to control. Good localisation stays selective: enough flexibility to reflect real demand, but not so much complexity that the business loses efficiency.

Balance breadth, depth, space, and margin

Every assortment decision is a trade-off. More choice can attract more shoppers, but it can also fragment demand and leave inventory spread too thin across too many options. Broader assortments increase variety. Deeper assortments improve availability on proven winners. Retailers have to decide which side matters more by category and by channel.

Bottom-up demand also has to fit top-down financial guardrails such as budget, cash flow, and margin targets, and a retail margin calculator guide can help quantify that. Space matters just as much. Shelves, fixtures, stockrooms, and pick faces all limit how wide and deep the range can realistically be. Shelf life, reorder points, and pricing should be considered before the buy, not after it.

If an item only works once it is heavily discounted, it was probably a weak assortment choice to begin with. When breadth, depth, space, and margin are planned together, the result is better full-price sell-through, fewer markdowns, and healthier stock turns, which are easier to review with an inventory turnover guide.

Adjust in season before stock problems snowball

Assortment plans should act like living plans, not static files. Live sales, supply shifts, and competitor moves can all change what the range needs mid-season. The main in-season levers are practical: replenish faster into winners, transfer stock to places where demand is stronger, adjust pricing when needed, and rebalance categories when one part of the assortment is underperforming.

This works best when assortment, allocation, replenishment, marketing, and store operations are all using the same demand view. When they are not, execution teams end up firefighting stock problems that better planning could have prevented.

Where range planning and assortment management sit in the bigger retail process

When spreadsheets stop being enough

Spreadsheets can take a retailer surprisingly far, especially when the range is focused and review routines are disciplined. But they start to strain when the business adds more stores, more channels, more variants, tighter review cycles, and heavier localisation. The real issue is not just bigger files. It is rising SKU-store complexity and faster decision speed.

Retail assortment management software typically adds clearer SKU-store visibility, scenario planning, localisation or space logic, and faster updates across teams. Many readers know these capabilities through enterprise examples such as legacy JDA assortment planning tools or Nielsen assortment and space optimisation solutions. Those are examples, not the only route.

Smaller specialty retailers can still go a long way with clean data, clear category roles, and regular reviews. Larger chains usually reach the point where dedicated assortment management applications become worth it much sooner.