This is a project for experts with experienced with software named WinAutomation.
we need constantly to updated our ads prices on a portal of online sales, then we need make it bulk by downloading an Excel file (file A) directly from the portal and make massive changes, these prices are updated by taking the price of a Excel file we already have (file B) and afterwards then upload the file (A) back to the sales portal.
We need a script to automate the above process, such as I describe below:
1) log in to the sales portal with our user name and password, and download from there the Excel file (file A) with the prices.
2) Open both Excel files and update the prices of products taking this information from the worksheets Excel workbook (File B) by searching all the worksheets and update the Excel file (File A) save it and then upload to the site.
The Excel file (File A) is downloaded from the Internet and has a single sheet with information located:
Product Name: Column C, starting at C4
Product price: Column F, starting at F4
The Excel file (File B) is always in our pc and has several worksheets but always the information is located:
Product Name: Column E, starting at E7
Prodcut price: Column AS, starting at the AS7
This update should be performed by searching AND comparing the existing product names of the products.
The application must be in the ability to search all the pages of Excel file (File B)
1)FREELANCER must to send us the flowchart and algorithm before starting to verify that the information is clear between both.
2)FREELANCER should include error handle programming
3)FREELANCER must to test several times by hisself before sending the project to ensure us everything is working out
5 freelancer đang chào giá trung bình $129 cho công việc này
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi