How to get country name from country code?

How to get country name from country code?

July 27, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How to get country name from country code?

Displaying Country Name Instead of Country Code in Magento

In Magento development, it’s common to work with custom tables and collections. One challenge you might face is when you want to display the country name instead of its code from your custom table.

The Problem: Storing and Retrieving Country Codes

When working with countries in Magento, you often deal with country codes rather than names. This is because country codes are shorter and easier to manage in the database. However, for user-facing interfaces like product pages or customer profiles, it’s much more intuitive to display country names.

Let’s say you have a custom table custom_table with a field named country_code. You’re retrieving data into your collection:

$collection = Mage::getModel('custom/table')->getCollection();

The $collection contains objects with country_code property, but not the country name.

The Solution: Joining Country Data to Your Collection

To get the country names in your collection, you need to join the data from the core_country table. This table stores both the country code and its corresponding name.

Here’s how you can achieve this:

$collection = Mage::getModel('custom/table')->getCollection();
$countryCollection = Mage::getResourceModel('directory/country_collection');

$collection->join(
    array('country' => $countryCollection),
    'main_table.country_code = country.code',
    array('country.name as country_name')
);

In this code:

  • We first create a collection of countries.
  • Then, we join the custom_table and core_country tables using the join method. The condition is main_table.country_code = country.code, which matches the country codes between your custom table and Magento’s core country data.
  • We select the column country.name as country_name. This renames the name field from the joined table to country_name.

Accessing Country Name in Your JavaScript

After this join, every object in your $collection will have an additional property called country_name. When you pass this collection to your JavaScript:

var data = <?php echo $this->getJson($collection); ?>;

The JSON response will include the country name like this:

{
    "items": [
        {
            "entity_id": 1,
            "country_code": "US",
            "country_name": "United States"
        },
        // More items...
    ]
}

Now, you can access data.items[0].country_name in your JavaScript to get the country name for each item.

Conclusion

This approach allows you to efficiently join country data into your custom collection. By doing this, you don’t need to perform separate queries or manage additional data structures in your JavaScript.

Remember that performance is crucial when dealing with collections and joins. Be mindful of the size of your collection and optimize your code accordingly.

For more advanced techniques in working with Magento’s database and collections, consider exploring Laravel Company’s guide on Magento 2 development.

Happy coding!

Catalog Database Customers Errors

Our network