We are looking for a way to get a list with all possible product configurations per product and its associated price, including delivery. If the same product has a different price or options it has to be registered as a new product.


productName, price, sku, entityId, array(options, optionIds), delivery

Flyer, 1.99, flyer, 1, [[small, 1], [colorful, 2]], normalDelivery

Flyer, 2.99, flyer, 1, [[big, 3], [colorful, 2]], normalDelivery

Flyer, 3.99, flyer, 1, [[small, 1], [colorful, 2]], fastDelivery

Flyer, 4.99, flyer, 1, [[big, 3], [colorful, 2]], fastDelivery

We tried the following code but it doesn’t contain all possible configurations and their associated price like shown in the example above:

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

Thanks in Advance.

  • We are using Magento 1.9.x Nov 14, 2017 at 8:20

1 Answer 1


With getUsedProducts function, an example code part may look like this:

$product = Mage::getModel('catalog/product')->load(%PRODUCT_ID%); 
$childProducts = Mage::getModel('catalog/product_type_configurable')->getUsedProducts(null,$product);

foreach($childProducts as $child) {

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.