Community Add-Ons

This is the full package.

One new file added: CHANGELOG.txt - detailing the new changes.

Two files modified: Step1_geo_zones.sql and Step2_tax_rates.sql updated with current (as of June 9th, 2008) Ohio tax rates.

This is a complete package which just updates the README to be more useful, based on my own experience trying this. Notes include:

- correcting that address_book.entry_zone_id refers to the zones table, not the geo_zones table.

- Providing more specifics about what happens when using this when there are existing customers, including an example of how to fix some addressbook entries.

I do not provide warranty or support for this contribution.

Seems there are some download issues with the last update. SQL & scripts are updated. For those that had previously installed this, just run Step2_tax_rates.sql.

Since the state tax went down .5 % July 1st, here is a little sql script you can run that will reduce all the counties by .5 %.

You will have to go back in to redo Hancock, Highland, and Trumbell as they had differnet changes.

But, it beats retyping all 88 counties! Here is the sql code. There is nothing in the zip file.

update tax_rates set tax_rate = tax_rate - .5

don't screw up the s in tax_rate and tax_rates.

drop an email to tkbeiser@yahoo.com if this was useful.

Corrected offset in the two sql files. Now correctly recreates the 4 required tables. Now includes remaining 49 states & Canada zones as part of the zones table.

Added support for COTA

**NO MODDING OF PHP FILES**
Simply run included sql files to recreate the zones, tax_rates, geo_zones, zones_to_geo_zones tables to have osC charge Ohio sales tax based on buyer's county. This is compliant with Ohio SSTP effective July 1, 2005.

I added the field 'tax_name' to the tax_rates table so that sql queries could be made by county for sales tax reporting. I needed this for my Peachtree Export CSV contribution.

**Please note that 3 of Ohio counties Hardin, Mahoning, & Richland will have sales tax changes this year.**