Discount Coupon - Minimum Order Value Excluding Tax

[allmart]

Hello All,

I am wondering if anyone has a suggestion for an issue I am having. Living where I do, we are blessed with sales tax (lucky us). When creating discount coupons I want to be able to have the minimum order value to qualify for the discount to exclude sales tax. Say $100.00 before tax.

Thanks in advance for your help!

[mc12345678]

Hello All,

I am wondering if anyone has a suggestion for an issue I am having. Living where I do, we are blessed with sales tax (lucky us). When creating discount coupons I want to be able to have the minimum order value to qualify for the discount to exclude sales tax. Say $100.00 before tax.

Thanks in advance for your help!

Well, a couple of questions back, what has been observed in trying to use a coupon code with a minimum order of $100?
Is the catalog side set to display prices with tax?

It looks like the ot_coupon code has a few issues... There is a setting in the admin under modules->Order Totals specific to ot_coupon where tax can be included or not; however, that doesn't seem to quite work as intended throughout. I found then also that if a product were restricted (not to be used for the coupon) and the customer's zone was not in the same tax zone as the tax that was being added, it is possible that the tax would not be properly considered when addressing the tax of the restricted product...

I did find with a relatively minor change to the code that allowed product could be determined by a minimum price that is based on the price of the product excluding tax, but other settings and as I said product restrictions could cause issue with minimum order totals when using the coupon. :/

I plan to look at it more, but there's a lot involved in testing by having at least three screens open (code, catalog and admin for reference/response review).

[allmart]

The catalog is set to prices excluding tax and if it helps I am only using 1 zone.
Thanks for your help!!!

[lat9]

What are your order-total sort orders? Is the ot_coupon's sort-order lower than that for ot_tax?

[allmart]

Order-total sort order is 999 and ot_tax is 300.

[mc12345678]

Order-total sort order is 999 and ot_tax is 300.

What about ot_coupon?

[allmart]

Sorry for the late reply the ot_coupon is 280

[lat9]

What is your store's setting for Configuration->My Store->Display Prices with Tax?

[allmart]

Display Prices with Tax: false

[lat9]

All those settings look good. I just created a product with a 99.99 price and a coupon set for a minimum order of 100.00. When I applied that coupon to an order containing only that product, I received the message "You must spend at least $100.00 to redeem this coupon".

Am I misinterpreting your original question? Were you indicating that the coupon wasn't working or asking how to set that coupon up?