Questions tagged [sales-order-grid]

Denotes questions regarding Magento Sales Order Grid

Filter by
Sorted by
Tagged with
0
votes
0answers
13 views

Reload page after mass action on sales order grid

I created a new order status called Printed that has to be assigned after the mass action Print invoices on sales_order_grid. I created all the custom logic to achieve the result. The only problem ...
0
votes
1answer
39 views

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

I am looking for solution for multiple sales order Grid as per order status. One grid will have all pending order and another grid for Processing orders. Please have a look attached screenshot. how ...
0
votes
0answers
11 views

hide columns conditionally in sales_order_grid

Hi to all I added three custom columns in sales_order_grid, here below the code relating to the first: <column name="create_invoice" class="Vendor\AppFatturazione\Ui\Component\Listing\Column\...
0
votes
1answer
28 views

How to get product ordered quantity column in sales grid in Magento2.2.6?

How to get product Ordered Quantity Column in the sales grid in Magento 2.2.6 ? Any help would be appreciated. Thanks in advance..!
2
votes
0answers
24 views

How do i add quick filters to the admin grids?

I've been trying to add a new filter category for an already existing column when I discovered the existence of Quick Filters. My question is twofold: is Quick Quickfilters compatible with the ...
1
vote
2answers
104 views

How to resolve “The store that was requested wasn't found. Verify the store and try again.”?

I don't know why it is not accessing my orders page in backend admin, When I navigating to Admin dashboard -> Sales -> Orders. I am having this issue "The store that was requested wasn't found. Verify ...
0
votes
1answer
35 views

Attention: Something went wrong, Error when applying filter

I added an attribute in sales_order, and display it as a column in sales_order_grid, all is set but when I try to apply filter on my custom column it gives me an error with a pop-up like: Attention: ...
1
vote
1answer
83 views

Magento 1.9.4.3 Custom Column Filter not working

I have a custom column on my sales order grid showing the ordered items sku's. Done by following the guide here. It worked well in previous versions but no longer does work correctly in 1.9.4.3. When ...
0
votes
1answer
36 views

How to add column in sales_order_grid also want to get that attribute from sales_order collection?

I want to a column in sales_order_grid I successfully did that but I also want to get my custom attribute from sales_order collection because I want to set value on some action, my problem is a can't ...
0
votes
1answer
28 views

Billling address and shipping_address populate from billing_address_id and shipping_address_id in magento 2

I need to known how Billing address and Shipping address is populate in sales_order_grid table from sales_order table Even in the sales_order table there is billing_address_id and shipping_address_id ...
0
votes
0answers
30 views

Magento 2: Custom value save in sales_order_grid table

I have a custom column in the sales_order_grid table and want to save some custom values that are not in sales_order table. Too many tutorials are there that populate sales_order table column into ...
2
votes
2answers
200 views

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

How can I add customer comment from checkout page using observer? Customer comment is introduced from the block with a text area. When I create new order I need to add a comment to this order using ...
0
votes
0answers
8 views

Setting UI Component (Sales Order Grid) Settings for Specific Route

I can add the sales order grid to a route easily by adding this in the layout file: <referenceContainer name="content"> <uiComponent name="sales_order_grid"/> </referenceContainer>...
1
vote
1answer
55 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
90 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
19 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
362 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
130 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
77 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 ...
3
votes
2answers
370 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
37 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
2answers
463 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
25 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
19 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
36 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
37 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
2answers
435 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
1answer
60 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
158 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
35 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
552 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
22 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
106 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
650 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
174 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
417 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
41 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
160 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
180 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
88 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"?>...
2
votes
0answers
147 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
64 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
148 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
170 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
142 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
390 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
159 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
124 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
1k 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 ...