What we need is to get the following information from [login to view URL] in the Video games / software section for each items.
Here is the information we require to be fetched from [login to view URL] :
-Platform information
-Best Amazon price with fulfilment
-Best Amazon price without fulfilment but including shipping
-ESRB RATING
-Seller rank (in video games)
-Product dimensions / weight (2 excel boxes)
-Release date
-Manufacturer
-item discontinued?
-(If possible) we want the UPC code pulled from Amazon even if a UPC was used to get to the item (only 1 UPC, first one)
Here is how we want this to work
The macro has to be started by the user.
1- Search with the ASIN, if none, use the UPC code.
2- Fill in the field with the information from the product found on [login to view URL]
a. If an information is missing, leave the excel box clear.
3- Indicate once it’s completed.
We need:
The ability to stop the macro and resume at a later time.
The code to be non-encrypted.
The name of the software(s) used.
The macro to work in Excel 2003, 2007 and 2010
To add rows freely
Attached is a template with how we want the information displayed. **note that some information from the example may have changed since the creation of the template. In red are the user supplied information and green are the fields that needs to be pulled from Amazon.com.
PM me if any questions. I can provide some upc and/or ASIN for testing purposes.
We want to see a sample of what it looks like and how it works before we accept the bid.
Thank you
Hi...I will provide you a VB.Net based desktop application for this....My application will allow you to enter/import isbn list of which data needed to be extract...see PMB for more information..
$270 CAD in 5 days
5.0 (68 reviews)
5.3
5.3
15 freelancers are bidding on average $343 CAD for this job
HI ,
I have good exp in data scraping i will the script for Amazon and capture all required data automated.
Please provide me ASIN number. So i will provide sample file by today EOD.
Thanks,
Sonu
I'm a US born and based software developer with 15 years+ of VBA excel macro development experience as well as other languages. I just actually completed my first Freelancer.com gig of macro work in Excel similar to the scraping you request, and the client is very happy. It's straight forward actually. I ran a test with the link you provided in Amazon and I can bring back the data. The work actually is in the formatting of the retrieved data. I'm sure I'm not the least expensive, but I have learned that doing it correctly the first time is the way to go. By the way, please notice that I do not ask for any initial payment.