Local Sales Tax Mod - Support Thread

[potteryhouse]

I am trying to use this add on for zencart 1.51, specifically for san francisco sales tax which is higher than the California sales tax. I have it installed properly and am using these zip codes but its still not working:

94102;94103;94104;94105;94107;94108;94109;94110;94111;94112;94114;94115;94116;94 117;94118;94121;94122;94123;94124;94127;94129;94130;94131;94132;94133;94134;9415 8

and I have it set to zipcode. Can somebody tell me if they are having trouble with their add on?

If you do not already have the zone setup, this SQL should add the San Fran 1% additional tax to the table, make sure you verify the zip codes and additional sales tax before you use this:

INSERT INTO tax_rates_local (`zone_id`, `local_fieldmatch`, `local_datamatch`, `local_tax_rate`, `local_tax_label`, `local_tax_shipping`, `local_tax_class_id`) 
VALUES
	(12, 'postcode', '94102;94103;94104;94105;94107;94108;94109;94110;94111;94112;94114;94115;94116;94 117;94118;94121;94122;94123;94124;94127;94129;94130;94131;94132;94133;94134;94158', 1.0000, 'San Francisco (1.0%)', 'true', 1);

Make sure that you have turned this mod on (see previous post) and set the other items listed in the readme file.
If this does not work we will need more info as to what is happening to make suggestions.

[potteryhouse]

I overlooked a blank space in one of the zip codes "94 117" in the post above, that needs to be removed. There should not be spaces in any of the zip codes.

[noyloza]

thank you ver much for your help, however I don't know how to implement an SQL, can you tell me how to do this?

[noyloza]

I have activated the module in modules / order totals, and the rate is set in Locations > local sales taxes as well...

It just always picks up CA tax over the SF tax... Please let me know how I can install that SQL...

[lhungil]

... It just always picks up CA tax over the SF tax...

Do you mean it is showing "California Tax" and "San Francisco" Sales Tax lines? This module will add a "tax line" for every valid tax rate which matches the tax rules defined in both Zen Cart and Local Sales Taxes ("admin" -> "locations / taxes" -> "local sales tax"). So if you have a rate defined for both "California Sales Tax" and "San Francisco Sales Tax", I would expect to see both as long as the "tax rules" are correctly defined.

... I don't know how to implement an SQL ...

To add, remove, or modify rules for how tax rates are applied to an order you do not need to use SQL... You can just navigate to "admin" -> "locations / taxes" -> "local sales tax" and enter the rules for your location (by zipcode or city name). Matching by "suburb" is not currently supported. Most of the "how do I do configure taxes" is outlined in the "HowTo-Example.pdf" (included in the downloadable distribution).

[noyloza]

it only picks up CA, and never SF for a user who is based in SF and has one of the zipcodes set in the rules for the local sales tax mod. I added all of the zipcodes, set to zipcode, and use SF as the description. I'm assuming that if the mod picks up the user who is using a zip code for shipping that is one of the ones I have set to find, it will apply SF(8.75%) as the tax instead of CA (8.25%). Right now however, it is only picking up CA for a user who is using shipping in SF...