How can I get the 'friendly' text for product status and visibility attributes?

How can I get the 'friendly' text for product status and visibility attributes?

October 13, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How can I get the 'friendly' text for product status and visibility attributes?

Retrieving Friendly Text for Product Status and Visibility Attributes in Magento

When working with Magento products programmatically, you might find yourself needing to retrieve the human-readable text for status and visibility attributes instead of their numeric values. This is particularly useful when building custom reports or interfaces.

Understanding the Problem

By default, when you use $product->getStatus() or $product->getVisibility(), Magento returns the numeric values corresponding to these options:

  • Status: 1 = Enabled, 2 = Disabled
  • Visibility: 1 = Not Visible Individually, 2 = Catalog and Search, 3 = Search, 4 = Nowhere

However, in the admin interface, you see friendly labels like “Enabled/Disabled” for status and detailed visibility descriptions. How do we get these?

The Solution

Magento handles attribute options via a separate mechanism called eav (Entity-Attribute-Value). Each option has an ID and a label associated with it. To retrieve the friendly text, we need to access this information.

Here’s how you can achieve this:

  1. Load the necessary product attributes: First, load the status and visibility attributes using the addAttributeToSelect method in your product collection query.
$products = Mage::getModel('catalog/product')
    ->getCollection()
    ->addAttributeToSelect('sku')
    ->addAttributeToSelect('status')
    ->addAttributeToSelect('visibility');
  1. Access the attribute resource: Once you have the products, access the attribute resource using $product->getResource(). This gives you access to the eav data structure.

  2. Retrieve the option label: Use getAttribute() method to get an instance of the attribute object, then call getFrontend()->getValue($product) to fetch the friendly text for the current product’s value.

foreach ($products as $product) {
    echo 'SKU: ' . $product->getSku() . '<br/>';
    // Get status label
    echo 'Status: ' . $product->getResource()->getAttribute('status')->getFrontend()->getValue($product) . '<br/>';
    // Get visibility label
    echo 'Visibility: ' . $product->getResource()->getAttribute('visibility')->getFrontend()->getValue($product) . '<br/>';
}

The Complete Example

Here’s a complete example that retrieves all products, their SKUs, status labels, and visibility labels:

$products = Mage::getModel('catalog/product')
    ->getCollection()
    ->addAttributeToSelect('sku')
    ->addAttributeToSelect('status')  // Load the status attribute
    ->addAttributeToSelect('visibility');  // Load the visibility attribute

foreach ($products as $product) {
    echo 'SKU: ' . $product->getSku() . '<br/>';
    // Get status label using friendly text
    echo 'Status: ' . $product->getResource()->getAttribute('status')->getFrontend()->getValue($product) . '<br/>';

    // Get visibility label using friendly text
    echo 'Visibility: ' . $product->getResource()->getAttribute('visibility')->getFrontend()->getValue($product) . '<br/>';
}

Remember, to make this work, you need to have the necessary product attributes selected in your collection query.

Conclusion

Retrieving friendly text for product status and visibility options involves leveraging Magento’s eav data structure. By accessing the attribute resource and frontend label, we can obtain human-readable labels instead of numeric values. This is a common requirement when building custom interfaces or reports in Magento.

For more advanced techniques like extending this functionality to other attributes or creating reusable utility functions, consider checking out Laravel Company’s Magento development resources.

This approach ensures your code remains clean and efficient while providing the necessary flexibility for custom implementations.

Catalog Database Admin Errors

Our network