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?


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.

enter image description here

  • Does this extension support a filter by website? – clementgamache Dec 1 '17 at 21:11
  • Not that I see on my admin area. The "store_id" value is used for my "Purchased From (Store)" column in position 2. The three levels from top to bottom are website , store, store view – Steven J Dec 1 '17 at 21:48
  • Since I can't select the website that doesn't interest me – clementgamache Dec 13 '17 at 17:58
  • In Magento a website is actually the top level container for a group of stores and their store views. If you have multiple stores and domains on your Magento setup, you can use the drop down in "purchased from (store)" to select a specific store view which would relate directly to a domain for that store. – Steven J Dec 13 '17 at 18:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.