Automatic Repricing System
The Problem
The company sold on MercadoLibre, Tienda Nube, and their own website. With over 800 SKUs, the pricing team (3 people) dedicated 6 hours daily to manually reviewing competitor prices. They lost sales due to outdated prices and sold with negative margins without realizing it.
The Solution
- Price scanning of 12 competitors every 4 hours via APIs and scraping
- Business rules: "never sell below 8% margin"
- Automatic updates on MercadoLibre and Tienda Nube
- Slack alerts when competitor drops more than 15%
Results (6 months)
| Metric | Before | After |
|---|---|---|
| Weekly hours in pricing | 90 hrs | 2 hrs |
| Average margin | 11.2% | 14.7% |
| Lost sales/month | ~$13,000 USD | ~$3,200 USD |
| Sales with negative margin | 4.3% | 0% |