Magento Configurable Products – Get All Without Associated Products

ce-1.9.2.2configurable-productproduct-collection

In magento 1.9 I need to get collection of all configurable products that have no associated products. The first idea is to get all configurable and then in loop check each for its children. But maybe there is more elegant way?

Best Answer

You can use below code to get all configurable products which does not have any associated products.

$collection = Mage::getModel("catalog/product")->getCollection()->addAttributeToSelect("*")->addAttributeToFilter('type_id', 'configurable');
$collection->getSelect()->join(
        'catalog_product_super_link',
        'entity_id != catalog_product_super_link.parent_id',
        array('parent_id')
    )->group('parent_id');
foreach($collection as $product){
    echo $product->getName()."<br>";
}

Related Solutions

Magento – Configurable products show option box without any options

The problem was that I had added jQuery without putting it in no conflict mode.

my local.xml code is now as follows:

<reference name="head">
        <block type="core/text" name="jquery.cdn.google">
            <action method="setText">
                <text><![CDATA[<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>]]></text>
            </action>
        </block>
        <block type="core/text" name="google.jquery.noconflict" after="google.jquery">
            <action method="setText">
                <text><![CDATA[<script type="text/javascript">var $j = jQuery.noConflict(); </script>]]></text>
            </action>
        </block>

        ....

Hope this helps someone!

Magento Configurable Products – Count In-Stock Associated Products

Like Tim said in him comment above ideally you don't want to be running load within a loop as this causes extra work and MySQL calls. (Making it "really slow")

I had a play around and I think I have a rough version of what your trying to achieve - get a count of configurable products who have at least 1 associated products that are in stock in category X?

May not be perfect, but should work and much faster too.

    <?php
//Update part 1 start
$eavAttribute = new Mage_Eav_Model_Mysql4_Entity_Attribute();
$code = $eavAttribute->getIdByCode('catalog_product', 'status');
//Update part 1 end

    $currentCat = Mage::registry('current_category');

    //Gets all simple products that belong to a configurable product
    $productCollection = Mage::getResourceModel('catalog/product_type_configurable_product_collection')
        ->setFlag('require_stock_items', true)
        ->setFlag('product_children', true);

    //Adds stock, status and visibility filters.
    Mage::getSingleton('cataloginventory/stock')->addInStockFilterToCollection($productCollection);
    $productCollection->addAttributeToFilter('status', 1);
    $productCollection->addAttributeToFilter('visibility', 1);

    //Filters by simple products who's parents are in the current category
    $productCollection->getSelect()->joinLeft(
        array('ccp' => 'catalog_category_product'),
        'link_table.parent_id=ccp.product_id',
        array('*'))->where('ccp.category_id = ?',$currentCat->getId())->group('parent_id');

//Update part 2 start
    $productCollection->getSelect()->joinLeft(
        array('statust' => 'catalog_product_entity_int'),
        'link_table.parent_id=statust.entity_id',
            array('value'))->where('statust.value = ?',Mage_Catalog_Model_Product_Status::STATUS_ENABLED)->where('statust.attribute_id = ?',$code);

//Update part 2 end

    $cnt = $productCollection->count();
echo $cnt;

    ?>

Best Answer

Related Solutions

Magento – Configurable products show option box without any options

Magento Configurable Products – Count In-Stock Associated Products

Related Topic