Client Business Challenge
Our client needed to verify the contact details of pharmacies it conducts business with. The details included information on postcodes, addresses, phone numbers, etc. The verification process, executed manually once a month, was time-consuming since the responsible employee had to verify information correctness for every pharmacy through Excel files and multiple websites and then update the company’s database, if necessary.
By implementing an RPA-enabled workflow, the verification process is now fully automated. Customer data are retrieved, synchronised, and verified using RPA components, web scrapers and Excel processors, to minimise completion time and maximise data accuracy.
The process starts by uploading an Excel file with the latest ERP contact information and another Excel file containing the latest correct contact information, downloaded from a central hub or acquired by email from an external source.