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();
发表评论(评论将通过邮件发给作者):
	
		
	
   
    

