Questions tagged [order-grid]

Questions specific to the admin panel order grid

Filter by
Sorted by
Tagged with
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 ...
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', '...
0
votes
1answer
999 views

Integrity constraint violation: 1052 Column 'base_grand_total' in where clause is ambiguous

I've been able to add a few custom attributes to the sales order grid (sku, custom name). I am able to filter correctly. When I add the customer email, I can add and filter it too, but then if I ...
0
votes
1answer
317 views

Blank Country Column - Magento Order Grid

I added a Country column to the order grid but it appears blank! Can anyone see why this might be? My Grid.php (rewrite) is below! <?php /** * Magento * * NOTICE OF LICENSE * * This source ...
0
votes
3answers
1k views

Sales Grid - Adding country appears blank

I am trying to add Shipping Country to the sales order grid. I have tried a lot of code snippets I found on stack but none of them seem to work! These were for older Magento and I am running 1.9.2.2 ...
0
votes
1answer
108 views

Selecting Data form a table when attribute Id is 1105?

I am trying to display a customer reference on the sales order grid which i have created as a custom attribute on the sales order grid. I added this to _prepareColumns() to create the column $...
0
votes
1answer
816 views

Error on loading Sales in Backend

I become en Shop-Error on Magento 1.9 when I will call the Sales in Backend. Where can I found the problem? Here are the Logfile a:5:{i:0;s:50:"Die angeforderte Zahlungsart ist nicht verfügbar.";i:...
1
vote
1answer
131 views

Creating an extra field in sales order grid [duplicate]

I need to insert the company name into the order grid. I added this to app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php in the function _prepareColumns() $this->addColumn('...
3
votes
1answer
394 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 ...
0
votes
1answer
437 views

How to have different Order ID's or Order Prefix/Suffix for Frontend and Backend Order

We have a unique requirement from one of our client. What is needed is a separate Order Id for Frontend orders and different for backend orders. The basic necessity is to differentiate between the ...
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 ...
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 ...
1
vote
1answer
751 views

Integrity constraint violation: 1052 Column 'increment_id' in where clause is ambiguous after SUPEE 6788

I am not trying to do anything fancy, or change anything, but this is the issue. I just updated site with SUPEE 6788, and now when I try and filter the orders by the order id, I get Magento error. ...
0
votes
1answer
572 views

Mass action in Sales order grid

How to add the new mass action in magento sales order grid to update my custom status.
0
votes
1answer
599 views

how to notify customer when admin puts into hold status from grid?

In admin side sales order grid screen we can select orders & we can put into hold status.but in this case there is no possibility for notifying customers. When we are open that order there is a ...
0
votes
1answer
216 views

Fatal error when I enable filter => true in addColumn

I've been able to filter based on custom addColumn to sales_order_create_search grid. Custom Added Column $this->addColumn('seller_id', array( 'header' => Mage::helper('marketplace')-&...
0
votes
1answer
731 views

Custom filter in the sales order admin grid giving Invalid block t

I've been able to filter custom added column like 'seller name ' its get from seller id of product. other filters are working. $this->addColumn('seller_id', array( 'header' => Mage::...
1
vote
1answer
2k views

How to do multiple join query in magento

I have to add Extra field like buyer name in Admin sales order create section Mage_Adminhtml_Block_Sales_Order_Create_Search_Grid In collection Add code like $collection->getSelect()->join(...
0
votes
1answer
936 views

Is that possible to add Textarea in Order Grid view

How to insert a personal note or text area on order grid page for each order, This should save when entered the text. is that possible using Renderer. If there is any module for this please suggest, ...
1
vote
1answer
323 views

Add subscriber status to flat order grid

I'm trying to add subscriber status to sales_flat_order_grid. I already got postcode working, but now I'm kind of stuck. This is what I've tried so far: startSetup(); // Add column to grid table $...
1
vote
1answer
855 views

Sales Order Grid - Can't export custom columns

I've added the a few columns to the sales_flat_order_gridtable. The values are obtained in these two events sales_order_resource_init_virtual_grid_columns (using addVirtualGridColumn() ) and ...
1
vote
1answer
332 views

Order grid fails to load in admin panel

Magento CE 1.8.0.0 on server running Apache & PHP5.4. Woke up this morning to discover our store's order grid had disappeared from our admin panel this morning without logging errors. I ...
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 ...
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 ...
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 ...
2
votes
1answer
95 views

Order Export issues on Chrome

Magento 1.6.2.0. When exporting Orders from the grid view in magento, as CSV, the name of the file downloaded is appended with -, attachment. This seems at the minute to be only happening in Chrome. ...
2
votes
1answer
788 views

Custom filter in the sales order admin grid giving php strict notice error

I've been able to add columns to the sales order grid table in admin, but when I try to use the column to search I get an error Strict Notice: call_user_func() expects parameter 1 to be a valid ...
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()) ? $...
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 ...
1
vote
1answer
1k views

Join to get thumbnail from sales order item - add column to order grid [duplicate]

I'm trying to use an observer to add the thumbnail path to the sales order grid collection - the purpose of this is to add an extra column to the order grid which displays the sales item images. I've ...
0
votes
1answer
2k views

Apply custom discount in grand total in create order magento admin

i want to apply custom discount on grand total (without coupons) in create order section in magento admin. i have added 2 lines code for check in this file app\code\core\Mage\Adminhtml\Block\Sales\...
0
votes
3answers
732 views

Billing name order in billing_name column in sales_flat_order_grid table

Can someone please tell me when a record is pushed into the "sales_flat_order_grid" table? How can I switch first name and last name in "billing_name" column of this table?
1
vote
1answer
779 views

Magento - Last order date to customer grid

I currently use XTENTO Enhanced Order Grid to add fields to the customer grid which works perfectly. I need to however put in a column for the customers last order date. I have searched however the ...
1
vote
1answer
232 views

Orders grid, display [ deleted ] in Purchased from (store)

I removed some stores and now when I see the dropdown "Purchased from (store)" in Sales -> Orders ->Grid I found the deleted option. I remove every relationship between the stores deleted and ...
2
votes
1answer
903 views

after ajax load grid massaction additional form not working

i am adding the mass action from observer that are work perfectly but after the ajax load grid it is not working. cannot show the additional form. copying this code from ...
1
vote
2answers
5k views

Add custom block to admin sale order grid

i am trying to add the custom block after the sale order grid.i tried below xml code but could not succeeded. <adminhtml_sales_order_grid> <reference name="sales_order.grid"> ...
0
votes
1answer
125 views

Print order attachment in magento order mass action

I have an extension of order attachment installed in my magento 1.7. What I need to do is to have an option in mass action of order grid to print order attachment. How can I do that?
1
vote
1answer
967 views

Display custom billing address checkout fields in admin sales order grid

In my custom module, I have modified the checkout process a bit and added some custom fields in billing address section following the below tutorial: http://excellencemagentoblog.com/blog/2011/10/06/...
1
vote
1answer
614 views

Show notice in admin order grid based on filter

Background I am migrating a site to the Magento platform. I have a requirement to notify the admin if they're searching for an order that comes from the old platform. I have table of old orders. I'...
0
votes
1answer
89 views

Custom Grid for One Vendor

I'm still working my way around Magento so I apologize ahead of time for my lack of knowledge. I have a custom report with the collection coming from the a model. I need my report to show only one ...
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 ...
2
votes
1answer
1k views

Magento sales order grid - add shipping and tax

So I wanted to change the columns in the sales - order - grid I created my own version of the Grid.php (located at app\code\local\Mage\Adminhtml\Block\Sales\Order\Grid.php) in _prepareCollection() I ...
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
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 ...
0
votes
1answer
862 views

Adding Customer Email to adminhtml order grid breaks the ability to search

There are a couple of questions relating to adding a custom email field to the order grid. For example, this and this. However, both these create a problem when you try and filter. What happens is ...
2
votes
1answer
877 views

Prevent Magento from auto-completing orders

We have a scenario where we fulfill orders via an API. Previously the logic has been tied to the invoicing process, so that when an invoice is created, the fulfillment logic is executed. If there were ...
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 ...
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 ...
2
votes
0answers
99 views

Add Comment to Sales Report

I have a custom report based on the tutorial at http://wrightcreativelabs.com/create-a-custom-magento-report-product-skus-in-new-orders/. The report is working well as is. Now I'm trying to add a ...