Tax not working (tax always equals 0)

Same problem here! =/
But it’s good to know that i’m not alone.
If anyone figure this out don’t forget to share ??

viniciusgersen check this:

Database – Some installs don’t have a wp_tax_rate_locations table, don’t know why. Add the table with the following mySql script, use it in phpMyAdmin:
https://pastebin.com/rVGcPpZ5
There are several recent threads on here about that. The table can be empty but it must exist.

it solve my problem

I solved my problem with lorro helps ??

1- Create the wp_woocommerce_tax_rate_locations table (check if you already have it)

CREATE TABLE wp_woocommerce_tax_rate_locations (
location_id bigint(20) NOT NULL,
location_code varchar(255) NOT NULL,
tax_rate_id bigint(20) NOT NULL,
location_type varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2- Delete Tax Rates

3- Disable Tax Options

4- Enable Tax Options

That’s all i did, i hope it helps ??

elrik007 That’s what i did, i didn’t see your answer before.

Thanks

There is a simple FREE solution if you want to charge a simple tak rate for everyone and not change the tax per state.

Install the Woocommerce Extra Fee Option and set the name of the extra fee to “Sales Tax” (or whatever you wish) and the rate and that’s it!

https://terrytsang.com/shop/shop/woocommerce-extra-fee-option/

Also available by searching the plugins for terrytsang or WooCommerce Extra Fee Option

Indeed it is a big issue. I’m glad to hear that I’m not alone. Just that my client won’t really care.

@viniciusgersen

Thanks!! It did the trick!

Thanks to lorro and the SQL Query from viniciusgersen I solved my problem and my Woocommerce is now calculating VAT ??

Thanks guys for helping out with this issue or bug in Woocommerce ??

@lorro
Thank you for providing the information that you did.

I was knocking my brains out with this same issue that everyone else was having.

From what I’ve concluded it seems to be a glitch of installing the woocommerce plugin OR it can be the latest version of this plugin that the “wp_tax_rate_locations” table isn’t being installed to the database…… before I started working on the project that had this Tax issue, I checked a previous project that isn’t finished yet, haven’t done much with it, but I checked the database of it, and the “wp_tax_rate_locations” table is their from that installation.

Thanks again for this help!!

Not sure if this will help but I was having the same issues with mine and pretty much tried everything mentioned above to no avail, lastly probably a big brain fart on my behalf but for the standard tax rate I just put “13” thinking it would format it correctly for me but that was not the case. I retyped it as “13.00” and it fixed the issue right away.

I’ve tried everything above and still can’t get it to work. Fresh install of WP 4.2.4 and Woocommerce 2.3.13

I can’t even get it to calculate VAT at UK standard rate.

Anyone any ideas?

This works – Thanks viniciusgersen

1- Create the wp_woocommerce_tax_rate_locations table (check if you already have it)

CREATE TABLE wp_woocommerce_tax_rate_locations (
location_id bigint(20) NOT NULL,
location_code varchar(255) NOT NULL,
tax_rate_id bigint(20) NOT NULL,
location_type varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2- Delete Tax Rates

3- Disable Tax Options

4- Enable Tax Options

That’s all i did, i hope it helps ??

Thanks Kosala, I tried that but unfortunately it didn’t work.

I’ve not used PhpMyAdmin before so I may have created the table in the wrong place, or cocked it up somehow!

I’ve been advised that a fix is being applied in the new release due next week, so hopefully all will be well!

Hi, I would like to try ‘creating’ this table as I’m having the same tax issue. I’m not a developer so if someone could advise me on how to ‘create a table’ and where to do that it would be great. Is it set up in WordPress or in my control panel?

Thanks!

Tori.

Figured out what it was – I had the country code as UK instead of GB – now it works anyway!!