Local Sales Tax Mod - Support Thread

Welcome!

Support Thread for the Local Sales Tax Module
Available for Download --> HERE


I thought it was time to begin a new support thread for the Local Sales Tax Mod mainly because the old thread was getting a bit lengthy and the title was somewhat misleading since the mod has moved way beyond the testing phase.

The previous support thread can be found Here


A Little Info on the Mod
The module should apply tax based on the field you choose options are Zip Code, City, and Suburb.
It should also compound the tax to whatever zone taxes you already have set up.
Which means you can apply multiple taxes to any zone based on different criteria.

Even though this mod does not overwrite any core files or effect any data tables, its ALWAYS a good idea to backup your DB and files.

LadyHLG

I am so happy you have started a new thread for this.

I am having trouble uploading the mod to my site. When I upload the sql file, it just says, "Failed" at the top of my admin panel.

I went through the last thread and saw someone who had the same problem, so I tried to follow the direction there, but was unsucessful. :dontgetit

Please help! Thanks so much!!!

So did you try to copy and paste the sql statment into the text box rather than upload the sql file?

LadyHLG

No way, I have tried that before and it didn't work, but this time it did.

I added a ; at the end of the code and it went through! Zen cart notes "be sure to end with ;"

Awesome Thanks!!! :clap:

Glad to hear things are working.

LadyHLG

I have installed the local sales tax mod

Local Sales Tax Mod for Zen Cart Version 2.2
By:Heather Gardner (LadyHLG)
Based on several prior local sales tax mods.
Modifications by: Qian Gu (guqian)
Support Thread at Zen Cart Fourms --> http://www.zen-cart.com/forum/forumdisplay.php?f=37

and quantity discounts

Quantity Discounts Module for Zen Cart 1.3.5 and above
Version 1.8
Author: Scott Wilson
http://www.thatsoftwareguy.com
Zen Forum PM swguy

and am having problems with my order total. If I change the sort in order total so the quantity discounts come before sales tax, then the quantity discount is not included in the "Total Amount". If I change the sort order so it is after sales tax, then it is reflected properly in the "Total Amount" of the order. Gift Certificates (redeemed) are similar if the sort order is before sales tax in that the "Total Amount" of the order excludes the gift certificate in the calculation. However, if the sort order for the gift certificate is after the sales tax, the "Total Amount" is totally screwed up almost double what it should be. Can someone help me out here?
thanks.....

Update on previous thread on Gift Certificates:



Sub-Total: $5.00

Flat Rate (USPS Flat Rate Shipping): $5.00

98101 SEATTLE 9.00%: $0.90

Gift Certificates: -$8.17



Total: $4.56



In order for the Gift Certificate to calculate, I have to set the sort order after local sales tax. When I do that, the sub-total, shipping, and gift certificate are doubled.

Sub Total = 10.00
Shipping = 10.00
Gift Certificate = -16.34
Sales Tax = 0.90

Total = 4.56

Does anyone know why this is happening? Can you help me out?

I am currently on a deadline with a client, I will try to take a look at your issues when I have completed my current project.
I will help but the bills have to be paid first.
:smile:

LadyHLG

Thanks!!!!

I have until the 21st when the site goes live, so no problem there. I really appreciate your help.

THANKS!!!

Rory,
Still looking into this but I am wondering if you have seen this post:
http://www.zen-cart.com/forum/showth...-calculate+Tax

It appears there is calculation error in the gift cert totals in version 1.3.8. Before we proceed I need to know what effect the bug fix has on the totals you are seeing.

Thanks
LadyHLG