Automation of Price Updates for E-commerce (Prom.ua)

The client (store on Prom.ua) faced the problem of manual price updates. Problem: Suppliers constantly send new price lists. Manually reconciling thousands of products by SKUs and changing prices is time-consuming and leads to errors. Standard import does not always correctly handle deleted products. Input data: Export files from Prom (.xlsx) and various formatted supplier price lists.

MY SOLUTION (The Solution)
I developed a custom tool based on VBA (Excel Macro) that fully automated the update process with 1 click.