Questions tagged [sales-order-grid]

Denotes questions regarding Magento Sales Order Grid

Filter by
Sorted by
Tagged with
1
vote
1answer
42 views

Add a column to sales order grid without breaking the order's view

Here is the plugin code i tried to add the columns of the custom table to the sales order grid <?php namespace Testing\Testorder\Plugins; use Magento\Framework\Message\ManagerInterface as ...
0
votes
0answers
33 views

Show Tier Price in Admin Order Product Grid

I want to show Tier Price in admin sales order grid. For that, I have the override below file. Magento\Sales\Block\Adminhtml\Order\Create\Search\Grid.php When I am adding below code in the ...
1
vote
0answers
11 views

How to display Category name in Sales order grid in magento2

I am using magento 2.2 version i want to display category name in admin sales order grid as well as in frontend customer sales order. Can you please help me.
3
votes
1answer
44 views

Magento 2 Export CSV on Sales Order Grid with Custom Fields

I succesfully added some custom fields on Sales Order Grid. If I export "Excel XML" is working fine but with "CSV" custom fields are blank. I have compared the following files: Magento\Ui\Model\...
2
votes
1answer
56 views

Magento 2.3.1 Sales Order Grit Filter “Not Null” value

In Magento 1.9 I had: protected function getOptionArray() { return array( 'Has Ticket' => Mage::helper('Sales')->__('Si'), 'Has No Ticket' => Mage::helper('Sales')->__(...
1
vote
1answer
49 views

How to copy a module in Magento2?

I have created a new module in app/code/namespace/Mymodule. Now, I'm trying to display the information about Custom_order or exactly. I want to copy module sales in vendor/magento/module-sales. I ...
2
votes
2answers
49 views

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

How could i change this label? Tried with sales_order_grid.xml didn't work. <listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:module:...
0
votes
0answers
16 views

Get Filters selected in admin sales order grid

How can I retrieve the selected filters when a sales order admin grid loads programmatically in Magento 2? For e.g., if the filter is selected as Status = Cancelled, I want to be able to access it ...
2
votes
1answer
48 views

New orders are not showing in the orders grid but payement received?

I upgraded from Magento 2.5.0 to 2.3.1 I am using only PayPal as a payement method. new orders are not showing in the orders grid in Admin > Sales > Orders and emails are not sent !! when I check ...
0
votes
0answers
23 views

Set a default filter for Order Grid

How can I set a default filter for Order Grid programmatically? I read many different answer but they don't work properly.
0
votes
0answers
9 views

Mass Action assigned to a custom button in Sales Order page Magento 1.9

I am working on a custom module. One part of that module creates a button above the Sales Order Grid. The current code for that button is; public function addNewButton($observer) { $...
1
vote
0answers
23 views

Filter a custom attribute in Order Grid

I added new attribute and new column to Order Grid : [vendor]\[module]\view\adminhtml\ui_component\sales_order_grid.xml <?xml version="1.0" encoding="UTF-8"?> <listing xmlns:xsi="http://www....
2
votes
0answers
22 views

Unable to resolve the source file. magento 2 admin sales order grid

In admin. We are getting this error open SALES=>Orders. Unable to resolve the source file for 'adminhtml/Magento/backend/en_US/Magento_Ui/templates/collection' #0 /var/www/abc.com/vendor/magento/...
3
votes
1answer
259 views

Add default filter to sales_order_grid for order status

I want to filter the order grid in admin to see only the orders in status "processing" in the grid by default. This grid is different from the others, I tried solutions from here but no success add ...
0
votes
0answers
22 views

Magento 1.9.3.1 Sales Order Grid limit records

I have a Magento store running with over 18,000 order records all the other pages within admin load within 1 - 2 seconds apart from Sales>Orders this can take anything between 5 - 20 seconds to load. ...
0
votes
1answer
53 views

Magento 2 : Default filter on sales admin order grid

I need to create a filter on sales admin order grid that only shows the orders that contain products from a specific source. I found questions that sort of answered this for Magento 1 but not for ...
1
vote
0answers
27 views

Magento 2.2.8 exact search in backend

In the admin backend on the order grids we used to be able to do an exact search like, "Firstname" in Magento 2.2.5 Now i have upgraded Magento to 2.2.8 and the exact match doesn't work anymore. It ...
0
votes
1answer
282 views

Some Payment Method Not Showing in Sales grid after upgrade magento to 2.3.1

I upgraded Magento version 2.2.3 to 2.3.1 by using composer. All Things are working fine, except Sales order grid. In sales grid it's showing only payment method check, rest other payment methods are ...
0
votes
0answers
12 views

what is difference between magento1 and magento2 sales order table list

what is difference between magento1 and magento2 sales order table related data to be stored and which table to be affected. Magento1 Sales related table Magento2 Sales related table Thank you, ...
1
vote
0answers
68 views

How to add shipment numbers to sales_order_grid column?

So, question is: how can i correctly add column with shipment numbers from to sales order grid table? Currently i made it with plugin but there're several issues: got an error at order's shipment ...
1
vote
2answers
209 views

Magento2 : Add sales_order column coupon_code in sales order grid

In sales_order table we have a column coupon_code. I need to show it in sales order grid. I have added the column coupon code by overriding sales_order_grid.xml file. The column is being shown. Now I ...
1
vote
0answers
88 views

Missing Rows In Sales Order Grid

I have an interesting issue. Admin sales order grid does not show all records in sales_order_grid table. I tried several solutions. For example, I activated async grid generation on admin panel, ...
0
votes
1answer
208 views

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

I have added two new column ('Billing Company', 'Shipping Company') in sales order gird using below code. di.xml <type name="Magento\Framework\View\Element\UiComponent\DataProvider\...
1
vote
1answer
34 views

How save value in custom_attribute of “sale_order_grid”

I have to save value in custom_attribute(current_seller_id) in "sales_order" table. using event below code But now i want to save same value in custom_attribute(current_seller_id) of "sale_order_grid"...
2
votes
1answer
58 views

Getting order id for guest checkout order

I need to assign a Guest Order to a Customer, so i found this link How to assign a Guest Order to a Customer - Magento 2 Using SQL UPDATE sales_order SET customer_id = {YOUR CUSTOMER ID}, ...
1
vote
1answer
51 views

How to update sales_order_grid table in M2 production mode?

We have a working, well filled sales_order_grid table. But those orders we add via custom integration do not show up there - or show up, but with a very long delay. We found in the cron_schedule ...
2
votes
0answers
83 views

how to add Custom column with link in sales order grid magento

I want to add custom column in sales order grid. In the row data I want to add link using block render or using ui-component.
6
votes
2answers
2k views

Add Phone Number column in sales order grid

I am trying to add phone number column in my order grid. I have added new column through sales_order_grid.xml in my ui_component directory. Code is below: <?xml version="1.0" encoding="UTF-8"?>...
1
vote
0answers
72 views

Magento 2: Add invoice Increment ID to Order grid

I am trying to add invoice increment ID to order grid in magento 2 admin like below: app/code/Payment/Status/view/adminhtml/ui_component/sales_order_grid.xml <?xml version="1.0" encoding="UTF-8"...
0
votes
1answer
53 views

Remove sale order grid total count in magento 1

I am on Magento 1.9 and would like to remove one of the block in sales -> orders page See attachment. Can someone please show me which file that i need to edit in order to remove that?
2
votes
1answer
116 views

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

I need to add line separator before my two newly created custom mass action "Custom Action 1" and "Custom Action 2" and
2
votes
1answer
75 views

Magento 2 : Currency Symbol missing when exporting Saler Order Grid

I am exporting Magento 2.1.9 Saler Order Grid to CSV and XML formats using the provided buttons. But when I open the file in Excel the currency symbol is missing in Grand Total (Base) and Grand Total (...
0
votes
1answer
116 views

Adding Custom massAction to Orders Grid in Magento 2

I added the custom massAction to Orders List and it's executing my massAction method but it's redirecting to dashboard. for these I have written below code. protected function massAction(...
1
vote
1answer
248 views

How can i filter in sales order grid magento 2?

While i am using same code for filter it's working but i have break other grid like customer,invoice,cms page and get error "Not registered handle cms_page_listing_data_source" While i have moved di....
2
votes
0answers
81 views

Order purchase date filter range not showing expected results

Preconditions Magento 2.2.2, Nginx, Redis. Magento local timezone AEDT, server time AEDT mysql SELECT CURRENT_TIMESTAMP(); returns AEDT time SELECT @@global.time_zone, @@session.time_zone; returns ...
0
votes
1answer
74 views

add condition to collection join

$collection = $observer->getOrderGridCollection(); //get the attribute id of our custom eav $attributeId = Mage::getResourceModel('eav/entity_attribute') ->getIdByCode('catalog_product', '...
3
votes
2answers
567 views

Magento2 Mass Action to Sales Order Grid

I am trying to apply a mass action to sales_order_grid but there is nothing happening. I have done so for is: vendor_name/module_name/view/adminhtml/ui_component/sales_order_grid.xml <?xml ...
2
votes
1answer
126 views

Duplicate sales order grid to custom admin page

I need to copy the sales_order_grid table to a custom admin page. Is there a way to do so using Magento's API?
1
vote
0answers
202 views

Magento2 : Add custom column in sales order grid

I have added a custom column in sales order grid, and it is also coming in export CSV file but at the first position. But I want to add it after id column (any place after id column) in CSV export ...
1
vote
1answer
1k views

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

when order placed at that time in admin sales order check that there is a gift option available or not if it is available that dispaly "yes" in order grid column else display "no". please see ...
1
vote
1answer
143 views

How to get billing address from sales/order_grid_collection?

I have sales/order_grid_collection where I'm getting the desired attributes on my grid, but the last one attribute I need is the billing street of the order, how can I get that programmatically? ...
3
votes
1answer
2k views

Magento 2 sales order grid custom column export csv issue

I have added a tracking number(custom field) column in sales order grid. It is displaying in sales order grid and export by XML also working fine. But while I export the data by csv only the following ...
3
votes
1answer
925 views

Hide or remove column from sales order grid

I want to hide or remove Purchase Point column from sales order grid in backend using custom module, how do i do this?
0
votes
1answer
241 views

Company Column on Sales Order/Invoice/CreditMemo/Shipment Grid

I have built a module to show the Billing and Shipping Company Name in the Admin Grids for Order, Invoice, CreditMemo, and Shipment. I still can't believe this is not built into Magento2. At first I ...
1
vote
0answers
113 views

Company name in Billing and Shipping Columns On Sales Order Grid

I need to know how to insert company name for Billing and Shipping Columns on sales order Grid in Magento admin, also Company name need to display on both billing/shipping columns under Sales shipment ...
2
votes
1answer
1k views

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

I have added a column "rescue_order_name" in sales_order table. Now i want to display the values of this column in the admin panel, sales, order grid and give the option to the admin to filter ...
1
vote
2answers
1k views

Magento 1.9 : sales_flat_order and sales_flat_order_grid tables are not updating

I used many update methods for update values in sales_flat_order and sales_flat_order_grid tables, but no method didn't work. I don't know why the update is not done. Method 1:- $coreResource = ...
4
votes
0answers
143 views

Magento 2.1.5 - Sales Order reports show missing data

I am having issue with order sales report its skipping some data from monthly order report, Some order dates are missing in reports but in order gird it displays same dates order Magento: 2.1.5 ...
2
votes
2answers
840 views

Magento 2.1.9 : Product Details Column in Sales order Grid

I need to extra column to Sales Order Grid that displays product name or product SKU.
3
votes
1answer
667 views

Magento 2 bar disappeared in Sales Order Grid after adding column

My custom module adds a column to the Sales Order grid. The problem is that the bar above the Grid disappeared. This is shown in the screenshots. With my module: Without my module: In order to add ...