magento category product count,salable
piaoling 2011-10-10 11:39:56
$productCollection = $category->getProductCollection();
//product stock status is 1 that's in stock
$productCollection->getSelect()->joinInner(array('pStock'=>'cataloginventory_stock_status'),"pStock.product_id=e.entity_id and pStock.stock_status=1","pStock.stock_status")
->columns('visibility','cat_index');
//product status is enabled and is not unvisibility
$productCollection->addAttributeToFilter("status",array("eq"=>1))
->addAttributeToFilter("visibility",array('neq'=>1));
$count = $productCollection->count();
发表评论(评论将通过邮件发给作者):