Super California Sales Tax Add-on

Hi. I apologize for not understanding how to set up this module. I performed a test transaction and my program could not calculate shipping. I received the following error: > 1146 Table '(password)_(databasename).local_cities' doesn't exist

in:
[SELECT rate FROM local_cities WHERE city='Novato']

I do have the city of Novato in the database.

I am thinking there may be a problem in that I am using the Ceon Advanced Shipper shipping module.

Alternatively, the above post shows that my zone has a red light stating it is not configured.

Have I missed something, or should I uninstall the module and assume it will not work with Advanced Shipper?

If I uninstall the module, I suppose I could just make a zone for each tax rate in California, add that to the zone definitions, and then activate the zones and tax rates for each.

What do you think?

If no responses, I will probably just uninstall and try making the zones manually. What have people done who do not use this module, to accommodate the new California tax rules?

Thanks.

Notageek

I seem always to ask questions before trying solutions. I recalled posts #14 and #16 where the solution was to remove the table prefix, so I did take out my table prefix, and now I have a "local cities" table and the program works wonderfully.

Whew.

I guess I am not the adventurous type and my reserve for troubleshooting is usually low. But at least this forum allows one to sustain hope and nerve by just talking it out and examining the possibilities, bit-by-bit.

Thanks again for the module.

Blunderingly,
Notageek

I might investigate putting the table prefix into the SQL file, because with future updates of Zen Cart versions, there would be a continuing problem of needing to recall that the "local cities" module did not have the prefix.

Perhaps this would be something that could be incorporated into the instructions.

Notageek

notageek:

I might investigate putting the table prefix into the SQL file, because with future updates of Zen Cart versions, there would be a continuing problem of needing to recall that the "local cities" module did not have the prefix.

Perhaps this would be something that could be incorporated into the instructions.

Notageek

So is this the only module that you found to install the california tax tables into the db?

Did you get this module to work properly? I tried to install it and got errors from the admin>tools>Install SQL patches section when trying to upload the .sql files

I uploaded the file structure for the mudule and tried it out (i knew it wouldnt work without the sql patches but tried anyway) and got more errors.

If you got this to work, is there any way you can provide a zip of your files? I would love to be able to have my site calculate tax for every county/city automatically. Otherwise I will probably end up with a conversation of "Sorry but our web designer (me) sucks and he didnt include this incredibly essential feature. Now I have to charge you another $50 to your order because you live in Costa Mesa"

I am VERY green when it comes to adding, editing or even thinking about the mySQL db.

wendyandmilo:

hliang,
ok, try this for the coupon fix. Just upload the two files to your cart.

Order_total modules:
ot_city_tax: 250
ot_coupon: 280 (false, false, standard)
ot_shipping: 400
ot_subtotal: 100
ot_tax: 300
ot_total: 999

Let me know if that works for you! If it does, I'll see about the low order fee and whatnot.

Wendy

I got a chance to test the v3.0 update today, found the following issues:

1. The sales tax does not change when the shipping address change, instead it follows the billing address change. Shouldn't the sales tax be based on the ship to address?
   Example, when my billing address is Los Angeles, shipping address is costa mesa, the sales tax rate follows Los Angeles County 8.75%. But if i change my billing address to Costa Mesa, the rate changed to Orange County 8.5%
2. Aside from #1 issue, when i apply store coupon, the tax is recalculated by after the discount amount, but the $$ a little bit off, like a few cents different.

Any Idea?

Issue #2 in Know issues -- IS my issue. Can you post which lines to remove.

If you already posted, I'm sorry, I couldn't find it.

I have applied your very cool mod for Arkansas and it will display the city tax but not the AR State tax.

I belive the code change you mention is what I need. If not, I'll make my own adjustments.

Thanks!

I installed this module and it works fine for California. We also charge taxes in Arizonia but it does not calculate Arizonia sales tax unless I set ot_tax to a lower sort order than the city tax. Am I missing something?

sorry to bother you. read everything still having issues.

sql patches will not upload.

fixed the ; in syntax error
rearranged to order total sort orders

sql patches will not upload.
tried by copy and paste,
tried by admin,
tried combining both files to one file.

read instructions and followed, read posts and followed.

getting frustrated..been at it for hours now. need help please.

ready to go live in 2 weeks (or less)

ok fixed it on my own. posting how to here (at least what i did)

first fix the syntax error ; missing at local_cities (city, rate, county) VALUES ('Base Line', 8.75, 'San Bernardino County');

took the 2 sql files and made it into one file.

went to "phpmyadmin" in cpanel removed the zen_local_cities folder from the database.

went to zc_admin install sql patches and uploaded the new file.

took like 2 seconds..no errors

works great

backup.backup.backup:D

sorry everyone for the learning curve on this one. v 1.50

when i run a "test" i can add to cart, shows shipping by ups (added module) chose shipping rate the hit continue (checkout_payment) and i get "error, please refresh page" and the page is blank.

i must be missing a step somewhere. everyone else seems to have much more complicated issue than i do.

also installed the export files, but they do not appear on the admin. must be missing something there too.

based in california, sell to california and all us states and us territories.

might be missing rates, zones, something but i have 2 days on this now and i really need to get this going. please help.

fixed it!! happy now.

ok so what i did is take the ot_city_tax.php and changed the 2 places where local_cites SHOULD be zen_local_cities..saved it....ran my test and worked perfectly. even added the tax and shipping correctly...ready for credit card input which i have already mastered.

do not forget to fix the syntax error ;

should work exactly as intended...now for the rest of the usa.

i guess this is the layman's way to say how to fix this module so it works.:yes:

still have to figure out the export_tax to an excel spreadsheet..but all is well in cali

Need a little help. Installed the Super California Tax add-on to my 1.39h cart. The problem I'm having is even through I change the code to "delivery" so it will use the shipping zip code to apply the tax it still uses the billing address for the tax. Please help I llok for a solution for hours.

In addition to 510ego's excellent pointers, the sql install needed to be combined for my site, and at the top of the file they were trying to append to local_cities rather than the zen_local_cities we changed in the two ot_city_tax files. It wouldn't upload twice, then I changed that item and 1 statement processed. This is 1.5.1 store, and being in CA, need this item.

Marc

I thought I had this wired, got the cities to upload, got the thing to install, but when going to the tax screen in an order it stops the cart. How can the makers of this addon let it die and not be updated? I cannot find anything worth replacing it for, therefore, who can complete the update for 1.5.1? This is an essential addon!

Many thanks for any advice.

Marc

does this still work?? with 1.5.1??? is there any other plugin for california sales tax? wish that state would fall off the map.

uploaded this but nothing shows up on zones, tax rates, etc.. how does this work with 1.5.5 or doesn't it?

Trademagic:

In addition to 510ego's excellent pointers, the sql install needed to be combined for my site, and at the top of the file they were trying to append to local_cities rather than the zen_local_cities we changed in the two ot_city_tax files. It wouldn't upload twice, then I changed that item and 1 statement processed. This is 1.5.1 store, and being in CA, need this item.

Marc

did you ever get this to work??

i use local_sales_tax. not sure if it meets your needs, but good my clients in CA.

good luck!

carlwhat:

i use local_sales_tax. not sure if it meets your needs, but good my clients in CA.

good luck!

is there a support thread for that plugin?? i installed it and tested it with my zip code and it doesn't show any taxes.. how should it look on the customer's side?

lidlchris:

is there a support thread for that plugin?? i installed it and tested it with my zip code and it doesn't show any taxes.. how should it look on the customer's side?

support thread:

https://www.zen-cart.com/showthread.php?111782-Local-Sales-Tax-Mod-Support-Thread/

i'm not really sure what you mean by how should it look on the customer side. it is an order total module and in theory in should display like any other order total module based on your template and how you configure it.

good luck!