Questions tagged [sales-order-grid]

Denotes questions regarding Magento Sales Order Grid

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

How to apply null value filter for magento admin grid

I have added an additional column to sales grid in admin by adding the following to sales_order_grid.xml <column name="email_sent" > <argument name="data" xsi:...
0
votes
0answers
11 views

Show admin order comments in sales order grid

I am trying to show admin order comments in a new column I created in sales order grid. Anyone know how I would do this?
1
vote
3answers
100 views

In Magento 2 how to show an image in the custom column on sales order grid

In Magento 2 how to show an image in the custom column on the sales order grid. I added a custom dynamic column in sales order grid Magento 2 Vendor\Module\Ui\Component\Listing\DataProvider.php <?...
1
vote
1answer
28 views

Magento 2: “Back” Link from View Order to Custom Grid

I have a custom sales order grid that has a "view" link for each entry which takes the user to the standard Order View page. Is there a way to make the "Back" link on the order ...
0
votes
0answers
5 views

Sales Order Grid Set Predefined filter of 30 days

I need to set predefined filter on Purchase Date on 30 days from current date and load the orders for that filter only. Any time should be able to load all orders if we remove the filter I tried ...
0
votes
0answers
43 views

Magento 2.2.9. Sales Order Grid. Order & Filter by column not in database

I´m trying to create a new calculated colunm on sales order grid. This column must indicate if all the products in the order are in stock at the moment the grid is displayed. I managed to create the ...
0
votes
0answers
16 views

Understanding <?php echo $this->getChildHtml('totals') ?> Magento 1

I've been working into magento 1 to understand some of its concepts & relations. I can see that the order total section in admin (re-order page) is made up of <div id="order-totals" ...
0
votes
1answer
43 views

I want to show the admin user on, change order status in bulk or single order

I want to show the admin user name on change order status in order comment history in bulk or single order, using a single event or plugin Magento 2.3.5p1 Community edition Any help highly ...
0
votes
0answers
15 views

FILTER CUSTOM COLUMN SALES ORDER GRID, error SQLSTATE[42S22]: Column not found: 1054 Unknown column' in 'where clause'

I am trying to add custom column in sales order grid the column name is WoF Status. its work and show at sales order grid. but my problem is, when I filter this column. I got error like this : main....
0
votes
0answers
14 views

Orders grid not loading magento 2 (Something went wrong with processing the default view…)

Info: Magento 2.3.5 PHP 7.2 database: mariadb-10.2 Hi guys! Had someone already faced this issue on Magento order sales grid? "Something went wrong with processing the default view and we have ...
0
votes
1answer
28 views

Magento 2 - Get Shipping Code or Method in Sales Order View in Admin

I have a custom shipping module that passes some information into the Sales Order and the email. The problem is that it shows the data even when the shipping method isn't used. How can I get the ...
0
votes
2answers
77 views

Magento 2 - Get Shipping Code in Sales Order view in Admin

I have a custom shipping module that passes some information into the Sales Order and the email. The problem is that it shows the data even when the shipping method isn't used. How can I get the ...
2
votes
0answers
15 views

Add entity_id column and filter in sales order grid magento 2

I want to add entity_id column and filter for its search in sales_order_grid in magento 2.3 admin. Any one have any idea?
0
votes
0answers
21 views

Magento 2 in custom grid click action result redirect given object object

I have created my custom grid increment id is click to result in redirect sales order view page. But given the action return object object. file-path vender/module/view/adminhtml/ui_component/...
0
votes
1answer
24 views

Magento 2.3 Admin Sales Order Grid hide cancelled orders

I want to remove all cancelled orders from admin sales_order_grid. I am trying to add a collection as below. But it's not updating. However the printed data showing correctly. <?php namespace ...
0
votes
0answers
26 views

set default filter status on sales order grid, not working

i try set default filter status on sales order grid with this code: app/code/FP/Orders/Model/ResourceModel/Order/Grid/Collection.php <?php namespace FP\Orders\Model\ResourceModel\Order\Grid; use ...
0
votes
0answers
8 views

select element or add filter after massaction

I need your help because I really can't move forward with my problem. I would like to select or filter the elements that have been manipulated during my massaction in sales_order_grid. So I would like ...
0
votes
0answers
12 views

Unable to Filter Order Grid Collection for Diffrent Layouts in magento 2

i am using sales_order_grid in two layouts sales_order_index and custom_order_index I want to filter collection for both grid based on a custom attribute in sales_order_grid table its name is archived ...
0
votes
0answers
9 views

COD orders not shown in Sales->Order

I'm having an issue with COD not being displayed in the Sales -> Order grid. All payment methods are being displayed here except for COD. I'm not sure why I also tried filtering by "Pending" ...
0
votes
1answer
21 views

How to show the po_number in sales order grid and My order Table at frontend - Magento 2.3

How the show po_number from sales_order_payment_table to Sales order grid in admin html and My order tabel at frontend after customer login. Thanks in Advance :)
0
votes
1answer
22 views

How to show the column from sales_order in the sales grid admin Magento 2.3

I want to show the column and it's data from sales_order in the sales order admin panel magneto. How to show this.
0
votes
0answers
16 views

How to remove/customise magento 2 extended sales order grid

I have extended the sales order grid on my custom module, I am trying to remove create a new order, go to archive, default view, columns, export and search box. Any help, appreciated.
2
votes
1answer
274 views

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

Magento 2.3.3 CE Sales Order Grid table is empty but data exist in sales_order and sales_order_item. Earlier I have thought that some module issue so I have disabled all but still after running ...
1
vote
0answers
45 views

How to filter pending and processing orders at the same time

I want to be able to filter orders "pending" and "processing" at the same time (like the last option on the image). How would I do that?
0
votes
0answers
48 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
120 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
1answer
32 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
26 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
383 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
121 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
2answers
355 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
132 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
131 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 ...
1
vote
0answers
127 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
587 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 ...
1
vote
1answer
146 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 ...
1
vote
0answers
46 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
876 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
295 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
132 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
676 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
66 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
1k 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 ...
1
vote
0answers
49 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
57 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
808 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
151 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
240 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
42 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
751 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 ...