How can you optimize your supermarket assortments?

How to optimize product assortments in supermarkets?

Margot Bonhomme
December 12, 2023 - 8 min reading
Mis à jour le 26 février 2025

Optimizing retail assortments is a key factor in the commercial success of a store and a brand.

However, finding the right balance between meeting consumer expectations and maintaining high profitability can be complex.

For this reason, negotiating and optimizing assortments in supermarkets requires constant, meticulous analysis of various factors such as the nature of the product, the location of the point of sale, seasonal variations, the ability of consumers to buy the product...

This article will guide you through the various stages involved in creating an optimal assortment for supermarkets.

Contents:

Criteria to take into account when building an assortment

Establish your distribution strategy

Selon les enseignes dans lesquelles vous allez distribuer vos produits, vous n’allez pas mettre en place la même stratégie.

Beyond changing your offer, price or even packaging, you need to distribute your products in stores that match your brand image. Not all products are sold in all stores.

Also bear in mind that some chains want exclusivity on certain brands. This doesn't necessarily mean that you can't be sold anywhere else. Nevertheless, to attract a target clientele and differentiate themselves through their offer, some stores or chains require exclusivity on a range or product, which cannot be included in other assortment plans.

Understanding distributors' objectives

Sales targets vary between you and your distributors.

While you want to align your stores' offering with your sales targets, retailers are looking to satisfy consumer demand and maximize profitability. When putting together assortments, it is above all the ability of consumers to come and buy the products present in the store that is taken into account. For example, socio-professional category is taken into account: if a store's main clientele is CSP+ households, it will be able to stock more expensive products.

The challenge lies in the price/volume effect for the store:

  • "Do I have enough appeal for them to come to my store rather than another? " ;
  • "Do I have enough complementary product to get as many people as possible to buy the more expensive products?".

Their challenge is to satisfy customers' needs while minimizing shopping time. With limited sales space, store managers are looking to maximize their profitability per square meter.

In addition to these divergent objectives, there is the question of product quantity. The quantity of products in the assortment depends on market share (MSP).

For example, if tomato sauce has a market share of 10% in a given department, it must represent 10% of that department's assortment. When creating assortments, distributors also take into account the market share of each brand.

And PDM is important for maintaining sales! To better understand this, let's take a concrete example:

In France, ham has a 25% share of the charcuterie market.

Among brands selling ham, brand 1 has a PDM of 15%.

Naturally, ham accounts for 25% of the charcuterie aisle. Among the brands that sell ham, brand 1 accounts for 15% of the aisle.

This department sells an average of €10,000 / week, or €480,000 / year.

The ham PDM represents €120,000 in sales / year and the brand €18,000 / year.

Except, that's not always the case.

The store didn't take into account the ham's PDM. It then allocates only 20% of the shelf to ham. The remaining 5% is then reallocated to pies, which normally only have a PDM of 5%.

In this case, the volume allocated to the pie is greater than the volume used up.

Sales of pâté en croûte are €24,000 / year.

Ham sales are down to €96,000 / year (-20% of sales on the shelf / year).

Brand 1 sales are down to €14,400 / year (-20% sales / year).

It's a lose-lose situation for everyone, even though the PDM of brand 1 has not changed. But the latter can go up as well as down in the assortment.

The PDM of ham is well respected and achieves €120,000 in sales / year. But brand 1 is losing 5% to brand 2, which normally only has a 5% market share.

Brand 1 will therefore generate sales of €12,000 / year for the store on hams.

Brand 2 generates sales of €6,000 / year for the store.

In this case, the volume allocated to brand 2 is greater than the volume sold. Due to poor assortment in the department, the store loses €4,000 and brand 1, €6,000.

It's important to understand that if one or more flagship products are not present, then the department will lose sales volume, which will also impact the producer. Producers and distributors are not in competition. Quite the opposite: they are allies, with the common aim of increasing sales. If one earns more, intrinsically, so does the other.

PDM, based on reliable external data such as IRI, is a good way of explaining to your distributors how, by increasing your presence in assortments, they can gain in sales. Indeed, if they allocate the missing PDM to another product, they can have more breakage, especially when it comes to fresh products like ham!

It's important to note that sales figures can vary from region to region. For example, galettes and crêpes have a much higher MDP in Brittany than in Auvergne.

Finally, the type of assortment will change according to the type of retailer. For example, Lidl and Monoprix do not base their sales strategy on the same criteria, and therefore do not sell the same products. What's more, within the same chain, strata or modulation will affect the width and depth of the assortment.

This is what we're going to look at together in the rest of this article.

Types of supermarket assortments

In supermarkets, assortments refer to the variety of products available for sale in a store. Assortment types are generally classified according to the width and depth of the product ranges on offer.

In all, there are five types of supermarket assortment.

  1. TheBroad assortment, which offers a wide variety of different product categories. For example, a hypermarket offering items ranging from food to clothing, electronics and household products.
  2. TheProfond assortment, which offers numerous choices in a specific product category. For example, a store specializing in wines and spirits offering a vast selection of wines from different regions, grape varieties and vintages.
  3. Limited assortment, which offers a limited number of products, often focusing on the most popular or best-selling items. For example, a convenience store or small grocery store that focuses on staples and everyday items.
  4. Extended assortment, which combines width and depth, offering a wide variety of product categories and many options within each category. For example, a large supermarket or hypermarket offering a wide range of products in each category.
  5. L’assortiment Saisonnier, qui propose des produits temporairement en fonction de la saison ou d'événements spécifiques. Par exemple, les produits de Noël en décembre, les articles de jardinage au printemps, les fournitures scolaires en août-septembre.

How do you create your assortment plan?

A retail assortment plan is a detailed strategy that defines which products will be sold in a store or chain of stores. This plan is essential to ensure that product choice is available to meet customers' needs and preferences, while maximizing the profitability and efficiency of the sales space.

Here are some key elements of an assortment plan:

  1. Product selection: The plan determines the specific product categories and SKUs to be stocked. This can include a variety of goods, from staples to specialty or seasonal items. The aim is to take up as much shelf space as possible (and therefore that of your competitors);
  2. Depth and width of assortment: Depth refers to the number of variants of the same product (such as different flavors or sizes), while breadth concerns the range of different product categories on offer;
  3. Adapting to local needs: chains generally draw up a national assortment plan. The plan must also take into account the particularities of local customers. For this reason, stores are free to adapt. The national assortment plan is respected to a certain percentage. This is generally ~95% for integrated stores and ~80% for independent stores;
  4. Taking seasonality into account: Planning must anticipate demand and adapt to the seasonal needs of consumers. This is why it is important for a brand to follow the assortment plan, which will be dynamic throughout the year. For example, at Christmas, the poultry assortment is wider and deeper;
  5. Adapting to market trends and consumer habits: To optimize assortments, it is also necessary to take into account local and national macro-demographic changes, as well as societal evolutions. The halal market in France is a good example. From just 80 million euros in 2009, the market for halal products in supermarkets has risen to 282 million euros in 10 years, an increase of 247%;
  6. Profitability: Each product in the assortment must contribute to overall profitability, taking into account factors such as profit margin, stock turnover and customer appeal;

How to optimize your assortment

Optimizing sales space

There are three types of supermarket products:

  • Appeal products: without their presence on the shelf, consumers won't come into the store. These are strong products, on which chains and stores have little leverage to make margins. These products are generally placed at the head of the aisle or at the end of the shelf. For example: Nutella spread;
  • Other national brand products: these are the most profitable products for stores, as they can make higher margins on them. These products are generally placed in the middle of the shelves. For example: Lucien Georgelin spread;
  • Private labels: these products are becoming increasingly popular, as they enable retailers to control their image, broaden their range and generate high margins. These products are generally placed around national brand products. For example: Carrefour spread.

Today, supermarkets offer an average of between 7,000 and 10,000 items. Hypermarkets offer between 10,000 and 30,000 items. The current trend, however, is for chains to optimize their use of sales space.

🚨 To understand the trends ahead for 2024 in supermarkets, I invite you to read our white paper on sales optimization in supermarkets.

This can result in a more limited selection of products, favoring those that offer a quick turnaround. What's more, the number of new brands and references on the market is exploding, and the growing presence of private labels is further reducing available shelf space.

Sales space is a precious resource, and there isn't room for everyone. And it's mainly the second type of product (other national brands) that's taking up most of it.

So it's vital to select products that guarantee fast turnover and high profit margins. According to Nielsen research, fast-moving products can contribute up to 80% of a store's total sales. By concentrating the assortment on these high-demand products, stores can maximize profitability while effectively meeting customer needs.

Refined inventory management

Well-orchestrated inventory management is crucial to maintaining the availability of the most popular items, while avoiding surplus. According to McKinsey & Company, optimized inventory management can increase sales by 2-5% and improve gross margins by 5-10%. This involves a balance between consistent product availability and the reduction of overstocks or out-of-stocks.

Regular assortment adjustments

Regular assortment adjustment is a fundamental element in guaranteeing the relevance and attractiveness of the in-store offering. This involves constant evaluation of product sales performance, and close attention to customer feedback and changes in buying behavior.

La clé réside dans la capacité d'adaptation. En révisant fréquemment l'assortiment en fonction de vos analyses, vous pouvez ajuster votre offre pour mieux répondre aux attentes actuelles du marché et donc vendre plus. Cette stratégie assure que la gamme de produits proposée reste non seulement attrayante, mais aussi parfaitement alignée avec les besoins et les désirs des consommateurs.

Comment optimiser ses assortiments dans son CRM commercial ?

Vos assortiments sont optimisés ? C’est un bon début ! Il ne vous reste plus qu’à les intégrer dans votre CRM commercial pour améliorer la gestion des ventes en GMS. Cela permet aux équipes terrain d’accéder à une vision claire et actualisée des produits à promouvoir dans chaque point de vente. Voici quelques conseils pour y parvenir :

Créer et mettre à jour régulièrement les assortiments

Il est essentiel de configurer des assortiments adaptés à chaque enseigne ou typologie de magasin. Cela implique de regrouper des produits spécifiques avec des prix personnalisés, en tenant compte des particularités locales et des stratégies commerciales. Une mise à jour régulière des assortiments garantit que les équipes terrain disposent en permanence des informations les plus récentes, facilitant ainsi leur travail et l’exécution commerciale.

Créer des vues spécifiques pour les assortiments

Le principe est simple : on ne travaille jamais sur l’ensemble des points de vente en même temps, mais uniquement sur ceux qui répondent à un critère particulier. Parfois, ce critère peut être l’assortiment, afin d’optimiser le suivi des visites et des commandes. En créant des vues dédiées dans votre CRM, vous segmentez vos magasins pour identifier ceux où un assortiment spécifique est appliqué.

For example:

Vue "Assortiment Hypermarché E.Leclerc - Région Sud" : liste des hypermarchés E.Leclerc appliquant un assortiment spécifique dans le Sud.

Ces vues peuvent être partagées avec l’ensemble de l’équipe ou filtrées pour ne s’afficher qu’à certains collaborateurs selon leurs besoins.

Intégrer le picking

Le picking consiste à proposer des produits additionnels en complément de l'assortiment principal. Cette flexibilité permet aux commerciaux d'ajuster leur offre en fonction des opportunités et des besoins spécifiques de chaque point de vente, tout en respectant les cadres définis par la direction commerciale.

Pour tirer pleinement parti du picking, nous vous conseillons de définir en amont une liste de produits éligibles et de l’intégrer dans votre CRM.

Le CRM doit être utilisé par vos commerciaux pour enregistrer les produits ajoutés, assurant ainsi une meilleure visibilité des assortiments réellement mis en place en magasin. Cela vous aidera à analyser les performances des produits en picking. En comparant leurs résultats avec ceux des assortiments principaux, vous pourrez identifier les références qui mériteraient d’être intégrées de façon permanente à votre offre.

Cost optimization
Gérer le multi-marque avec précision

Pour les entreprises commercialisant plusieurs marques, il est important de structurer les assortiments de manière à refléter cette diversité. Deux approches sont possibles :

- Créer des assortiments distincts pour chaque marque**, afin de mieux segmenter l’offre.
- Regrouper plusieurs marques au sein d’un même assortiment**, lorsque cela répond aux attentes du distributeur.

Cette organisation facilite le remplissage des relevés terrain et permet une analyse plus fine des performances par marque. Pour une organisation plus claire, nous vous conseillons de structurer vos assortiments par enseigne, strate et marque.

Assurer un accès facile au catalogue produit

Un accès simplifié et en temps réel au catalogue produit est indispensable pour les équipes commerciales. Celui-ci doit inclure :

  • Des descriptions détaillées des produits
  • Des visuels
  • Les prix
  • Les disponibilités

Disposer de ces informations directement dans le CRM permet aux commerciaux de répondre rapidement aux demandes des clients et d’identifier des opportunités de vente additionnelle.

En appliquant ces conseils, vos équipes pourront gérer leurs assortiments de manière plus efficace, optimiser leur exécution en magasin et améliorer leur impact commercial.

CRM for all your distribution networks
Try Sidely free for 15 days. 
Request a demo
On the floor
Your daily source of sales advice
Sign up
The Sales Side
Recevez, 2 vendredis par mois,, un décryptage des tendances et actualités du secteur et du métier.
Recevoir la newsletter