Insert order data from csv programatically in Magento 2.2 Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Magento site shows error SQLSTATE[HY000]: General error: 5 Out of memoryMagento programatically convert quote to order - orders missing in backendMagento export/import category product sort orderQuerying a table using data from another tableHow to transfer Magento site/store view data to an existing install of Magento?Get order data from database vs. using Mage functionsMagento 2: Data Migration From Non Magento Database to Magento DatabaseMagento 2 Customer Order Attribute SQL Error in ControllerRestoring related products from database back upsql query in cms_block table in magento 2

Found this skink in my tomato plant bucket. Is he trapped? Or could he leave if he wanted?

Why not send Voyager 3 and 4 following up the paths taken by Voyager 1 and 2 to re-transmit signals of later as they fly away from Earth?

How often does castling occur in grandmaster games?

Is there public access to the Meteor Crater in Arizona?

What is the difference between a "ranged attack" and a "ranged weapon attack"?

Special flights

My mentor says to set image to Fine instead of RAW — how is this different from JPG?

Simple Line in LaTeX Help!

How do living politicians protect their readily obtainable signatures from misuse?

A term for a woman complaining about things/begging in a cute/childish way

Google .dev domain strangely redirects to https

How many time has Arya actually used Needle?

Can an iPhone 7 be made to function as a NFC Tag?

How much damage would a cupful of neutron star matter do to the Earth?

How were pictures turned from film to a big picture in a picture frame before digital scanning?

Why complex landing gears are used instead of simple,reliability and light weight muscle wire or shape memory alloys?

Sally's older brother

GDP with Intermediate Production

What does Turing mean by this statement?

If Windows 7 doesn't support WSL, then what is "Subsystem for UNIX-based Applications"?

How to ask rejected full-time candidates to apply to teach individual courses?

What are the main differences between the original Stargate SG-1 and the Final Cut edition?

Moving a wrapfig vertically to encroach partially on a subsection title

malloc in main() or malloc in another function: allocating memory for a struct and its members



Insert order data from csv programatically in Magento 2.2



Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?Magento site shows error SQLSTATE[HY000]: General error: 5 Out of memoryMagento programatically convert quote to order - orders missing in backendMagento export/import category product sort orderQuerying a table using data from another tableHow to transfer Magento site/store view data to an existing install of Magento?Get order data from database vs. using Mage functionsMagento 2: Data Migration From Non Magento Database to Magento DatabaseMagento 2 Customer Order Attribute SQL Error in ControllerRestoring related products from database back upsql query in cms_block table in magento 2



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








1















I have 2 different CSV files 1st has orders and 2nd have order details. I am trying to insert data into magento2 DB using Magento Models. so that my data will insert into all different tables and will also show on the Admin side.



Right now I have inserted data in DB but the data is just inserted into sales_order table, all the other tables related to orders are empty, that's why order's data is not showing on the Admin side.



Need some serious help










share|improve this question






















  • mageplaza.com/devdocs/…

    – Rk Rathod
    2 days ago











  • Specify the code which you have try? and also does it show any error on screen?

    – Dhiren Vasoya
    2 days ago











  • no it's working fine, and inserting the orders data in Sales_order table, but Magento uses EAV system, that's why I have to insert data according to that method, which I don't know.

    – Farhan Ali
    2 days ago

















1















I have 2 different CSV files 1st has orders and 2nd have order details. I am trying to insert data into magento2 DB using Magento Models. so that my data will insert into all different tables and will also show on the Admin side.



Right now I have inserted data in DB but the data is just inserted into sales_order table, all the other tables related to orders are empty, that's why order's data is not showing on the Admin side.



Need some serious help










share|improve this question






















  • mageplaza.com/devdocs/…

    – Rk Rathod
    2 days ago











  • Specify the code which you have try? and also does it show any error on screen?

    – Dhiren Vasoya
    2 days ago











  • no it's working fine, and inserting the orders data in Sales_order table, but Magento uses EAV system, that's why I have to insert data according to that method, which I don't know.

    – Farhan Ali
    2 days ago













1












1








1








I have 2 different CSV files 1st has orders and 2nd have order details. I am trying to insert data into magento2 DB using Magento Models. so that my data will insert into all different tables and will also show on the Admin side.



Right now I have inserted data in DB but the data is just inserted into sales_order table, all the other tables related to orders are empty, that's why order's data is not showing on the Admin side.



Need some serious help










share|improve this question














I have 2 different CSV files 1st has orders and 2nd have order details. I am trying to insert data into magento2 DB using Magento Models. so that my data will insert into all different tables and will also show on the Admin side.



Right now I have inserted data in DB but the data is just inserted into sales_order table, all the other tables related to orders are empty, that's why order's data is not showing on the Admin side.



Need some serious help







database magento2.2 php-7






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked 2 days ago









Farhan AliFarhan Ali

1406




1406












  • mageplaza.com/devdocs/…

    – Rk Rathod
    2 days ago











  • Specify the code which you have try? and also does it show any error on screen?

    – Dhiren Vasoya
    2 days ago











  • no it's working fine, and inserting the orders data in Sales_order table, but Magento uses EAV system, that's why I have to insert data according to that method, which I don't know.

    – Farhan Ali
    2 days ago

















  • mageplaza.com/devdocs/…

    – Rk Rathod
    2 days ago











  • Specify the code which you have try? and also does it show any error on screen?

    – Dhiren Vasoya
    2 days ago











  • no it's working fine, and inserting the orders data in Sales_order table, but Magento uses EAV system, that's why I have to insert data according to that method, which I don't know.

    – Farhan Ali
    2 days ago
















mageplaza.com/devdocs/…

– Rk Rathod
2 days ago





mageplaza.com/devdocs/…

– Rk Rathod
2 days ago













Specify the code which you have try? and also does it show any error on screen?

– Dhiren Vasoya
2 days ago





Specify the code which you have try? and also does it show any error on screen?

– Dhiren Vasoya
2 days ago













no it's working fine, and inserting the orders data in Sales_order table, but Magento uses EAV system, that's why I have to insert data according to that method, which I don't know.

– Farhan Ali
2 days ago





no it's working fine, and inserting the orders data in Sales_order table, but Magento uses EAV system, that's why I have to insert data according to that method, which I don't know.

– Farhan Ali
2 days ago










0






active

oldest

votes












Your Answer








StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f270632%2finsert-order-data-from-csv-programatically-in-magento-2-2%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes















draft saved

draft discarded
















































Thanks for contributing an answer to Magento Stack Exchange!


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f270632%2finsert-order-data-from-csv-programatically-in-magento-2-2%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Get product attribute by attribute group code in magento 2get product attribute by product attribute group in magento 2Magento 2 Log Bundle Product Data in List Page?How to get all product attribute of a attribute group of Default attribute set?Magento 2.1 Create a filter in the product grid by new attributeMagento 2 : Get Product Attribute values By GroupMagento 2 How to get all existing values for one attributeMagento 2 get custom attribute of a single product inside a pluginMagento 2.3 How to get all the Multi Source Inventory (MSI) locations collection in custom module?Magento2: how to develop rest API to get new productsGet product attribute by attribute group code ( [attribute_group_code] ) in magento 2

Category:9 (number) SubcategoriesMedia in category "9 (number)"Navigation menuUpload mediaGND ID: 4485639-8Library of Congress authority ID: sh85091979ReasonatorScholiaStatistics

Magento 2.3: How do i solve this, Not registered handle, on custom form?How can i rewrite TierPrice Block in Magento2magento 2 captcha not rendering if I override layout xmlmain.CRITICAL: Plugin class doesn't existMagento 2 : Problem while adding custom button order view page?Magento 2.2.5: Overriding Admin Controller sales/orderMagento 2.2.5: Add, Update and Delete existing products Custom OptionsMagento 2.3 : File Upload issue in UI Component FormMagento2 Not registered handleHow to configured Form Builder Js in my custom magento 2.3.0 module?Magento 2.3. How to create image upload field in an admin form