Update sales order grid on order saving - Magento 2
2
I added a new attribute on order entity :
$salesSetup->addAttribute(Order::ENTITY, "shipping_date", [
'type' => "date",
'label' => "Shipping date",
'input' => "text",
'user_defined' => true,
'required' => false,
'visible' => true
]);
and display it on the sales order grid (view/adminhtml/uicomponent/sales_order_grid.xml) :
<listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Ui:etc/ui_configuration.xsd">
<columns name="sales_order_columns">
<column name="shipping_date">
<argument name="data" xsi:type="array">
<item name="config" xsi:type="array">
<item name="filter" xsi:type="string">text</item>
<item name="label" xsi:type="string" translate="true">Shipping Date</item>
</item>
</argument>
</column>
</columns>
And when I'm saving a new order I would like to populate the sales_order_grid so I added this code in etc/adminhtml/di.xml :
<virtualType name="MagentoSalesModelResourceModelOrderGrid">
<arguments>
<argument name="columns" xsi:type="array">
<item name="shipping_date" xsi:type="string">sales_order.shipping_date</item>
</argument>
</arguments>
</virtualType>
The issue is when I'm saving the order it creates a blank line in sales_order_grid table with only the shipping date filled, all other fields are NULL, where is my mistake ?
Thanks !
magento2
asked Apr 11 '18 at 13:46
magentodevmagentodev
585
add a comment |
2
I added a new attribute on order entity :
$salesSetup->addAttribute(Order::ENTITY, "shipping_date", [
'type' => "date",
'label' => "Shipping date",
'input' => "text",
'user_defined' => true,
'required' => false,
'visible' => true
]);
and display it on the sales order grid (view/adminhtml/uicomponent/sales_order_grid.xml) :
<listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Ui:etc/ui_configuration.xsd">
<columns name="sales_order_columns">
<column name="shipping_date">
<argument name="data" xsi:type="array">
<item name="config" xsi:type="array">
<item name="filter" xsi:type="string">text</item>
<item name="label" xsi:type="string" translate="true">Shipping Date</item>
</item>
</argument>
</column>
</columns>
And when I'm saving a new order I would like to populate the sales_order_grid so I added this code in etc/adminhtml/di.xml :
<virtualType name="MagentoSalesModelResourceModelOrderGrid">
<arguments>
<argument name="columns" xsi:type="array">
<item name="shipping_date" xsi:type="string">sales_order.shipping_date</item>
</argument>
</arguments>
</virtualType>
The issue is when I'm saving the order it creates a blank line in sales_order_grid table with only the shipping date filled, all other fields are NULL, where is my mistake ?
Thanks !
magento2
asked Apr 11 '18 at 13:46
magentodevmagentodev
585
I followed this way, but all the value are updating to the sales_order_grid table except the custom column value. is there any other code is missing?
– senthil
Oct 10 '18 at 10:40
Also when i add the above virtualtype my page will be blank
– senthil
Oct 10 '18 at 10:56
add a comment |
2
2
2
I added a new attribute on order entity :
$salesSetup->addAttribute(Order::ENTITY, "shipping_date", [
'type' => "date",
'label' => "Shipping date",
'input' => "text",
'user_defined' => true,
'required' => false,
'visible' => true
]);
and display it on the sales order grid (view/adminhtml/uicomponent/sales_order_grid.xml) :
<listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Ui:etc/ui_configuration.xsd">
<columns name="sales_order_columns">
<column name="shipping_date">
<argument name="data" xsi:type="array">
<item name="config" xsi:type="array">
<item name="filter" xsi:type="string">text</item>
<item name="label" xsi:type="string" translate="true">Shipping Date</item>
</item>
</argument>
</column>
</columns>
And when I'm saving a new order I would like to populate the sales_order_grid so I added this code in etc/adminhtml/di.xml :
<virtualType name="MagentoSalesModelResourceModelOrderGrid">
<arguments>
<argument name="columns" xsi:type="array">
<item name="shipping_date" xsi:type="string">sales_order.shipping_date</item>
</argument>
</arguments>
</virtualType>
The issue is when I'm saving the order it creates a blank line in sales_order_grid table with only the shipping date filled, all other fields are NULL, where is my mistake ?
Thanks !
magento2
asked Apr 11 '18 at 13:46
magentodevmagentodev
585
I added a new attribute on order entity :
$salesSetup->addAttribute(Order::ENTITY, "shipping_date", [
'type' => "date",
'label' => "Shipping date",
'input' => "text",
'user_defined' => true,
'required' => false,
'visible' => true
]);
and display it on the sales order grid (view/adminhtml/uicomponent/sales_order_grid.xml) :
<listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Ui:etc/ui_configuration.xsd">
<columns name="sales_order_columns">
<column name="shipping_date">
<argument name="data" xsi:type="array">
<item name="config" xsi:type="array">
<item name="filter" xsi:type="string">text</item>
<item name="label" xsi:type="string" translate="true">Shipping Date</item>
</item>
</argument>
</column>
</columns>
And when I'm saving a new order I would like to populate the sales_order_grid so I added this code in etc/adminhtml/di.xml :
<virtualType name="MagentoSalesModelResourceModelOrderGrid">
<arguments>
<argument name="columns" xsi:type="array">
<item name="shipping_date" xsi:type="string">sales_order.shipping_date</item>
</argument>
</arguments>
</virtualType>
The issue is when I'm saving the order it creates a blank line in sales_order_grid table with only the shipping date filled, all other fields are NULL, where is my mistake ?
Thanks !
magento2
magento2
asked Apr 11 '18 at 13:46
magentodevmagentodev
585
asked Apr 11 '18 at 13:46
magentodevmagentodev
585
asked Apr 11 '18 at 13:46
magentodevmagentodev
585
asked Apr 11 '18 at 13:46
magentodevmagentodev
585
asked Apr 11 '18 at 13:46
magentodevmagentodev
585
585
I followed this way, but all the value are updating to the sales_order_grid table except the custom column value. is there any other code is missing?
– senthil
Oct 10 '18 at 10:40
Also when i add the above virtualtype my page will be blank
– senthil
Oct 10 '18 at 10:56
add a comment |
I followed this way, but all the value are updating to the sales_order_grid table except the custom column value. is there any other code is missing?
– senthil
Oct 10 '18 at 10:40
Also when i add the above virtualtype my page will be blank
– senthil
Oct 10 '18 at 10:56
I followed this way, but all the value are updating to the sales_order_grid table except the custom column value. is there any other code is missing?
– senthil
Oct 10 '18 at 10:40
I followed this way, but all the value are updating to the sales_order_grid table except the custom column value. is there any other code is missing?
– senthil
Oct 10 '18 at 10:40
Also when i add the above virtualtype my page will be blank
– senthil
Oct 10 '18 at 10:56
Also when i add the above virtualtype my page will be blank
– senthil
Oct 10 '18 at 10:56
add a comment |
1 Answer
1
active
oldest
votes
0
I think it's because you forget to add the type on your virtualType in di.xml
Update your virtualType like this :
<virtualType name="MagentoSalesModelResourceModelOrderGrid" type="MagentoSalesModelResourceModelGrid">
<arguments>
<argument name="columns" xsi:type="array">
<item name="shipping_date" xsi:type="string">sales_order.shipping_date</item>
</argument>
</arguments>
</virtualType>
answered 5 mins ago
magefmsmagefms
594216
add a comment |
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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%2f221919%2fupdate-sales-order-grid-on-order-saving-magento-2%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
I think it's because you forget to add the type on your virtualType in di.xml
Update your virtualType like this :
<virtualType name="MagentoSalesModelResourceModelOrderGrid" type="MagentoSalesModelResourceModelGrid">
<arguments>
<argument name="columns" xsi:type="array">
<item name="shipping_date" xsi:type="string">sales_order.shipping_date</item>
</argument>
</arguments>
</virtualType>
answered 5 mins ago
magefmsmagefms
594216
add a comment |
0
I think it's because you forget to add the type on your virtualType in di.xml
Update your virtualType like this :
<virtualType name="MagentoSalesModelResourceModelOrderGrid" type="MagentoSalesModelResourceModelGrid">
<arguments>
<argument name="columns" xsi:type="array">
<item name="shipping_date" xsi:type="string">sales_order.shipping_date</item>
</argument>
</arguments>
</virtualType>
answered 5 mins ago
magefmsmagefms
594216
add a comment |
0
0
0
I think it's because you forget to add the type on your virtualType in di.xml
Update your virtualType like this :
<virtualType name="MagentoSalesModelResourceModelOrderGrid" type="MagentoSalesModelResourceModelGrid">
<arguments>
<argument name="columns" xsi:type="array">
<item name="shipping_date" xsi:type="string">sales_order.shipping_date</item>
</argument>
</arguments>
</virtualType>
answered 5 mins ago
magefmsmagefms
594216
I think it's because you forget to add the type on your virtualType in di.xml
Update your virtualType like this :
<virtualType name="MagentoSalesModelResourceModelOrderGrid" type="MagentoSalesModelResourceModelGrid">
<arguments>
<argument name="columns" xsi:type="array">
<item name="shipping_date" xsi:type="string">sales_order.shipping_date</item>
</argument>
</arguments>
</virtualType>
answered 5 mins ago
magefmsmagefms
594216
answered 5 mins ago
magefmsmagefms
594216
answered 5 mins ago
magefmsmagefms
594216
answered 5 mins ago
magefmsmagefms
594216
594216
add a comment |
add a comment |
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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%2f221919%2fupdate-sales-order-grid-on-order-saving-magento-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');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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
I followed this way, but all the value are updating to the sales_order_grid table except the custom column value. is there any other code is missing?
– senthil
Oct 10 '18 at 10:40
Also when i add the above virtualtype my page will be blank
– senthil
Oct 10 '18 at 10:56