Magento – How to get the custom attribute values in the catalog category list block

blockscatalogcategorycustom

I have added a custom attribute to my category.
On category product listing page i want to retrieve the values of that custom attribute.
When i got Mage/Catalog/Block/Product/List.php i can find this protected function _getProductCollection() function. Is this function that is getting the collection from the db?
If yes how to get my custom attribute values in that method?

Or else which is the method that is responsible for getting collection from db and how to get the attribute value in that method?

EDIT:
The purpose is to add some more skus to that collection based on the custom attribute value

Best Answer

Product Attribute

Just add it to this xpath:

/config/frontend/product/collection/attributes

You can find an example here:

/app/code/core/Mage/Catalog/etc/config.xml:718

Category Attribute

Just add it to this xpath:

/config/frontend/category/collection/attributes

You can find an example here:

/app/code/core/Mage/Catalog/etc/config.xml:742

Related Solutions

Magento – How to Get All Custom Category Attribute Values

I'm doing it in phtml file like this way

<?php $categories = Mage::getModel('catalog/category')->getCollection()->addAttributeToSelect('*'); ?>

<?php foreach ($categories as $category): ?>
   <?php $categorySku = $category->getCategory_sku(); ?>
   <?php print_r ($categorySku); ?>
<?php endforeach; ?>

That way I can populate all my custom category attribute values which is category_sku :).

And this will make it to a select option list.

    <?php $categories = Mage::getModel('catalog/category')->getCollection()->addAttributeToSelect('*'); ?>

        <select id="my-id" name="my-name">
            <option value="">Select</option>
            <?php foreach ($categories as $category): ?>
<?php /*magento fetch data by using get and attibute name like banner_id change to getBannerId*/   ?>
                <?php $categorySku = $category->getCategorySku(); ?>
                <option value="<?php echo $categorySku; ?>"><?php echo $categorySku; ?></option>
            <?php endforeach; ?>
        </select>

Magento – Get custom category attribute

Try something like that:

$value = Mage::getModel('catalog/category')->load($category->getId())->getData('catalog_pdf');

EDIT:

Better way (without loading whole category model):

Mage::getResourceModel('catalog/category')->getAttributeRawValue($category->getId(), "catalog_pdf", Mage::app()->getStore()->getId());