11 votes

Add Phone Number column in sales order grid

Please add the ui_component class for your column as per below. <?xml version="1.0" encoding="UTF-8"?> <listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:...
Aasim Goriya's user avatar
  • 5,374
10 votes
Accepted

Add Phone Number column in sales order grid

You added the column in ui_component correctly Just replace the _renderFiltersBefore function with my function in your module collection class Path should be Vendor/Yourmodule/Model/ResourceModel/...
Muhammad Hasham's user avatar
7 votes
Accepted

Magento 2 Product Details Column in Sales order Grid

Create sales_order_grid.xml at app/code/Vendor/Module/view/adminhtml/ui_component/sales_order_grid.xml <?xml version="1.0" encoding="UTF-8"?> <listing xmlns:xsi="http://www.w3.org/2001/...
Prince Patel's user avatar
  • 22.5k
7 votes
Accepted

Magento 2 : Sales Order Grid table is empty but data exist in sales_order

Disable Asynchronous indexing under Store > Configuration > Advance > Developer > Grid Settings Clear cache and reindex, Hope this will work or you.
Kishor Thummar's user avatar
6 votes
Accepted

Magento2 : sales order grid add new column with it's values

I created a UI component sales_order_grid.xml under [Vendor]/[Module]/view/adminhtml/ui_component/sales_order_grid.xml and add the following code to your sales_order_grid.xml: <?xml version="...
Sukumar Gorai's user avatar
6 votes
Accepted

Magento 2 bar disappeared in Sales Order Grid after adding column

The bar was under the table and not disappeared. Just adjust the order and you'll get this solved. I solved the problem in Magento 2.2.x adding <listingToolbar name="listing_top"/> on top of ...
Vixent's user avatar
  • 349
5 votes
Accepted

Magento 1.9 add custom button in admin order grid page

I've got it works.Here the complete files: <config> <modules> <Company_Module> <version>0.1.0</version> </Company_Module> </modules> <...
krybbio's user avatar
  • 1,258
5 votes
Accepted

Magento 2 sales order grid custom column export csv issue

join is happening twice in process of exporting, to avoid it, add checking in registry: use Magento\Framework\Message\ManagerInterface as MessageManager; use Magento\Framework\Registry; use Magento\...
Ilja's user avatar
  • 1,258
5 votes
Accepted

Get additional_information from sales_order_payment to show in backend sales order grid

You can display the additional_information by using the joinLeft concept. The actual "additional_information" data resides in sales_order_payment table. We can join the sales_order_grid ...
Siranjeevi K S's user avatar
4 votes
Accepted

Magento 2: admin sales grid, filter column from sales_order table

You need to join your new field rescue_order_name to order grid collection first. First override Magento\Sales\Model\ResourceModel\Order\Grid\Collection and add below function to join. protected ...
Sarvesh Ahuja's user avatar
4 votes
Accepted

Magento2 Mass Action to Sales Order Grid

Create a module with name Vendor_Module by following steps: Step 1: Create registration.php under: app/code/Vendor/Module/registration.php with below content: <?php \Magento\Framework\...
Sukumar Gorai's user avatar
4 votes
Accepted

Magento 2 Add Billing and Shipping Company Column on Sales Order Grid

Try this: class AddColumnsSalesOrderGridCollection { public function aroundGetReport( \Magento\Framework\View\Element\UiComponent\DataProvider\CollectionFactory $subject, \...
Sohel Rana's user avatar
  • 35.5k
3 votes
Accepted

Magento2 : Add sales_order column coupon_code in sales order grid

EDIT: Add in or add an InstallSchema.php from this path of your custom module: Vendor/Module/Setup/InstallSchema.php <?php namespace vendor\module\Setup; use Magento\Framework\Setup\...
fmsthird's user avatar
  • 4,562
3 votes
Accepted

How save value in custom_attribute of "sale_order_grid"

Try following way will copy data automatically when saving sales_order table: VendorName\ModuleName\etc\di.xml <?xml version="1.0"?> <virtualType name="Magento\Sales\Model\ResourceModel\...
Sohel Rana's user avatar
  • 35.5k
3 votes

Magento 2 how to pass order id's from sales order grid to my module controller

\Magento\Ui\Component\MassAction\Filter::getCollection is responsible for adding filter criteria to your collection and you can iterate through it to do some mass action. It will obtain \Magento\Ui\...
KAndy's user avatar
  • 20.7k
3 votes
Accepted

Magento 2 Export CSV on Sales Order Grid with Custom Fields

In my case the problem was in plugin aroundGetReport since i use $this->registry->registry('cc_added') check. Magento\Ui\Model\Export\ConvertToCSV calls $dataProvider->getSearchResult() more ...
krybbio's user avatar
  • 1,258
3 votes

Magento 1.9.X: Add customer comment to order using observer

You can use the below code in your observer to add order comment: $comment = "Comment to be added in the order"; $order->addStatusHistoryComment($comment) ->setIsVisibleOnFront(...
Sumit's user avatar
  • 4,815
2 votes

Hide or remove column from sales order grid

The solution should be <column name="store_id" class="Magento\Store\Ui\Component\Listing\Column\Store"> <argument name="data" xsi:type="array"> ...
MagEx Ditital's user avatar
2 votes

Hide or remove column from sales order grid

You need to override the layout for sales order grid, in order to do this create the sales order grid layout file inside your custom module Namespace/Module/view/adminhtml/ui_component/...
Idham Choudry's user avatar
2 votes

Magento 2 sales order grid custom column export csv issue

use Magento\Framework\Message\ManagerInterface as MessageManager; use Magento\Sales\Model\ResourceModel\Order\Grid\Collection as SalesOrderGridCollection; class AddColumnsSalesOrderGridCollection { ...
Charvi Parikh's user avatar
2 votes
Accepted

Magento2 Add line separator in mass action list in sales order grid

I got one of the resolution of my question. In order to add line separator between mass action just like Amasty extension. person should add this action in listing_massaction tag in ui component file. ...
Muhammad Hasham's user avatar
2 votes

Add default filter to sales_order_grid for order status

Update For this use case there are two possible solutions 1. A simple non coding solution Apply the Order Status Filter "Processing" in the Admin Order Grid then click on the "Default View" Tab ...
mydons's user avatar
  • 481
2 votes

Magento 2 Multiple Sales Order Grid(Duplicate) as per order Status

Hi if your need multiple Order Grid based on status then you need to create module for that Create below file for your module as usual create registration.php etc/module.xml Create your module ...
rakesh prajapati's user avatar
2 votes
Accepted

Magento 2: "Back" Link from View Order to Custom Grid

You can do this by plugin. Create this class: <?php namespace NameSpace\ModuleName\Plugin\Sales\Block\Adminhtml\Order; use Magento\Sales\Block\Adminhtml\Order\View as OrderView; use Magento\...
Adarsh Khatri's user avatar
2 votes
Accepted

Recreate sales order grid in custom admin page

A few months ago I created a module that I think can help you. In my case, I created a new page in the admin that showed a grid in which it took sales_order as the main table and joined with other ...
Noty's user avatar
  • 66
2 votes

Display Customer Attribute in Sales Order Grid

Create sales_order_grid.xml inside adminhtml > ui_component directory <listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:...
Arun Sharma's user avatar
  • 1,205
2 votes
Accepted

How to add Button in Magenot 2 Sales order Grid with out a link?

app/code/Vendor/Module/view/adminhtml/ui_component/sales_order_grid.xml <?xml version="1.0" encoding="UTF-8"?> <listing xmlns:xsi="http://www.w3.org/2001/...
M2 Dev's user avatar
  • 460
1 vote

Magento2 : Add sales_order column coupon_code in sales order grid

For new orders via Virtual type definition: - di.xml above ( copy on the fly values from sales_order table into sales_order_grid ) For exists orders: I didn't find advice, so solution you can find ...
Ocheretnyi's user avatar
1 vote
Accepted

How to copy a module in Magento2?

Go to root > vendor > magento > module-sales Download all files from this location Created your module at app > code like app/code/namespace/mymodule Upload all files from your storage to your newly ...
Teja Bhagavan Kollepara's user avatar
1 vote

Magento 2 - How to change sales order grid column label?

you can do this from Admin Only, go to, Store -> Configuration -> Advance -> Developer -> Translate Inline -> Enabled for Admin == Yes and change the inline translations asp per the ...
Oscprofessionals's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible