Price sync with a supplier price list
Once a day the script compares the supplier's price list with the shop catalogue and updates the prices that changed.
- Script
- 2025
- Python, pandas, cron
The task
The shop manager copied prices from the supplier's Excel file by hand — about an hour every day.
What I did
- Wrote the Excel parser and matching by SKU
- Set up a scheduled run on the server
- Added a Telegram report: what changed and what was not found
Result
Prices update overnight without the manager.