Project Description

Use cases > Detect assortment gaps in sales channels

Detect assortment gaps in sales channels

A leading distributor of FMCG household brands in Spain uses flipflow to optimize the availability of its assortment in key sales channels. Our platform allows to proactively detect stock gaps, ensuring efficient replenishment and maximizing sales opportunities.

Assortment analysis at geographic level

The company’s sales team analyzes assortments by postal code to understand where they have the most opportunities. Each Key Account Manager is assigned a specific area, and can:

Retail analytics dashboard displaying visualizations such as a pie chart for the number of products by website, a bar chart showing product distribution by categories, a line graph for monitored products' stock evolution, a stacked bar chart for product distribution by brand, and another pie chart for the number of products by brand.
Number one

Analyse hot spots and opportunities
by postcode to increase sales

The tool allows them to visualise where product shortages are occurring, facilitating replenishment decisions in areas of high demand.

Number two

Segment analysis by reference and category

Thanks to this segmentation, they locate gaps in the product catalogue, limited to the supermarkets they check by postcode.

Number three

View stock shortages in real-time

All teams have access to real-time, up-to-date data that enables them to act quickly.

Customised and automated reporting

The leading FMCG household brand company uses flipflow’s powerful BI system to generate detailed reports and make data-driven decisions:

Business intelligence data explorer showing a table with product details such as website images, product names, point of sale, time, ZIP codes, country, and stock availability. Filters and measures include dimensions like time, point of sale, and in-stock ratio, with a sidebar listing analytics options like prices, availability, and digital shelf metrics.
Number one

Customised reports for each Key Account Manager

They set up reports focused on specific assortment and performance KPIs.

Number two

Daily automatic alerts with stock-outs or price changes

Their sales team receives immediate notifications when different patterns are identified such as:

  • Out of stocks of certain products.
  • Discounts that are too high (when a product is more than 10% off, for example, they are alerted).
  • Products priced above RRP.
Number three

User-friendly dashboards by region and shop for the sales network

They clearly visualise the status of the assortment, facilitating the detection of opportunities and problems.

Problem solving and performance optimisation

Lastly, the company manages its product range efficiently, achieving specific results and maximising its profits:

Availability

Increase in availability

Their Key Account Managers reduce stock shortages by ensuring that their products are always available in key channels.

spain map - Availability by region

Decisions based on accurate data

They detect patterns in the assortment and improve them with objective information. For example, if they detect that in Seville their assortment in Alcampo is only 15 references, while in the same city but in Carrefour, the assortment is 27 references, they have objective data and a hook to motivate the sale of 12 new references at Alcampo.

upward arrow

Maximising sales

By ensuring product availability and reducing time-to-restock, they increase sales opportunities and improve the customer experience.

Request your free demo

Discover flipflow in action

Fill out the form and explore the intelligent platform that is transforming retail. We will contact you to analyze and understand how we can help you make the best decisions in real time:

  • Control your distribution network

  • Monitor your competitors

  • Secure your position in the Digital Shelf