Local Sales Tax Mod - Support Thread

[LadyHLG]

Cafinity,
Check your mod sort order.

LadyHLG

[Cafinity]

Okay, it's chargeing the local sales tax and adding it to the total,
but it is not displaying the actual tax ammount.
The display show state sales tax 0 which is correct. (No state tax for this product) There is no display for the local tax ammount but it is added to the total ammount. How do I get the local tax to display?

[LadyHLG]

Cafinity,
I think you still need to adjust the sort order some more.

Make the sort order for the local sales tax mod lower than that for the tax. So if your tax sort order is 300 make the local sales tax 299.

LadyHLG

[Cafinity]

That was the fix.
Thankyou for your help

[psychicpet]

I have been using this mod successfully for about a year and I am about to set up a new site. Since CA just had a major update to most of its local tax rates I was wondering if I could just use MySQL to upload the new rates. I was able to download all the rates from the BOE's website in the following format:

City Tax County

Acampo 8.750% San Joaquin
Acton 9.250% Los Angeles
Adelaida 8.250% San Luis Obispo
Adelanto 8.750% San Bernardino
Adin 8.250% Modoc

Problem is, I am not too sharp with MySQL... Can anyone assist with this? I am also attaching the 2009 CA City rates for anyone else that might need them (csv format)!

[psychicpet]

Here is that file... I had to save it as a CSV to meet the forum file size guidelines.

[LadyHLG]

psychicpet,
Are you using these rates strictly as a city name match or are you using them in some combination with the county name for more specific tax matches? Each solution will require a very different set up.

LadyHLG

[m4w29c]

Here is that file... I had to save it as a CSV to meet the forum file size guidelines.

DUDE!!!!! YOUR ROCK!!!!


I have been trying to get these rates for a week now! THANK YOU! THANK YOU! THANK YOU!!!!

[psychicpet]

LadyHLG,

I have one site where I did it all by zip code without using the CSV info I posted. I am setting up a new site and I am hoping to do it by city.

Anyone have advice on how to upload that data via MySQL?

thanks

[LadyHLG]

psychicpet,
In order to upload the data you will need to get the data organized first. The data provided as is from the state of CA will not work as I am sure there are duplicate city names (this happens when a city spans more than one county and therefore may have different tax rates for different parts of the city in each county). The only way you can have duplicate city names is if you are using counties as zones and each city name is linked to a different zone (i.e county). This is not a simple process, but is much more accurate than assigining a single tax rate to a city name.

If you do not want to use the cities by county method then you will have remove all the duplicate city names otherwise you will run into problems with the tax mod.

Once you get the data organized that far I can help you get it into the proper format to upload via mysql.

LadyHLG