Shopping Cart Price Rule that excludes products on special

Question

I'm trying to create a Discount coupon that won't reduce the price of products already on sale. Is there a way to do that?

Answer 1

Admin > Catalog > Manage Attributes:

• Edit special_price attribute, setting "Use for Promo Rule Conditions" to "Yes"

Add special_price = 0 condition to your coupon logic (test this of course).

Answer 2

For anyone still trying to figure this out as I was, this is the answer:

First change the special price attribute as benmarks advises above.

Go to your price rule, under the actions menu find the section "Apply the rule only to basket items matching the following conditions (leave blank for all items)"

Set the conditions to

If ALL of these conditions are FALSE :

Special Price equals or greater than 0.01

this way the discount is applied only to the products that are NOT on special. I found that every other way threw an error when there was a mixture of special price and full price products in the basket.

Answer 3

This may be an older post but I just went through the same process in Magento 1.9.3.2 and here is how I was able to apply a promo code to all items excluding sale/special price items:

---

Manage Attributes:

Set change special_price attribute to "Yes" for "Use for Promo Rule Conditions"

"Rules" under "Actions" tab in Shopping Cart Rules:

If ALL of these conditions are FALSE :

Attribute " Special Price " is not assigned
Special Price equals or greater than 0.01

---

Hope this helps!