Magento – How to Get New Products List from Specific Category with Widget in CMS

cmswidgets

Is there any way to get New Products List from specific Category with Widget in CMS Pages? I have tried specifying category ID using category_id="12" but it is pulling latest products from all the categories.

Below is the Widget code which I am using:

{{widget type="catalog/product_widget_new" category_id="12" products_count="4" template="catalog/product/widget/new/content/new_grid.phtml"}}

Best Answer

The new products widget does not support filtering by category.
but you can create your own block [module]/product_new that extends Mage_Catalog_Block_Product_New.
the only thing you need to add in your block are these methods.

//category member var
protected $_category = null;
//load the category
public function getCategory() {
    if (is_null($this->_category)) {
        if ($this->hasData('category_id')) {
            $category = Mage::getModel('catalog/category')->setStoreId(Mage::app()->getStore()->getId())->load($this->getData('category_id'));
            if ($category->getId()) {
                 $this->_category = $category;
            }
        }
        //if the category is not valid set it to false to avoid loading it again.
        if (is_null($this->_category)) {
            $this->_category = false;
        }
    }
    return $this->_category;
}
//override the _beforeToHtml() method
protected function _beforeToHtml() {
    parent::_beforeToHtml();
    //if a category is specified filter by it.
    if ($this->getCategory()) {
        $this->getProductCollection()->addCategoryFilter($this->getCategory());
    }
    return $this;
}
//Change the cache key so you won't get the same products for different categories when the cache is on
public function getCacheKeyInfo()
{
    $cacheKeyInfo = parent::getCacheKeyInfo();
    if ($this->getCategory()) {
         $cacheKeyInfo[] = $this->getCategory()->getId();
    }
    else {
         $cacheKeyInfo[] = 0;
    }

    return $cacheKeyInfo;
}

Now all you need to do is use your block in the {{block}} directive

{{widget type="[module]/product_new" category_id="12" products_count="4" template="catalog/product/widget/new/content/new_grid.phtml"}}

Related Solutions

Magento 1.8 – How to Get New Products from Each Category on Home Page

Create a local.xml under app/design/frontend/yourpackage/yourtemplate/layout/local.xml code of this file are

< ?xml version="1.0"?>
<layout version="0.1.0">
 <cms_index_index>

       <reference name="content">
            <block type="core/template" name="my_default_home_page" template="cms/home.phtml"/>
        </reference>
    </cms_index_index>

</layout>

and create home.phtml under app/design/frontend/yourpackage/yourtemplate/template/cms and code is this file below

here the code

$catgorcollection=Mage:getModel('catalog/category')->getCollection();
foreach($catgorcollection as $category ){

$todayStartOfDayDate  = Mage::app()->getLocale()->date()
            ->setTime('00:00:00')
            ->toString(Varien_Date::DATETIME_INTERNAL_FORMAT);

        $todayEndOfDayDate  = Mage::app()->getLocale()->date()
            ->setTime('23:59:59')
            ->toString(Varien_Date::DATETIME_INTERNAL_FORMAT);

        $collection = Mage::getResourceModel('catalog/product_collection'); 
        $collection->setVisibility(Mage::getSingleton('catalog/product_visibility')->getVisibleInCatalogIds());
    $collection
            ->addMinimalPrice()
            ->addFinalPrice()
            ->addTaxPercents()
            ->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes())
            ->addUrlRewrite();
$collection = $this->_addProductAttributesAndPrices($collection)
            ->addStoreFilter()
            ->addAttributeToFilter('news_from_date', array('or'=> array(
                0 => array('date' => true, 'to' => $todayEndOfDayDate),
                1 => array('is' => new Zend_Db_Expr('null')))
            ), 'left')
            ->addAttributeToFilter('news_to_date', array('or'=> array(
                0 => array('date' => true, 'from' => $todayStartOfDayDate),
                1 => array('is' => new Zend_Db_Expr('null')))
            ), 'left')
            ->addAttributeToFilter(
                array(
                    array('attribute' => 'news_from_date', 'is'=>new Zend_Db_Expr('not null')),
                    array('attribute' => 'news_to_date', 'is'=>new Zend_Db_Expr('not null'))
                    )
              )
            ->addAttributeToSort('news_from_date', 'desc')
            ->setPageSize(7)
            ->setCurPage(1);

$collection->addCategoryFilter($category);
}

How to Update a Widget Using AJAX

Try this in your controller:

public function couponPostAction()
{
    if (!$this->getRequest()->isAjax()) {
        $this->_forward('noRoute');
        return;
    }

    $block = $this->getLayout()->createBlock('catalog/product_widget_new', 'product.widget.new', array(
        'show_pager'        => 1,
        'products_per_page' => 24,
        'products_count'    => 1000,
        'display_type'      => 'new_products',
        'template'          => 'catalog/product/widget/new/content/new_grid.phtml'
    ));

    $this->getResponse()->setBody(
        Mage::helper('core')->jsonEncode(array(
            'field' => $block->toHtml()
        ))
    );
}

Best Answer

Related Solutions

Magento 1.8 – How to Get New Products from Each Category on Home Page

How to Update a Widget Using AJAX

Related Topic