Quick Amazon Research Task
Output I need the Amazon best sellers in the TV category (in the US) here:
http://www.amazon.com/gp/bestsellers/electronics/172659/ref=pd_ts_e_nav
into a spreadsheet:
An example product from amazon’s website looks like
———————————————-
Sharp LC19SB27UT 19-Inch 720p LCD HDTV, Black by Sharp
4.4 out of 5 stars (26 customer reviews) | 2 customer discussions
In Stock
List Price: $349.99
Price: $167.00
You Save: $182.99 (52%)
24 used & new from $158.95
———————————————
Each of those elements needs to be output to a cell in a spreadsheet.
Each product should have it’s own row. like so
MANUFACTUER, MODEL
Sharp, LC19SB27UT
Sharp, LC1ABDF7UT
…
Here’s a sample COLUMN to row entry.
—————————
MANUFACTUER: Sharp
MODEL: LC19SB27UT
DESCRIPTION: Sharp LC19SB27UT 19-Inch 720p LCD HDTV
Rating: 4.5
Ratingmax:5
CustomerReviews:26
Discussions:2
AmazonInstock: 0 for no, 1 for yes
AmazonListPrice: $349.99
AmazonSalePrice: $167.00
NonAmazonStock: 24
NonAmazonInStock: (if NonAmazonStock > 0: 1 else 0)
NonAmazonStartSalesPrice: 158.95
It can be done by hand, scrape or Amazon Associate Web Services (A2S)
http://www.a2sdeveloper.com/page-php-examples.html
If done by hand, the output would be a spreadsheet in xls, odf, or csv
If done by script, prefer PHP as I will be doing this periodically.