Questions tagged [sales-order-grid]
Denotes questions regarding Magento Sales Order Grid
103
questions
0
votes
1
answer
50
views
Default filter for admin sales order grid Magento2
If there is no active filter for sales order grid, I need to add a default filter in sales order grid in admin that will show only current date orders if no other filter are applied.
I need to do it ...
- 930
0
votes
0
answers
55
views
Display Latitude and Longitude in billing and shipping address and display value on admin panel order section
Add new fields(Latitude, Longitude) in billing address and shipping address and display both custom fields and it's value on following sections:
Admin Order Section
Order notification and email ...
- 525
0
votes
0
answers
77
views
Magento 2.4 admin sales order grid spinner loading forever
Scenario: new Magento 2.4.5 environment with sample data
I added my custom plugin by which I add to sales order view three custom columns. All seems to work but when I go to sales/order in admin panel ...
- 155
0
votes
3
answers
122
views
Magento 2.4.x: Get stripe payment status on admin grid
Is there a way to get the stripe payment status on custom sales order grid column?
- 350
0
votes
1
answer
38
views
I am new in magento! :: I have task to add a custom field('is_vip') in order columns. please help me?
Programatically, add a custom field('is_vip') in order. If a customer order value over $150 , the field value will be 1 and in order grid it will show yes.
0
votes
0
answers
88
views
Keyword Search in Sales Order Grid
I have added entity_id to my sales order grid. This is working and i am able to apply a filter.
It was pretty straight forward to add the extra column, as entity_id already exists in the ...
- 518
1
vote
0
answers
275
views
how to magento 2 rest api change date formatted created at field
I have created a new module.
app\code\Sale\Paymentext\etc\webapi_rest\di.xml
<?xml version="1.0" ?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:...
- 353
0
votes
4
answers
557
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.
- 626
0
votes
1
answer
507
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 ...
- 626
0
votes
1
answer
772
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 ...
0
votes
2
answers
183
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 ...
0
votes
1
answer
674
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,...
- 581
0
votes
1
answer
640
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?
...
- 614
1
vote
3
answers
389
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. ...
- 3,593
2
votes
0
answers
140
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 ...
1
vote
1
answer
1k
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 ...
- 314
0
votes
0
answers
379
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 "...
0
votes
1
answer
648
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\...
- 614
2
votes
2
answers
2k
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 ...
- 721
0
votes
2
answers
558
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"?>
<...
- 2,074
0
votes
1
answer
175
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.
...
- 47
1
vote
1
answer
484
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?
- 916
0
votes
0
answers
188
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 ...
- 309
0
votes
0
answers
81
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
...
- 161
0
votes
1
answer
1k
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 ...
- 2,045
0
votes
1
answer
813
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 ...
- 1,130
0
votes
2
answers
298
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?
- 47
1
vote
3
answers
605
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,441
1
vote
1
answer
383
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 ...
- 834
0
votes
0
answers
23
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" ...
- 2,630
1
vote
1
answer
256
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 ...
- 595
1
vote
1
answer
1k
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....
- 11
0
votes
1
answer
666
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 ...
- 131
0
votes
2
answers
2k
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 ...
- 131
1
vote
0
answers
184
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?
- 385
0
votes
0
answers
328
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/...
- 11
0
votes
1
answer
412
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 ...
- 533
0
votes
1
answer
208
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 :)
- 328
0
votes
1
answer
154
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.
- 328
4
votes
1
answer
2k
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 ...
- 504
1
vote
1
answer
141
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?
- 33
0
votes
1
answer
693
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 ...
- 2,887
0
votes
1
answer
138
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
0
answers
63
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 ...
- 43
2
votes
2
answers
3k
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 ...
- 143
0
votes
1
answer
757
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,228
1
vote
2
answers
946
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 ...
- 765
0
votes
1
answer
829
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 ...
- 1,228
0
votes
1
answer
646
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,620
1
vote
0
answers
388
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 ...
- 1,620