Create PHP script that reads all magento orders and write information to user SQL tables.
The task is to create a PHP script that would use magento API and write order information into two user SQL tables (plt_order in plt_order_item). One table is for order header and the other for order items (like magento sales_order and sales_order_item).
Script for user SQL tables is attached. I also give description of columns and where that information is stored in magento database (not for all columns).
Rules are the following
1) PHP script can be run multiple times and only new orders should be added to user tables (plt_order and plt_order_item) - existing orders are not overwritten.
2) plt_order.n_for_pay = sum(plt_order_item.n_for_pay) + plt_order_shipping.
3) ONLY simple items are written to plt_order_item (in case of configurable item only simple item is written to table)
Hi there , We have reviewed your attachments and can write Php script for getting orders in magento 2 .. As we are Php experts and can easily help you in your task. Please ping us to discuss detail. Regards, Zeta Sol Daha Fazla
Hi, Abhijeet here from ZecraTech We understand the requirement for you to be able to have the order data inserted in the new table and only the new data to be inserted. We can take care of this for you. From the Daha Fazla
Bu iş için 18 freelancer ortalamada $181 teklif veriyor
Hi sir. I'm a Magento developer with 10 years of experience and I also checked your requirement so I'm sure I can help you fix it without bug. Let's contact me to discuss Best regard!
Hello I can help you with magento script, I can help with script for multiple user Let's conectg and discuss in details Thank you Kind Regards, Mehul Parmar
Hi, I have experience connecting to the Magento REST API. I can make the requirement you need in 3 days but in Java technology. I don't know what the Magento version is? For more detail we can talk in private.