Case Study: Leading Colombian pharmacy chain implements Pricing and Space Planning modules

calendar_today September 25, 2020
Personal image
Gustavo Sappia

Customer Success Manager

  • One of the leading pharmacy chains in Colombia, owning 960 stores nationwide and selling more than 20,000 products, pursued a digital transformation that would allow coping with typical retail problems and increasing its profitability.
  • To achieve this objective, the company implemented Prisma Pricing and Space Planning modules in July 2020, and with a team of two Price analysts and two Category Management analysts, they carried out the transformation that currently means the administration of thousands of pricing suggestions for the entire chain.
  • Throughout this case study, we pretend to showcase an example of business consulting activities, definition of strategies, and implementation carried out by Prisma in conjunction with a retail company to accomplish the launch phase of the platform.

The implementation of Pricing module required action on the following aspects:

  • Store segmentation considering format, region and socioeconomic level of the area.
  • Machine Learning models were used to validate purchasing patterns and established the respective price zones.
  • Identifying the “KVIs”.
  • Differentiated strategies were established for each product and trade area, which made it possible to measure price sensitivities more precisely.
  • Products with low sensitivity to price changes were identified in order to improve margin.
  • Web scrapers were developed to capture market information on a daily basis.
Pricing module
Mystery Shopper App
  • Prisma Mystery Shopper APP was implemented and throughout “weekly missions”, we captured competitors’ prices in each “trade area” for “KVIs” products.
  • Related products were identified to establish parenting rules and accelerate price changes, maintaining consistency and reducing errors.
  • We defined the “Role and Strategy” for each product category to establish consistent target margins.
  • We developed an ad hoc feature to automatically and securely manage medicine prices’ regulated by the National Government. This feature would import the current government resolutions and generate alerts if a supplier is selling at a price above the regulated one, and establishes maximum selling prices allowed by the Government, eliminating the risk of fines and penalties.
  • Automatic importers were developed to process the pricing lists of national and regional suppliers in a timely manner and thus be able to generate suggestions detecting changes in costs or taxes, avoiding margin losses.

And from the Category Management perspective, the following actions were carried out:

  • Analyzed stores design and furniture to standardize the display.
  • The definition of the “Role and Strategy” for each category was considered to assign the space in each store.
  • Images and dimensions of the products were captured automatically to speed up the implementation of the Space Planning Module.
  • Item Master has been improved by adding additional segmentations to products to enhance segment analysis.
Space Planning

You may also be
interested in.

Find out how we can help you!