It took me ages to find a way to import ALL California tax rates into WooCommerce. I started by hand, and after a while I said to myself “California is crazy! I wouldn’t want to be an accountant there!”.
As usual, I looked for existing free and premium plugins, but I decided to do it my way. this tutorial gives you a ready-made CSV with all California US tax rates (as of 9 August 2014). Yes, it’s out of date, but you can download it, see how it is built, revise it with the correct rates, and follow the tutorial.
Option 1: “Automated tax calculations” (2018)
As of 2018, WooCommerce enabled “automated tax calculations” for certain countries, US included. Maybe, you don’t need to do the manual CSV import any longer.
All the info are here: https://woocommerce.com/posts/woocommerce-sales-tax-for-the-us-how-to-enable-automated-calculations-and-filing/
In a nutshell, go to Settings > Tax > Automated taxes > Enable automated taxes and you won’t need to set up taxes manually. Follow the tutorial above as you’ll need a free plugin, as well as Jetpack, in order to make this work.
Option 2: Import taxes CSV in WooCommerce (2014)
1) Go to WooCommerce / Settings / Tax / Standard Rates
2) Click on “Import CSV”
3) Select the CSV file that you can download below
4) Click on “import” – and there you go! A lot of work saved with a free, simple file download
Download CA tax rates .csv for WooCommerce now
1) Click on the file below
2) If you appreciate my help, please click on “Like” and share this post with your colleagues
Forgot, here’s the .csv file: CA_tax_rates.
42 thoughts on “WooCommerce: Import California Tax Rates (.csv)”
My present web site has limitations and these prevent me from running Jetpack as well as WooCommerce Shipping and Tax plugins. These plugins require the latest and greatest wordpress/woo commerce/php combined, which my web site does not have for now. So in order to get the tax calculation going, I create a CSV file for California (up to date 2020-11). Rodolfo Melogli post here give me a hint on how to do it.
Ok, when you enable HTTPS on your site I will link to it
Option 1 has some caveats. You’ve got to install extra plugins (WooCommerce Services + Jetpack). One of the problems with the automated solutions is they can sometimes be really slow at the checkout; and WooCommerce won’t even show you a final price / payment options until the tax is calculated, so users can get left waiting. It really depends on how close your server is to the server that its pulling the data from. Jetpack has quite a lot of unnecessary bloat as well.
Option 2 is still the fastest way to handle sales tax. Load the data from your own server so it’s instant. If you need other states rates, I have created a CSV of all US state taxes to purchase for a few bucks which I keep up to date. https://salestaxusa.com.
For those looking for an updated tax rates csv; we made one with all 50 states current from April 2020. Check the link in my profile image if you need it.
Hello Rodolfo. Could you please update the SVC file with the 2019 rates? I will donate. I’m sure this will be very useful for others and they will donate, too.
Diana, thanks for your comment! I’ve updated the blog with a new section on “automated tax calculations”, take a look 🙂 There is no need for a CSV any longer I believe
Super thanks for doing this.
You’re welcome 🙂
For some reason this didn’t really work the way it should for me, instead of putting 8.5 as the tax as it was on the spreadsheet, it would round it up to 9.
Hey Ana, thanks for your comment! this is an old post and old CSV, so rates might even be wrong. Try creating your own CSV by following mine and see it that one works 🙂 Let me know!
You should add dates to these articles
Jessa, thanks for your comment! Sure, will do. Did you find this blog out of date?
Thank you so much! This helped me out tremendously.
You’re welcome 🙂
Hey guys! I actually have the up-to-date sales tax. The problem is getting it to work in WooCommerce. California charges a flat state sales tax; however there is additional tax applied to specific counties, and in some cases – even a city tax. The problem we’re running into is this: certain ZIP codes have (2) different tax rates, depending on the CITY they are located in (crazy right).Any idea how to account for this in WooCommerce?
Also, if you would like to see my spreadsheet (updated 03/17) – email me [email protected] and I would be happy to share.
In the WooCommerce settings you can add multiple rules (rows) based on either country, state, city, zip. So, in your case, you’d have a line for state, another for county, another for zip and another for the same zip 🙂
Hi Rodolfo – What is the process that you recommend to use to update the Sales Tax Rate CSV files? Looking at the California Board of Equalization Site, it appears that they don’t sort by zip codes and use cities instead. Thanks!
Hey Michael, thanks so much for your question! I’m not able to help in this case, as it’s something that goes beyond my knowledge. I’d recommend asking the same question on Quora or the “WooCommerce Help & Share” Facebook group if you have an account there. Hope this helps!
Thank you for putting these together – are they current for 2016? You are AWESOME!
No problem Mandy 🙂 No, these rates are a bit old, but you can always download the CSV, edit and re-upload to Woo. Let me know, ~R
Thank you so much !
You’re very welcome Dei! 🙂
You’ve come to the rescue for me again, Rodolfo! Woocommerce was not calculating my sales tax when I was using (*) or 90000-99999 for all my California zip codes. I noticed if I entered a specific zip code, the tax would correctly calculate and display. The thought of manually entering 2500+ zip codes or purchasing a tax table was painful but thanks to you — the best Woocommerce friend anybody could ever for — I solved my problem in 2 minutes. If you’re ever in Los Angeles, I’d love to buy you a beer my friend!!! Thank you!
Ahah Patty that’s awesome to hear 🙂 And I’ll definitely take you on the beer offer. I lived in San Diego 3 years ago so you never know, I might be back one day!
by chance you’ll have the tax table of Florida? I’m looking everywhere but charge me or ask me to install unnecessary plugin Thanks
Hey Nelson, thanks for your comment! I’m afraid I don’t, but check Eric’s comment for a recommended service that may be cost effective. Take care 🙂
California has too many tax rates. I admire what you have done for the community Rodolfo. It’s insane trying to keep it up yourself and it’s not really worth of your time. I am a web developer and I use the sales tax rate tables from woosalestax.com for my clients. Tables are light weight and update monthly.
Eric, thanks so much for your kind words and your recommendation! I went to check woosalestax.com and despite it’s a great idea I feel pretty uncomfortable about it – would you know who are the website owners, where they’re based, how long they’ve been in business and who else is using it? As an ecommerce website is missing all the trust factors 🙂 Let me know. ~R
You are welcome. 🙂 I am not sure who the owner is. But I think they are based in Southern California. I have been using their tables for my WooCommerce clients for a year and half now. So they must be in business longer than that. I don’t have time to deal with the rate changes myself and it’s not worth of my time. I did reluctant to use their csv file at first, so I chose their 3 months option and it tested out ok and it did charge tax if customers enter zip+4 (where csv file like yours won’t be able to handle unfortunately). The update is pretty quick since there are not that many rows of tax rates to remove. Their e-mail support is usually pretty quick. They seem to be very knowledgeable on the Tax setup part of WooCommerce. I have used their Tax Setup Service to resolve a weird tax problem I had where I couldn’t save the tax rates I entered to the WC (they said there was a table missing in our mysql database and they had to recreate it). Anyway, I haven’t have any problem with their support and service so far. I do recommend their sales tax rate table for those who don’t want to deal with the rate updates themselves. Cheer! -E
This is awesome Eric, thanks a lot for helping me and the community 🙂 Thank you!
Hey Rodolfo. Any chance you would have gotten to the updated CA tax rates for Woo? If so, would be willing to donate some $, as it would save us a bunch of time. Thanks!
Hey Luke, thanks for your comment 🙂 I’m afraid I haven’t updated the CSV file recently, and I don’t have the new ones. Do you have an excel available?
I want to make a donation but the Fiverr account says “Gig Paused.” This tax table is awesome and I’ll make another donation for the July Update.
Let me know how to contribute. PayPal address?
Thank you so much Art. You can click here to donate: PayPal
Thank you very much
You are the man, thank you so much for sharing this! I’ve been fighting with some of the CSV tax lists posted by the state, but they wouldn’t upload. This worked like a charm!
I hope you’ll be providing an updated CSV when the April 1st tax changes go into effect!
Maybe if someone is willing to get me a coffee I’ll do it 🙂
Thank you Dave!