WooCommerce Florida Sales Tax not calculating

  • I’m new to WP and WooCommerce so I’ve probably missed something basic. I’m just setting up my shop. I’ve searched the forums and checked and re-checked my settings, but I cannot seem to get the Florida sales tax to calculate (it doesn’t show up at all in my cart or when I go to check out). I successfully uploaded the tax rates from taxrates.com. I double-checked and the zip code that matches the shipping address IS int he tax table.

    Again, I’m sure I’m missing something basic either in the settings or in my import. Any help would be greatly appreciated!!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter lainenixon

    (@lainenixon)

    Solved! I’m not sure exactly what was wrong with the tax rates I imported via csv file, but I decided to take a different approach. First I (manually!) deleted all 1460+ Florida tax rates (BTW, is there no way to delete tax rates in bulk??? I couldn’t find a way. It took me about 30 minutes to manually click on each record, page by page and delete).

    Then I entered just four rows of tax rates manually. Finally, with some major manipulation in excel I transposed and concatenated all of the zip codes that belonged to each tax rate, and then cut/pasted the zip codes (separated by ?? into the zip code cell in the tax rate table in the WooCommerce table. Whew.

    Not sure if this will help anyone out there. But thought I’d share just the same.

    Thread Starter lainenixon

    (@lainenixon)

    One last update. I noticed the tax rates did not work correctly if I entered my full 9 digit zip code. So, I changed all of the zip codes int he tax rate table to include the wildcard indicator (ie 99999*) This worked great when I entered by full 9 digit zip code (or anything beginning with my 5-digit zip code followed by at least one character). However, when I entered the 5-digit zip code exactly ie 99999, it stopped working again. So, I added exact matches AND wildcards to the tax rate table. What a pain when there are over 1460+ zip codes in Florida. I’m sure I’m doing something wrong (or perhaps I should just buy a plug in!). Just food for thought in case someone out there in WooCommerce land wants to add their 2-cents. I think I’ve got it working for now.

    We use the sales tax rate tables from https://www.woosalestax.com. Their zip code level sales tax tables will be able to handle zip code and zip+4 at zip level. The tables are very compact, instead of more than thousand rows, Florida table is consolidated to only a few rows. Big time saver. Hope this help. ??

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WooCommerce Florida Sales Tax not calculating’ is closed to new replies.