Take an excel list of UPC’s or ASIN’s and pull the following information from [login to view URL] based on the list uploaded. The uploaded list will consist of either UPC’s or ASIN but not both mixed in the same list. Sample’s of both included. The program should be able to distinguish between a UPC being uploaded or an ASIN.
Using
http://www.amazon.com/Everyday-Feeder-Programmable-Automatic-Dispenser/dp/B001F2117I/ref=sr_sp-atf_image_1_1?s=pet-supplies&ie=UTF8&qid=1377445528&sr=1-1&keywords=fish+feeder
as the example page.
Assuming the ASIN = B001F2117I was used to get to the page link above the following information from the page should be scrapped and put in an excel file (example excel file using link above attached):
Upload information – this is the original information that was uploaded from me. So the excel file I uploaded would have the data returned in the output file
Name – EHEIM Everyday Fish Feeder Programmable Automatic Food Dispenser
Seller – This is important. I want who the seller is on the main page, which is called the “buy box”, in this case is Amazon.
Shipped – Who is shipping the item. In this case it is Amazon but if Amazon did not have the buy box then it could be shipped either by the seller themselves or it could be fulfilled by Amazon.
List Price – Shows as 39.99
Quantity – If the quantity is shown then grab it. The quantity will on be shown if the seller has 20 or less. In this case it shows as “In Stock”
Price – The price of the seller who has the main page (buy box) which in this case is 29.25. If there is shipping costs then add the shipping cost to the price instead of separating them.
Seller 1 – If you look on the right side you will see 3 other sellers under “More buying Choices”. I want the seller name, the price they are selling it for and the shipping cost. If possible, combine the shipping cost and the sell price in one column.
Seller 1 Price – Described above
Seller 2 – Described above
Seller 2 Price – Described above
Seller 3 – Described above
Seller 3 Price – Described above
Frequently Bought Together Section
FBT Name - Start with product two since one is always the product on the current page. “Marineland PA0401 Aqua-Timer with 24-hr Cycle, Grounded”
FBT Price – The price of the second shown Frequently bought together item – “6.66”
FBT ASIN – The ASIN of the second shown Frequently bought together item – “B0006JLS42”
FBT 2 Name - Start with product two since one is always the product on the current page. “API Freshwater Master Test Kit”
FBT 2 Price – The price of the second shown Frequently bought together item – “6.66”
FBT 2 ASIN – The ASIN of the second shown Frequently bought together item – “B000255NCI”
Product Detail Section
Product Dimensions – The dimensions of the product “2.5 x 2.5 x 5.5 inches; 9.4 ounces”
Shipping Weight – the shipping weight of the product “12 ounces”
ASIN – The ASIN of the product “B001F2117I”
Item # - The model number of the product “3581090”
Amazon Best Sellers Rank – The main category sales rank “329 Pet Supplies”
Sub Category Rank 1 – The sub category sales rank “1 Automatic Feeders”
Sub Category Rank 2 – The other sub category sales rank “1 Cleaners”
Bullet Point 1 - Great for everyday use whether you are home or away
Bullet Point 2 - Set it and let if feed your fish everyday
Bullet Point 3 - Convienient worry-free feeding for healthy fish
Bullet Point 4 - Easy to set up and use and includes easy start guide
Bullet Point 5 - Integrated fan and ventilation system keeps the food dry
The rest of the project is included in the attached word document. Please read the entire project included the attachment before placing a bid.
I have excellent knowledge in programming and designing to work on your project efficiently and complete job in time. I have read your deepest requirement at my best and will surely give better results. Efficient in html/css/javascript/php Thank