Questions tagged [order-grid]

Questions specific to the admin panel order grid

Filter by
Sorted by
Tagged with
1
vote
1answer
61 views

Magento 2 : Load/Get Orders by Direct Queries

I have multiple Order Id in foreach loop, and I want to load or get orders by these order_ids. I have used this code if ($requestName == 'sales_order_grid_data_source') { if ($result instanceof $...
2
votes
1answer
1k views

grid column filter based on existing values

In Magento 2.1.8 I trying to add a custom column to the admin order grid, that contains the cc_type field. Long story short, I managed to make the column appear, display the correct data, and be ...
2
votes
1answer
714 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 ...
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[...
-1
votes
1answer
81 views

Hide completed order in magento 1.9 order panel [duplicate]

Please can anyone help me with step to step on how to create an observer on this page: Hide completed orders from sales/orders I have created observer.xml in app/etc/modules/ with the code below: &...
0
votes
1answer
1k views

Unable to get order details using magento 2 rest api

I have created an order in magento 2. And magento gave me this message "Your order number is: 000000235. We'll email you an order confirmation with details and tracking info." Screen shot is ...
0
votes
2answers
402 views

View action open blank detail page for an order in adminhtml

I get from a 3rd party orders that I save into sales_flat_order, sales_flat_order_grid, sales_flat_order_payment and sales_flat_order_address I can see the orders I create into those table in order ...
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:...
0
votes
1answer
508 views

Which data to fill to show order in grid order row

I get some data and save it to the sales_flat_order and sales_flat_order_address . My issue is that I can't see my order created on the Magento grid order. Which data I have to fill or add to see my ...
1
vote
1answer
54 views

How to add the item_ID value next to item_SKU value at Admin view order for items ordered block?

By default Magento 2.1.6 shows the item description and the item_SKU , but I also want to add/show the item_ID field to it's first column. Any idea how to add it?
4
votes
0answers
752 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 ...
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"?> ...
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 = ...
0
votes
2answers
1k views

How to add searchable column “shipping methods” into Sales/Orders admin grid?

To make my admin Sales/Orders grid better I added column to the grid: and as on the picture above it shows order delivery method but ... how to create "delivery method" dropdown list to make it ...
0
votes
1answer
29 views

Get current grid name

How do we get Current grid name in our grid.phtml I want to check whether we are on sales order grid or not. if(Sales_order_grid){ Do some Action }
1
vote
0answers
57 views

E-mail and country code in admin sales

In my Magento Sales admin grid i would like to have an email and country so I created a code to make it possible: protected function _prepareCollection() { $collection = Mage::...
2
votes
0answers
113 views

Sales order collection error

I want to add custom product attribute to sales order grid, and here is my code below, $collection = Mage::getResourceModel($this->_getCollectionClass()) $vendor1_total = Mage::getResourceModel('...
3
votes
2answers
394 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->...
1
vote
0answers
270 views

How do i use UI components in front-end in magento2

I want to show orders grid in my account section in Front-End. I have extended luma theme. I know it is possible to show admin grid in Front-End but, I don't have a breakthrough. Please assist me on ...
1
vote
1answer
219 views

add weight to order grid

I am trying to add a weight column to my magento order grid (I want the total weight of the order) I have this part _prepareColumns $this->addColumn('weight', array( 'header' => Mage::...
0
votes
1answer
44 views

Invalid Block issue in rewrite Sales Order Grid in Magento 1.8

I am getting error of Invalid block on Live site but same code is working in Local system. Can anyone help me in getting out from this ASAP. Below is my code: Config.xml <?xml version="1.0"?> ...
1
vote
0answers
201 views

Magento 1.x - Sales Order Grid join with custom attribute in customer_entity_varchar

I am trying to add a new column to the sales order grid populated with data from an attribute in the customer_entity_varchar table. I have created the module and the new column is showing correctly: ...
0
votes
1answer
724 views

Magento 2 Add new column tracking/mobile number to sales grid

Hello guys I need your help to know how to add new column "tracking/mobile number" to sales grid.
0
votes
1answer
440 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() ...
0
votes
0answers
1k views

Magento 2 : Update Custom Column Value in Sales Order Grid Table

I have added custom column in sales_order_grid table and values are showing in backend but how to update that column's value if customer has edited it from frontend order view? Anyone please help! ...
1
vote
0answers
57 views

Category Filter in add product option when creating order from backend

When i am creating an order from backend and clicking on add a product option its showing me all products and showing fields of id, product name, sku, price, select, qty to add ... what i want to do ...
2
votes
1answer
1k views

How can i get Tracking Number on Sales order grid

I need tracking number on sales order grid,
1
vote
1answer
235 views

show all order count of a customer in order grid

I want to show all the record of the customer who have multiple order in one row as per customer entered email in my order grid, any who have tried this earlier please suggest me the way.
2
votes
2answers
2k views

1.9 - Add custom column to Sales Order Create Grid

I've copied app/code/core/Mage/Adminhtml/Block/Sales/Order/Create/Search/Grid.php To app/code/local/Mage/Adminhtml/Block/Sales/Order/Create/Search/Grid.php And added ->addAttributeToSelect('...
1
vote
1answer
98 views

customer mail is not showing in custom sales grid

Here is my collection below.I tried to rewrite the sales order grid with adding another column as email .The column came but the result for the column email is not displaying in my custom grid. On ...
0
votes
1answer
995 views

How to get the order html table and shipping address on success page?

I'm working on a customized success page and I would like to get that same table from cart to display on success page, I mean, it should contain product thumb, product name with configurable options (...
0
votes
1answer
1k views

How to create a custom button in Order grid in Magento 1

I want to create a custom button in magento 1 backend in **order tab.** I want this button to be General(for all orders), but i can't find anything related to my issue. All i find it's this article ...
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 ...
2
votes
1answer
568 views

How to add product image in sales order grid?

How to add product image in sales order grid. Using Observer. I have to create custom module, in this module i have to add product image that selected in place order. i have to use observer for ...
1
vote
0answers
189 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 ...
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.
0
votes
2answers
775 views

Magento 1.9.3.2 add purchase order number to order grid

I am using Magento 1.9.3.2 and I have got payment method to show along wits order sku's following: https://www.atwix.com/magento/adding-sku-column-to-orders-grid/ But, I would also find it rather ...
1
vote
0answers
21 views

Display a custom text at the top of order grid

I have saved AWB no.s in my database and it is alloted according to a particular algorithm. I have specified a range of AWB no.s. From my order grid, I select the orders and allot AWB no.s to them. I ...
1
vote
0answers
180 views

add conditional filter to sales_order_grid collection (magento2)

I want to add a custom filter to the order collection, checking if some conditions are met. A helper method should return false/true, and then apply the custom filter if it returns true. The custom ...
1
vote
2answers
303 views

Display coupon code in order grid

I want to display the coupon code used, if any, in the orders grid. The field should be filterable and sortable. How can I achieve this ?
1
vote
1answer
41 views

Magento ver. 1.9.2.1 new order missing

Recently I transfer my hosting to Godaddy. They did a site migration for me. However, after the migration, there is a weird situation that when a new order comes in, I can see it when I first logged ...
0
votes
1answer
369 views

Ajax.Responders.register's onComplete Executes Before Ajax Complete

I'm trying to add background colors on the admin orders grid based on the order status in a Magento 1.9 install. I have colors coming fine on page load, but when the grid is reloaded with ajax if any ...
0
votes
1answer
299 views

Error sales order grid using column search

I created a custom module to extend the sales order grid with a SKU column. It works well, until you search in that specific column. Then I do receive a error message. How can I solve this? Then I ...
0
votes
1answer
101 views

How Can i directly redirect products landing page from sales order page

I need to directly redirect products landing page from order page,
2
votes
0answers
404 views

Unable to refresh the page after generating PDF file in order grid

We have kept one button in mass action in orders grid, upon clicking it should generate a PDF file, which is working fine, but after generating PDF the should refresh automatically. That's we are ...
1
vote
1answer
678 views

How to redefine massaction actions in grid ui-component sales_order_grid

In my custom extension i have tried modify section massaction name="listing_massaction". Just copy content from ui_component/sales_order_grid only keep actions neccessary but after clear cache, ...
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
0answers
275 views

Admin order grid: Column 'store_name' in where clause is ambiguous when filtering by store

I am getting this error when trying to filter the sales grid by store. I can fix this error by altering app\code\core\Mage\Adminhtml\Block\Sales\Order\Grid.phpand replacing if (!Mage::app()->...
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 ...
2
votes
2answers
255 views

While Exporting CSV from Sales > Order Grid, I am getting error - “You cannot define a correlation name 'order' more than once”

When I try to export csv in Sales > Order Grid, I am getting You cannot define a correlation name 'order' more than once Trace: #0 /www/Myproject/htdocs/lib/Varien/Db/Select.php(281)...