Magento – How to Get All Simple Products Without Configurable Product

configurable-productproductsimple-product

i want collection of those product which remain as simple product.

in other world i got all simple product which is include in configurable now i just want those product which does not included in configurable and still alone.

Best Answer

This is just an adaptation of what Amit Bera answered.
I just took the code and transformed it into one single query instead of 2.
The idea is to join left the products table with the table that keeps the relation between simple and configurable, and filter only the products that don't have such a relation:

$collection = Mage::getResourceModel('catalog/product_collection')
    ->addAttributeToFilter('type_id', array('eq' => Mage_Catalog_Model_Product_Type::TYPE_SIMPLE))
    ->addAttributeToSelect('*'); //or just the attributes you need

$collection->getSelect()->joinLeft(array('link_table' => $collection->getTable('catalog/product_super_link')),
    'link_table.product_id = e.entity_id',
    array('product_id')
);
$collection->getSelect()->where('link_table.product_id IS NULL');

now you just need to loop through the collection.

foreach ($collection as $product) {
     //do something with $product
}

Related Solutions

Magento – how to check if a product is a simple product and not a child of a configurable product

Simply I did: (Magento 1.8)

if($_product->isConfigurable()) {
   echo 'config'; 
}

Magento – how to get all attributes name and value from configurable product

load config product:

   $currentProduct = Mage::getModel('catalog/product_type_configurable')->setProduct($this->getProduct());;

    $products = array();

        $skipSaleableCheck = Mage::helper('catalog/product')->getSkipSaleableCheck();

getting all all simple products

    $allProducts = $conf->getTypeInstance(true)
            ->getUsedProducts(null, $conf);

    foreach ($allProducts as $product) {
        $products[] =  $product;
    }
        getting all configurable attribute of that products
        $AllowAttributes=$conf->getTypeInstance(true)
            ->getConfigurableAttributes($conf);

Getting config attribute for this product by attribute value id and label

    foreach ($products as $product) {
       foreach ($AllowAttributes as $attribute) {

            $productAttribute   = $attribute->getProductAttribute();
            $productAttributeId = $productAttribute->getId();
            $attributeValue     = $product->getData($productAttribute->getAttributeCode());
            /* Simple Product data */

            /* getting option text value */
            if ($productAttribute->usesSource()) {
                 $MYabel = $productAttribute->getSource()->getOptionText($attributeValue );
            }else{
                 $MYabel='';
            }


        }
    }

Best Answer

Related Solutions

Magento – how to check if a product is a simple product and not a child of a configurable product

Magento – how to get all attributes name and value from configurable product

Related Topic