Magento - Special Price Page - 'How do I' Questions - eCommerce Software for Growth

Skip to site navigation »
Skip to main content »
Skip to footer content »

Login

Login:

Password:

Remember password
Show my name in the online users list

Forgot password?
Register
Job Board

Magento Forum

From setting up your store to managing your products, pages and promotions to generating detailed reports, the Magento User Guide empowers the user to utilize the platform for all of its vast capacity.
Available in eBook and Print formats – Download Now!!!

Special Price Page

artoxicated Total Posts: 14 Joined: 2008-05-08 Ignore user	Any ideas how do i make a page that displays all the products with a “Special Price” in my shop? Many Thanks
	Posted: August 27 2008 \| top

Johan05 Total Posts: 48 Joined: 2008-06-25 Ignore user	Up ?
	Posted: October 25 2008 \| top \| # 1

hulaqueen Total Posts: 19 Joined: 2008-09-20 Ignore user	Manually? Just create a new category called SPECIALS and add those products to it. Sorry I don’t see any automated way to do this yet. UNLESS you created a static block and were able to do a database query looking for special prices… that is beyond me though.
	Posted: October 25 2008 \| top \| # 2

Johan05 Total Posts: 48 Joined: 2008-06-25 Ignore user	Hello, And with the option “Special Price Form"..." To"… ? Is it possible to display it on a special price’s page ? (sorry for my english, i’m so frenchie !!!)
	Posted: October 25 2008 \| top \| # 3

Alexandre Queiróz Total Posts: 43 Joined: 2008-02-27 Brazil Ignore user	I´m also interested in this feature too.
	Posted: November 6 2008 \| top \| # 4

michaelc Total Posts: 54 Joined: 2008-05-21 Qld, Australia Ignore user	I’ve done this with both the Catalog Price Rules and the Manage Product Process a few times. Catalog Price Rules: What I did was go to Admin -> Promotions -> Catalog Price Rules -> + Add New Rule Rule Information: Add here your rule name and required details like Status, Websites and Customer Groups… Conditions: This is where you define what your rule will apply to - If you want it to apply to a product category, select the + button under nd under the condition add… select under product attribute “Category” (NB: there will be all of your product attributes you can apply this to) If you select “Category”, you will need to apply the appropriate Category ID. Varian has added a little selector icon that looks like a table if you don’t already know your stores category IDs. Select this and check your category and select the “tick” button above to apply the ID. Actions : This is where you apply what type of discount and how; - By percentage of original price - By fixed amount - To Percentage of the original price - To fixed amount You will also need to choose to allow other rules from applying or not as well. Now when this is setup, you will need to either choose to “Save and Apply” or to just “Save Rule”. This is where I’ve had some issues. Not sure if it is a bug, or in my store setup, but I’ve had to apply it a few times...i.e. “Save Rule” first, then “Apply Rules” in the root directory of the Catalog Price Rules and visa verse… when it works, it works well. I’ve also had a few weird things happen when applying these Catalog Price Rules. One time it disappeared and replaced a Shopping Cart Price Rule… weird??? Let me know if this is what you are looking for, or if you have any issues. If this doesn’t work, then the point that @hulaqueen made does also work. Manage Product Process: You just need to go into the products within your category. Go Admin -> Catalog -> Manage Products -> (Select your Product) -> Prices -> Special Price -> (Add your discounted price here) -> Also add your special price “to” and “from” dates. This will manually apply the “Special” prices. If you want to apply your special prices immediately, make sure your “from” date is set to “today’s date” or “yesterdays date”.... hope this helps!
	Posted: November 7 2008 \| top \| # 5

befree22 Total Posts: 24 Joined: 2008-09-22 Ignore user	michaelc, could you show me a working website example of your suggestion above? Thanks a lot, Signature Leslie })i({ Save on Your Hosting Bill Today!
	Posted: December 27 2008 \| top \| # 6

michaelc Total Posts: 54 Joined: 2008-05-21 Qld, Australia Ignore user	@befree22 check out http://www.musicshop.com.au/50-percent-sale.html Also, to display it on a specials page, all I’ve done is create a new category and added these products to it...(note URL above) You can display this categories products on any CMS page by adding this code below and editing the category ID to suit you: {{block type="catalog/product_list" template="catalog/product/list.phtml" category_id="67"}} hope this helps…
	Posted: December 28 2008 \| top \| # 7

befree22 Total Posts: 24 Joined: 2008-09-22 Ignore user	Hi michaelc, I do appreciate your quick response and your willingness to help us out. I’m quite new to this wonderful yet simple shopping cart—once you get an idea of it’s structure. Pardon me if I ask “you should know this” questions” but understanding how the code works is unknown to me. Days ago, I created a root category named Products and 2 subcategories: Soap and Specials. This root category is separate from the Magento demo root category named Root Catalog which contains the following 3 subcategories: Furniture, Electronics, and Apparel. I also created a Specials webpage in CMS Static Blocks. I read your Nov. 7th post and now I have a Promotions>Catalog Price Rules>Specials webpage. Once problems I’m experiencing is that in “Edit Rule ‘Specials">Conditions> and dropdown Product Attribute>Category, whenever I enter 33 in the Category is ... text box, I get the following error message after I click the green tick icon and the Save Rule: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute. Question #1: Does anyone know why I’m getting this error? All of the other catalog rules are ok, ie no errors. I admit that I’m still adding products to my shopping cart and categories and there’s nothing in Specials subcategory yet. Is this why? Or is this a bug? Question #2: I know that the display url for my Specials subcategory in the root catalog on the CMS webpage entitled Specials is http://www.mysite.com/specials and when I visit this url, I see the Specials heading and a webpage empty of product items. However, to display the items belonging in the root catalog Specials subcategory and in the Promotions>Catalog Price Rules>Specials webpage, what is the block code I have to use in the CMS webpage? Is it {{block type="catalog/product_list" template="catalog/product/list.phtml" category_id="33"}} or something else? I ask because I I created a root category named Products and 2 subcategories: Soap and Specials so the path may be different. Thanks again, Signature Leslie })i({ Save on Your Hosting Bill Today!
	Posted: December 29 2008 \| top \| # 8

michaelc Total Posts: 54 Joined: 2008-05-21 Qld, Australia Ignore user	@befree22 Question 1: Checkout SimpleHelix.com answer to your mySQL error at -> http://www.magentocommerce.com/boards/viewthread/35/ ...This seems to have worked for a lot of people… Question 2: If you are running version 1.1.8, then you should be able to see the category ID in brackets next to the title of the category at the top of it page in admin. That is, go to Admin -> Catalog -> Manage Categories -> (select category). This is just to double check your category ID is correct. The other thing to consider, is that the shop you are setting up has still got the original Magento root category selected as its “root category”. To update, or check this, go to Admin -> System -> Manage Stores -> (select your store name). This will take you to a page that has the options for: Website / Name / Root Category / Default Store View. This is where you can select which root category will be assigned to your store. Update this to be your new root category, this should fix your viewing problem. Hope this helps…
	Posted: December 29 2008 \| top \| # 9

friends1976 Total Posts: 22 Joined: 2008-11-10 Ignore user	michaelc - 06 November 2008 05:11 PM Manage Product Process: You just need to go into the products within your category. Go Admin -> Catalog -> Manage Products -> (Select your Product) -> Prices -> Special Price -> (Add your discounted price here) -> Also add your special price “to” and “from” dates. This will manually apply the “Special” prices. If you want to apply your special prices immediately, make sure your “from” date is set to “today’s date” or “yesterdays date”.... hope this helps! I have tried this and for some reason it is not working for my product. The product page is here.... http://skipperslawnclippers.com/store/index.php/clearance/4-the-fight-against-cancer-long-sleeve-t-shirt.html The item has a special price of $10.00 and it has dates in there that are appropriate. Is there some sort of global setting that is causing the special price to not take effect? Thank you! Signature Ashley Bailey Designs, LLC
	Posted: January 11 2009 \| top \| # 10

michaelc Total Posts: 54 Joined: 2008-05-21 Qld, Australia Ignore user	Hi @friends1976, Just checked your page and the specials prices seem to be working. Is everything working OK?
	Posted: January 12 2009 \| top \| # 11

friends1976 Total Posts: 22 Joined: 2008-11-10 Ignore user	No, not really. I just used 2008 as the start date and it works temporarily. I also set the special price to expire today (2009) and it hasn’t done so. :( Signature Ashley Bailey Designs, LLC
	Posted: January 12 2009 \| top \| # 12

clickcomkyle Total Posts: 28 Joined: 2008-08-07 Ignore user	I am having the same problem that friends1976 is having. Anyone figure out why? I have a date range specified, that is within range, but it still displays the regular price, not my special price.
	Posted: April 6 2009 \| top \| # 13

devinrayolsen Total Posts: 59 Joined: 2009-01-28 Ignore user	Strangely Magento provides no real way to list out all products that have a special price or rather a “Whats on Sale” page. But there is this code that will do just that for you. Simple create a new .phtml file and save it under /template/page/on_sale.phtml and then in the backend create a new CMS page and assign this new on_sale.phtml layout to this new CMS page. If you don’t know how to make custom .phtml files be listed in the Custom Design/Layout’s drop down then read this: http://www.magentocommerce.com/boards/viewthread/43809/#t142273 Ok moving on! You can name the new CMS page something like “Whats On Sale”. Then back on the on_sale.phtml page add this snip of php code to run over all products and display ones with a special price ONLY! Code Created By: philwinkle <?php include_once 'app/Mage.php'; Mage::app(); Mage::getSingleton('core/session', array('name' => 'frontend')); $_productCollection = Mage::getResourceModel('catalogsearch/advanced_collection') ->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes()) ->addMinimalPrice() ->addStoreFilter(); Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($_productCollection); Mage::getSingleton('catalog/product_visibility')->addVisibleInSearchFilterToCollection($_productCollection); $todayDate = date('m/d/y'); $tomorrow = mktime(0, 0, 0, date('m'), date('d')+1, date('y')); $tomorrowDate = date('m/d/y', $tomorrow); $_productCollection->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'); foreach($_productCollection as $_product){ if($_product->getData('special_price')!=null){ echo '<img src="'.$this->helper('catalog/image')->init($_product, 'thumbnail')->resize(75).'" alt="'.$_product->getName().'" /><br />'; echo $_product->getName().'<br />'; $specialPrice = $_product->getData('special_price'); $orignalPrice = $_product->getData('price'); echo number_format($specialPrice, 2)."<br/>"; echo number_format($orignalPrice, 2)."<br/>"; echo '<a href="http://www.yourwebsite.com/magento/checkout/cart/add?product='.$_product->getId().'&qty;=1">Add To Cart</a><br />'; } } ?>
	Posted: June 9 2009 \| top \| # 14

Dorgo Total Posts: 75 Joined: 2008-12-16 Ignore user	thanks for that code devinrayolsen. I can’t undersand why there isn’t any functionality for displaying specials either. I did things a bit differently, kinda new at this though and not getting what i want. First off, instead of making it into a new Page template and then having to add all the other stuff, i just stuck with 3-column layout. Then i created a new template in template/specials/on_sale.phtml and called it from a CMS page with `{{block type="core/template" name="specials" as="specials" template="specials/on_sale.phtml"}}` Then i wanted it to display like a category with all the related options, pagination etc so (after trying unsuccessfully to get the $_productCollection to go through the existing code at template/catalog/product/list.phtml) i copied the code from template/catalog/product/list.phtml into my new file. This kinda works but i am missing prices and compare link as well as the pager, viewby and seemingly translations. I know i’ve just kinda run at this and mashed things together and expected them to work but im getting most of what i need. Anyone know why the other things are not being output? I also noticed that the link to the actual product is /product_url.html rather than /category/product_url.html ... i also noticed that both of these URLs are indexed by google… which cant be a good thing for SEO.. but ill post about that elsewhere
	Posted: June 16 2009 \| top \| # 15

Magento Community

Magento Community

Back to top

how to use Promotion.php

Virtual Products

© Copyright 2010 Varien. Magento, eCommerce software, is a trademark of Irubin Consulting Inc. DBA Varien
Privacy Policy|Terms of Service Magento Community Count
177680 users|1162 users currently online|277246 forum posts