Show Simple Product attribute on homepage

Question

I want to show a custom_attribute of a simple product only.

I need this on the home page.

I want to foreach loop the 10 highest priced configurable products and show the lowest priced simple product custom_attribute

I can do it on the product page itself with its own simple products just fine with the following:

    if($_product->getTypeId() == "configurable"): ?>
    <?php 
        $childIds=Mage::getResourceSingleton('catalog/product_type_configurable')
            ->getChildrenIds($_product->getId());
        $simple_collection=Mage::getResourceModel('catalog/product_collection')->
        addAttributeToFilter('entity_id', array('in' =>  array_values($childIds[0])))
        ->addAttributeToSelect('*')->addAttributeToSort('price', 'asc');   
                // add  in stock to collection
        $cond = array(
            '{{table}}.use_config_manage_stock = 0 AND {{table}}.manage_stock=1 AND {{table}}.is_in_stock=1',
            '{{table}}.use_config_manage_stock = 0 AND {{table}}.manage_stock=0',
        );

            $cond[] = '{{table}}.use_config_manage_stock = 1 AND {{table}}.is_in_stock=1';

        $simple_collection->joinField(
            'inventory_in_stock',
            'cataloginventory/stock_item',
            'is_in_stock',
            'product_id=entity_id',
            '(' . join(') OR (', $cond) . ')'
        );

foreach($simple_collection as $simple_product){ 

        echo $sample_attribute
        echo $sample_attribute_2

}

Answer 1

Not sure I understood what you need, but you could try using somethig like this in your loop:

$top10 = Mage::getModel('catalog/product')->getCollection();
$top10
    ->addPriceData()
    ->addAttributeToFilter('type_id', Mage_Catalog_Model_Product_Type::TYPE_CONFIGURABLE)
    ->addAttributeToSort('price', Varien_Data_Collection::SORT_ORDER_DESC)
    ->setPageSize(10)
    ->setCurPage(1);

foreach ($top10 as $product) {   
    $simpleCollection = Mage::getModel('catalog/product_type_configurable')
        ->getUsedProductCollection($product);

    $simpleCollection
        ->addPriceData()
        ->addAttributeToSelect('*')
        ->addAttributeToSort('price', Varien_Data_Collection::SORT_ORDER_ASC);

    Mage::getSingleton('cataloginventory/stock')
        ->addInStockFilterToCollection($simpleCollection);

    $lowestSimple = $simpleCollection->getFirstItem();
    echo $lowestSimple->getAttributeName();
}

---

2nd part of your question in comments (how to add category filter):

$category = Mage::getModel('catalog/category')->load($categoryId);

$top10 = Mage::getModel('catalog/product')->getCollection();
$top10
    ->addPriceData()
    ->addAttributeToFilter('type_id', Mage_Catalog_Model_Product_Type::TYPE_CONFIGURABLE)
    ->addAttributeToSort('price', Varien_Data_Collection::SORT_ORDER_DESC)
    ->addCategoryFilter($category)
    ->setPageSize(10)
    ->setCurPage(1);

foreach ($top10 as $product) {  
    $simpleCollection = Mage::getModel('catalog/product_type_configurable')
        ->getUsedProductCollection($product);

    $simpleCollection
        ->addPriceData()
        ->addAttributeToSelect('*')
        ->addAttributeToSort('price', Varien_Data_Collection::SORT_ORDER_ASC);

    Mage::getSingleton('cataloginventory/stock')
        ->addInStockFilterToCollection($simpleCollection);

    $lowestSimple = $simpleCollection->getFirstItem();
    echo $lowestSimple->getAttributeName();
}