Magento Special price products page

{{block type="catalog/product_special" template="catalog/product/list.phtml" column_count="3" num_products="0"}}

<?php

class Mage_Catalog_Block_Product_Special extends Mage_Catalog_Block_Product_List

{

    protected function _getProductCollection()

    {

        if (is_null($this->_productCollection)) {

            $categoryID = $this->getCategoryId();

            if($categoryID)

            {

              $category = new Mage_Catalog_Model_Category();

              $category->load($categoryID); // this is category id

              $collection = $category->getProductCollection();

            } else

            {

              $collection = Mage::getResourceModel('catalog/product_collection');

            }

            $todayDate = date('m/d/y');

            $tomorrow = mktime(0, 0, 0, date('m'), date('d')+1, date('y'));

            $tomorrowDate = date('m/d/y', $tomorrow);

            Mage::getModel('catalog/layer')->prepareProductCollection($collection);

            $collection->addAttributeToSort('created_at', 'desc');

            $collection->addStoreFilter();

            $collection->addAttributeToFilter('special_from_date', array('date' => true, 'to' => $todayDate))

                ->addAttributeToFilter('special_to_date', array('or'=> array(

                0 => array('date' => true, 'from' => $tomorrowDate),

                1 => array('is' => new Zend_Db_Expr('null')))

                ), 'left');

            $numProducts = $this->getNumProducts() ? $this->getNumProducts() : 0;

            $collection->setPage(1, $numProducts)->load();

            $this->_productCollection = $collection;

        }

        return $this->_productCollection;

    }

}

25 Comments

• 
  Chris May 1, 2013 at 10:16 am

  Hi there,

  Thanks for the tutorial – I’m developing a Magento site however when I enter the code you’ve mentioned I receive an exception of “exception ‘Mage_Core_Exception’ with message ‘Invalid block type: Mage_Catalog_Block_Product_Special'” and the page dies halfway through loading. Do you have any suggestions please?

  Many thanks, Chris

  Reply
  • 
    kalpesh May 1, 2013 at 10:49 am

    I hope you have created the file Special.php at “app/code/local/Mage/Catalog/Block/Product/” and pasted the content of the file I provided in the post. If the file is in place, then you should not get this error.

    Reply
• 
  manoj May 14, 2013 at 5:24 pm

  Hi Sir,

  I want to hide all products which have special price(ie if product contain special price it should be hidden from listing page),
  i have tried with layer.php as well as list.php but i haven’t find solution please help me out .
  how should hide all the products which which have special prices as null
  i have also tried to addAttributetofilter but haven’t find solution.

  Please Reply as soon as possible.

  Reply
  • 
    kalpesh May 15, 2013 at 4:07 pm

    Hi. In products list.phtml file, filter $_productCollection with special_price equal to null. Something like

    $_productCollection->addAttributeToFilter('special_price', array('null'=>true));

    Reply
• 
  Ankur Goyal August 7, 2013 at 6:46 am

  Hi,
  Thanks for this post.It really helps a lot.
  Can you tell me how can i add left panel filters like on normal category page to this special product page.

  Reply
• 
  Ali August 27, 2013 at 6:49 am

  Hi

  What about if I am using Magento enterprise, dose the same code apply or i need to do some changes to the codes.

  Reply
  • 
    kalpesh August 27, 2013 at 2:05 pm

    Yes it should apply, although I have not checked it. Check it in your local and if it works, then move it to production.

    Reply
• 
  Allan August 29, 2013 at 8:32 am

  Just tried following you great tutorial, but i just get a blank CMS page when loading it 🙁

  Placed the code in the 2 places mentioned

  I think the problem is the folder structure

  I had to create the folders “Mage” –> “Catalog” –> “Product” –> “Block” so I could place the Special.php

  Shouldn’t the folder structure be there already? http://screencast.com/t/ZrDOE4I3

  Reply
  • 
    kalpesh August 29, 2013 at 9:03 am

    Hi Allan, the file/folder structure should be Mage -> Catalog -> Block -> Product -> Special.php
    The folder structure will not there already, as we are doing it in local codepool.
    Check all the steps are done correctly, it should work.

    Reply
    • 
      Allan August 29, 2013 at 9:13 am

      Changed the structure: http://screencast.com/t/r3Byd0hcF

      CMS page looks like this: http://screencast.com/t/SwRR4VKt2DzO

      Still no special products shows up 🙁

      Reply
      • 
        kalpesh August 29, 2013 at 9:33 am

        What I can suggest is:
        Check if you have atleast 1 special product. Special From and To dates should be valid. Clear cache.

        Reply
        • 
          Allan August 29, 2013 at 9:42 am

          Nothing :-(… This is the special product: http://screencast.com/t/UgLbVMECJHi

          Price is there, and dates are valid..

          Anyways, thank your for your help

          http://www.net-ost.dk/specials
        • 
          Allan August 29, 2013 at 9:58 am

          Everything should be alright.. Path is correct, and product is enabled with specialprice for valid dates

          http://www.net-ost.dk/specials
• 
  Allan August 29, 2013 at 9:12 am

  Changed the structure: http://screencast.com/t/r3Byd0hcF

  CMS page looks like this: http://screencast.com/t/SwRR4VKt2DzO

  Still no special products shows up 🙁

  Reply
  • 
    kalpesh December 8, 2013 at 7:57 pm

    Hi Allan, I know this is very late reply but I just came across this page and checked your screenshots again to know why it was not working for you. The issue was, the double quotes were not in correct format. This usually happens if you copy-paste the code, and as double quotes are easily missed to get noticed.

    Hope this will help someone with such kind of issue.

    Reply
• 
  Milo December 4, 2013 at 3:02 pm

  Hi,
  how to limit the number of displayed products?
  how to use buttons to sort the product?
  Allan try turn off compilation.

  Reply
• 
  Leon January 1, 2014 at 12:52 pm

  Hi, thank you for this code, it is working great on Magento 1.7.0.2.
  http://www.huckleberrysmenswear.co.uk/sale

  Reply
• 
  Octavio January 24, 2014 at 12:04 am

  My friend I used your code and it works fine but I have problems with the template, it shows in disorder the products… can we use layered navigation? 🙂 Thanks for your help

  Reply
  • 
    Octavio January 24, 2014 at 12:05 am

    forgot to paste the page 🙂
    http://www.trapolis.com/ofertas-especiales

    Reply
  • 
    Octavio January 24, 2014 at 12:05 am

    I forgot to paste the page 🙂

    http://www.trapolis.com/ofertas-especiales

    Reply
• 
  Ziya August 30, 2014 at 11:38 am

  Is it compulsary to create a page with name “Specials”. Can I call block code in other cms page?

  Reply
• 
  Karthik December 23, 2014 at 11:22 am

  Thank you for this code.. Worked well… Thanks a lot

  Reply
• 
  kishore June 10, 2015 at 8:02 am

  it works for me. thanks for a great tutorial Kalpesh.

  Reply
• 
  Markom February 14, 2016 at 10:09 pm

  Many thanks Kalpesh .

  Reply
• 
  Sandip July 23, 2018 at 11:18 am

  Thank you for post, I have import this code , but CMS page blank, Please help me…

  Reply