Magento order list

In Progress Posted 4 years ago Paid on delivery
In Progress Paid on delivery

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)

Magento

Project ID: #24033385

About the project

18 proposals Remote project Active 4 years ago

Awarded to:

zetaSolutions12

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 More

$40 USD in 4 days
(41 Reviews)
4.9
zecratech

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 More

$60 USD in 2 days
(10 Reviews)
5.8

18 freelancers are bidding on average $181 for this job

vniteam

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!

$220 USD in 5 days
(289 Reviews)
7.5
magento2expert

Hello, I Am " Magento 2 frontend& Backend developer" and fully expertise in Magento2 store development,Magento2x migration magento2 speed optimise,Magento2 Customization,Magento2 3rd party,Magento2 ERP,Magento2 JSON E More

$140 USD in 7 days
(130 Reviews)
7.6
ahmadayaz

Hi, Hope you are doing great, I Rank in world's top 400 freelancers. I've skills and proven record in PHP (Magento ) , Plugin development & API integration! After detail discussion, I will prepare final budget, timelin More

$200 USD in 7 days
(7 Reviews)
5.4
oscworker

Hello. I am ready to start immediately. Thanks, Vitaliy.

$70 USD in 2 days
(16 Reviews)
5.8
coolguyinus2004

Why you want to use Magento API? If you want to have this PHP script work on your Magento site itself? let me know more details on the API of it with URL. Also clarify most on the configurable item with simple item ple More

$200 USD in 2 days
(4 Reviews)
4.5
Mexi2705

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

$350 USD in 10 days
(2 Reviews)
2.7
DaveMJie

Hi there. Greetings! I have just checked your post and attached SQL files with care. Overall due to my successfully building several Magento/WooCommerce websites experience, I have full confidence in your project. I’d More

$250 USD in 5 days
(0 Reviews)
0.0
mousevirtual

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.

$250 USD in 3 days
(0 Reviews)
0.0
rabhardwaj

I mainly work with API Integration project.I have experience in Upwork API. I have been in this field for more than 7 years. i have experience in C#,php,Perl,wordpress,Html,postgress ,Ubuntu,Crontab,Web Services, Rest More

$140 USD in 3 days
(0 Reviews)
0.0