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

进行中 已发布的 6 年前 货到付款
进行中 货到付款

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.

Amazon Web Services 数据库编程 JavaScript MySQL PHP

项目ID: #15650552

关于项目

4个方案 远程项目 活跃的6 年前

授予:

suresh1986sl

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, 更多

$200 USD 在7天内
(20条评论)
4.7

有4名威客正在参与此工作的竞标,均价$210/小时

rinsadsl

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 更多

$157 USD 在3天内
(970条评论)
8.6
mehboobafridi786

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 更多

$283 USD 在10天内
(121条评论)
7.0
MTudorrrr

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 更多

$200 USD 在5天内
(1条评论)
1.8