How to replace searchable column “store_id” to “website_id” into Sales/Orders admin grid?

Question

I want to filter the orders by website (rather than store ID)

I have tried to remove:

    $this->addColumn('store_id', array(
            'header'    => Mage::helper('sales')->__('Purchased From (Store)'),
            'index'     => 'store_id',
            'type'      => 'store',
            'store_view'=> true,
            'display_deleted' => true,
            'filter_index' => 'main_table.store_id',
            ));

And to replace it by:

    $this->addColumn('website_id', array(
            'header'    => Mage::helper('sales')->__('Website'),
            'align'     => 'center',
            'width'     => '80px',
            'type'      => 'options',
            'options'   => Mage::getSingleton('adminhtml/system_store')->getWebsiteOptionHash(true),
            'index'     => 'website_id',
        ));

(Which I copied from app/code/core/Mage/Adminhtml/Block/Customer/Grid.php)

The website combo box shows the right websites, but the row value is blank.

Am I doing something wrong?

Answer 1

Have you looked into BL Custom Grid? It allows a lot of customization of the columns in sales, catalog, and some other grid pages.

Here's a screenshot of my sales > orders page. Column Titles and widths are customizable.