Magento

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.

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

Yes, we need a solution for this!

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

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

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.

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

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!

3rdRock - 17 October 2008 11: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.

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/

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

Click thumbnail to see full-size image

Thank you, your answer was useful!

mlacy - 03 November 2012 02: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

Copy Mage_SalesRule_Model_Validator to your local directory

In 1.7, locate the following around line 280

and above it paste the following

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.

elfling - 03 December 2012 11:42 AM

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.

Thanks a lot elfling, you have save me!

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

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 ?