California Sales Tax Module

[jeremy7786]

Awesome Module!

Quick question though...

When using this module i get the following in the Order Total Section of the checkout process:

select zip from local_zips where zip='92128'

How can I get rid of this? Thanks!

-Jeremy

[creeperkat]

I am getting a similar error:

select zip from local_zips where zip='92822'
1146 Table 'db188733754.local_zips' doesn't exist
in:
[select zip from local_zips where zip='92822']


It works fine for out of state zip codes but not local.

[DrByte]

Your "table does not exist" errors indicate that you neglected to install the database table required for the mod to work.
The readme.txt explains to do that.

[creeperkat]

I tried installing the database but I am having a bit of trouble.

My host uses MySQL. Here is what I have done so far:
I go to the database and click on phpMyAdmin and see a list of all the tables.
At the bottom, I see: Create new table on database. I use the name provided in the readme.txt notes. The setup asks me for how many fields, I entered 1.

I change all the attributes to match the sql.txt example. The only thing I wasn't sure about is the type. I left the default which is MyISAM.

It looks like I have everything setup. It looks like I can add them one at a time but is there a way to import a file? I see a link for: Insert data from a text file into the table.
Do I just edit the sample lacountylocalzip.sql txt file so it starts with this (removing the CREATE TABLE stuff at the top of the example):
INSERT INTO `local_zips` (`zip`) VALUES(90001);
INSERT INTO `local_zips` (`zip`) VALUES(90002);
INSERT INTO `local_zips` (`zip`) VALUES(90003);
INSERT INTO `local_zips` (`zip`) VALUES(90004);
INSERT INTO `local_zips` (`zip`) VALUES(90005);
INSERT INTO `local_zips` (`zip`) VALUES(90006);
INSERT INTO `local_zips` (`zip`) VALUES(90007);

Then send it up?

[DrByte]

No.

Select your Zen Cart database from the left pulldown menu.
Then click on the "Import" tab across the top right (if no "Import", choose "SQL").
Then you can either paste the contents of the lacountylocalzip.sql file in the textbox, or you can browse for the file and upload/submit it.
That should create the table and insert the required records.

If you specified a "table prefix" during installation of your Zen Cart system, you'll need to make some changes to the lacountylocalzip.sql file contents before you do this. You can determine this by checking if your "DB_PREFIX" setting in the /includes/configure.php file is set to blank (ie: '').

[creeperkat]

Think I got it now! Thanks!

One last question. When I use the checkout, step 2 (Payment information) shows this in the YOUR TOTAL box.

select zip from local_zips where zip='92822'

Is there a way to change this?

[wickedstangs]

Could sure use some help installing this? Thanks

[wickedstangs]

Think I got it now! Thanks!

One last question. When I use the checkout, step 2 (Payment information) shows this in the YOUR TOTAL box.

select zip from local_zips where zip='92822'

Is there a way to change this?

I second that how to change it?? very nice hack thank you

[fymbscu]

This sounds like a nice module and I am looking to adapt it to Orange County California.

I have a question about implementation: Why the reliance on zip codes, rather than say, city names. The BOE provides both CVS and Excel versions of the tax rates linked to City and County names, but no zip code information.

Can this module be adapted to work with city names instead of zip codes? Not sure where to get the necessary zip code information.

Thanks for the contribution.

Regards,

Mark Harrison

[decohenh]

It would be nice to see this work with cities as well, instead of zip codes. The state publishes a free database that has tax rates based on cities, that is constantly updated. Here is the link for the state database. Thank you.

http://www.boe.ca.gov/sutax/pam71.htm