Skip to content

Instantly share code, notes, and snippets.

@yratof

yratof/update-tax-status.sql

Forked from BFTrick/update-tax-status.sql
Created October 26, 2016 08:56
Show Gist options
  • Save yratof/52b62c6131ee8a1b9d98fa756621435d to your computer and use it in GitHub Desktop.
Save yratof/52b62c6131ee8a1b9d98fa756621435d to your computer and use it in GitHub Desktop.
Download ZIP
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'
@MaxedOnline
Copy link

I've tried doing this, but it will only update 4 rows. Any idea on how to do this? I have limited coding experience

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