Simple product getName() is empty

Question

I'm trying to show the name + quantity in stock for each simple product of a configurable product. I'm trying

<?php
if($_product->isConfigurable()) {
/*  $itemsinstock = 0; */
        echo '<p>Aantal in voorraad van:</p>';
        echo '<table>';
        foreach ($_product->getTypeInstance(true)->getUsedProducts ( null, $_product) as $simple) {
                $stock = Mage::getModel('cataloginventory/stock_item')->loadByProduct($simple)->getQty();
                $stock = round($stock,2);
                echo "<tr><td>". $simple->getName()." <td>&nbsp;:&nbsp;</td><td style='font-weight : bold; text-align : right;'>$stock</td></tr>";
/*              $itemsinstock+= $stock; */
        }
    echo '</table>';
/*  echo $itemsinstock; */
} else {
        echo "<p class='availability in-stock'>". $this->__('Availability:') ."&nbsp;<span>". number_format(Mage::getModel('cataloginventory/stock_item')->loadByProduct($_product)->getQty(), 0) ."</span></p>";
}

?>

I do see the quantity, but the name is empty. When I replace getName by getId, I get the correct id.

I read somewhere that the name is an attribute, but I can't get the name. I must do something wrong, but what/where?

Can some of you point me to the right direction?

Answer 1

Well here is the code you can try, this will get you simple product names too.

<?php
$product = Mage::getModel('catalog/product')->load(3);
if($product->isConfigurable()):
$childProducts = Mage::getModel('catalog/product_type_configurable')->getUsedProducts(null,$product);
foreach($childProducts as $child) {
    print_r($child->getName());
    // You can use any of the magic get functions on this object to get the value
}
endif;

I hope this helps you out.

Answer 2

There are an alternative solution by which you can get name use.

First get simple product ids from that configurable product then filter a product collection by those ids and using addFieldToSelect('name') at add product collection.

`

$ids=Mage::getResourceSingleton('catalog/product_type_configurable')
            ->getChildrenIds($_product);
 $_subproducts = Mage::getModel('catalog/product')->getCollection()
    ->addIdFilter ($ids)->addFieldToSelect('name');
        foreach ( $_subproducts  as $simple) {
                $stock = Mage::getModel('cataloginventory/stock_item')->loadByProduct($simple)->getQty();
                $stock = round($stock,2);
                echo "<tr><td>". $simple->getName()." <td>&nbsp;:&nbsp;</td><td style='font-weight : bold; text-align : right;'>$stock</td></tr>";
              $itemsinstock+= $stock; 
        }