California Sales Tax Module

[ronlee67]

response to creeperkat, jeremy7786, wickedstangs, perhaps others:

Regarding the message displayed on the Order Total section of the checkout process that reads "select zip from local_zips where zip='#####'" where ##### is a zip code:

First, if the message also mentions "does not exist" then do as DrByte mentions: verify that your local_zips table has been installed in your database. If you have a unique table prefix, you must go through the code in includes/modules/order_total/ot_zip_tax.php and add the prefix to every instance of 'local_zips'. For instance, I use the characters"as" for the prefix to my tables so I changed each instance of 'local_zips" to 'as_local_zips'.

This should eliminate the "does not exist" message, however you may still get the rest of the message ("select zip from local_zips where zip='#####'). If you would like to remove this message from your displays then open the following file in an editor:

file: includes/modules/order_total/ot_zip_tax.php
Find the following lines:
$selstr = "select zip from local_zips where zip='$zip'";
echo $selstr;
 
Change to:
$selstr = "SELECT zip FROM local_zips WHERE zip='$zip'";
// echo $selstr;

That should clear it up.

Also, I found an error in the included readme.txt file for this contribution:

In the instructions "to install the database version:" in step 3 there are two files you should copy to your store. The second one reads includes/modules/ot_zip_tax.php when it should read includes/modules/order_total/ot_zip_tax.php.

It's possible a similar error appears in step 2 of the instructions "to install inline zip version" but I didn't use that method so have not verified it as an error.

Once I made the above changes I found this contribution to work very smoothly.
Ron

[wickedstangs]

ronlee67 Nice fix thanks..

[ronlee67]

A desireable enhancement would be to provide for additional taxes for specific zip codes.

For instance, in my case I have four separate jurisdictions to consider. Each covers different or overlapping geographical/political areas.

My store is located in all four areas.

The four jurisdictions are:

1. State
2. County
3. Rural Transport Authority (RTA)*
4. City

*The RTA tax involves several communities within the county but does not cover the entire county.

Since I am located in all four, I have to collect tax for one of these combinations depending on where the order is delivered:

1. Out of state (no tax)
2. In state, but not in my city or county (2.9%)
3. In-state, in-county (2.9% + 1%=3.9%)
4. in-state, in-county, within RTA areas (2.9%+1%+1%=4.9%)
5 in-state, in-county, in city (and by default: within RTA because my city is within RTA). (2.9%+1+1%+2.5%=7.4%)

In my case differentiating these areas by zip code combinations would work fine. It still leaves a problem when a zip code extends outside a taxing area. The only idea that comes to mind would be to add a flag table in the database that would allow the administrator to flag specific accounts to override default tax or taxes. (This could also be used by the administrator to flag any accounts that are tax exempt). In order to do that efficiently, code would need to be written to provide this functionality in the admin console.

Anybody got any thoughts on this or perhaps someone willing to write a new version?

[tirish]

I had thought this was functioning correctly when I installed it - at least it appeared to be! Today I've been alerted to an issue.

Everything is being taxed. I have one tax class: Taxable Goods - items that are set to none are getting taxed. It does appear to be working correctly with that execption. Any thoughts appreciated.

[tirish]

Oh, and one other thing... I used the above comment to get rid of

"select zip from local_zips where zip='#####'"

Now it just displays FALSE

I'm in Vermont, so the zip codes begin with zero which is left off when the above was displayed before I commented out "echo $selstr;"

Thanks...

[NomadRip]

I been lookin' for something like this too! Can't wait to try it out (it's pretty far down the development list right now).

Is it coincidence that BOE could also mean 'Bane Of my Existance'?

[cfe]

Due to needing it, I modified this..modification.. to store the relative tax rates along with the zip codes in the database, and automatically plug in the correct one in a customers order.

In the attached archive is the modified ot_zip_tax.php to go in the '/includes/modules/order_total' folder, as well as an SQL file that has the information for every zip code in California (I believe...).

So, replace the file, run the SQL statements, and you should be good.

-Joel

PS - I hope it was alright to modify this and share it, all copyright info was left intact. Just let me know if this isn't kosher.

PPS - I'm not really a PHP coder, but it worked fine in my store.

[cfe]

Heh, forgot to attach. Here ya go

[w00gle]

CFE, great job on the mod. I did work on similar mod and worked but yours is a cleaner implementation. I could share my sql which has more zip entries and tax rates (ie. i noticed you didn't include 8.275%, 7.875%)

Again, nice work!

[w00gle]

Whoops, here is the sql I mentioned about.
Disclaimer: The file is 'Use as is'.