I need someone with Amazon Product Advertising API experience to create what I believe is a fairly simple program/query.
Requirements are as follows:
Ability to select a top-level product category/node. Once selected, program runs and returns the products from the selected category Where the Amazon NEW Price is the lowest price of all vendors (new condition only). Output should be an excel or csv file and contain the following data elements:
Product Category/Node
Product Name
ASIN
Amazon Price
Next Lowest 3rd Party Vendor Product Price (New condition only)
Next Lowest 3rd Party Vendor Shipping Price (in dollars)
Next Loweset 3rd Party Vendor Total Price (product price + shipping price in dollars)
Margin between Amazon Price & Next Lowest 3rd Party Vendor Total Price (in dollars)
Total number of vendors selling the product (New condition only)
Solution can be either web or desktop-based. I also need full access to all source code upon completion.