Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Update the tax status of all WooCommerce products.
UPDATE `wp_postmeta`
SET meta_value='taxable'
WHERE meta_key='_tax_status'
@rrrhys
Copy link

rrrhys commented Oct 11, 2016

Legend

@yratof
Copy link

yratof commented Oct 26, 2016

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

@japick
Copy link

japick commented Nov 14, 2016

Nice one!

@amykallissa
Copy link

amykallissa commented Jun 2, 2017

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

@JoeyKhd
Copy link

JoeyKhd commented Jun 8, 2017

Thanks for sharing!

@c9dd
Copy link

c9dd commented Sep 5, 2017

Thanks!

@nomadicshiv
Copy link

nomadicshiv commented Sep 21, 2017

Thanks great idea

@MarkPraschan
Copy link

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
Copy link

takisv76 commented Mar 21, 2018

You are a legend mate...

@saibottrenham
Copy link

saibottrenham commented Jul 26, 2018

My Hero!

@akashjdongre
Copy link

akashjdongre commented Aug 27, 2018

awesome

@zhex900
Copy link

zhex900 commented Sep 20, 2018

Works like magic. Thanks!

@tecgal
Copy link

tecgal commented Oct 5, 2018

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

@anton-roos
Copy link

anton-roos commented Dec 6, 2018

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

@toniodz
Copy link

toniodz commented Feb 6, 2019

useful, thanks

@unscripted
Copy link

unscripted commented Apr 2, 2019

Saved me a lot of time. Thank you!

@mio31337
Copy link

mio31337 commented Sep 17, 2019

Thanks. Still working as of now.

@anton-roos
Copy link

anton-roos commented Nov 25, 2019

This helped me thank you!

@curdaneta
Copy link

curdaneta commented Feb 21, 2020

Thanks, you have saved me a lot of work

@brynzovskii
Copy link

brynzovskii commented Mar 31, 2020

Perfect!

@gagankhatri
Copy link

gagankhatri commented Jun 29, 2020

how i am supposed to run this?

@SeydaAsan
Copy link

SeydaAsan commented Jun 30, 2020

Kral adamsın :)

@Deimz
Copy link

Deimz commented Aug 26, 2020

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

Thanks bro !

@Whendriksen-Spec
Copy link

Whendriksen-Spec commented Aug 26, 2020

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!

@RonR-WebDesign
Copy link

RonR-WebDesign commented Oct 22, 2020

Thanks! Found easily with a google search...

@MilenFrom
Copy link

MilenFrom commented Oct 3, 2021

Yup same
KING :D

@davidebr90
Copy link

davidebr90 commented Dec 11, 2021

Thanks !!!!

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