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)

Taidot: Magento

Näytä lisää: 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

Tietoa työnantajasta:
( 6 arvostelua ) Trzic, Slovenia

Projektin tunnus: #24033385

Myönnetty käyttäjälle:


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 Lisää

$40 USD 4 päivässä
(5 Arvostelua)

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 Lisää

$60 USD 2 päivässä
(5 Arvostelua)

18 freelanceria on tarjonnut keskimäärin 181$ tähän työhön


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 5 päivässä
(287 arvostelua)

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 Lisää

$140 USD 7 päivässä
(125 arvostelua)

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 Lisää

$200 USD 7 päivässä
(7 arvostelua)

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

$70 USD 2 päivässä
(15 arvostelua)

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 Lisää

$200 USD 2 päivässä
(4 arvostelua)

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 Lisää

$200 USD 7 päivässä
(12 arvostelua)

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 Lisää

$150 USD 4 päivässä
(21 arvostelua)

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 Lisää

$200 USD 7 päivässä
(4 arvostelua)

* 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 Lisää

$177 USD 6 päivässä
(9 arvostelua)

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 Lisää

$277 USD 250 päivässä
(7 arvostelua)

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 10 päivässä
(2 arvostelua)

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 Lisää

$230 USD 5 päivässä
(0 arvostelua)

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 Lisää

$250 USD 5 päivässä
(0 arvostelua)

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 3 päivässä
(0 arvostelua)

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 Lisää

$140 USD 3 päivässä
(0 arvostelua)

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 Lisää

$110 USD 6 päivässä
(0 arvostelua)