Connect Amazon MWS to MySQL database
€250-750 EUR
Pagado a la entrega
Summary:
The goal of the project is to create a single PHP file, which connects to the Amazon Marketplace Web Service (MWS), downloads pending orders and inserts them into a MySQL database with a given field structure. After the orders have been shipped, the tracking numbers must be submitted to Amazon through a second file
The API description is available from [url removed, login to view]
A PHP library from Amazon for accessing MWS is available at [url removed, login to view]
The Amazon MWS documentation is available at [url removed, login to view]
API-Reference:
[url removed, login to view]
Detailed project description
Our internal ERP systems uses a connection to an existing MySQL database to process orders. With the growing amount of orders through Amazon marketplace it is necessary to automate the import of Amazon Marketplace orders into the MySQL based database. The goal of the project is to have one PHP file, which can be run e.g. once per hour and which downloads all orders from Amazon and imports them into the given MySQL database structure.
After inserting the data, it is required to submit tracking numbers to Amazon MWS. All non-shipped orders on Amazon are parsed again. The file needs to check the orders table in MySQL for the corresponding order number through the field memo/AmazonOrderId
This order number is then used to fetch the tracking number from the table shipments. The fetched tracking number must then be transferred back to Amazon MWS through the Feeds API (_POST_ORDER_FULFILLMENT_DATA_)
connect to the Amazon MWS endpoint and parse all outstanding orders that have not yet been shipped
download all these outstanding orders
parse addresses and order details of these orders
check whether an address already exists in the database, in this case use the existing customer number, otherwise create a new customer/address combination
The country name must be entered in written German language, e.g. “Deutschland, Österreich, Frankreich” etc. The corresponding country names are available in the database table shipping_countries
If a customer does not yet exist in the database, create a new entry in the customer database, incrementing the highest number by one. Create an additional entry in the addresses database with the same customer number, id=0 and the corresponding address.
check whether the downloaded order already exists in the database, if so discard the order, otherwise create a new entry in the orders and order-details table
create a new entry in the orders table for every new pending order from Amazon
For every pending order that has already been inserted in the database, fetch the order number from the orders table
check the shipments table for a tracking number for this order
use the tracking number and shipment provider from the shipments table to submit it to Amazon MWS through the Feeds API (_POST_ORDER_FULFILLMENT_DATA_)
Nº del proyecto: #6148016
Sobre el proyecto
Adjudicado a:
Hi, I would like to apply for this PHP project. Please contact me if you have any questions. Best wishes, Sasha
31 freelancers están ofertando un promedio de €601 por este trabajo
Hi, I like to help you get this done. I can develop exactly whats needed with MWS API. Best quality work assured. Thanks
Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself doing programming so you will directly work with one person and that's me. No mediators. No managers. No sub Más
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
Hi Please disucss with me. I can do this work because I familiar with Amazone APIs and MySQL. Regards,
Hello, I would love to do your project. I have gone through the requirements. They are all feasible. Please feel free to message me to discuss further details if you want. Thanks !
I have 20 years experience writing tools in PHP/MySQL and other languages. From searchengines to complex analytics tools. I would be happy to discuss this project with you further.
Hi, I have gone through your descriptions,I understand it thoroughly,I am 5+ years experienced HTML,PHP,MySQL,SQL Server developer at CMMI-5 level company.I can do your job easily before your deadline . I can give you Más
Hello I've read your task carefully. I can complete your task. Believe me!!! Waiting for your reply. Thanks.
Dear Sir, We are the globalized software services organization specialized in providing Mobile, ECommerce and Social media frameworks using cutting edge and emerging technology. Leveraging best-in-class people, proc Más
Greetings, I am experienced with Amazon MWS, done complete EDI order automation with Amazon with 4 customers. It is correct that I have no profile on freelancer.com, as i have good profile on other renowned freelan Más