Questions tagged [sales-order-grid]

Denotes questions regarding Magento Sales Order Grid

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

Sales Order Item Grid (Ui Component)

I'd like to create a grid (Ui Component) in the Backoffice of Magento 2.4 to display this table sales_order_item and join it with sales_order_grid for the name of the client... (order_id) Could You ...
user avatar
0 votes
4 answers
62 views

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

I want to add a button without a link at the sales grid top in Magento 2.4 SS: Anyone has any idea how to add only a button with a custom ( ID or class ). Any help is appreciated.
user avatar
  • 526
0 votes
0 answers
9 views

How to write custom query for sorting for a new column added in sales order grid in Magento 2?

How to write custom query for sorting data for a new column added in sales order grid in Magento 2 ? It shows Printed when invoice is created and it is blank if invoice is not created. I have ...
user avatar
  • 526
0 votes
1 answer
61 views

How to create custom sorting in sales grid custom column in Magento 2?

I have created a custom column named printed which shows the invoice is printed or not and works well. But how to apply sorting in in it like when i click on printed firstly it shows all data with ...
user avatar
  • 526
0 votes
1 answer
122 views

How to sync custom columns from sales_order to sales_order_grid in magento 2?

I create 2 custom columns in sales_order table and sales_order_grid tables. As far as I know columns will be sync by cron job if name of both tables are same. So I run a cron but data from sales_order ...
user avatar
0 votes
2 answers
29 views

How does submit shipment updates the order status in magento 2 admin panel?

I am looking for a Controller from where does the Order status gets updated in sales_order when we click on Shipment in magento 2 admin panel I want to hook some event on Submit Shipment button in ...
user avatar
0 votes
0 answers
19 views

adding custom popup in mass action in sales order admin page

Is that possible to create Modal like this but with custom dropdown inside the Modal? All I found only tree-massaction
user avatar
0 votes
1 answer
178 views

Date range issue in sales order grid in Magento2

In the sales order admin grid when we select a date range in Filter option Magento backend Sales -> Orders, it is not sticking to that date, and showing other dates too in the filter... For example,...
user avatar
  • 561
0 votes
1 answer
104 views

how to join sales_order_address table with sales collection factory

If I already have the function (last 30 minutes order cron job)below to get sales_order_grid table data, how can I join table to get sales_order_address table and get country_id, city and postal_code? ...
user avatar
  • 508
0 votes
0 answers
68 views

Newly added column in sales order table not showing in grid

I had added a new column in sales_order table using UpgradeSchema. The column was successfully added and also I was able to save value in it. Now what I want is to show this column in Sales Order Grid....
user avatar
  • 1,128
0 votes
3 answers
36 views

Display Customer Attribute in Sales Order Grid

I have a customer attribute named business_name on customer registration page. It is a customer attribute with type varchar. I need to display this attribute in Sales >> Order sales_order_grid. ...
user avatar
  • 3,554
2 votes
0 answers
59 views

Magento 2 - Sales order grid on the frontend with export option

I need to show the sales order grid on the frontend under My Orders or else I need to show the custom field under my orders on the frontend so that the customer will filter the orders based on the ...
user avatar
1 vote
1 answer
319 views

Get additional_information from sales_order_payment to show in backend sales order grid

I have a custom sales order grid module I want to extend, to show the information from the field additional_information, in the table sales_order_payment. I have this right now, but it ain't showing ...
user avatar
  • 310
0 votes
0 answers
95 views

Magento 2.4 extension attribute "pickup_location_code" not updated in grid

For every order I add dropdown that admin user can assign order to another "Pickup location". When user click button "Assign" I call Ajax and in controller change/update "...
user avatar
0 votes
0 answers
38 views

Magento 2: Add shipment link in sales order grid

Magento 2, how can I add a shipment link in sales order grid & then redirect that link to the shipment page directly http://127.0.0.1/freshmagento240/admin/admin/order_shipment/new/order_id/5/key/...
user avatar
  • 3,426
0 votes
1 answer
80 views

If I want to get data from sales_order_grid table, which CollectionFactory I should use?

If I want to get data from sales_order_grid table, which CollectionFactory I should inject? for example: If I want to get Sales_order_item, I should use \Magento\Sales\Model\ResourceModel\Order\Item\...
user avatar
  • 508
2 votes
2 answers
850 views

Recreate sales order grid in custom admin page

I'm looking to create a custom admin page and add a grid similar to the sales_order_grid. I've already created my admin route, menu item and page -- just can't seem to figure out how to duplicate the ...
user avatar
  • 650
0 votes
2 answers
289 views

Add DropDown in Sales Order Grid Section in Magento 2.2.5

I have checked some of the links but they do not work my need so Please help someone who did this before sales_order_grid.xml <?xml version="1.0" encoding="UTF-8"?> <...
user avatar
  • 1,873
0 votes
1 answer
59 views

Make customer phone number searchable in admin

How would I make the customers phone number searchable in admin for orders. Either in main admin search or the search bar in sales order grid. I have a custom column with the customers phone number. ...
user avatar
  • 35
1 vote
1 answer
165 views

Magento 2 - How to hide order with specific status from the sales order grid

I want to hide order from sales order grid with status like 'pending_payment'. How can I do in Magento 2?
user avatar
  • 815
0 votes
0 answers
78 views

Split Custom Line Item in magento 2

I need a functionality to split custom line item in magento 2.3.4 . For example, suppose Product A has custom addon Child A, then by default magento will show like this Product-A-Child-A in sales ...
user avatar
0 votes
0 answers
35 views

No data in sales transactions grid

In my magento 2.3.6 I have successfully completed an order but in sales -> transactions grid there is no data appearing. I am using three payment methods 1- CCAvenue Net banking 2- Cash on delivery ...
user avatar
  • 121
0 votes
1 answer
449 views

Custom module column in sales order grid with select filter in magento 2

I have a custom module with the columns id, order_id & reason. Now I want to add the reason value in the order grid with the select filter. Reasons are listed in the other table of the custom ...
user avatar
  • 1,957
0 votes
1 answer
523 views

Magento 2 : How to add country_id column in sales order grid

I want to add/filter country_id column of shipping address in sales order grid. I refer below link which is useful to display regoin_id. By doing same I am able to add country id as a column but when ...
user avatar
  • 1,120
0 votes
0 answers
106 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?
user avatar
  • 35
1 vote
3 answers
237 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 <?...
user avatar
  • 1,389
1 vote
1 answer
187 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 ...
user avatar
  • 804
0 votes
0 answers
19 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" ...
user avatar
1 vote
1 answer
118 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 ...
user avatar
0 votes
0 answers
628 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....
user avatar
0 votes
1 answer
218 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 ...
user avatar
  • 121
0 votes
2 answers
1k 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 ...
user avatar
  • 121
1 vote
0 answers
75 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?
user avatar
0 votes
0 answers
164 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/...
user avatar
0 votes
1 answer
247 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 ...
user avatar
0 votes
1 answer
117 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 :)
user avatar
  • 300
0 votes
1 answer
49 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.
user avatar
  • 300
4 votes
1 answer
1k 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 ...
user avatar
1 vote
0 answers
106 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?
user avatar
  • 23
0 votes
1 answer
532 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 ...
user avatar
  • 2,717
0 votes
1 answer
64 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..!
user avatar
2 votes
0 answers
47 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 ...
user avatar
2 votes
2 answers
2k 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 ...
user avatar
0 votes
1 answer
500 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: ...
user avatar
1 vote
2 answers
785 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 ...
user avatar
0 votes
1 answer
386 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 ...
user avatar
0 votes
1 answer
401 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 ...
user avatar
  • 1,516
1 vote
0 answers
300 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 ...
user avatar
  • 1,516
2 votes
2 answers
1k 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 ...
user avatar
1 vote
1 answer
361 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 ...
user avatar
  • 2,048