Hi,

Good article but is it possible to have same behavior without create an “On Sale” category, just to put a block in a CMS page which is listing all products with a special price ?

Thanks.

Hi. It is possible to put it just to CMS page like this:
{{block type=”catalog/product_list” name=”specials” as=”specials” template=”templatename.phtml”}}

but how can I handle number of products per page?
When I normally have 30 products pre page and 20 has no special price the result will show only 10 products. The worse thing is that the number of products is on every page different.

Oops, the comment system didn’t like my code snippet. 2nd try:

PS: @Branko:

Thanks for sharing your knowledge.

It would be very helpful if you indicated which characters/tags are allowed in your comments or how to post code.

I can only get this to display products with a special price and not those with a catalog price rule.

ie this part of the statement: $_product->_rule_price !== null isn’t working. If I use it on it’s own I get no products returned even though I have a whole category discounted with a rule.

I’m using Magneto 1.4.1.1 Could that be the problem?

Any idea how I can get this to work?

Hi, i want to make paging on bestselling products without refreshing the pages with help of jquery.Can anyone help me.

Thanks

Surely you have to assign something to the toolbar to keep it in step with the displayed results?

I too have tried to use catalog price rules, but with no luck. it just will not work work. v1.6

As serks said, please elaborate Branko.

Thanks

i should note that in my previous post. using this method renders things like ->getToolbarHtml() and ->getMode()
useless because calling the phtml directly from a CMS page would be setting $this. to the CMS handler not the catalog handler. but!! in using my suggested method you can customize the product list using all the same product manipulation functions(ie. getName getProductUrl etc.) you can create your own stylings to display this data as you wish. you can create a custom CMS page such as Special_Offers.html(CMS page) using the {{block}} to display the contents of onsale_list.phtml .

i should also note that it seems in order to properly add the {{block}} on a CMS page it may require you to do it in the “Html mode” in the CMS editer

below is a simple example of a onsale_list.phtml

<?php
$_productCollection = Mage::getResourceModel('catalog/product_collection')
    ->addAttributeToSelect('*') // select all attributes
    ->addAttributeToFilter('special_price', array('notnull' => 1)) // only products where special_price is not empty
    ->setOrder('special_price', 'ASC'); // sort products by attribute special_price  in ascending order
?>
 <style type="text/css">
   div.special-price-list { border-bottom:black 1px solid; margin-bottom:5px; padding-bottom:10px; }
   h5.special-price-title { text-align:center; font-size:15px; }
   div.special-price-desc {  position:absolute; margin-left:200px; margin-top:-125px; border:red 1px solid;  height:auto; width:300px; overflow:none; padding:10px 10px 10px 10px; }
   p.special-price-desc { position:absolute; margin-top:-20px; margin-left:10px; background:white; }
   div.special-price-control { position:absolute;  margin-top:-175px; margin-left:550px; }
 </style>
<?php
if ($_productCollection < 1):
 echo 'There currently is no special offer products available';
else:
 foreach($_productCollection as $_product):
  $_product->load();
  ?>
        <div class="special-price-list" id="product-special-<?php echo $_product->getId()?>">
            <h5 class="special-price-title"><a href="<?php echo $_product->getProductUrl() ?>" title="<?php echo $this->htmlEscape($_product->getName()) ?>"><?php echo $this->htmlEscape($_product->getName()) ?></a></h5>
            <p class="special-price-image">
                <a href="<?php echo $_product->getProductUrl() ?>" title="<?php echo $this->htmlEscape($_product->getName()) ?>">
                    <img src="<?php echo $this->helper('catalog/image')->init($_product, 'small_image')->resize(135, 135); ?>" width="135" height="135" alt="<?php echo $this->htmlEscape($_product->getName()) ?>" />
                </a>
            </p>
            <div class="special-price-desc"><p class="special-price-desc">Description</p><?php echo nl2br($_product->getShortDescription()) ?></div>
            <div class="special-price-control">
              <?php echo $this->getPriceHtml($_product, true) ?>
              <?php if($_product->isSaleable()): ?>
              <button class="form-button" onclick="setLocation('<?php echo $this->getAddToCartUrl($_product) ?>')"><span><?php echo $this->__('Add to Cart') ?></span></button>
              <?php else: ?>
              <div class="out-of-stock"><?php echo $this->__('Out of stock') ?></div>
              <?php endif; ?>
            </div>
        </div>
<?php
 endforeach;
endif;
?>

you’ll have to excuse my css. im not really one for designing. im a backend developer lol.

as you can see this would be an example better suited for having it’s own page but could easily be used on say the “home page” or any page of your choosing

I think when the number of products are more this if condition will effect the pagination.