Amazon Scraping EAN PRICE ASIN and More!!!

Closed Posted Aug 23, 2012 Paid on delivery
Closed Paid on delivery

I sell products on Amazon and before adding new products for sale, I need to generate price history and rank history on potential new products as well as whether Amazon directly sells the product on a daily basis.

I'm not sure the best way to do this. My vision was a visual basic macro where we enter a EAN code or URL for an amazon product into the EXCEL spreadsheet, the macro then finds the URL to the product, fetches the page, identifies the price and pastes it one cell next to the URL, identifies the overall rank and pastes it to the right of the price, identifies the category rank and pastes it to the right of the overall rank, and identifies the seller and pastes it to the right of the price, the ASIN code, and the POSTAGE cost. I would also if possible like the TITLE and DESCRIPTION as well as two or three more parts that I can list if you would like to take this Job.

Specifically, I would enter the name of product 1 in Well b1 and the URL for product 1 in Well b2. Additional products would be spaced out every 5 columns (i.e. Product 2 name in Well f1 and Product 2 URL in well f2, Product 3 name in Well k1, etc.). The macro would begin by inserting a row below row 2, and then inserting the current date into well a3, then starting at the left, finds URL on row 2, fetches the page enters the information in row 3 below the URL (skipping information not present on the webpage), then moving onto the next URL and repeating until all URLs have been completed at which point it saves the file.

This is just one way for this to be done. I am open to any other way that accomplishes the same thing and presents it in a way that it can be easily extracted to EXCEL for analysis. Please reply if you need further details and if you have a different way of doing it, please detail it.

PHP Software Architecture Website Design

Project ID: #2426888

About the project

6 proposals Remote project Active Sep 29, 2012

6 freelancers are bidding on average £222 for this job

arnab0143

--Hello Sir, Amazon API expert. Please check your pm for more details. Thanks, Arnab.--

£200 GBP in 1 day
(70 Reviews)
6.6
waelfree

Hi, I can do that

£200 GBP in 2 days
(58 Reviews)
5.9
intechwebworks

Hello Sir I would like to help you in this task Thankyou

£250 GBP in 7 days
(18 Reviews)
5.3
jitendraparmar07

Expert scrapper here. I've already written a few bots to scrape amazon. Please check your PMB.

£180 GBP in 3 days
(11 Reviews)
4.6
kevinclark8

Hello Sir, Please check PMB for listing and confident to complete the project with quality services.. Best Regards

£230 GBP in 5 days
(0 Reviews)
0.0
LG897FhbI

Custom software development (<b><i>Removed by Admin</i></b>)

£250 GBP in 1 day
(0 Reviews)
0.0