Case Studies

Grocery retailer uses machine learning to adjust daily prices to maximize revenue and profits

Posted by | Shashank Kulshrestha


A US-based Grocery and Fresh retailer was grappling with retail giants like Walmart and national grocery chains, and wanted to leverage Machine Learning to optimize pricing.


  • The company wanted to leverage Machine Learning (ML) pricing optimization to model price-demand to maximize profit or revenue, based on the objectives of store owners.
  • They also wanted to execute price optimizations on a weekly basis, while ensuring adherence to the rules and guardrails defined at the enterprise, category, and location levels.


  • Fuld’s team of analysts designed jobs to integrate the weekly sales, product and sales hierarchy, competitor pricing, and other SKU metadata into the SAP database for both the SKUs and individual stores
  • Using Python and Alteryx we created ML jobs to model a demand-price response and calculate predicted sales, volume, and gross profit for each SKU and price-point
  • Once the jobs were in place, we designed the system to select optimal prices based on:
    • Pre-defined price rules and guardrails
    • Targets of balancing the revenue and profit goals
  • As part of the verification stage of the project, we triggered and executed optimization jobs daily to recalculate optimal pricing which we then shared with our client’s pricing team to evaluate and approve
  • We completed the project by creating dashboards in Power BI to help the client visually monitor revenue, profitability, opportunity curve, and the cost of rules


  • The prices were successfully optimized for each store location, product category and SKU family on a daily basis
  • The retailer was able to meet and/or maintain the revenue and gross profit targets for 80% of its stores within the first 3-months of deployment of the new system.

Tools Used




Tags: , , , ,

Related Resources

Read More

Competitive Intelligence through conference tracking

A leading US-based global manufacturer, specializing in scientific and lab equipment, supplies, and software for scientists, faced a challenge. They […]

Read More

Sustainable innovation in the polymer industry

Delivering sustainable innovation How we helped a leading industrial polymer manufacturer cut 1.5 years off its R&D timeline… and win […]

Read More

Leveraging Machine Learning in customer sentiment analysis

In a highly competitive market, staying ahead of customer expectations is critical for any manufacturer. A leading US plumbing fixture […]

Subscribe to our mailing list for our latest updates: