How to automate price and margin monitoring in e-commerce

Manually checking prices and calculating margins in a spreadsheet is work that doesn’t scale with your catalogue. At a few hundred products it still works. At a few thousand it becomes a source of errors and delays. The good news: most of this process can be automated without expensive software.

What such a process usually involves

1. Data sources - supplier price lists (CSV/XML), store sale prices, marketplace prices.
2. Processing - unifying formats, matching by EAN or SKU, calculating margin.
3. Presentation - a dashboard or report showing margins and anomaly alerts.

A minimal, working architecture

You don’t need an enterprise platform on day one. This is enough:

• Python to load and join the data,
• a scheduled job (cron) on a VPS that runs the script, e.g. once a day,
• a simple dashboard or email report with the results.

Supplier price list (CSV) ─┐
Store prices (API) ────────┼─► Python ─► margin calculation ─► dashboard / alert
Marketplace prices ────────┘

What to watch out for

• Product matching. EANs can be inconsistent - keep a fallback rule by SKU or name.
• Currencies and discounts. List price isn’t purchase price. Account for discounts and costs.
• Alerts over tables. Nobody checks a spreadsheet daily - it’s better to get notified when a margin drops below a threshold.

The result

Instead of an occasional manual spreadsheet, you get a live view of margins and automatic alerts. This is exactly the type of project I built on my own VPS - and the one that pays back fastest in saved team time.