In Progress

Magento order list

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)

Skills: Magento

See more: magento category list vertical, pho order list mysql date name description, magento order email database, using ajax order list database, drag drop order list save database php, dropdown list select countrystate stored database php, magento contacts details stored database, magento order list, magento order set shipping description, magento order status description, magento shipping amount stored database tables, magento order list b2b, create order list online shopping customer, magento pre order list, magento order create script, magento order picking list, magento 2 create custom module with database, magento create custom module with database, magento 1.9 create custom module with database, magento create admin user in database

About the Employer:
( 6 reviews ) Trzic, Slovenia

Project ID: #24033385

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
(5 Reviews)
2.1
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
(5 Reviews)
5.3

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
(287 Reviews)
7.4
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
(125 Reviews)
7.5
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
(15 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
pareshpansuriya

Dear Sir, Hope you are doing well. I am a Magento2 and Magento1 certified developer: [login to view URL] I have 6+ years of experience, I am Expert in Magento integration, Custom More

$200 USD in 7 days
(12 Reviews)
4.4
overtservices

Hello, I am highly interested in your project. I have reviewed your requirement to create the php script to read all magento orders and write information to user tables. I believe I can manage your task efficiently.I More

$150 USD in 4 days
(21 Reviews)
4.7
santoshm143

Hi there, I have gone through your job post, I fully understand your requirements. I’m an expert in magneto with more than 7 years experiences. I have a lot of websites in magneto 1 and magento 2 and I am specialist More

$200 USD in 7 days
(4 Reviews)
3.9
singhalmohit123

* Individual Seneior Magento Professional * Dear Client , Hope you are doing well ! I can help you to write a php script using Magento API and will write the information into the SQL table i.e order header and or More

$177 USD in 6 days
(9 Reviews)
4.1
matinict

Hi, I am 7 year+ Magento 1 & 2 Developer with LEMP/LAMP/Docker stack, Also Certified Magento 2 . I am interested to work with you on this project, I would like to have a convenient time of yours to have a discussion on More

$277 USD in 250 days
(7 Reviews)
2.9
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.6
sapnathakur14

Hello, Warm Greetings!! I am a web developer having sound knowledge of Magento with 3+ years of experience on this position. I have updated and created number of magento themes as well as integrations and customizatio More

$230 USD in 5 days
(0 Reviews)
0.0
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
EcommerceTeam20

Bok, We are ready to make Magento Order list. I have been very good experience in Magento since 2010. We are working on this Magento platform with fully experienced team and dedicated development. I have checked your More

$110 USD in 6 days
(0 Reviews)
0.0