Add Columns to Order Grid - effectively manage customer's orders

Add Columns to Order Grid was developed by Cmsideas

DESCRIPTIONS

Managing customers’ orders is often the time consuming but important task of all sellers, especially the online store owners when a plenty of order information is recorded. How to avoid overwhelming by the continuing flow of information? The answer might be Magento store owners’ applying Add Columns to Order Grid in Backend. This extension will simplify their order management process by letting them customize their order grid in backend with ease.

With this extension, store owners can choose additional columns from seven custom order columns namely Product thumbnails, Customer email, Coupon code, Payment method, Shipping method, Shipping address, and Billing address to add into their order grids. Just take some quick steps, then all necessary order information will be displayed on the extended order grid to facilitate the order management. It is time Magento store owners forgot about their tedious order operations and have the quick and efficient order processing by using Add Columns to Oder Grid in Backend.

ADMINS’ BENEFITS
- Have a visually view of all customers’ orders in backend
This extension allows showing product thumbnails on the order grid that makes it easy for admins to manage their customers’ orders.

Attachment 725

- Save a great deal of time spending on managing customers’ orders
By adding more useful oder information columns to the order grid, admins can keep track with customers orders easily. That is why they can process these orders quickly.

Attachment 726

- Manage customers’ orders efficiently
Having an overview of all customers’ orders statuses, admins are able to take promt actions towards cancelled orders or pending orders, etc.

Attachment 727

FEATURES
- Admins can extend the order grid in backend by adding useful order information columns from seven additional custom columns supported by this extension:
+ Product thumbnails
+ Customer email
+ Coupon code
+ Payment method
+ Shipping method
+ Shipping address
+ Billing address
- Admins are able to choose which kinds of order statuses are shown on the order grid.
- Admins can also add columns to the order grid by attributes from a wide range of attributes in backend


DEMO

Backend:http://magento-add-columns-order-gri...dex.php/admin/

Document:http://cmsideas.net/documentation/ma...end/index.html


SUPPORT: http://support.cmsideas.net/
We provide the Ticket system, when you submit a ticket about your problems to us; our support team will give answers your questions as quick as possible. It is also fast and easy to check whether your problem has been solved and how it is fixed by checking your ticket status.

For more detailed information and other themes, please visit http://cmsideas.net/magento-add-colu...ders-grid.html

Great module! We have one similar


Custom Order Grid - Make orders grid page more efficient and handy by adding necessary custom columns and removing those that are useless.

1) Make orders grid page more handy based on your needs

With this extension you can easily add necessary columns to orders grid. It provides 40+ custom columns that include information about the order, ordered products, customer, order totals, billing and shipping addresses. If you won't find the column you need then our support team can quickly add it for free.

2) Easily add or remove the grid columns you need to

Some of the columns that standard Magento shows in orders grid may be useless for some customers. For example, most of stores use only one currency and they don't need to show both "Grand Total (Base)" and "Grand Total (Purchased)" columns. In this case, the extension will help you hide the columns you'd like to.

3) Change sort order of the enabled grid columns

The newly added columns will be put to the end of the grid by default. But you can easily manage the order of the columns and put them into the place you want.

(y) Really nice! Thanks for sharing!

Hi!
You can also try this extension - Extended Order Grid
Its features include:

Show all necessary product data on the order grid
Search and sort orders by product data - name, SKU, etc
Display product thumbnails on the order grid
Coupon codes, shipping and payment methods on the grid
See all product info without going to the order view page

There is also an extension for Magento 2 - https://amasty.com/extended-order-gr...magento-2.html

Hi,
Does your Magento order grid have all of the fields you need? Adding or removing columns is fairly simple. Let’s explore how. Here we will discuss both: – Adding a custom attribute/column to the order grid. – Removing a column that you don’t need. The grid is under Sales -> Orders.
Attachment 4180

We are going to first copy the core file to a local directory, then code a bit. Copy /app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php to /app/code/local/Mage/Adminhtml/Block/Sales/Order/Grid.php. First, to make custom attribute available for inserting to grid we need to modify _prepareCollection function. Here, we are working with database table fields and using SQL joins. Let`s suppose that we need to add a postcode column. Search for _prepareCollection function and simply add this line:


$collection->getSelect()->join('sales_flat_order_address', 'main_table.entity_id = sales_flat_order_address.parent_id',array('postcod e'));
before


return parent::_prepareCollection();
so function will look like:

protected function _prepareCollection()
{
$collection = Mage::getResourceModel($this->_getCollectionClass());
$collection->getSelect()->join('sales_flat_order_address', 'main_table.entity_id = sales_flat_order_address.parent_id',array('postcod e'));
$this->setCollection($collection);
return parent::_prepareCollection();
}
As you can see, we have joined the sales_flat_order_address table that stores the postcode field. To insert this column into the order grid, edit _prepareColumns() function. Here you can see how default columns are inserted, so using the addColumn method, we add our own postcode column.

$this->addColumn('postcode', array(
'header' => Mage::helper('sales')->__('Postcode'),
'index' => 'postcode',
));
That’s it.

Attachment 4181

Similarly, for removing a field, you just need to delete the corresponding portion of code. A few more advanced examples are provided below. Making a new custom Address column that consists of country, city and street:


$collection->getSelect()->join('sales_flat_order_address', 'main_table.entity_id = sales_flat_order_address.parent_id',array('telepho ne','postcode','address'=>new Zend_Db_Expr('concat(sales_flat_order_address.coun try_id, ", ",sales_flat_order_address.city, ", ",sales_flat_order_address.street)')) );
Product SKUs of an order:


$collection->getSelect()->join('sales_flat_order_item', '`sales_flat_order_item`.order_id=`main_table`.ent ity_id', array('skus' => new Zend_Db_Expr('group_concat(`sales_flat_order_item` .sku SEPARATOR ", ")')));
The last, is an example of adding custom product attributes. It stores at catalog_product_entity_varchar table and we need to know its attribute_id:


$collection->getSelect()->join('sales_flat_order_item', '`sales_flat_order_item`.order_id=`main_table`.ent ity_id AND `sales_flat_order_item`.parent_item_id IS NULL ', null);
$collection->getSelect()->join('catalog_product_entity_varchar', '`catalog_product_entity_varchar`.attribute_id=144 AND `catalog_product_entity_varchar`.entity_id = `sales_flat_order_item`.`product_id`', array('models' => new Zend_Db_Expr('group_concat(`catalog_product_entity _varchar`.value SEPARATOR ",")')));