Magento get customer by Tax/VAT number field

Magento get customer by Tax/VAT number field

October 4, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento get customer by Tax/VAT number field

Retrieving Magento Customer by Tax/VAT Number

Hello developers! Today we’re diving into an essential aspect of customer management in Magento - retrieving customers using their Tax/VAT number. This can be particularly useful for tax calculations or administrative purposes where you need to pull specific customer data.

The Challenge: Retrieving Customers by Tax/VAT Number

You might think that you could simply use the setAttributeToSelect and addFieldToFilter methods like in this example:

$customer = Mage::getModel('customer/customer')->getCollection()
    ->addAttributeToSelect('*')
    ->addFieldToFilter('taxvat',  $ss_5_last)
    ->load();

However, as you’ve discovered, the ‘taxvat’ field doesn’t exist in standard Magento. This is because by default, Magento doesn’t include a Tax/VAT number attribute for customers.

The Solution: Creating a Custom Customer Attribute

To solve this, we need to create a custom customer attribute for the Tax/VAT number:

  1. Create the Custom Attribute

    In your Magento admin panel, navigate to Customers -> Attributes -> Manage Attributes. Click on “Add New Attribute” and fill in the details like this:

    • Attribute Code: taxvat
    • Frontend Label: VAT Number
    • Input Type: Text Field
  2. Assign the Attribute

    After creating the attribute, you need to assign it to your customer form. Go to Customers -> Attributes -> Manage Attributes again, find your new ‘VAT’ attribute and click on “Edit”. Scroll down to the “Used in Forms” section and select the appropriate forms (usually Customer Form and Adminhtml Customer).

  3. Add the Attribute to Your Customer Collection

    Now that the custom attribute is set up, you can use it in your code:

$customer = Mage::getModel('customer/customer')->getCollection()
    ->addAttributeToSelect('*')
    ->addFieldToFilter('taxvat',  $ss_5_last)
    ->load();

Remember to replace $ss_5_last with the actual Tax/VAT number you’re looking for.

Conclusion

Retrieving customers by their Tax/VAT number in Magento requires a bit of setup, but it’s definitely possible. By creating a custom customer attribute and using it properly in your collection filters, you can easily pull customers based on this field.

This technique is especially useful when integrating with external tax services or when you need to perform specific calculations for certain customers based on their Tax/VAT status.

For more advanced Magento customizations and best practices, feel free to explore our Magento Development Services at Laravel Company. We’d be happy to help you optimize your e-commerce platform!

Admin Customers Pricing CLI

Our network