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
Pointing to problems without suggesting solutions
What were wait-states, and why was it only an issue for PCs?
What could prevent concentrated local exploration?
Can a Wizard take the Magic Initiate feat and select spells from the Wizard list?
How was Lagrange appointed professor of mathematics so early?
Suing a Police Officer Instead of the Police Department
Married in secret, can marital status in passport be changed at a later date?
How to ask rejected full-time candidates to apply to teach individual courses?
How to charge percentage of transaction cost?
Can this water damage be explained by lack of gutters and grading issues?
Assertions In A Mock Callout Test
Are Flameskulls resistant to magical piercing damage?
How to create a command for the "strange m" symbol in latex?
Like totally amazing interchangeable sister outfit accessory swapping or whatever
Weaponising the Grasp-at-a-Distance spell
What is the evidence that custom checks in Northern Ireland are going to result in violence?
Will I be more secure with my own router behind my ISP's router?
When does Bran Stark remember Jamie pushing him?
Short story about an alien named Ushtu(?) coming from a future Earth, when ours was destroyed by a nuclear explosion
Is it OK if I do not take the receipt in Germany?
Marquee sign letters
Does the Pact of the Blade warlock feature allow me to customize the properties of the pact weapon I create?
Why do people think Winterfell crypts is the safest place for women, children & old people?
Providing direct feedback to a product salesperson
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;
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
add a comment |
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
mageplaza.com/devdocs/…
– Rk Rathod
Apr 18 at 11:55
Specify the code which you have try? and also does it show any error on screen?
– Dhiren Vasoya
Apr 18 at 12:28
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
Apr 18 at 13:09
add a comment |
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
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
database magento2.2 php-7
asked Apr 18 at 10:21
Farhan AliFarhan Ali
1406
1406
mageplaza.com/devdocs/…
– Rk Rathod
Apr 18 at 11:55
Specify the code which you have try? and also does it show any error on screen?
– Dhiren Vasoya
Apr 18 at 12:28
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
Apr 18 at 13:09
add a comment |
mageplaza.com/devdocs/…
– Rk Rathod
Apr 18 at 11:55
Specify the code which you have try? and also does it show any error on screen?
– Dhiren Vasoya
Apr 18 at 12:28
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
Apr 18 at 13:09
mageplaza.com/devdocs/…
– Rk Rathod
Apr 18 at 11:55
mageplaza.com/devdocs/…
– Rk Rathod
Apr 18 at 11:55
Specify the code which you have try? and also does it show any error on screen?
– Dhiren Vasoya
Apr 18 at 12:28
Specify the code which you have try? and also does it show any error on screen?
– Dhiren Vasoya
Apr 18 at 12:28
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
Apr 18 at 13:09
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
Apr 18 at 13:09
add a comment |
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
mageplaza.com/devdocs/…
– Rk Rathod
Apr 18 at 11:55
Specify the code which you have try? and also does it show any error on screen?
– Dhiren Vasoya
Apr 18 at 12:28
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
Apr 18 at 13:09