Update the tax status of all WooCommerce products. · GitHub

Update the tax status of all WooCommerce products.

Raw

update-tax-status.sql

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

rrrhys commented Oct 11, 2016

Legend

yratof commented Oct 26, 2016 •

edited

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

japick commented Nov 14, 2016

Nice one!

amykallissa commented Jun 2, 2017

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

JoeyKhd commented Jun 8, 2017

Thanks for sharing!

c9dd commented Sep 5, 2017

Thanks!

shivsingh7150 commented Sep 21, 2017

Thanks great idea

MarkPraschan commented Oct 10, 2017

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

takisv76 commented Mar 21, 2018

You are a legend mate...

saibottrenham commented Jul 26, 2018

My Hero!

akashjdongre commented Aug 27, 2018

awesome

zhex900 commented Sep 20, 2018

Works like magic. Thanks!

tecgal commented Oct 5, 2018

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

anton-roos commented Dec 6, 2018

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

toniodz commented Feb 6, 2019

useful, thanks

unscripted commented Apr 2, 2019

Saved me a lot of time. Thank you!

mio31337 commented Sep 17, 2019

Thanks. Still working as of now.

anton-roos commented Nov 25, 2019

This helped me thank you!

curdaneta commented Feb 21, 2020

Thanks, you have saved me a lot of work

brynzovskii commented Mar 31, 2020

Perfect!

gagankhatri commented Jun 29, 2020

how i am supposed to run this?

SeydaAsan commented Jun 30, 2020

Kral adamsın :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

You can’t perform that action at this time.