Magento – Create Category page which displays all Special Price products

categoryextensionspriceproduct-listsales

Basically, I've created a category 'Products on Sale', which I would like to automatically contain all products in my catalog that have had a Special Price applied to them (via Catalog > Manage Products). I would like the page to retain the layered navigation and sorting capabilities that a standard Magento Category page contains.

It seems like this is something that would be valuable to a majority of Magento users, and I'm surprised it is not included as part of the core functionality.

I've tried over a dozen Stack Exchange answers, blog posts, and forums, and nothing has worked thus far. Does anyone have a programmatic solution for this?

=== EDIT ===

Based on @pspahn's critique in the comments below, I've decided to pursue an alternate method of achieving similar functionality. With that said, if you are interested in pursuing this line, @sander-mangel describes a method which seems entirely feasible.

Best Answer

Easiest way to do this is to create a custom extension that works with an Observer and a Cronjob.

Create a category for the sales products. This way you can use the normal Magento functionalities in the frontend like layered navigation etc.

To get the products in this category automatically we will use the observer and cronjob. The observer will observe the catalog_product_save_after event that is triggered when a product is saved in the backend. When this happens you can check the special_price, special_price_from date and special_date_to date to determine if you need to put the product in the sales category or remove it from there.

The cronjob is there for the special from and to dates. Every night after midnight first empty the sales category of all the products. Then use a collection to retrieve all products that have a special price and are falling within the special from and to date. If so move them to this sales category.

Related Solutions

Magento – Create Special Price page which shows Catalog price rules products

it took me a while to figure this out. Should work for you, if you customy it for your needs.

To list products affected by a price rule, you must make your way over the rule-model.

Here is the code:

<?php
// we need the date to filter for the special price
    $dateToday = date('m/d/y'); 
    $tomorrow = mktime(0, 0, 0, date('m'), date('d')+1, date('y'));
    $dateTomorrow = date('m/d/y', $tomorrow);

// this gets the product collection and filters for special price;
// grabs products with special_from_date at least today, and special_to_date at least tomorrow
        $_productCollection = Mage::getModel('catalog/product')->getCollection()
            ->addAttributeToFilter('special_from_date', array('date' => true, 'to' => $dateToday))
            ->addAttributeToFilter('special_to_date', array('date' => true, 'from' => $dateTomorrow))
            ->load();

// this loads the standard magento catalog proce rule model
        $rules = Mage::getResourceModel('catalogrule/rule_collection')->load();

// read: if there are active rules
        if($rules->getData()) {
            $rule_ids = array(); // i used this down below to style the products according to which rule affected
            $productIds[] = array(); // this will hold the ids of the products

            foreach($rules as $rule) {
                $rule_ids[] = $rule->getId();
                $productIds = $rule->getMatchingProductIds(); // affected products come in here
            }

// merge the collections: $arr is an array and keeps all product IDs we fetched before with the special-price-stuff
            $arr = $_productCollection->getAllIds();
            if($productIds) {
                // if there are products affected by catalog price rules, $arr now also keeps their IDs
                $arr = array_merge($arr,$productIds);
            }

// we initialize a new collection and filter solely by the product IDs we got before, read: select all products with their entity_id in $arr
            $_productCollection = Mage::getModel('catalog/product')->getCollection()
                ->addAttributeToFilter('entity_id',array('in'=>$arr))
                ->load();
        }

== UPDATE ==

I added some comments to the code and renamed $skus to $productIds (which fits better).

If you are still getting errors, please let me know what's exactly happening. This code is tested for Magento v1.7.0.2.

Cheers
Simon

Magento – How to add special price to category products grid

In order to achieve this you need to override the block that displays the product grid in the category edit screen. This block is Mage_Adminhtml_Block_Catalog_Category_Tab_Product.
For this, create a new module. Let's call it Easylife_Adminhtml with the following files:
app/etc/modules/Easylife_Adminhtml.xml - the module declaration file.

<?xml version="1.0"?>
<config>
    <modules>
        <Easylife_Adminhtml>
            <active>true</active>
            <codePool>local</codePool>
            <depends>
                <Mage_Adminhtml />
            </depends>
        </Easylife_Adminhtml>
    </modules>
</config>

app/code/local/Easylife/Adminhtml/etc/config.xml - the module configuration file

<?xml version="1.0"?>
<config>
    <modules>
        <Easylife_Adminhtml>
            <version>0.0.1</version>
        </Easylife_Adminhtml>
    </modules>
    <global>
        <blocks>
            <adminhtml>
                <rewrite>
                    <catalog_category_tab_product>Easylife_Adminhtml_Block_Catalog_Category_Tab_Product</catalog_category_tab_product><!-- override the default block with your ownw-->
                </rewrite>
            </adminhtml>
        </blocks>
    </global>
</config>

app/code/local/Easylife/Adminhtml/Block/Catalog/Category/Tab/Product.php - the block override class.

<?php 
class Easylife_Adminhtml_Block_Catalog_Category_Tab_Product extends Mage_Adminhtml_Block_Catalog_Category_Tab_Product{
    protected function _prepareCollection()
    {
        if ($this->getCategory()->getId()) {
            $this->setDefaultFilter(array('in_category'=>1));
        }
        $collection = Mage::getModel('catalog/product')->getCollection()
            ->addAttributeToSelect('name')
            ->addAttributeToSelect('sku')
            ->addAttributeToSelect('price')
            ->addAttributeToSelect('special_price')//add attributes you need
            ->addStoreFilter($this->getRequest()->getParam('store'))
            ->joinField('position',
                'catalog/category_product',
                'position',
                'product_id=entity_id',
                'category_id='.(int) $this->getRequest()->getParam('id', 0),
                'left');
        $this->setCollection($collection);

        if ($this->getCategory()->getProductsReadonly()) {
            $productIds = $this->_getSelectedProducts();
            if (empty($productIds)) {
                $productIds = 0;
            }
            $this->getCollection()->addFieldToFilter('entity_id', array('in'=>$productIds));
        }

        //simulate parent::parent::_prepareCollection() because you cannot call parent::_prepareCollection
        if ($this->getCollection()) {

            $this->_preparePage();

            $columnId = $this->getParam($this->getVarNameSort(), $this->_defaultSort);
            $dir      = $this->getParam($this->getVarNameDir(), $this->_defaultDir);
            $filter   = $this->getParam($this->getVarNameFilter(), null);

            if (is_null($filter)) {
                $filter = $this->_defaultFilter;
            }

            if (is_string($filter)) {
                $data = $this->helper('adminhtml')->prepareFilterString($filter);
                $this->_setFilterValues($data);
            }
            else if ($filter && is_array($filter)) {
                $this->_setFilterValues($filter);
            }
            else if(0 !== sizeof($this->_defaultFilter)) {
                $this->_setFilterValues($this->_defaultFilter);
            }

            if (isset($this->_columns[$columnId]) && $this->_columns[$columnId]->getIndex()) {
                $dir = (strtolower($dir)=='desc') ? 'desc' : 'asc';
                $this->_columns[$columnId]->setDir($dir);
                $this->_setCollectionOrder($this->_columns[$columnId]);
            }

            if (!$this->_isExport) {
                $this->getCollection()->load();
                $this->_afterLoadCollection();
            }
        }

        return $this;
    }

    protected function _prepareColumns()
    {
        //add the special price collumn after the 'price' column
        $this->addColumnAfter('special_price', array(
            'header'    => Mage::helper('catalog')->__('Special Price'),
            'type'  => 'currency',
            'width'     => '1',
            'currency_code' => (string) Mage::getStoreConfig(Mage_Directory_Model_Currency::XML_PATH_CURRENCY_BASE),
            'index'     => 'special_price'
        ), 'price');
        return parent::_prepareColumns();
    }
}

Clear the cache and it should work. It worked for me.

Best Answer

Related Solutions

Magento – Create Special Price page which shows Catalog price rules products

Magento – How to add special price to category products grid

Related Topic