Automation of price and stock updates on the Horoshop website

Task: automate the synchronization of prices and stock between the online store on Horoshop and several suppliers, so that the store updates only current products without manual work and without errors regarding missing items.

What has been done: a Python service has been developed that downloads supplier price lists from XML/FTP/YML sources, reconciles them with the reference product database of Horoshop, filters out unnecessary items, calculates prices and discounts according to individual supplier rules, updates stock through the Horoshop API, maintains local snapshots, has protection against critical drops in the number of products, Telegram reports, and a web admin panel for settings and manual synchronization launch.

Stack: Python, FastAPI, Jinja2, Horoshop API, FTP/SFTP, Telegram Bot API, CRON, Linux VPS, GitHub.

#Horoshop #python #XML #fastapi #cron