Magento - Adding New Column to Sales Order Grid Not Working

Magento - Adding New Column to Sales Order Grid Not Working

September 20, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento - Adding New Column to Sales Order Grid Not Working

Debugging Magento Grid Column Additions

Adding new columns to the sales order grid in Magento can be a complex task, especially when dealing with version 1.7. There are several steps involved that require careful attention to avoid typical pitfalls.

Step 1: Overriding Core Files Correctly

The first issue you mentioned is the incorrect overriding of core files. When you’re working with Magento versions prior to the introduction of layout XML files, you need to follow specific naming conventions for your override files.

For example, if you want to override app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php, the correct path for the local file should be:

/public_html/wholesale/app/code/local/Mage/Adminhtml/Block/Sales/Order/Grid.php

Note that the “local” folder is created under the appropriate module namespace (Mage/Adminhtml) and not in a separate app/code/local directory. This structure helps Magento’s autoloading mechanism find your override files correctly.

Step 2: Enabling Custom Logging

To verify if your local files are being loaded, you can enable custom logging within your override file. Add the following line at the beginning of your Grid.php file:

// Enable custom logging
Mage::log('Local Grid File Loaded', null, 'grid.log');

This logs a message to the grid.log file in your Magento installation’s var/log/ directory when the local file is loaded.

Step 3: Preparing the Collection

You’ve correctly identified that you need to extend the _prepareCollection() method to add an additional field from another table. However, there are some issues with the provided code:

  • The collection class is not being called properly.
  • The join condition should use sales_flat_order.entity_id instead of sales_flat_order.parent_id.

Here’s the corrected version:

protected function _prepareCollection()
{
    $collection = Mage::getResourceModel('sales/order_collection');

    // Add a join to include the company field from sales_flat_order_address
    $collection->getSelect()->joinLeft(
        array('address' => 'sales_flat_order_address'),
        'main_table.entity_id = address.parent_id',
        array('company')
    );

    $this->setCollection($collection);
    return parent::_prepareCollection();
}

Step 4: Preparing the Columns

In your _prepareColumns() method, you’ve correctly added a new column called “Company”. However, the index attribute should point to the correct column from the joined table:

$this->addColumn('company', array(
    'header' => Mage::helper('sales')->__('Company'),
    'index'  => 'address.company',
));

Wrapping Up

Debugging grid column additions in Magento often requires a combination of proper file overriding, logging, and careful manipulation of the collection and columns. Always ensure you’re following the correct naming conventions for override files and use Magento’s built-in resources where possible.

Remember to clear your cache after making changes to see the updates in action. You can do this by running the command php shell/indexer.php rebuild from the Magento root directory.

If you find yourself needing more advanced customizations or help with other Magento development tasks, feel free to check out our services at Laravel Company.

Happy coding!

Magento 1 Extensions Themes Admin

Our network