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();

类别 :  magento(258)  |  浏览(4208)  |  评论(0)
发表评论(评论将通过邮件发给作者):

Email: