Hi All,
I am not able to select / fetch my custom attribute popular_product using resource model
$productCollection = Mage::getResourceModel('catalog/product_collection') ->addAttributeToSelect('popular_product') ->addAttributeToSelect('*') ->setStoreId($storeId) ->joinField('category_id', 'catalog/category_product', 'category_id', 'product_id=entity_id', null, 'left') ->addAttributeToFilter('category_id', array('in' => $catIds)) ->addAttributeToFilter('status', array('eq' => 1)) ->addAttributeToFilter('dis_continue', array('eq' => 0))
Although I can fetch it using following
$collection = Mage::getModel('catalog/product')->getCollection() ->addAttributeToSelect('sku') ->addAttributeToSelect('name') ->addAttributeToSelect('seller_id') ->addAttributeToSelect('manufacturer') ->addAttributeToSelect('popular_product') ->addAttributeToSelect('attribute_set_id') ->addAttributeToSelect('type_id');
Please help
Hi vikas,
Please check below code:-
$storeId = Mage::app()->getStore()->getId();
$collection = Mage::getResourceModel('reports/product_collection') ->addAttributeToSelect('*') ->setStoreId($storeId) ->addStoreFilter($storeId) ->addAttributeToFilter('visibility', $visibility) ->addAttributeToFilter('popular_product', true) ->setOrder('updated_at', 'desc') ->addAttributeToSelect('status') ->setPageSize($productCount); Mage::getSingleton('cataloginventory/stock')->addInStockFilterToCollection($collection); $collection->addFieldToFilter(array(array('attribute' => 'popular_product', 'eq' => 1))); /* To display product by category id */ if($categoryId=$this->getData('category_id')){ $category = Mage::getModel('catalog/category')->load($categoryId); $collection->addCategoryFilter($category); } foreach ($collection as $_product){ echo $_product->getId(); }