- Number of suppliers – about 100
- Each section sales manager updates suppliers’ data
- Time for update — about two hours
- Totally managers — 10
- Total time expenditures — about 24 hours
Price-List Update
The case of the wholesale and retail company:
Problem
Increased time expenditures for suppliers’ data processing on availability, price, assortment. Growing number of suppliers requires permanently check products availability, special offers, best prices and purchasing conditions. As a rule, this routine is performed by the Purchasing Department officers, category managers, sales managers.
The customer’s requirements:
- One uploading type fits all formats of suppliers’ price-lists.
- Various file formats .xlsx, .xml, .yml, .csv to be processes
- Compare price-list items with internal assortment
Solution
Make suppliers’ price-list data update automatic
Stage 1 . The Sherpa software robot visits suppliers’ web-sites and downloads price-lists
Stage 2 . The robot compares price-list items with internal assortment (guided by the rules) and forms new price-list in Excel format
Stage 3. Upload files to the 1C system
Stage 4. A report on updated price-list creation is sent to the manager’s e-mail address
Sherpa RPA exchages data between systems:
Advantages
Now, it takes maximum 3 hours to process 100 price-lists
Now, to upload data from price-lists, only 1 person is required
No integration with third-party systems and services is required
Sherpa RPA can develop the best price offer for a client and remain competitive!
How can Sherpa RPA help you with it?
- Automate the process of updating price lists, eliminating the need for manual data entry.
- Quickly and accurately extract data from multiple sources, such as websites, databases, and spreadsheets.
- Configured to detect changes in pricing and alert users when prices need to be updated.
- Compare prices across different vendors and identify the best deals.
- Generate reports on pricing trends and help businesses make informed decisions.
Request for this solution