Update the tax status of all WooCommerce products.

update-tax-status.sql

UPDATE `wp_postmeta`
SET meta_value='taxable'
WHERE meta_key='_tax_status'

Legend

"Does this work multilingual?" – yes it does, everything in the database is based on american english.

Nice one!

Hi there, where do I actually paste this coding to get it to work?!

Thanks for sharing!

Thanks!

Thanks great idea

Exceptional! Thanks, BFTrick.

I paired this with the following quick tutorial about executing the code since I wasn't 100% confident:
http://support.hostgator.com/articles/how-to-run-sql-queries-in-phpmyadmin

You are a legend mate...

My Hero!

awesome

Works like magic. Thanks!

It took a second ... absolutely pure gold. Thank you!

Thank you!! This helped me a lot and saved me so much time. I am grateful <3

useful, thanks

Saved me a lot of time. Thank you!

Thanks. Still working as of now.

This helped me thank you!

Thanks, you have saved me a lot of work

Perfect!

how i am supposed to run this?

Kral adamsın :)

This looks like SQL, so you should run it in phpmyadmin or in you mysql console :)

Thanks bro !

Thanks for this query, flipped all rows in wp_wc_product_meta_lookup to taxable but the products kept saying it wasn't taxable. This query solved my issue, great!

Thanks! Found easily with a google search...

Yup same
KING :D