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.

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.