Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.
Sign up to join this community
In my website I have several stores available. One particular store contains both the simple and configurable products. This is a huge collection of products. What is the fastest way to get all enabled products (including child products of configurable products) collection of this store by store id?
Note: I tried this lot of different ways. But it takes loo much time. Sometimes cause to crash the server even.
Note : I'm using Magento CE 1.3
Any suggestions will be appreciated.
$category = Mage::getModel('catalog/category')->load($categoryId);
$collection = Mage::getModel('catalog/product')->getCollection()
->addCategoryFilter($category);
//you can use the next lines to add some minimal information about the products to the collection
//thanks @DavidManners
$collection->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes()) //add list attributes
->addMinimalPrice() //add prices
->addFinalPrice()
->addTaxPercents()
//or
//$collection->addAttributeToSelect('*');//if you want all the attributes
Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($collection);//only enabled products
Mage::getSingleton('catalog/product_visibility')->addVisibleInCatalogFilterToCollection($collection);//only visible products
Now the problem. Usually the simple products associated to the configurable ones are not associated to a category or they are set not to be visible. If this is not the case for you then the code above should be enough. If they are associated to a category but they are not visible then just comment the last line.
Otherwise you have to loop through the products and when you find a configurable one get it's associated products:
//this is needed if you want to get the out of stock simple products also
Mage::helper('catalog/product')->setSkipSaleableCheck(true);
$allProducts = array();
foreach ($collection as $product){
$allProducts[] = $product;
if ($product->getTypeId() == 'configurable'){
$simpleProducts = $product->getTypeInstance(true)
->getUsedProducts(null, $product);
foreach ($simpleProducts as $simple){
$allProducts[] = $simple;
}
}
}
Now you should have all the products you need in $allProducts array.
This may not be fast due to getting the simple associated products but should get you what you need. I hope it doesn't crash the server.
Mage::getSingleton('catalog/config')->getProductAttributes() or specifing the attributes you want.
– David Manners
Oct 1 '13 at 13:25
addCategoryFilter() for the Mage_Catalog_Model_Product object.
– Sukeshini
Oct 1 '13 at 15:29
$category->getProductCollection() instead of $collection = Mage::getModel('catalog/product')->getCollection()->addCategoryFilter($category) and carry on with the rest of the code from there.
– Marius♦
Oct 2 '13 at 6:47
To add on @Marius his answer, to limit the used resources you can use the resource_iterator class.
Mage::getSingleton('core/resource_iterator')->walk($collection->getSelect(), array('productCallback'), array());
function productCallback($args)
{
var_dump($args['row']);
[...]
}
Instead of executing the the query and retrieving all the results at once Magento will now handle one result at the time, then moving on to the next.
