Skip to content

Instantly share code, notes, and snippets.

@pejantantangguh

pejantantangguh/remove _sale_price.sql

Created March 6, 2019 23:04
Show Gist options
  • Save pejantantangguh/43df2224af777570d59e7a527e5833a8 to your computer and use it in GitHub Desktop.
Save pejantantangguh/43df2224af777570d59e7a527e5833a8 to your computer and use it in GitHub Desktop.
Download ZIP
SQL script to remove sale price Woocommerce
Raw
remove _sale_price.sql
UPDATE wp_postmeta m
JOIN wp_posts p ON m.post_id=p.id
AND m.meta_key = '_sale_price'
SET m.meta_value = ''
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment