In Progress

Fetch search results by (UPC, ASIN, EAN, or Keyword) from Amazon API, and output results to TXT file and MySQL

I need a script which uses the Amazon API to return all available details of either a list of provided: ASINs, UPCs, EANs, or Keywords. The values to search will be provided in a TXT file, and the credentials and search type (ASIN, UPC, EAN or keyword) will be provided in a separate TXT file. The search output will be a new TXT file with all the available values returned from Amazon API, and the filename of the new TXT file being “yyyy-mm-dd - hh-mm – ASIN Search Results” or “yyyy-mm-dd - hh-mm – UPC Search Results” etc. This script can be done in any code of your choosing, as long as the results are as specified.

In addition to the TXT file needing to be created, I need all of the retrieved data to be added to a MySQL database. I need you to create a table for Amazon-ASIN-Details, Amazon-UPC-Details, Amazon-EAN-Details, and Amazon-Keyword-Details. Each new search results will be added to this table, with a timestamp and unique incremental key identifier for each row. mySQL credentials will be provided in the same TXT file as the AWS credentials, and search type.

There will also need to be a separate table in MySQL called Amazon-ASIN-Details which has one row per each unique ASIN, with all static details which do not change on a daily basis (name, upc, details, etc.) If an ASIN does not exist, it will need to be added to this table, and if any of the details (from the search) are different than an existing ASIN, they should be updated. There will also need to be a separate table in MySQL called Amazon-UPC-To-ASIN created, which will have each unique UPC, with a column containing how many ASINs exist for that UPC, and then a column containing the main ASIN for that UPC, and then a column containing a list of every ASIN assigned to that UPC (up1, upc2, upc3, etc.) If a UPC does not exist, it will need to be added to this table, and if any of the details (from the search) are different than an existing UPC, they should be updated. These 2 tables are different from the tables described previously (Amazon-ASIN-Details, Amazon-UPC-Details, Amazon-EAN-Details, and Amazon-Keyword-Details), as these are only updated if an entry does not exist (or if a change is made). The 4 tables per each search result will have a new row added for each search result found, along with time stamp and unique incremental identifier.

Skills: Amazon Web Services, Database Programming, Javascript, MySQL, PHP

See more: google search results api excel, amazon search upc api, upc ean convert amazon asin, php, amazon asin ean list download, convert amazon asin ean, upc ean codes amazon, amazon api lowest price asin, amazon upc asin, need upc ean codes amazon upload, amazon api product search, amazon api asin, amazon api search 4000 items, google api importing search results, asin ean upc, product search amazon api php, html amazon api book search, google api search results, facebook api scrape search results, bing api search results pages php

About the Employer:
( 10 reviews ) Monson, United States

Project ID: #15650552

Awarded to:


I have worked with APIs and mysql numerous times, based on our discussion I will provide GUI version as well as command line script to do the processing. Relevant Skills and Experience Expert in PHP, MySQL, Web APIs, More

$200 USD in 7 days
(20 Reviews)

4 freelancers are bidding on average $210 for this job


H, I am an Amazon MWS, AWS API expert I have done several projects similar to your requirement using Amazon Product Advertising API (ItemSearch, ItemLookup) Relevant Skills and Experience I am good in PHP and Amazon A More

$157 USD in 3 days
(970 Reviews)

Hi Dear, I am Amazon API Guru! I can make an app for you through which you can fetch data Using ASINs or UPCs and EANs. I have done many projects in the past related to your project. Relevant Skills and Experience P More

$283 USD in 10 days
(121 Reviews)

Hi I'm a java developer interested in this project. I can do ti like a desktop application with simple GUI (where could be displayed the progress, some stats). Соответствующие навыки и опыт Also I''m experienced enou More

$200 USD in 5 days
(1 Review)