Questions tagged [order-grid]

Questions specific to the admin panel order grid

Filter by
Sorted by
Tagged with
19
votes
5answers
28k views

Magento 2 How to Add a New Column to Orders Grid

I've added a new column to the table sales_order called export_status, now I want to add new order grid column with the data from the new sales_order column. I've managed to add column to the ...
16
votes
4answers
18k views

Add Column to a grid (observer) - Column ‘store_id’ in where clause is ambiguous issue

I'm adding a column to the order grid using observer approach: On the event -> sales_order_grid_collection_load_before I'm adding a join to the collection On the event -> ...
21
votes
4answers
36k views

Add Column to Admin > Sales > Orders Grid

How can I add a column to the grid in the Admin section under Sales > Orders?
14
votes
3answers
15k views

Add new column to sales_flat_order_grid

How can I add a new column to the sales_flat_order_grid table and ensure that values are properly inserted there? The "source" for the new column is a custom column we've added to sales_flat_order, ...
2
votes
1answer
1k views

How can i get Tracking Number on Sales order grid

I need tracking number on sales order grid,
2
votes
1answer
5k views

Adding custom sales order attribute to order grid

I have created a custom sales order attribute using the installer of my custom mage module like this: $installer = new Mage_Sales_Model_Mysql4_Setup; try { $installer->addAttribute('order', '...
1
vote
3answers
4k views

add new column with custom attribute in sales > order grid in Magento ver. 1.9.3.3

Magento ver. 1.9.3.3 I am trying to add columns with **custom product attribute **(like publisher which was created by me) in Admin > sales >order. Copied app/code/core/Mage/Adminhtml/Block/...
18
votes
2answers
6k views

Magento 1.9.2.0: table “sales_flat_order_grid” contains extra space in customer's name value

In admin panel, when I want to search the orders based on customers name, I have to add 2 spaces between the first name and last name. When I looked at the value in Inspect element window, I noticed ...
2
votes
2answers
3k views

How to add custom column of custom table field or module to sales order admin grid in magento2?

I am trying to add my custom table field to order grid but its not working fine for sales order grid but its working fine product grid so below are the code adding column to sales order grid and ...
7
votes
2answers
2k views

Magento 2 + Custom column added sku on grid not showing data in export file

I have added sku column on sales order grid using following steps, Package\Company\view\adminhtml\ui_component\sales_order_grid.xml <?xml version="1.0" encoding="UTF-8"?> <listing xmlns:...
1
vote
1answer
1k views

Sales Order Grid is empty after data migration process

I've made data migration from Magento 1 to Magento 2 using data-migration-tool according to this article http://devdocs.magento.com/guides/v2.0/migration/migration-migrate-data.html Orders migrated ...
3
votes
2answers
767 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 ...
3
votes
1answer
689 views

Magento2 Add Quote ID in Sales Order Grid

I am trying to display quote id of an order in the sales order grid. New field is getting displayed in the grid. However the value of the quote id is not getting populated in the grid against each ...
6
votes
2answers
474 views

Hide completed orders from sales/orders

In sales/orders is it possible to hide completed orders ? using something like filters. or can I filter the status column with more than one status ?
1
vote
1answer
6k views

Adding new custom mass order status action

I am using Magento 1.9.1 . I am working on a new extension which is adding new custom mass status action here: Here is my code: /app/code/local/VivasIndustries/MassCustomStatusses/etc/config.xml : ...
1
vote
3answers
6k views

how to add customer's shipping address detail in Admin > Sales > Order grid

I trying to add customer's shipping address detail in Admin > Sales > Order grid with following code in protected function _prepareCollection() $collection->getSelect()->join(array('Shipping'=...
2
votes
2answers
72 views

magento 2 order grid loading issue after data migration

PHP Fatal error: Uncaught Error: Call to a member function getAdditionalInformation() on null in /var/www/magento/vendor/magento/module-sales/Model/OrderRepository.php:172 Verified found that file ...
1
vote
1answer
2k views

How to add a column Total row in a magento grid at the end

How to display total row at the end of sales order grid.see below image
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"?>...
7
votes
3answers
6k views

Add More Mass action in Order grid in magento2

I want to create delete order functionality in magento2, but i am not able to add mass action in order grid. please help me how to create delete order functionality in magento2. Please help me if any ...
9
votes
1answer
5k views

Magento 2 Filter not working while Custom column added on Sales Grid Using Ui Component

I have added Custom column track_number into sales>>Order grid at Backend. <vendor_name>/Sales/view/adminhtml/ui_component/sales_order_grid.xml <?xml version="1.0" encoding="UTF-8"?> ...
10
votes
3answers
4k views

Magento2.1 ui grid, remove or clear filter issue (after removing filter, result row apply to whole collection)

I created ui grid in magento 2.1.0 and facing issue while removing filters or clear all filters from ui grid. My filtered result occupies whole grid means same row repeated in the whole grid after ...
6
votes
3answers
21k views

add column to sales/orders grid

I'm trying to add a column to the sales/order grid in the backend. I've found some wonderfull tutorials, but I can't get it to work. This is the tutorial I'm following.. http://www.atwix.com/magento/...
3
votes
1answer
388 views

how to add order grid serializer in custom module

i want to create the Order Grid Serializer functionality. If Anyone create that type functionality then please guide me..
3
votes
2answers
1k views

Magento 2 how to pass order id's from sales order grid to my module controller

I am working on a custom module. I need order data in my own controller. I want users to use the checkboxes to select orders so i can use the order id's/data in my controller. How do I do this? What ...
2
votes
2answers
898 views

Magento 2, add color style in Status column in sale order

Using Magento 2.2, Admin Grid. I want to add style to Status column in sale order. How to do this?
2
votes
3answers
4k views

add complete address in default columns in order grid

I want to add complete address in default "Bill to Name" and "Ship to Name" columns in order grid in Magento admin. I am attaching screen-shot for more explanation. Please suggest me how can I ...
1
vote
2answers
59 views

Magento2.3.2 During data migration I got Only enties mismatch error . Only orders data in not migrated

My migration is from Magento 1.9.1.0 to Magento 2.3.2. I ran the below command : php -dmemory_limit=-1 bin/magento migrate:data vendor/magento/data-migration-tool/etc/opensource-to-opensource/1....
0
votes
5answers
3k views

Show SKU and Product Name in Sales_Order_Grid?

I have been stuck for hours trying to add both Product Name and SKU to the Sales Order Grid in Magento. I have created the joins and added the columns but the no data is being displayed and can't ...
0
votes
2answers
727 views

How to get custom customer attribute value in sales order grid?

I have made customer attribute 'sales_executive' which shows proper value in customer grid. Now i want to show the same value in sales order grid by adding column. How to add this column and get value ...
0
votes
3answers
3k views

How to add “SKU” and “Product Name” to sales order grid?

I am trying to add "sku" and "product name" to sales order grid with filtering. I have created my joins but the columns are empty and I'm not sure what I have done incorrectly here... Trying to get ...
4
votes
1answer
1k views

Admin Grid - Remove columns from export

I am in a situation, where I need to display an email_address1 in grid, and during export have to use other one (email_address2). For this I have added two columns in grid, with email_address1 is ...
4
votes
1answer
387 views

addColumn() or addAttribute() ? What is the best for performance, migration & usability?

What is the best method of adding new attributes to the sales and/or quote tables in magento via an install script: use: addColumn() or use addAttribute() ? So the main questions are : What is ...
4
votes
0answers
737 views

Add custom dynamic column in sales order grid Magento 2

This solution shows how to add custom column to sales order grid, but to add a custom column you need to add the column via xml,the problem is i need to read data collection to get available column ...
2
votes
2answers
647 views

Add custom product attribute to Order Grid

I have an custom product attribute shipper imported with all the products, which show that the product shipper. I want to show this attribute on the Order Grid with values to know that which order ...
1
vote
0answers
227 views

Include discount amount on subtotal in order export file Magento 2.2.2

I would like to export sales order from sales->Orders and the column subtotal(in csv and excel file) which should include the discount amount which we have apply while purchasing the product. for ...
1
vote
2answers
600 views

add button inside custom column in sales order grid page

I added new column in Sales Order Grid & successfully added title [say download] of column, now i want to add button [ say button name download1] for all rows of that column. I did't created any ...
1
vote
1answer
89 views

How to add custom column as link in sales order grid in magento 2

I wish to add a column as link in sales order grid. While clicking the link, I wish to perform some logic, I have reffered the below link for magento 1 which is based on layout grid add button inside ...
1
vote
0answers
184 views

In Sales Order Grid Some Fields Data are Repeated

I Have Create Module That Add Some Field In Sales Order Gid, but That Field Data Are Repeated, When More Order Are Placed. Product Type, Quantity Ordered, Product Id, Product Name, Sku are repeated ...
1
vote
1answer
2k views

Default to 100 orders in sales order admin page

Could someone help me with this, I need to change the default number orders being showed in the Admin panel/Sales/Order view page. Currently it starts from 20 per page. I want to maintain that but ...
1
vote
0answers
3k views

Magento 2 better way create custom grid

I found 2 website reference for creating custom grid. https://ranasohel.me/2014/04/20/creating-magento2-adminhtml-grid/ 2.http://www.mage-world.com/blog/grid-and-form-in-magento-2-admin-panel-part-1....
1
vote
1answer
119 views

How can I add new Class in Magento2 sales grid?

I was trying to add new class in Sales order grid in table rows based on some conditions in admin of Magento2 but I couldn't succeed. Can anyone help me out how to do such thing? please find ...
0
votes
1answer
602 views

Having problem to add new column in admin >sales > order grid ,product name is repeating

I am try to add columns in Admin > sales >order by overriding method. Copied app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php to app/code/local/Mage/Adminhtml/Block/Sales/Order/Grid....
0
votes
1answer
676 views

Restrict Order Grid to Specific Status for User

How would I restrict access to only show completed orders in the admin for one user or role? This employee only needs to see new pending orders, and I don't want this employee to be able to look back ...
0
votes
2answers
3k views

Add new field to administration orders grid

I am building my first Magento plugin that will hook into the event of when an order is placed, and export the order to a third party web service. Now, rather than creating a separate table to store ...
0
votes
1answer
305 views

Zip code to order grid backend

I currently use a extention to display the payment method and SKU inside the grid. I want to expand this with adding the zipcode. How should I expand my code? CODE: app/code/local/Atwix/...
0
votes
1answer
420 views

Magento 2 add css to order grid on basis of custom column

I want to add css class and highlight the order from grid on the basis of my custom column value(Yes/No). Anyone please suggest solution. Below is my custom column : $setup->getConnection() ...