Had an annoying little problem with taxes not showing in WooCommerce recently. Despite my best efforts to configure the Tax pages correctly, all I was getting was $0 for taxes. I had specified an address in the checkout but the tax amount would consistently come back as $0. This was on two separate, new installs of Wordpress v4.2.4 + WooCommerce v2.3.10 and I had no other tax plugins installed.
Thankfully, a response to my post to the Wordpress support forums got me back on track. It was suggested I may be missing the wp_woocommerce_tax_rate_locations table in the database, and sure enough, upon inspection I had no such table.
I created the table using the following SQL from another post describing an identical problem:
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;
Next, I clicked Save on the WooCommerce/Settings/Tax/Tax Options screen before taxes would show.
Thanks lorro! Read the full thread here: https://wordpress.org/support/topic/tax-displays-as-0
Where do you put that code? I know nothing about SQL, and limited wordpress... is there a place in the wordpress dashboard that I need to go to?
ReplyDeleteyarberryln@gmail.com
You have to execute this statement in MySQL--it won't be in Wordpress but in your hosting account. If you don't have much experience here, be sure to backup your database first and/or find someone who knows their way around as this has the potential to bring down your site.
Delete