Magento Expert Forum - Improve your Magento experience

Results 1 to 5 of 5

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

  1. #1
    Junior Member Cms_ideas's Avatar
    Join Date
    Jun 2014
    Location
    https://cmsideas.net
    Posts
    385
    Thanks
    1
    Thanked 7 Times in 7 Posts

    Default 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.

    Name:  order grid_1.jpg
Views: 483
Size:  45.3 KB

    - 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.

    Name:  order grid_2.jpg
Views: 591
Size:  31.8 KB

    - 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.

    Name:  order grid_3.jpg
Views: 402
Size:  72.2 KB

    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

    View more threads in the same category:


  2. #2
    Junior Member MagestyApps's Avatar
    Join Date
    May 2015
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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.

  3. #3
    Junior Member Alexsmith's Avatar
    Join Date
    Apr 2016
    Posts
    341
    Thanks
    2
    Thanked 7 Times in 7 Posts

    Default

    (y) Really nice! Thanks for sharing!

  4. #4
    Junior Member Amasty's Avatar
    Join Date
    May 2013
    Posts
    396
    Thanks
    1
    Thanked 4 Times in 3 Posts

    Default

    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

  5. #5
    Expert
    Join Date
    Mar 2016
    Location
    india
    Posts
    570
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    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.
    Name:  1.png
Views: 266
Size:  134.4 KB

    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.

    Name:  2.jpg
Views: 339
Size:  51.3 KB

    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 ",")')));

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •