9

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?

Mark Robinson
  • 1,479
  • 2
  • 15
  • 34

3 Answers3

11

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).

benmarks
  • 23,384
  • 1
  • 62
  • 84
  • I know it's an old question but do you know if catalog price rule set special_price? I tested your suggestion regarding my issue (http://stackoverflow.com/q/11718504/281258) but no luck. – Ovidiu Jul 30 '12 at 11:27
  • 1
    Price rules will *not* set this at the database level. – benmarks Jul 30 '12 at 12:21
  • Yes, I tested and just saw this. Thanks anyway. – Ovidiu Jul 30 '12 at 12:31
  • 2
    This doesn't work if you use scheduled sales since your special price won't be 0 but it will no longer be on sale. – Mike Jul 16 '14 at 19:54
6

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.

riotgirl85
  • 61
  • 1
  • 1
  • 1
    Wouldn't this solution have some false positives? For example, what if the special price is set, but the product is not currently being sold at full-price (because of "Special price (to|from) date") Edit: Just saw that the OP did say "Products that have a Special Price set", but understand that this is not the same as "already discounted" – Eric Seastrand Nov 26 '14 at 16:36
2

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!

Matt
  • 21
  • 2