Local Sales Tax Mod - Support Thread

[Snicklefritz]

In the cart admin go to Tools -> Install SQL Patches

From there you can either upload the sql file or copy and paste the contents of the file.

Good Luck,
LadyHLG

I tried what you suggested when I tried to upload but nothing new appears in Modules..Order totals. What I see is shown below.
I thought maybe I did something wrong so I tried cutting and pasting but I get an error saying the following:
Failed: 1
Error ERROR: Cannot create table tax_rates_local because it already exists
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.


=====================

COD Fee
Discount Coupon
Group Discount
Gift Certificates
Low Order Fee
Shipping
Sub-Total
Tax
Total
Module Directory: /Applications/XAMPP/xamppfiles/htdocs/Store/includes/modules/order_total/

[Snicklefritz]

Update: I went back through some of the earlier threads and noticed that a similar problem was described in posts 16 and 40. I made sure to include the semicolon when cutting and pasting, but unlike in post #40, that didn't solve the problem. I also looked in my zencart database and on the bar on the left I see tax_rates_local listed there. When I click on it, I see 8 different fields listed in the center of the screen, including "local_tax_id", "zone_id", "local_fieldmatch"...

So it appears the table is in the database, but this is getting into things I'm not that familiar with but hopefully there's a simple explanation for what's going on.

[LadyHLG]

Snicklefritz,
Unfortunately, if you are not seeing the mod listed under Modules -> Order Totals then the most likely reason is you have not copied all of the files over correctly.

I'm afraid that is about as much as I can help at this point based on the info so far.

LadyHLG

[Snicklefritz]

Snicklefritz,
Unfortunately, if you are not seeing the mod listed under Modules -> Order Totals then the most likely reason is you have not copied all of the files over correctly.

I'm afraid that is about as much as I can help at this point based on the info so far.

LadyHLG

Maybe part of the problem is the Admin folder. There are two admin folders, htdocs/Admin and htdocs/Store/Admin.

I put the local_tax files in the first one, but after moving them to the second one then it installed properly. Makes me wonder why there are two admin folders, but at least the tax thing installed...

[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.

[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]

edit: Thanks LadyH for helping me get this far. I know my questions are pretty basic but thanks for taking the time to answer them. I'm now able to create test customers and see that the tax is being calculated correctly for the few cities that I have entered manually.

[jprough]

Hi Snicklefritz, Here is what I found when I was looking in to this for a customer of ours.

First I would suggest you refer to Publication 105 at the California Board of Equalization web site. After finding this document in a Google search I actually called the California Board of Equalization for clarification.

Long story made short. You don't have to charge each individual district rates. You only have to charge for the district(s) you hold a business presence in. The catch here is that if you deliver out side of your district using your company vehicle, the you have a presence in that district, and there for have to collect the tax. Any California orders out side of districts you have a presence, IE you ship via Fedex,UPS or USPS you are only required to collect the California sales tax of 8.25%.

What we did was set up a zone for Ca of 8.25. Then used this mod to ad one more zone with each zip code with in this costumers county. Any one with one of these zip codes gets charged an additional 0.5%

Hope this helps

This Local Sales Tax Mod made it a lot easyer than we expected. This is a great mod, Thanks LadyHLG

[Snicklefritz]

Hi Snicklefritz, Here is what I found when I was looking in to this for a customer of ours.

First I would suggest you refer to Publication 105 at the California Board of Equalization web site. After finding this document in a Google search I actually called the California Board of Equalization for clarification.

Long story made short. You don't have to charge each individual district rates. You only have to charge for the district(s) you hold a business presence in. The catch here is that if you deliver out side of your district using your company vehicle, the you have a presence in that district, and there for have to collect the tax. Any California orders out side of districts you have a presence, IE you ship via Fedex,UPS or USPS you are only required to collect the California sales tax of 8.25%.

What we did was set up a zone for Ca of 8.25. Then used this mod to ad one more zone with each zip code with in this costumers county. Any one with one of these zip codes gets charged an additional 0.5%

Hope this helps

This Local Sales Tax Mod made it a lot easier than we expected. This is a great mod, Thanks LadyHLG

Many thanks for your post. This simplifies things considerably! Looks like I just have to add the info for zipcodes in alameda county.

[Snicklefritz]

To jprough:

I set this up and am able to get the correct taxes when shipping addresses are within my county. However, no tax is charged when the shipping addresses are within california, but outside my county.

The drop down menu for field selector is showing zipcode, city and suburb. I'm using version 2.0a of this mod in case that makes a difference. What should I change to fix the problem I'm having?