Adding column to customer grid in Magento - Data not populating

Adding column to customer grid in Magento - Data not populating

August 13, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Adding column to customer grid in Magento - Data not populating

Adding a Custom Column to the Magento Customer Grid

Are you trying to display a custom attribute like customer_id on the admin customer grid in Magento? If so, you might be facing issues where the data isn’t populating correctly. In this guide, we’ll walk through the steps required to add a new column with a custom attribute and ensure that the data shows up properly.

Understanding the Problem

The original code provided is almost correct, but there are a couple of key points being missed:

  1. The _prepareCollection() function is skipping the addition of customer_id to the collection.
  2. The _prepareColumns() function is not ensuring the new column appears before existing columns like entity_id.

Let’s dive into the solution step by step.

Fixing the Code

Step 1: Modify the Collection Setup

We need to ensure that our custom attribute, customer_id, is added to the collection. This can be done in the setCollection() function:

public function setCollection($collection)
{
    $collection->addAttributeToSelect('customer_id');
    parent::setCollection($collection);
}

Step 2: Reordering the Columns

To ensure that our new column appears before other columns, we need to use addColumnsOrder(). This should be done after adding the new column and before calling parent::_prepareColumns():

$this->addColumn('customer_id', array(
    'header' => Mage::helper('customer')->__('Dynamics ID'),
    'width'  => '75px',
    'index'  => 'customer_id',
));

$this->addColumnsOrder('customer_id','entity_id');

// Rest of the function...

Step 3: Removing Unnecessary Columns

If you find that certain columns are no longer needed, you can remove them using removeColumn(). In this case, let’s remove the billing_country_id column:

$this->addColumnsOrder('customer_id','entity_id');

parent::_prepareColumns();

$this->removeColumn('billing_country_id');

// Rest of the function...

The Complete Solution

Combining all these changes gives us the final corrected code:

class WACI_AdminHtmlExt_Block_Customer_Grid extends Mage_Adminhtml_Block_Customer_Grid
{

    public function setCollection($collection)
    {
        $collection->addAttributeToSelect('customer_id');
        parent::setCollection($collection);
    }

    protected function _prepareColumns()
    {

        $this->addColumn('customer_id', array(
            'header' => Mage::helper('customer')->__('Dynamics ID'),
            'width'  => '75px',
            'index'  => 'customer_id',
        ));

        $this->addColumnsOrder('customer_id','entity_id');

        parent::_prepareColumns();

        $this->removeColumn('billing_country_id');

        return $this;
    }
}

Conclusion

Adding a new column to the Magento customer grid involves modifying the collection setup and reordering the columns. By following these steps, you can ensure that your custom attribute data populates correctly in the admin panel.

Remember, working with Magento’s grid and collection systems requires careful attention to detail. Always double-check your code for any potential oversights.

For more advanced customizations and a deep dive into Magento development best practices, I recommend checking out the resources available at Laravel Company. They provide comprehensive guides on everything from theme development to core functionality extensions.

Happy coding!

Admin Orders Customers Errors

Our network