Questions tagged [order-grid]
Questions specific to the admin panel order grid
435
questions
0
votes
2
answers
39
views
General search bar in customer order grid on frontend
We would like to create a general search bar at the customer order grid on frontend.
So customers can search within the placed orders for "order_id" and "sku". We already achieved ...
- 1,422
0
votes
0
answers
36
views
Magento 2 Mass Action PDF open into new tab
I have create one custom mass action at order grid using this mass action download one custom pdf.
Now, when I click on this mass action option pdf is automatically download but did not open into new ...
0
votes
1
answer
57
views
Magento2: Create orders grid replica and add custom columns
I want to replicate the order grid, add custom columns in it and fetch that columns data from the API.
- 676
0
votes
3
answers
130
views
How to remove 'Create New Order' button from sales order grid
How can I remove 'Create New Order' button from sales order grid?
I don't want to hide it, i know about following code
<item name="style" xsi:type="string">display:none</...
- 1,091
0
votes
1
answer
417
views
Export Button in sales order grid Magento 2
I've included the following code in sales_order_grid.xml, but it's triggering a form key error. My goal is to export data to a text file. Could you please advise on how to accomplish this? Do I need ...
- 4,562
0
votes
1
answer
95
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 ...
- 950
0
votes
1
answer
139
views
add custom order status to orders grid bulk actions in Magento 2.4.5
How to add more order statuses to orders grid bulk actions drop down to update one or more orders status at a time by selecting the check box of orders.
- 1,463
0
votes
1
answer
85
views
In sales order grid shipping addess in i getting error can i know how solve this error magento 2?
like this in shipping address First Name
{{if this.getTemplateFilter().filter(dummy)}}{{/if}}
0
votes
0
answers
144
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 ...
- 165
0
votes
1
answer
248
views
Magento2 join product details in sales order grid as filterable column
We have added some additional sortable / filterable columns to sales order grid using some basic joins. This would be the relevant code regarding data
app/code/Vendor/Module/etc/di.xml
<?xml ...
- 3,165
0
votes
3
answers
198
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?
- 440
0
votes
1
answer
41
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
1
answer
39
views
Magento 2.4.5 product link at admin order gird view
I want to show the product link on order admin onclick go to storefont product link
or onclick to product thumbnail it open store product ordered image by new tab
exabople link html http://example.com/...
1
vote
0
answers
17
views
Request Order Status Change
Is there a way to change status from Shipped to Processing? I accidentally click the Ship status. Please help
- 11
1
vote
0
answers
202
views
Order filter and search issue in admin order grid magento 2?
I have two types of order numbers( order Increment Id ) in my order table. Based on a condition i am updating the order increment id like below.
EX - 000000767 To HTO-000000767
I have other orders ...
- 2,823
1
vote
0
answers
354
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:...
- 637
0
votes
2
answers
760
views
magento 2.4.3 admin order grid not showing
I installed my custom plugin in Magento 2.4, but after that I'm not able to see the order list in the grid. Here below a screenshot:
My plugin adds three columns in sales_order_grid, here below I'll ...
- 165
1
vote
3
answers
1k
views
Filter admin order by store id magento 2
I'm trying to filter orders by store instead of store view.
I have 2 stores, each has 2 store views.
I wanted to filter order with store.
I declared a collection in di.xml
<type name="Magento\...
- 73
0
votes
4
answers
811
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.
- 623
0
votes
1
answer
2k
views
Get order by date and status filters in magento 2 with rest api
Get Orders details using rest API with filters status and date range in magneto 2.4
- 1,119
0
votes
1
answer
781
views
How can we resolve the sales order filter with sku gaves "Something went wrong with processing for sku colum....." in Mageto 2
The Sales Order Grid Not Working And It's Gives this kind of error when search by sku
"Something went wrong with processing the default view and we have
restored the filter to its original state....
- 658
0
votes
1
answer
57
views
Magento add custom action in massaction sales/order resulting bug in Order detail
I want to add custom action inside mass action in Sales/Order, here the code:
sales_order_grid.xml
<?xml version="1.0" encoding="UTF-8"?>
<listing xmlns:xsi="http://...
- 29
0
votes
1
answer
594
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 ...
- 623
0
votes
1
answer
110
views
Custom link in order grid not able to access custom controller but forward to order details page
I've successfully create a column in order grid page. The
sales_order_grid.xml
<?xml version="1.0" encoding="UTF-8"?>
<listing xmlns:xsi="http://www.w3.org/2001/...
- 2,221
0
votes
1
answer
1k
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
260
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 ...
1
vote
0
answers
751
views
How to add a input field in admin grid and post it using mass action- Admin Panel
The question is how to get the input data in mass action.
I have currently added a input field in the admin grid. Like this:
I have added the input field using the block. I want to post that values ...
- 180
0
votes
1
answer
778
views
Magento 2 Admin Orders Date show not actual result
I have Magento 2.4.2-p1 EE.
When i filter orders by dates, example: Purchase Date: 12/12/2021 - 12/12/2021
I have result with 777 found orders.
But on last page i can see orders with wrong dates for ...
- 165
0
votes
2
answers
214
views
Sales Order Grid Mass Action Route 404 Error
I have created module to send email using mass actions, but it is showing 404 error.
etc/acl.xml
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:...
- 195
0
votes
3
answers
319
views
Adding custom column in order grid, removes toolbar from page
In administration Orders Grid, I added a custom column containing telephone. I used a custom extension for this and it causes order toolbar to disappear somehow
Here's the module code:
etc/adminhtml/...
- 660
0
votes
1
answer
859
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
879
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?
...
- 658
1
vote
3
answers
639
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,513
2
votes
0
answers
180
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
2k
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 ...
- 298
0
votes
0
answers
498
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
2
answers
525
views
Admin grids: Force custom grid view for specific admin user or admin user role?
We have a special admin user account that should not see certain columns in the admin panel order grid. Let's assume we want to hide the "Bill to name" and "Ship to name" from that ...
- 1,122
0
votes
1
answer
69
views
Sales Order grid column name cached?
Magennto 1.9.4
I added a column to the sales order grid like this:
$this->addColumn('data', array(
'header' => Mage::helper('sales')->__('X'),
'index' => 'data',
));
...
- 569
0
votes
1
answer
977
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\...
- 658
2
votes
2
answers
3k
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 ...
- 751
0
votes
4
answers
3k
views
How to add filter to a already working custom sales order grid column module?
I have the following from another post, and now I'm looking for a way to make these 4 extra columns filterable.
Thank you,
\app\code\Vendor\SalesOrderGrid\Ui\Component\Listing\Column\Address.php
&...
- 298
1
vote
3
answers
1k
views
Change shipping address column format in Sales Order Grid (Magento 2.4.2)
Where do I change the column shipping address format in the Sales => Order => Grid in Magento 2.4.2?
I need to have the post code/zip code in front of the city. "Stan" and "99999&...
- 298
1
vote
2
answers
644
views
How to display sales_order (only pending orders) grid in custom module
How we can display sales_order grid in custom module with only pending status.
For now I display sales_order_grid using ui component. I only want to display pending orders in this grid
- 1,337
0
votes
0
answers
86
views
Display number of orders per customer in admin order view
I'm trying to display number of orders made per customer in admin order grid, using the following join and select I could get the number or orders.
$collection->getSelect()->joinLeft('...
- 91
0
votes
1
answer
52
views
how to get number of orders made per customer in admin order grid
I am trying to display number of orders made per customer (customer is identified by email) in admin order grid. Number of orders should be the sum of orders made per customer, regardless if customer ...
- 91
0
votes
2
answers
591
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,134
0
votes
1
answer
238
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.
...
- 109
1
vote
1
answer
588
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?
- 946
0
votes
0
answers
213
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 ...
- 511
0
votes
0
answers
91
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
...
- 195