Free Shipping Coupon & Sales Tax

Zen Cart 1.3.7 w/security patches
Shipping Table Rate (we need to charge sales tax on shipping here in WI only)
Free Shipping Installed
I created a Coupon for "Free Shipping"

I tried several combinations of settings in
ModulesShippingfreeshipper
ModulesOrder Totalot-coupon
I did NOT turn on Free shipping in:
ModulesOrder Totalot-shipping

I cannot find the right combinations of settings to remove the sales tax after applying the coupon code.

Sub Total: $33.00
Shipping (Best Way): $9.50
Discount Coupon: xxXXxxXX : -$9.50
State Sales Tax: $2.34
Total: $35.34

5.5% Sales Tax $2.34 is the correct amount including the shipping, it should be $1.82 after the shipping is deducted.

Let me know if you need more info
JOhn ><>

Is there anyone out there with an idea how to fix this? I need to get this functioning properly ASAP!

LibertyFlag:

Zen Cart 1.3.7 w/security patches
Shipping Table Rate (we need to charge sales tax on shipping here in WI only)
Free Shipping Installed
I created a Coupon for "Free Shipping"

I tried several combinations of settings in
ModulesShippingfreeshipper
ModulesOrder Totalot-coupon
I did NOT turn on Free shipping in:
ModulesOrder Totalot-shipping

I cannot find the right combinations of settings to remove the sales tax after applying the coupon code.

Sub Total: $33.00
Shipping (Best Way): $9.50
Discount Coupon: xxXXxxXX : -$9.50
State Sales Tax: $2.34
Total: $35.34

5.5% Sales Tax $2.34 is the correct amount including the shipping, it should be $1.82 after the shipping is deducted.

Let me know if you need more info
JOhn ><>

LibertyFlag:

Is there anyone out there with an idea how to fix this? I need to get this functioning properly ASAP!

If I am understanding correctly, it looks like your sort order is incorrect. Whatever the sub-total sort order is (eg. 100), make the sales tax next (120), then the shipping (200), then the coupon (300). These options are in the modules/order total in admin and the numbers I use are just examples. It will then figure the tax on the sub-total before the shipping is figured in.

Dennis
www.stampdays.com

This is what I have. Not positive about the logic, but I am assuming that Everyting above 300 Tax is calculated in the tax field and everything below is not - Correct?

So in my above example the shipping and the associated discount are above (200) both the charge and the discount should be calculated in the tax figure.

COD Fee 950

Discount Coupon 280

Group Discount 290

Gift Certificates 840

Low Order Fee 400

Quantity Discount

Shipping 200

Sub-Total 100

Tax 300

Total 999

JOhn ><>

Just thinking out loud (very dangerous)...

If shipping in WI is taxable, would the tax on shipping not still be due
by either you or your customer?

TShooters:

Just thinking out loud (very dangerous)...

If shipping in WI is taxable, would the tax on shipping not still be due
by either you or your customer?
I had that discussion with our sales department and they said that it was not. I probably need to send it to accounting to verify.

Thanks for the thought.
JOhn ><>

LibertyFlag:

This is what I have. Not positive about the logic, but I am assuming that Everyting above 300 Tax is calculated in the tax field and everything below is not - Correct?

So in my above example the shipping and the associated discount are above (200) both the charge and the discount should be calculated in the tax figure.

COD Fee 950

Discount Coupon 280

Group Discount 290

Gift Certificates 840

Low Order Fee 400

Quantity Discount

Shipping 200

Sub-Total 100

Tax 300

Total 999

JOhn ><>

The sort order looks correct for what you want, but there is an option in the shipping mdules for a Tax Class. It might be overriding that sort order if it is set to taxable goods (I have never set that option so this is just a guess).

Tried it on - Tried it off and no success. That's why I came to the group, I thought maybe there was some magic combination of attributes on and off.

I'll keep trying. Hopefully someone will have the answer before I pull the rest of my hair out.

Thanks
JOhn ><>

Good luck!

LibertyFlag:

Tried it on - Tried it off and no success. That's why I came to the group, I thought maybe there was some magic combination of attributes on and off.

I'll keep trying. Hopefully someone will have the answer before I pull the rest of my hair out.

Thanks
JOhn ><>

Looks like we both confused ourselves on this one. Your sort order is incorrect, the tax is being figured after the shipping, not before. My eyes were playing tricks on me when I answered the first time. Set your tax somewhere between the subtotal and the shipping and see what happens!

sub-total = 100
tax=200
shipping=300

awhfy99:

Looks like we both confused ourselves on this one. Your sort order is incorrect, the tax is being figured after the shipping, not before. My eyes were playing tricks on me when I answered the first time. Set your tax somewhere between the subtotal and the shipping and see what happens!

sub-total = 100
tax=200
shipping=300
I didn't think I was confused. The Shipping HAS to be taxed in WI. The shipping 200 has to be above the tax 300

The real concern here is why is it not discounting the FREE SHIPPING before it calculates the tax?
JOhn ><>

LibertyFlag:

I didn't think I was confused. The Shipping HAS to be taxed in WI. The shipping 200 has to be above the tax 300

The real concern here is why is it not discounting the FREE SHIPPING before it calculates the tax?
JOhn ><>

OK. I think I see what you mean. Looks like I was a little confused to begin with, and hopefully I am not now.

The coupon will never refund any excess taxes paid on the shipping charge and the shipping charge automatically. My first choice would be to try the option listed below, but a quick fix would be to add the 5.5% of your $9.50 coupon to make it a $10.02 coupon ((5.5%x$9.50)+$9.50)= $10.02. Your coupon would then be $10.02 and do both as it would then refund the shipping and the excess tax on the shipping. I do not know what this would do to any bookkeeping issues that your client may have but as along as the state and the customers are happy!

What you may want to try is to ditch the coupon and install the "Free Shipping" module. The options I would try are Free Shipping Cost" = $9.50, Tax Class set to taxable goods , Shipping Zone set to WI. and the sort order set to 280. I do not use that mod so I am assuming that those options are there for that reason.

Hopefully, one or the other options will work for you.