PHP script for exporting orders from Opencart to Amazon (knowledge of SP-API)
TASK:
It is required to write a PHP script that will be launched by Cron every 5 minutes.
No UI is required.
This script exports newly received orders from my website on opencart to my Amazon seller account using Amazon SP-API.
I imagine it like this:
1. The ORDERS table on my website is checked for new orders with the status "opened".
2. Once such a new order is found, the Amazon SP-API function Create_MCF_Order() is called, which creates a new MCF order on Amazon.
Analog of manually creating an MCF order:
https://sellercentral-europe.amazon.com/mcf/orders/create-order
3. Then the quantity of product stock on my website and at the FBA Amazon warehouse is synchronized.
4. The script checks if Amazon has shipped the order, then the status on the website in the ORDERS table on my site is changed to "shipped".
5. Once Amazon has delivered the order, the status on the website in the ORDERS table should be changed to "delivered". And an email with the tracking number Track & Trace is sent to the customer.
That's all!
* MCF - Amazon multi-channel fulfillment (MCF) is Amazon's fulfillment service for sellers with orders on sales channels other than Amazon
** Table names and functions are conditional
You are required to test in the sandbox on your developer Amazon account, and once everything is verified, launch it in the seller's Amazon live account and verify its functionality.
Current freelance projects in the category Databases & SQL
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 19 hours 36 minutes back ∙ 9 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 1 day 6 hours back ∙ 4 proposals |
CRM system for Railway LogisticsCreation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 1 day 18 hours back ∙ 39 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 4 days 13 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
602 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 6 days 17 hours back ∙ 58 proposals |
Zaporizhzhia