Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [order-grid]

Questions specific to the admin panel order grid

Filter by
Sorted by
Tagged with
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?
19
votes
5answers
29k 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 ...
19
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 ...
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 -> ...
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, ...
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 ...
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"?> ...
9
votes
1answer
3k views

Recent orders are not appearing in the backend but exist in the database and are displayed in the dashboard

I'm using Magento 1.9.1.0. There are three recent orders that do not appear in the Sales > Orders panel. Here is a screenshot of the most recent orders, please see the order numbers: However, the 3 ...
8
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:...
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 ...
7
votes
2answers
848 views

Magento: Filter huge sales order collection

I am trying to filter a huge collection of sales order. There are more then 5 million records in it. Below is my code to get the order collection and also i puts some joins to get the desired columns ...
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"?>...
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/...
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 ?
5
votes
5answers
5k views

Column 'store_id' in where clause is ambiguous when adding custom order attribute to grid and changing store

I have created a custom order attribute and I am now able to show it in the sales order grid; my previous question: Adding custom sales order attribute to order grid If I were to change the drop down ...
5
votes
1answer
2k views

Export a field from custom model grid with a diferent render to Csv

I created a custom column on sales order grid. It works as well but a used a custom render on a field (like this). When I export the grid to CSV, the file contains the raw value, but I need apply ...
5
votes
1answer
133 views

Magento 2 - Call custom phtml before order grid

I want to show statistics graph in custom phtml. My question is, how can I call my custom.phtml before order grid
5
votes
4answers
1k views

(Zend_Db_Statement_Exception): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'created_at' in where clause is ambiguous

I added sku, country_code and product name in the order grid. All works fine but when I filter Orders by Created at it throws following error Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[...
4
votes
3answers
2k views

How to remove Export option from Sales/Order grid?

I want to remove the following from sale order grid: New Order RSS Export to: MassAction block for a particular admin user role. I currently use adminhtml_block_html_before event to remove the ...
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
2answers
2k views

magento Add Coupon code at sales order grid

I want to add coupon code in sales order grid . As we know Sales order gird build from sales_flat_order_grid table Coupon_code column is exist in sales_flat_order table not sales_flat_order_grid ...
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
1answer
704 views

show extra column items grid order

I have added a extra column in sales_flat_quote_item table. Populating the column during checkout works fine. But showing the values of the extra column on the order details page in admin does not ...
4
votes
0answers
741 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 ...
4
votes
1answer
2k views

Create order programmatically for the items on cart on checkout page

I am successfully creating the order in the Magento dashboard with the below code. //for order $id=3; // get Customer Id $customer = Mage::getModel('customer/customer')->load($id); $transaction = ...
4
votes
2answers
1k views

How to create custom grid like sales order in magento2?

How to create custom grid like sales order gird with new,edit,save,delete,status,massdelete..etc in magento2.?
3
votes
3answers
1k views

Deleted orders are not removed from grid

When I delete an order, it is still listed in orders grid. When I attempt to open it, I get the message This order no longer exists. This behaviour was seemingly introduced by a Magento update: I ...
3
votes
2answers
3k views

Magento 2: display yes/no in order grid instead 0/1 (Custom column value)

I needed a custom column to be displayed in order Grid (Yes/No) Type. So I followed below steps: I created a new column in table "sales_order_grid" $installer->getConnection()->addColumn( ...
3
votes
3answers
3k views

Get product image on success page

On the success page after the order is displayed, I want to display a summary. For this I use this code. I want to display the product image also. How can I achieve that? And how do I display the ...
3
votes
2answers
2k views

Convert SQL Select to Magento getCollection statement

I have a complex sql select query that I want to load as collection so as to display the data in a custom grid but I'm not able to convert the query into Magento's equivalent getCollection statement. ...
3
votes
2answers
5k views

Add custom css class to backend grid cell under certain conditions

I am looking for a way to add a custom css class to a backend grid cell when it has a specific value. I know I have the option to use a renderer and I also could use the frameback_call options in ...
3
votes
1answer
694 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 ...
3
votes
2answers
392 views

How to detect the Grid is filtered

I want to get increment id whenever filter is applied to the sales order grid.And When filter is cleared i need to revert the changes. This is what i have done so far: $collection = $this->...
3
votes
1answer
1k views

Magento 2 , How to add “Company Name” column to “Customer Grid”

When we going to create a new order manually from backend, I need to add a "Company Name" column w.r.t. customer. Also need to add filter for the same. Please help.
3
votes
1answer
5k views

How to add/join sales_flat_order.customer_firstname column to transaction grid?

I have the collection for transaction and I added a line to get customer_firstname: protected function _prepareCollection() { $collection = ($this->getCollection()) ? $...
3
votes
2answers
794 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
2k views

Magento 2 sales order grid custom column export csv issue

I have added a tracking number(custom field) column in sales order grid. It is displaying in sales order grid and export by XML also working fine. But while I export the data by csv only the following ...
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 ...
3
votes
2answers
2k views

How to add telephone number to the Sales Order Grid using an observer

In the Order Grid, I want to add the telephone number which customers used in order -> shipping or billing. I can add the title in the grid but I don't know how get the phone number. The event that ...
3
votes
4answers
2k views

Magento 2: how can I remove columns in exported csv from order grid?

I want remove columns while exporting order grid data in magento 2. I google it but didn't find solution. Like I want to remove these fields from exported csv. Payment Method Total Refunded Customer ...
3
votes
1answer
391 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
0answers
17 views

Magento2.1 payment method and shipping method on my orders of buyer panel

I want to show shipping method and payment method of my orders in my orders on customer panel. i'm using magento 2.1
3
votes
0answers
368 views

Join sales/order and ordered items in grid column render Magento 2

I created a custom column in sales/order grid named Product name, They are coming fine on first time, When I am doing sorting Found : Column not found: 1054 Unknown column 'product_name' in 'order ...
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 ...
2
votes
1answer
5k views

Magento 2: Add custom column to filter option in order grid?

I have created custom column in sales_order table in Magento 2. At the time placing order values is saved in that column. Now I want to this column to be available for filter option.
2
votes
3answers
4k views

How to format weight to display 2 decimal places in Orders Grid?

Currently my Orders Grid is set up to add a Weight column with the total order weight, but it is displaying with 4 decimal places and I would like to only display 2 decimal places. _prepareCollection ...
2
votes
2answers
929 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
2answers
1k views

Custom Admin Grid Without Database

I created a grid in the Magento admin, but the functionality like sort, filter and search doesn't work and that is because I didn't use a database table to get the information. I use a web service ...
2
votes
2answers
3k views

Override Mage_Adminhtml_Block_Sales_Order_Grid

I'm trying to override the Mage_Adminhtml_Block_Sales_Order_Grid class, but no success with that. My config.xml file: <?xml version="1.0"?> <config> <modules> <...
2
votes
1answer
695 views

magento 1.9 custom order grid condition

Am using Magento 1.9.3. Here am creating a custom order gird in admin->sales->order table, those columns following Coupon Code Sliver Exchange Declaration In Coupon Code is used to showing ...