
Use API to request and store data from Amazon to MariaDB
- or -
Post a project like this2717
$
- Posted:
- Proposals: 8
- Remote
- #2077006
- Awarded
Senior Full Stack Developer- PHP | React | Node | Wordpress | CMS
Professional Graphic designer, photo editor, clipping path, images background removes, Photo cleanup/ touch up, Image Manipulation

Senior Software Engineer | Building Scalable Apps, Everywhere | Mobile, Web, Desktop | 15+ Years

12898232275251726048803688228177717853644943272295299
Description
Experience Level: Entry
Abstract: I have a project with the following requirements:
In short I need to collect data from the German Amazon Marketplace API page, which is a selling platform, to an SQL DB (would prefer MariaDB).
I need the source code, ddls and dmls you created.
I need a list of products from Amazon with the current price, ASIN, EAN, Stock, reference to seller (see below), shipping time, delivery date, shipping cost, condition, pictures, condition description, product category, amount, currency, SKU, product name. This list has to be created according to a preexisting list of EANs that is given by the end user.
1) For each EAN of a given list (table in DB) store the three cheapest products in the DB (MariaDB). Attributes: current price, ASIN, EAN, Stock, reference to seller (see below), shipping time, delivery date, shipping cost, condition, pictures, condition description, product category, amount, currency, SKU, product name.
(If product is unavailable because there is no active seller, mark the EAN.
If less than three items are found, store the found items following the pattern above.
In any case delete the old products for this checkup and fill in the maximum of 3 new products in one transaction (Lock on row level)).
Repeat this process every 180 minutes.
2) For each individual product: Save seller - if it not already exists in the table seller - into the table seller (attributes: name, rating, number of feedback ratings, country, payment method)
Please let me know your thoughts and give me a rough estimation of the time that is required, as well as of the cost of this project.
Best wishes
In short I need to collect data from the German Amazon Marketplace API page, which is a selling platform, to an SQL DB (would prefer MariaDB).
I need the source code, ddls and dmls you created.
I need a list of products from Amazon with the current price, ASIN, EAN, Stock, reference to seller (see below), shipping time, delivery date, shipping cost, condition, pictures, condition description, product category, amount, currency, SKU, product name. This list has to be created according to a preexisting list of EANs that is given by the end user.
1) For each EAN of a given list (table in DB) store the three cheapest products in the DB (MariaDB). Attributes: current price, ASIN, EAN, Stock, reference to seller (see below), shipping time, delivery date, shipping cost, condition, pictures, condition description, product category, amount, currency, SKU, product name.
(If product is unavailable because there is no active seller, mark the EAN.
If less than three items are found, store the found items following the pattern above.
In any case delete the old products for this checkup and fill in the maximum of 3 new products in one transaction (Lock on row level)).
Repeat this process every 180 minutes.
2) For each individual product: Save seller - if it not already exists in the table seller - into the table seller (attributes: name, rating, number of feedback ratings, country, payment method)
Please let me know your thoughts and give me a rough estimation of the time that is required, as well as of the cost of this project.
Best wishes
Adrian W.
100% (3)Projects Completed
1
Freelancers worked with
1
Projects awarded
19%
Last project
25 Sep 2018
Germany
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies