Local Sales Tax Mod - Support Thread

[therealex]

The local tax module is working GREAT, but I wanted to add a discount to one of my products (6 for $5, instead of $1 each). Since I couldn't get it to work using the built-in stuff, I used the add-on discount module:
http://www.zen-cart.com/index.php?ma...roducts_id=235

While that works, the tax is calculated based on the original total - not the discounted total. I tried changing the priorities of the discount and tax, but no matter how I set them, it still gave the wrong amount. If anyone has any suggestions, I would greatly appreciate it!

[LadyHLG]

Russ-
Discounting and Local taxes have been a problem for a while.
The issue is because of tax classes. Because the Local Tax Mod is set up to calculate tax based on tax classes, a subtotal is determined for all items in whatever specific tax class the local tax is applied to. Then the local tax is based on that subtotal.
If a discount is applied to the cart total the mod has no way of knowing how much of that discount is applied to each tax class.

I'm sure there must be a way to do this, I just haven't been able to figure it out yet.

LadyHLG

[joudesign]

Hello LadyHLG

Thank you for this mod, I couldnt try it yet, I need to make sure it will solve my problem

I have a shop that will launch soon but the checkout does not count taxes

also when a customer is not logged in, he sees the right price (including taxes) when she is logged in, she sees prices without taxes (I dont want that)

Do you have any idea how to solve this please and if the mod will fix it? (I dont want to complicate the problem if I install another mod)

I appreciate your kind help

[LadyHLG]

joudesign,
This sounds like an issue with your default cart settings. The mod wont take care of this so you will need to find the right settings in the admin. I would suggest posting and searching in the General Questions forum for some assistance, hopefully someone there will be able to point you in the right direction as to where the setting are that are causing problems.
Be prepared to give as detailed a description of what is happening as you can.

Good Luck!
LadyHLG

[robarb]

Hello, LadyHLG.

I absolutely love your local sales tax module and have it working with all 1700+ cities in California. But I have two questions...
1) If a customer enters their city name without proper capitalization, it doesn't get charged tax. I saw a fix on the old forum posting but it doesn't seem to work now. Any ideas?
2) Do you know of any way to correlate the zip code and city (or look up the city based on zip code) to make sure they are properly related?

Thanks again for an incredibly useful mod.

Rob

[LadyHLG]

Rob,
1. As far as my testing has shown the following should work to take care of the city capitalization issue.
At or about line 168:
Change: This

if($myfield == $value){

to this

if(strtolower($myfield) == strtolower($value)){

From what I have seen that works.
If it is not working for you then I will need a more specific example.

2. Unfortunately, the only way this can be done is with some kind of outside address verification, perhaps with the USPS.
I am almost positive the USPS offers this kind of online service but a mod would have be to be written to accomplish it (if there isn't one already, I haven't checked).

LadyHLG

[robarb]

Rob,
1. As far as my testing has shown the following should work to take care of the city capitalization issue.
At or about line 168:
Change: This

if($myfield == $value){

to this

if(strtolower($myfield) == strtolower($value)){

From what I have seen that works.
If it is not working for you then I will need a more specific example.

2. Unfortunately, the only way this can be done is with some kind of outside address verification, perhaps with the USPS.
I am almost positive the USPS offers this kind of online service but a mod would have be to be written to accomplish it (if there isn't one already, I haven't checked).

LadyHLG

Thanks very much for the quick response. I look forward to trying this and will report back.

Rob

[Snicklefritz]

Rob,
1. As far as my testing has shown the following should work to take care of the city capitalization issue.
At or about line 168:
Change: This

if($myfield == $value){

to this

if(strtolower($myfield) == strtolower($value)){

From what I have seen that works.
If it is not working for you then I will need a more specific example.


LadyHLG

Which php file should be modified? All 9 of them or is it only in certain ones?

[Snicklefritz]

Hello, LadyHLG.

I absolutely love your local sales tax module and have it working with all 1700+ cities in California. But I have two questions...
1) If a customer enters their city name without proper capitalization, it doesn't get charged tax. I saw a fix on the old forum posting but it doesn't seem to work now. Any ideas?
2) Do you know of any way to correlate the zip code and city (or look up the city based on zip code) to make sure they are properly related?

Thanks again for an incredibly useful mod.

Rob

Rob,

May I ask what you did to get this working for all 1700+ cities? I've downloaded a csv file posted in an earlier message and am now digging around trying to find out how to upload this using mySQL or whatever it's called...I'd like to do tax rate by city but I can't imagine doing this by hand.