How to get the product count from the url's for the manufacture

$products = Mage::getModel('catalog/category')->load(4324)
   ->getProductCollection()
   ->addAttributeToSelect('*')
   ->addAttributeToFilter('manufacturer', array('eq' => 22));

echo count($products);

$products_combined = Mage::getModel('catalog/category')->load($currentCategoryId)->getProductCollection()->addAttributeToSelect('*')->addAttributeToFilter('status', array('gt' => 0))->addAttributeToFilter('visibility', 4)->addAttributeToFilter('material', array('eq' => 64));

echo count($products_combined);

/*for price range*/

$products_gt250 = Mage::getModel('catalog/category')->load($currentCategoryId)->getProductCollection()->addAttributeToSelect('*')->addAttributeToFilter('status', array('gt' => 0))->addAttributeToFilter('visibility', 4)->addFieldToFilter(array(array('attribute'=>'price','gt'=>'249')));

echo count($products_gt250);

$products_lt150 = Mage::getModel('catalog/category')->load($currentCategoryId)->getProductCollection()->addAttributeToSelect('*')->addAttributeToFilter('status', array('gt' => 0))->addAttributeToFilter('visibility', 4)->addFieldToFilter(array(array('attribute'=>'price','lt'=>'150')));

echo count($products_lt150);

$products150_250 = Mage::getModel('catalog/category')->load($currentCategoryId)->getProductCollection()->addAttributeToSelect('*')->addAttributeToFilter('status', array('gt' => 0))->addAttributeToFilter('visibility', 4)->addFieldToFilter('price', array(array('from'=>'150','to'=>'250')));

echo count($products150_250);

Comments

Post a Comment

Popular Posts

Magmi Single and Multiple Category Importer

Magmi On the fly Category Creator Magmi can create or update categories while it is importing products This document refers to On the fly category creator Version 0.2.3 Categories column To assign your products to categories, include a column called "categories" in your CSV file. If a category branch does not exist, it will be created on the fly during the import process and your products will be assigned to it sku,name,categories "100","My Products/Sample Products/Sample Category" "101","My Products/Other Products" 1 2 3 sku , name , categories " 100 " , " My Products / Sample Products / Sample Category " " 101 " , " My Products / Other Products " Each branch level of the category tree is separated with a forward slash (/). In the example shown above, the two products will be put into their own categories and the following tree ...
Read more