All work

E-COMMERCE

Online-pharmacy price monitoring (Gemini.pl)

Gemini.pl · 8 weeks to first value · ongoing retainer

Online pharmacy price monitoring dashboard
100k+
products tracked
−25%
purchasing cost
98%
data accuracy
daily
refresh

The brief

Problem, approach, result.

PythonWeb ScrapingFastAPISQLiteCrontab

Problem

Buying decisions on a catalogue of over 100,000 products were being made on a tiny, hand-checked sample of prices. By the time anyone finished comparing, the numbers had already moved.

Without a reliable history, nobody could tell whether a price was genuinely low or just noise, so the business consistently overpaid.

Approach

  • Built a resilient scraper with proxy rotation and request pacing that walks the full catalogue without tripping anti-bot defences.
  • Normalised every product into one schema so the same item is comparable across categories and over time.
  • Stored a dated price history and layered trend analysis and anomaly detection on top of it.
  • Pushed change alerts the moment a price crossed a meaningful threshold, and exported clean reports for the buying team.

Result

Purchasing costs dropped 25%, driven by always buying at the right moment from the cheapest reliable source.

The team replaced manual spot-checks with complete, validated, daily data, and a paper trail to justify every decision.

Excellent communication, on time, and fully committed. The result fully met my expectations.
Dominik Zielarski

Want results like these?

Send me the details of your project and I'll come back with specifics within 24 hours.

Let's talk