Product Assortment Optimization: Finding the Right SKU Mix for Every Outlet

All products don’t fit into all outlets.

One of the common pitfalls for FMCG and CPG brands is forcing the same SKU mix across all outlets. Consumers served by a metropolitan supermarket, a local kirana store, and even a pharmacy may differ greatly in their behavior and preferences.

What is important is not to offer more but to offer the right goods in the right place.

Here comes the importance of Product Assortment Optimization. With an optimal product mix, it is easier for companies to ensure good availability, boost sales, minimize surplus stock, and optimize the use of the available shelf space.

This article will cover product assortment optimization, its significance, problems, and approaches for creating a winning SKU mix in outlets.

What Is Product Assortment Optimization?

Product Assortment Optimization is the process of determining the ideal SKU mix and product assortment strategy for each outlet, channel, or market based on demand, sales performance, consumer preferences, and outlet characteristics.

The goal is to ensure that every outlet stocks the products most relevant to its shoppers while avoiding unnecessary inventory and slow-moving SKUs.

Two key variables determine the type of assortment:

• Width (breadth): This variable measures the variety of product categories and subcategories offered by the brand at a particular outlet. A broad assortment consists of several product types being offered in that location.
• Depth: It refers to the range of SKUs of the brand’s product type at a store. That is, several pack sizes of that product type are available at that location.

Why Product Assortment Optimization Matters More Than Ever

Product assortment optimization is no longer just a category management exercise. It directly impacts sales performance, inventory efficiency, retailer relationships, and profitability across the FMCG distribution network.

• Maximizes Limited Shelf Space

Shelf space is limited, particularly for GT, where a retailer can have a limited number of SKUs on his shelf. All products require the same amount of shelf space, focus, and inventory investments. Optimization allows for allocating shelf space to the SKUs with the greatest impact.

• Aligns Products with Local Demand

Different markets show different consumption patterns, so the same product portfolio is unlikely to perform as well in other places. Product assortment optimization will help to adjust the SKU portfolio to suit local preferences.

• Reduces Stockouts and Lost Sales

Consumers usually go for a competing brand rather than wait until the desired product comes to the perfect store. Proper product assortment helps to minimize out-of-stock situations.

• Controls SKU Proliferation

Effective SKU Rationalisation in FMCG helps brand in inventory complexity, operational costs, and working capital requirements. Product assortment optimization helps focus resources on the products that deliver the most value.

• Improves Inventory Efficiency

Too many slow-moving SKUs can increase inventory cost, create risks of stock aging, and utilize working capital of the distributor for other purposes. Assortment optimization assists brands in concentrating on their productive SKUs.

• Strengthens Retail Execution

With proper product assortment strategy, the brand will be able to offer the right products to the correct outlets which increase outlet productivity, strengthen relations with retail partners, and assist in managing inventory efficiently.

• Supports Better Demand Forecasting

When there is an informed and data-driven assortment approach, demand forecasts are made easier. By knowing which products should be offered to which outlets, it becomes easier to forecast demand and plan accordingly.

As product portfolios continue to grow and consumer preferences evolve, product assortment optimization is becoming a critical capability for brands looking to improve sales performance, reduce complexity, and drive profitable growth

Types of Product Assortment Strategies in FMCG

Prior to implementing an optimization solution, it is vital to determine what type of assortment model is being used by the brand at present. There are four main types of assortment strategies, and most FMCG brands typically use a combination of all four strategies in different sales channels:

• Wide Assortment

Wide assortments consist of many product categories but a lesser number of SKUs in each. Such assortments are common in supermarkets and large format retail outlets where people prefer having a large variety of products at one place.

• Narrow Assortment

In case of a narrow assortment, there will be a few product categories that offer only the most important SKUs. Narrow assortments are suited for speciality outlets like chemists, HoReCa trade channel, or small retail shops.

• Deep Assortment

In a deep assortment, various SKUs, pack sizes and formats of certain categories will be available. Such assortments are commonly seen in categories that require variety of SKUs and give brands room for flexibility.

• Shallow Assortment

The assortment that includes high performing SKUs in a lesser quantity belongs to a shallow assortment. This assortment is suited for those retail outlets that have less shelf space.

Common Product Assortment Mistakes FMCG Brands Make

Even brands with large portfolios and strong distribution networks can struggle with assortment optimization. The challenge is often not a lack of data, but the wrong assortment decisions being made.

• Same SKUs across all store formats: Every store format caters to customers who differ in their needs and characteristics, space restrictions, and customer demands. Applying the same assortment across all outlets instead of building an outlet-level assortment strategy often results in poor SKU productivity and lower sales performance.
• Introducing new SKUs without taking out old ones: Companies launch their SKUs faster than they take out non-effective SKUs leading to the problem of SKU proliferation which affects the complexity of the inventory and working capital position of the distributor.
• Taking decisions based on other factors besides consumer demand: Assortments made based on company schemes or target-setting instead of consumer demand results in excess stock, lower movement, and increased return rates.
• Taking averages for each territory: Sales at the territorial level do not always provide enough information on individual store performance. Assortment optimization depends on the visibility of SKU performance per store.
• Pursuing assortment breadth instead of SKU depth: Assortments should be focused not necessarily on the number of SKUs offered in stores but on their effectiveness in increasing the number of units sold.
• Ignoring regular review of assortments: The requirements of consumers, market conditions, and sales patterns keep changing all the time.

How to Build an Outlet-Level Product Assortment Strategy

Effective product assortment optimization starts with understanding that different outlets require different SKU mixes. The goal is to match the right products to the right outlets based on demand, outlet characteristics, and sales potential.

• Segment outlets for smarter assortment planning: A structured outlet-level assortment strategy typically starts with Outlet Classification based on channel, geographic locations, sizes, and potential sales volume. A super high-volume store like a supermarket, for example, will have a totally different SKU than say, a small kirana store or a pharmacy, which should not stock similar products.
• Establish must-stock SKUs for every outlet class: Determines the essential SKUs that are must-have for a particular category or type of store. These are usually the products generating most of the sales revenue in the category.
• Use secondary sales data to optimize the SKU mix: Conducts an analysis of SKU level sales data based on consumer sales behavior and trends to determine what items consumers are buying from various outlets.
• Customize assortments by region and season: Consumer demand depends on various factors such as geography, seasons, cultural events, and many more. It is important to make sure assortments reflect such changes.
• Align product assortments with shelf space reality: The shelves and storage area capacity differ from one outlet to another. An assortment strategy should take into account the shelf availability per type of store.
• Continuously review and refine assortments: Assortments need to be periodically reviewed because consumer demand changes and therefore product performance.

Brands that build assortments around outlet-level demand rather than broad channel assumptions are better positioned to improve product availability, reduce inventory inefficiencies, and drive stronger sales performance.

How AI Technology Enables Product Assortment Optimization at Scale

Manual assortment planning often relies on historical sales reports, assumptions, and individual experience. Modern technology enables brands to make faster, more accurate assortment decisions using real-time data and AI-driven insights.

• Capture outlet-level demand through SFA: Sales Force Automation can provide insight into SKU level sales for different outlets and their territories, enabling brands to identify what is selling and at which outlets.
• Product recommendations through AI: AI Product Recommendations analyze purchase history, outlet characteristics, seasonality, and demand trends to recommend the right products for every outlet.
• Track must-stock SKU compliance: Availability of must-stock SKUs at specific outlets can easily be monitored using technology, and real-time updates can enable brands to manage product availability effectively.
• Enable demand-driven replenishment: With a combination of SFA and Distribution Management Systems DMS, replenishing decisions can be made based on demand, eliminating excess and insufficient stocking.
• Monitor assortment performance in real time: Brands can check SKU level performance in real time and monitor gaps in the assortments.

How Botree Software Helps FMCG Brands Optimise Product Assortment

Botree SFA and DMS platforms help brands make smarter assortment decisions through AI, secondary sales visibility, and real-time execution insights.

• AI-powered product recommendations: Recommend the right SKUs and Suggested Order Quantity (SOQ) for every outlet based on demand, outlet type, and sales history.
• Outlet-level SKU tracking: Monitor SKU penetration and product performance across outlets, territories, and channels.
• Secondary sales visibility: Understand what products are selling at the outlet level and make data-driven assortment decisions.
• Must-stock SKU compliance: Track the availability of priority SKUs across outlets and improve assortment consistency.
• Demand-driven replenishment: Align inventory and replenishment decisions with actual market demand.
• Real-time assortment analytics: Identify assortment gaps, monitor SKU performance, and optimize product mixes continuously.

By combining AI, secondary sales visibility, and field execution insights, Botree helps brands deliver the right SKU mix to every outlet.

Real-World Use Case: How Nabati Improved Product Assortment Decisions

As Nabati expanded its direct distribution network across India, the company needed greater visibility into SKU-level performance and a smarter way to recommend products to retailers.

Using Botree SFA and DMS, Nabati gained access to outlet-level sales insights, SKU-level performance data, and AI-powered product recommendations. Botree AI powered Product Recommender helped sales representatives identify the most relevant SKUs for each retailer based on purchase history and buying patterns.

This enabled Nabati to:

• Improve range selling across outlets
• Recommend the right products to the right retailers
• Reduce order-taking time for field teams
• Improve assortment decisions using outlet-level data
• Increase sales productivity by 37.5%
• Double business growth while expanding market reach

Conclusion

It is important to note that Product Assortment Optimization is not about portfolios. This is all about effective distribution execution. Not the brands with the most SKUs or the bravest launch schedule will succeed at product assortment optimization. Rather, those who know precisely what SKUs should be stocked where and who have the necessary infrastructure to execute this knowledge on each visit.

Secondary sales data for outlets on the ground, AI-based product recommendations, and must-stock compliance tracking have created this opportunity for precision and actionable insight. With such capabilities, brands build an advantage that accumulates over time — a better rate of sales, higher profit margins, better relationship with distributors, increased availability, and lower number of returned goods.

Placing the right SKU in the right outlet at the right time is not a logistical issue anymore. Instead, it is about gathering and using the proper data and executing your plan.

With software solutions such as Botree SFA and DMS, brands have the ability to take advantage of AI-based recommendations, secondary sales tracking, and other tools to optimize their product assortment and increase their profits.