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.
11 freelancers are bidding on average €420 for this job
Yes. I have done a lot of api integration jobs with python/php/.net/node js. You can check my reviews. I'd like to work in backend like this. Please open your chat for me. Thanks.
I have more than 20 years experience in architecting software including on aws platform. The above requirement, I can fulfill with 100% satisfaction. Look forward to serve you