We need to retrieve Amazon ASIN numbers from amazon with product information we have. The information we have on products are: Manufacturers, Model numbers and UPCs.
What we need to be able to do is submit that data and get a ASIN (if exists) as a response. Providing those 3 data points can be used to query Amazon we need a "score" on how well match was, example:
-- No Match -- SCORE 0
-- Manufacturer, Model number and UPC all match -- SCORE 1
-- Only UPC match -- SCORE 2
The Manufacturers, Model numbers and UPCs will be stored in a Mysql table where they can be grabbed from along with a unique product ID for each row.
* Also Programming must be done in PHP.
* I am not sure if we need a special account with Amazon to be able to query their catalog, please advise on that.
* Script must be able to run from a cron environment set up in such a way that only the rows that have not already found a match get queried