Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Pricing Rules Based Upon Special Price or Original Price
 
3rdRock
Member
 
Total Posts:  47
Joined:  2008-09-08
 

Currently, all promotional pricing goes based off of Special Price, so you can run into issues where you could be giving away products on your website.

For example, you are selling a product for $50 and give a coupon that discounts the item by $25. Let’s say down the road you decide that you want the price to be on sale for $25 for everyone. The coupon would then give customers the product for $0.

For a tiny store with few coupon codes, this may not be a problem, but it will be for anyone with pages of coupons.

 
Magento Community Magento Community
Magento Community
Magento Community
 
JamesBee
Jr. Member
 
Total Posts:  26
Joined:  2008-01-02
 

I second this request. We have sent out coupons to customers that are unqiue to them. Some offer up to 20% off. Currently if we run discounts for everyone using the catalog price rules then the customers with coupons are getting their discount on top of the catalog discount which is more than we intended when the coupon was first created.

Surely we need an option to only apply the coupon discount to the original price.

Regards

James

 
Magento Community Magento Community
Magento Community
Magento Community
 
plamenski
Member
 
Total Posts:  35
Joined:  2009-01-04
 

Yes, we need a solution for this!

 
Magento Community Magento Community
Magento Community
Magento Community
 
plamenski
Member
 
Total Posts:  35
Joined:  2009-01-04
 

I have the products with special prices in Offers category. So I set up a special condition for the coupon which excludes products from this category.

If ALL of these conditions are TRUE
Category is not 82

 
Magento Community Magento Community
Magento Community
Magento Community
 
Ponnu Kumar
Jr. Member
 
Total Posts:  3
Joined:  2010-07-19
 

Hello Guys,

I was able to apply discount to work only on full price Ie. doesn’t work on sale/special price of the products.

My Steps to achieve this functionality:

1) Open the source app/code/core/Mage/SalesRule/Model/Validator.php
2) Modify function process() as below:
Add the following lines

$productId $item->getProductId();
$product Mage::getModel('catalog/product')->load($productId);
$baseItemPrice $itemPrice $product->getPrice();
right after
if ($itemPrice !== null{
       $baseItemPrice 
$item->getBaseDiscountCalculationPrice();
else {
       $itemPrice 
$item->getCalculationPrice();
       
$baseItemPrice $item->getBaseCalculationPrice();
}
3) Open the source app/code/core/Mage/Sales/Model/Quote/Item/Abstract.php
4) Modify function getPrice() as below:
public function getPrice()
{
    $productPrice 
$this->_getData('price');
    
$quoteObj=Mage::getModel('sales/quote')->load($this->getQuoteId());
    
$quoteCouponCode $quoteObj->getCouponCode();
    if (
$quoteCouponCode!=''){
         $productId 
$this->getProductId();
         
$product Mage::getModel('catalog/product')->load($productId);
            
         
$item Mage::getModel('sales/Quote_Item')->load($this->getItemId());
         
$discountAmount $item->getDiscountAmount();
         if (
$discountAmount>0){
             $productPrice 
$product->getPrice();
         
}
     } 
     
return $productPrice;
}

I know this is a very late reply but someone searching the forums may find it useful.

Yeah, one has to extend the above class files accordingly in an upgrade-safe way.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lakime
Jr. Member
 
Total Posts:  8
Joined:  2011-07-21
 

Thanks, Ponnu Kumar
That is brilliant, and I am sure it helped many.
After we do that, how do we apply it in the rule?
I thought it would be in the drop down of the Actions tab when crating a rule.
Sorry, but I hope you can help with this as well…
Shadi

 
Magento Community Magento Community
Magento Community
Magento Community
 
Alexandrable
Member
 
Total Posts:  55
Joined:  2011-09-01
 

Hey, 3rdRock

I’m not sure this is still relevant, since the post was made a while ago, but I found it just now and wanted to advise. To set the custom price according to your specific requirements, you can use this: http://www.mag-manager.com. This is kind of a helper in the management of your whole store, not only the pricing. And you might not need everything that’s there, but you should definitely get what you need out of it.

Hope this helps!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Amasty
Mentor
 
Avatar
Total Posts:  3988
Joined:  2009-11-10
 
3rdRock - 17 October 2008 10:50 AM

Currently, all promotional pricing goes based off of Special Price, so you can run into issues where you could be giving away products on your website.

For example, you are selling a product for $50 and give a coupon that discounts the item by $25. Let’s say down the road you decide that you want the price to be on sale for $25 for everyone. The coupon would then give customers the product for $0.

That can be easily prevented using Special Promotions extension, which allows to exclude items on sale from being discounted with coupons.

 
Magento Community Magento Community
Magento Community
Magento Community
 
pradeep_kumar67
Sr. Member
 
Avatar
Total Posts:  160
Joined:  2010-06-24
Bangalore
 

Thanks, Ponnu Kumar

I also faced same prob but little different logic i\\\\\\\\\\\\\\\’e i want special price Minus coupon discount of original price

i solved this issue and i posted you can check it
http://www.magentocommerce.com/boards/viewthread/270167/

 
Magento Community Magento Community
Magento Community
Magento Community
 
mlacy
Jr. Member
 
Total Posts:  5
Joined:  2010-04-25
 

There is a much simpler way.  See attached.

Make the condition

If ALL of these conditions are TRUE :

to

If ALL of these conditions are FALSE :

Then

Special Price equals or greater than 0

Image Attachments
pricerule.gif
 
Magento Community Magento Community
Magento Community
Magento Community
 
JustinasLelys
Jr. Member
 
Total Posts:  8
Joined:  2010-04-23
 

Thank you, your answer was useful!

mlacy - 03 November 2012 01:52 PM

There is a much simpler way.  See attached.

Make the condition

If ALL of these conditions are TRUE :

to

If ALL of these conditions are FALSE :

Then

Special Price equals or greater than 0

 
Magento Community Magento Community
Magento Community
Magento Community
 
elfling
Enthusiast
 
Avatar
Total Posts:  901
Joined:  2008-10-21
 

Copy Mage_SalesRule_Model_Validator to your local directory

In 1.7, locate the following around line 280

if ($itemPrice 0{
            
return $this;
        
}

and above it paste the following

$productId $item->getProductId();
        
$product Mage::getModel('catalog/product')->load($productId);
        
$basePrice $product->getPrice();
        
        
        
        if (
$baseItemOriginalPrice $basePrice) return $this;

This will prevent discounts for products that are already on sale, products that have tier based pricing and compensate for changes in currency.

So, those of you looking for the fix to prevent sale / special prices and tier prices from being discounted, this easy fix above will help you. Really this should be default functionality of Magento and just a drop down of the rule to say, include Special Price and Tier Priced Products… Yes, No.

 
Magento Community Magento Community
Magento Community
Magento Community
 
elfling
Enthusiast
 
Avatar
Total Posts:  901
Joined:  2008-10-21
 

Glad I could help. Must cost businesses a fortune in the long run.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Mounish
Jr. Member
 
Total Posts:  14
Joined:  2010-09-22
 

I want to apply Catalog Price Rules to Special Price of Products.

I have a lot of products in my site with special price. Now i want to apply an additional discount using catalog price rules to that same products with special prices. Its not possible by default in magento. Ho to achive this functionality ? Catalog price rules doesnt applies to Special priced product.

Eg:
Price : 1000
Sp Price : 800

Catalog Price Rule : 10% Discount

Final Price : 720 (i.e 10% Discount on Special Price : 800)

How could this be achived ? Is it possible ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Ollieno
Jr. Member
 
Total Posts:  2
Joined:  2009-12-22
 

Is there some module out there that is able to accomplish this?

price: 100
special price: 90
discount by catalog price rule: 10%

result: 90 - 9 = 81

In other words. Instead of…
By Percentage of the Original Price
is there some module enabling
By Percentage of the End Price

End price of course being the price or if the item has a special price, the special price

Kind Regards
Jeroen Olthof

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top