OpenCart Community

Here's a quick vQmod script for preventing coupons from applying to products that are on special

If you have 2 products:
Hat - 20.00
Shirt - special for 15.00

Coupon for 50% off would normally give a total of:

20.00 * .50 = 10.00
15.00 * .50 = 7.50
Total: 17.50

This mod will ignore the products that are on special from getting the additional discount:
20.00 * .50 = 10.00
15.00 (special ignored) = 15.00
Total: 25.00

Great! I needed this badly! Thanks Q.

Just curious where does this get applied to? where do i go to input this mod?

COMPACTER wrote:Just curious where does this get applied to? where do i go to input this mod?

Never mind i figured it out, works great thanks

Any chance this will be updated to work with OC 1.5?

Updated file in first post for 1.5.x support
Same file works on both 1.4.x and 1.5.x

Just tried this vQmod. It said "Coupon applied succesful", although its' shown value was zero at checkout. Any solution to display "Coupons are not eligible for special products"?

This is just how it works.. It prevents the coupon discount from applying to products on special. It doesn't prevent coupons from being entered tho. If you had 2 items in your cart, and one was on special, it would only apply the coupon to the non-special item.

Oh, didn't try it with 2 products. That's good though.

Thank you!

This mod works great however I like to suggest a pop-up or remarks to inform customer that special items are not eligible for coupon discount.

Is that possible?

EXCELLENT !!!! THANKS

Thank you!

Thank you! Can check something else off my "need to fix" list!

Thx for this Vqmod. Works likes a charm !

Is there a possibility to use or modify the file for Voucher ?

Angelheart29 wrote:Is there a possibility to use or modify the file for Voucher ?

I know that if someone had bought me a gift voucher to a website and then when I went to use it on a product I couldn't as it was already on sale would disappoint me, stopping an already discounted item from being discounted further is one thing but this seems to be penalising your customers for buying and using a gift voucher from you instead of using cash...

Just my opinion from the side of a customer as well as a eCommerce website owner.

I tried with $5.00 discount with one special product it shows coupon = $0.00

but

when I tried with 2 products 1 Special & 1 Regular the coupon set discount of $5.00 is showing less actually, it showed $4.38

Any idea why it is not showing the right amount as per coupon.


Thanks

The product is that this mod is not taking into account fixed/percentage correctly. When using a fixed discount the sub total also needs to exclude items that are on special.. I played around with the coupon system today and got it working but it requires more then this mod details.. correct me if I'm wrong.

The mod does account for fixed / percentage correctly, it just depends on your definition of correctly!

There are two ways this COULD work, but obviously only 1 of those options can actually be applied (without a lot of headache and extra options in admin pages etc etc etc)...

NB: In the following examples I will use Prod 1 = $20.00, Prod 2 = $10.00, Basket total = $30.00

Method 1: Fixed discounts could / should be deducted from the basket total, so a discount code for $10 is always $10
Method 2: Fixed discounts get deducted as a percentage per product

Example method 1: Basket total = $30 :: Discounted total = $20
Example method 2: Prod 1 discount = $6.6666, Prod 2 discount = $3.3333 :: Total discount = $9.9999 :: Discounted total = $30 - $9.9999 = $20.0001

I'm not quite sure why, but when the mod was written it was obviously decided that method 2 was the way to go.

As a result of this, when we apply the FREE vqmod above which skips products with special prices, the portion of discount that would have been applied to that product is no longer applied, so if Prod 1 was actually using a special price, the discount would get ignored and the basket total would become:

Prod 1 discount: *skipped*
Prod 2 discount: $3.3333
Total discount: $3.3333
Discounted total: $30 - $3.3333 = $26.6667

In order to get method 1 working, you would need to disable the "fixed rate" portion of the existing coupons code, then add some new code elsewhere which deducts the fixed rate discount from the final basket price (and adjusts taxes accordingly too).

[EDIT] As far as I can tell, it has been written this way so that a discount code cant cause a product to become a loss for the retailer, e.g. if I reduce the sale price of a product to my cost price (e.g. because I want to clear the stock) then I don't want someone to be able to get 10% off that price as this would mean they have bought the product from me for less than what I paid for it from my supplier!

OC 1.5.5.1

i have 2 products in cart
1. 189 (normal price)
2. 159 (special price from 189)

my coupon value is 100 (not percentage) . After applying the coupon it shows a discount of 54...
We don't have VAT or any kind of other taxes.

Why is the discount 54 and not 100?

markdyer wrote:The product is that this mod is not taking into account fixed/percentage correctly. When using a fixed discount the sub total also needs to exclude items that are on special.. I played around with the coupon system today and got it working but it requires more then this mod details.. correct me if I'm wrong.

If you made it work, can you please help me, i can't do it myself.