Magento - How to add country column in Orders grid filter?

Magento - How to add country column in Orders grid filter?

August 6, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento - How to add country column in Orders grid filter?

Magento: Add Country Column to Orders Grid Filter

Hello everyone! Today, we’re going to tackle an important task in Magento - adding a country column to the orders grid filter. This is a common requirement for e-commerce stores that need to analyze their sales data by geographical region.

Understanding the Problem

Our user tried to add the billing country column using the following code:

$collection = Mage::getResourceModel($this->getCollectionClass());
$collection->joinAttribute('billing_country_id', 'customer_address/country_id', 'default_billing', null, 'left');
$this->setCollection($collection);
return Mage_Adminhtml_Block_Widget_Grid::_prepareCollection();

However, they encountered an issue where the results were blank. Let’s dive into why this might happen and how to fix it.

The Issue: Missing Joined Table

The problem arises because the join statement is incorrectly pointing to a non-existent table (customer_address). In Magento, customer addresses are stored in the sales_flat_address table, not customer_address.

To resolve this, we need to update the join attribute and point it correctly.

The Solution: Correct Join Attribute

Here’s how you can add the country column to your orders grid:

$collection = Mage::getResourceModel($this->getCollectionClass());
$collection->joinAttribute('billing_country_id', 'sales_flat_address/country_id', 'default_billing', null, 'left');
$this->setCollection($collection);
return Mage_Adminhtml_Block_Widget_Grid::_prepareCollection();

In this updated code:

  • We’ve replaced customer_address with the correct table name: sales_flat_address.
  • The attribute country_id is correctly joined from sales_flat_address.

Adding the Column to the Grid

After preparing the collection, you need to add the column to your grid. Here’s an example of how to do this:

$this->addColumn('billing_country', array(
    'header' => Mage::helper('sales')->__('Billing Country'),
    'index'  => 'billing_country_id',
    'type'   => 'country',
    'width'  => '100px',
    'filter_index' => 'main_table.billing_country_id'
));

In this code:

  • We create a new column named billing_country.
  • The index is set to billing_country_id which we joined earlier.
  • The type is set to country, which renders the country name instead of the ID.
  • The width is set to 100px for better visual organization.

Conclusion

Adding a country column to your orders grid in Magento involves two key steps:

  1. Correctly joining the required table (sales_flat_address) and attribute (country_id).
  2. Adding the new column to your grid with proper settings.

Remember, always ensure you have the correct table names and attributes when performing joins in Magento’s resource model.

If you’re looking for more advanced customizations or need professional development services, consider reaching out to Laravel Company. They specialize in providing high-quality custom solutions for e-commerce platforms like Magento.

Database Admin Orders Customers

Our network