I would like to collect amazon product data and import it into a CSV file. Below, I've outlined everything that I would like to get, but please tell me if anything listed is potentially problematic or impossible. From specific Amazon categories I will give you, I need the 200-500 most "new and popular"(this is an Amazon sort option) results which have at least 5 offers listed for that item. I do not want any item in the results with less then 5 offers from sellers.
I need the following information from each item:
Title, image filename, price, product features (is listed in point form below price on product page if present), product details, product description(just the text is fine), and lowest 5 prices/offers with the shipping cost listed as well.
Need this information in a csv file plus all the image files (which will have the same filename as listed in the CSV file under "image name"). Please submit your bid for the cost of 1000 results. Over a couple months time I hope to gather 5000+ results.
-I give you the category of Toys & Games -> Action & Toy Figures.
Sorting the results by "New and Popular" your first result is "Super Mario Brothers: 2" Mini Figures Set of 18" (18 offers) which links to this product page:
From this page you get the following data that I need:
Title: Super Mario Brothers: 2" Mini Figures Set of 18
Price:[url removed, login to view]
Product Features:(In the CSV file, this will be included in 1 cell. I need each individual feature to have the tag before and after each feature.I also need the tag inserted once at the start only.
100% Brand [url removed, login to view] is a great gift for yourself or friends!1)Material: PVC2)Size:about 3-6.5 cm eachPacking including: cute figures X 18 (not include the Stand)Packaged in plastic pack!!
Product Details: (Follows the same format as Product features. I need the tag inserted at the end of this cell).
Product Dimensions: 7.5 x 5.3 x 0.6 inches ; 3.2 ouncesShipping Weight: 1 pounds (View shipping rates and policies)ASIN: B0032XV5DSManufacturer recommended age: 3 years and upAmazon Best Sellers Rank: #31 in Toys & Games (See Top 100 in Toys & Games)#1 in Toys & Games > Action & Toy Figures > Figures#14 in Toys & Games > Preschool > Pre-Kindergarten ToysAverage Customer Review: 4.0 out of 5 stars See all reviews (241 customer reviews)
Product Description:(Imported into 1 cell BEFORE Product features and Product details)
This is a great set of 18 Super Mario 2" figures. Perfect for Cakes or Cupcakes. High quality for long lasting play after. Great Decorations or party favors.
From this page, when you click on the link "18 new" at the top of the page you get the list of sellers and get the Lowest Prices (in new condition):
[url removed, login to view]+[url removed, login to view]|[url removed, login to view]+[url removed, login to view]|[url removed, login to view]+[url removed, login to view]|[url removed, login to view]+[url removed, login to view]|[url removed, login to view]+[url removed, login to view]
A sample CSV file is attached.
The only category I am interested in that does not include the number of offers in the result pages is the category of Video Games. For this category, I just want the top 300 results, but preferably not including video games that are listed as "pre-order".
There is also the difficulty of Amazon listings with variations. I really only need the 1 variation that links from the results in the catalog page (new and popular page), but if you can list all variations and prices, that would be a bonus.
Please ask questions. I will answer the best I can. Thanks for your interest.