Super California Sales Tax Add-on

[notageek]

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

[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

[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

[adrian_cls]

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.

[hliang]

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?

[JOAT-dontknownothin]

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!

[yakin_up]

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?

[510ego]

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)

[510ego]

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

[510ego]

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.