Skip to content

Instantly share code, notes, and snippets.

@virtualadrian

virtualadrian/update-regular-prices-woocommerce.sql

Forked from yanknudtskov/update-regular-prices-woocommerce.sql
Created February 9, 2019 21:25
Show Gist options
  • Save virtualadrian/74c97508751a73952f5e4ade7b173f21 to your computer and use it in GitHub Desktop.
Save virtualadrian/74c97508751a73952f5e4ade7b173f21 to your computer and use it in GitHub Desktop.
Download ZIP
Update all Regular Prices, increase by 40% in WooCommerce #woocommerce #mysql
Raw
update-regular-prices-woocommerce.sql
update wp_postmeta set meta_value = meta_value * 1.40 where meta_key='_regular_price'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment