The Local Sale Tax module was disabled, once enabled, it worked perfectly.Quote:
Originally Posted by lhungil
I wouldn't been able to figure that out by myself.
Thanks for your help. :clap:
Printable View
The Local Sale Tax module was disabled, once enabled, it worked perfectly.Quote:
Originally Posted by lhungil
I wouldn't been able to figure that out by myself.
Thanks for your help. :clap:
Thank You for letting us know Cannot believe I forgot that step in the readme :PQuote:
Originally Posted by dbpiano
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?
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:Quote:
Originally Posted by noyloza
Make sure that you have turned this mod on (see previous post) and set the other items listed in the readme file.Code: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);
If this does not work we will need more info as to what is happening to make suggestions.
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.
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?
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...
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.Quote:
Originally Posted by noyloza
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).Quote:
Originally Posted by 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...