Magento Configurable Product – Get Associated Products Price and Size

attributesconfigurable-productmagento-1.9product

I want to have in the product view page and in the category page a list with all size attribute and price for each configurable product. I use this code to display the size and is work perfect but I need to get the price too. How I can add the price for associated products in the following code.

Thank you

$ids = Mage::getModel('catalog/product_type_configurable')->getChildrenIds($_product->getId()); //get the children ids through a simple query
$attrs  = $_product->getTypeInstance(true)->getConfigurableAttributesAsArray($_product);
foreach($attrs as $attr) {
    if(0 == strcmp("size", $attr['attribute_code'])) {
        $options    = $attr['values'];
        foreach($options as $option) {
            print "{$option['store_label']}<br />";
        }
    }
}

I need to be something like in this image:

Edit:
I can get simple products prices with the following code but how I can have Size and Price foreach simple product?

if($_product->getTypeId() == "configurable"):
    $conf = Mage::getModel('catalog/product_type_configurable')->setProduct($_product);
    $simple_collection = $conf->getUsedProductCollection()->addAttributeToSelect('*')->addFilterByRequiredOptions();
    foreach($simple_collection as $simple_product){
        echo Mage::helper('core')->currency($simple_product->getPrice());
    }
endif;

Best Answer

considered size as attribute code and $simple_collection as simple products data.

    $_sized = array();
    $_size_id = array();
    foreach ($simple_collection as $simple_product) {              

      $label = $simple_product->getAttributeText('size');
      $_sized[] = $label;

      if (!isset($_size_id[$label])) {
        $_size_id[$label] = $simple_product->getData('size');
      }
    }

    //apply uniqueness
    $_final_sizes = array_unique($_sized);

EDITED ANSWER

    $j=0;
    foreach ($simple_collection as $simple_product) {
      $label = $simple_product->getAttributeText('size');
      $_sized[] = $label;

      if (!isset($_size_id[$label])) {
        $_size_id[$j][] =$label;
        $_size_id[$j][] = Mage::helper('core')->currency($simple_product->getPrice());
$j++;
      }
    }

    echo '<pre>';print_r($_size_id); echo '</pre>';

Related Solutions

Magento – Multiple attributes for configurable product

What you described here is the exact functionality of the magento configurable products.
Take a look at this for more details: http://www.magentocommerce.com/knowledge-base/entry/tutorial-creating-a-configurable-product.
When you create a configurable product you will also have the option to add a price delta to the options you use.
So for example for the size: Size 10 can have a +3E.
The down side is that all the size 10 will have that extra charge.
Then you can set for color green a price difference of -2.
This means that when selecting size 10 and color green you will have the price: BASE+3-2 = BASE + 1.

As for the colors depending on the size, this is what Magento does.
If you create a configurable product and you create simple products for only a few variations of colors and sizes only those will be visible in the product view page

Get Stock Values for Bundled Product in Product Grid

Here is an example how to access the is salable state or the stock quantity of all associated child products.
this first method is simply to fetch the child product ids from the bundled product.

function getBundledProductChildIds(Mage_Catalog_Model_Product $product)
{
    $childrenIds = [];
    if ($product->getTypeId() == Mage_Catalog_Model_Product_Type::TYPE_BUNDLE) {
        $childrenIds = array_reduce(
            $product->getTypeInstance(true)->getChildrenIds($product->getId()),
            function (array $reduce, $value) {
                return array_merge($reduce, $value);
            }, []);
    }
    return $childrenIds;
}

The next example gives you the in stock or out of stock for each child product.

$bundledProduct = Mage::getModel('catalog/product')->load(BUNDLED_PRODUCT_ID);

// Just get the is salable state of the child products
$childProducts = Mage::getResourceModel('catalog/product_collection')
    ->addIdFilter(getBundledProductChildIds($bundledProduct));
foreach ($childProducts as $child) {
    printf("%s -> %s stock\n", $child->getId(), ($child->getIsSalable() ? 'in' : 'out of'));
}

The final example gives you the stock qty of each child product.
Note that the key difference is that the require_stock_items flag is set on the collection before it is loaded.

$bundledProduct = Mage::getModel('catalog/product')->load(BUNDLED_PRODUCT_ID);    

// Get the inventory qty of each child item
$childProducts = Mage::getResourceModel('catalog/product_collection')
    ->addIdFilter(getBundledProductChildIds($bundledProduct))
    ->setFlag('require_stock_items', true);
foreach ($childProducts as $child) {
    printf("%s -> stock qty: %d\n", $child->getId(), $child->getStockItem()->getQty());
}

printf("Total stock item qty sum: %d\n", array_reduce(
    $childProducts->getItems(),
    function ($sum, $child) {
        return $sum + $child->getStockItem()->getQty();
    }, 0));

printf("Highest stock qty: %d\n", array_reduce(
    $childProducts->getItems(),
    function ($max, $child) {
        return max($max, $child->getStockItem()->getQty();
    }, 0));

That should hopefully enable you to get what you need.

Best Answer

Related Solutions

Magento – Multiple attributes for configurable product

Get Stock Values for Bundled Product in Product Grid

Related Topic