WooCommerce Taxes Not Working Correctly

Did you set the Base Location to CA and the Default Customer Address to Shop base address, both in Settings > General.

Thank you. Yes, I set Base Location to Canada – Ontario and the Default Customer Address to Shop base address. I also tried Geolocate address but it didn’t work either.

I forgot to mention that I also turned off all unnecessary plugins in case there might be a conflict.

Any other ideas?

Did you set “Enable taxes and tax calculations” = checked at Settings > Tax options.

On the product page, presumably the tax class is set to standard and the HST rate is set at Settings > Tax > Standard Rate.

On the Standard Rate page, check that the state column has a * to apply to all states.

I expect you’ve seen this but here it is anyway:
https://docs.woothemes.com/document/setting-up-taxes-in-woocommerce/

I’d try setting the country code in the Standard rates table to *. Presumably it doesn’t matter where the customer lives he still has to pay HST.

Thank you. Yes, I set “Enable taxes and tax calculations” in the tax options.

Yes, on the Product page I have the Regular Price of $555.75 with the Tax Status of Taxable and the Tax Class of Standard. It should read $628 when the HST is added.

Yes, I have the state code left as *. I have also tried leaving the country code as *.

Yes thank you I have read the link and many others. As I said, I have it working perfectly at https://mapenterprises.ca/shop/ so I know what settings to make. I am wondering if this is some kind of bug that it doesn’t work on this new IP address. I can’t even make it say HST instead of Tax, let alone put in 13% instead of 0.

I am appreciating all your input. Any other ideas?

Well, I am experiening similar trouble. The tax is all setup correct (at least, according to three different websites) and the link provided by Iorro. Somehow, the web shop simply shows VAT (not the Dutch equivalent BTW) 0.00.

Our website can be fount at: https://www.projecth.nl/shop/

It is driving me nuts, I just cannot stand it is not working properly.

I am not sure if it has anything to do with it, but in my online shop, tax rates are shown with a comma (,) as a decimal separator, and not a dot (.) as shown in the screenshots in the instructions.

same here. not working. I am setting up tax for Ontario in Canada. Straight forward. I think it is a bug. I have remove and added products a couple of times. and used new addresses too.

@mr3ry
On the Tax Options page, ensure:
Prices Entered With Tax = “No, I will enter prices exclusive of tax”

I can’t even make it say HST instead of Tax

– what it says is not the tax name, its whatever you have put at Settings > Tax Options > Price Display Suffix. This field should have: “inc HST”.

I appreciate you have checked all the settings several times but if you would like to post screenshots of the Tax tab: Tax Options page and the Tax tab: Standard Rates page, I can offer an independent check.

@haap and @arconsulting
Forum guidelines recommend starting a new thread even for what is apparently the same problem as some parts of your setup may be different and also this avoids posts getting mixed up. Say what you’ve tried and include some screenshots as described, and @arconsulting please include a link to your site.

Thank you so much for your help. Yes I know how to make it say HST. It did so in my mock-up site, and yes, as I said in my first post I did set “No, I will enter prices exclusive of tax”. All worked perfectly on the mock-up site.

I know what settings need to be made. I suspect this is a bug, however I have spoken to my client and he is fine with me just putting in the prices including the HST, so I’m not going to waste anymore time on it.

Hopefully it is something that will be fixed before I do my next WooCommerce website.

Did you ever come up with an answer on this? I have the most basic site I’ve ever put together where this is happening and I can’t for the life of me figure out why.

No, I never found a solution. I had to put the prices in including the taxes.

One issue seen on here lately is that the table wp_tax_rate_locations is missing. See if it exists in phpMyAdmin. If it is missing, code is available to create it. It can be empty, but it must exist.

I used the following code to manually install my wp_woocommerce_tax_rate_locations locations table (via phpMyAdmin). Just make sure to change the “wp_” to whatever table prefix you use for your WordPress installation. Also make sure the collation matches the collation for your other WordPress database tables.

CREATE TABLE IF NOT EXISTS wp_woocommerce_tax_rate_locations (
  location_id bigint(20) NOT NULL AUTO_INCREMENT,
  location_code varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  tax_rate_id bigint(20) NOT NULL,
  location_type varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (location_id),
  KEY tax_rate_id (tax_rate_id),
  KEY location_type (location_type),
  KEY location_type_code (location_type,location_code (191))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

The code simply changes the length of the location_code key to 191. There’s more information in this support thread and in this WordPress article.

jjbte:

YOU are genius!! I have been pulling my hair out for the past two days trying to find why my taxes weren’t being applied. I had quadruple checked my settings so much I was going cross-eyed until I found your post.

Copied and pasted the code into my SQL manager and problem is fixed!!! THANK YOU!!!! WHOHOOOOO!!!!

-DON-

Well, BigDon55, I wouldn’t go that far, but thanks so much for your kind words and I’m glad I could help. ??

jjbte, would you be willing to give some more detailed instructions on what to do from within PhpMyAdmin? I found the table, but I am a little lost from there.

In my case the taxes are displaying, but not the right total no matter what. I have configured Woo before, and I know the settings are accurate. The tax amount returned just isn’t. So I guess this problem is still going on a few months later.

Thanks a lot.