This is a project is for experts with experienced with software named WinAutomation ([login to view URL]), I am using the version 5.0
we have an amazon product list in EXCEL, with their product links and their prices and shipping costs for those products that arent prime ones.
An example of prime product (no shipping cost)
an example of NO prime product (they have shipping cost)
I would like an application that let me update all their prices including shipping cost if they have shipping costs The app have to be able of:
1) Let me open the excel file by search into my computer files
2) search in all the worksheets of the workbook and update all the Amazon links with price and shipping
a. if the link does not exist or item appears unavailable or appears with no price THEN write "NO" in a cell in front of product link and skip to the next
3) let me the option to give from which row number to start
4) let me the option of updating the actual file or make new one
5) this tasks could consume long time then the app have to save their work periodically to avoid loosing work
a minifile with just 100 links is attached to this project in order you could make a test if you want to before bidding in my project
1) FREELANCER should include error handle programming
2) before finishing the project FREELANCER must to test several times by hisself and perform a complete test with our test file with approximately 5000 links to ensure us everything is working out
3) Amazon scrapping would need to use IP proxy rotating, you must to include an sript to make this ip rotation.