Community Add-Ons

The only changes made here are to the Flodia County tax rates. They have been updated based on current tax rates as of May 1, 2009. Otherwise, this is the complete 2007 package. I did not change the 2007update.sql. Instead, run the exported-sql/tax_rates_2009.sql

Since the original contribution drops the foreign countries out of the zones table I've added the sql script to add them back in. I don't hard code the zone_id either since the table auto increments. I ship to foreign countries so I needed them back.

NOTE: You should really only use this on a clean install after installing the base contribution first. In other words if you have already shipped to foreign countries, don't use this!

Enjoy!

Found a solution:
This is the 1.3.3 of the contrib http://www.oscommerce.com/community/contributions,2028
Either way, download the contrib from the URL, not from here.

It' s highly recommended to install this contrib if you need to collect Florida surtaxes. If the address book don't ask the county you can have serious issues for not collecting the correspondent taxes.

Instructions:

This is just an update.

Only run this SQL file if you have previously installed the 2005 contribution.

Simply run the attached SQL file in PHPMyAdmin or Mysql.

You're done! Well, at least until they change rates again.

Here is a link to the FL state surtax information:

http://www.myflorida.com/dor/forms/2006/dr15dss.pdf
http://dor.myflorida.com/dor/forms/download/!discretionary.html

Many thanks to Kipland Iles for the initial contribution.

Steve Hudson
mcbsolutions


Information specific to 2007 update:

A cumulative update for 2007, also includes 2006 update for completeness.

A simple update for 2006.

As I write this, it appears the only Florida county that has had a change for its surtax rate is Gulf county.

It will be 1% surtax rate as of 1/1/2006. The prior rate in 2005 was 0.5%.

Instructions:

This is just an update.

Only run this SQL file if you have previously installed the 2005 contribution.

Simply run the attached SQL file in PHPMyAdmin or Mysql.

Your done! Well, at least until they change rates again!

Here is a link to the FL state surtax information:

http://www.myflorida.com/dor/forms/2006/dr15dss.pdf

Many thanks to Kipland Iles for the initial contribution.

Steve Hudson
mcbsolutions

Florida's Discretionary Sales Surtax undergoes review and modification each year. This contribution addresses the changes required to comply with Florida's 2005 Surtax.

This contribution includes exports of all of the tax tables required to setup County Based tax zones for Florida under OSC 2.2 MS2. No code modifications are required. Also included are PHP scripts and data source files used to generate the sql files, initially. These zones are based on the Discretionary Sales Surtax Information form DR-15DSSR.1130. Installation instructions included in the README.txt.