UPDATE `wp_postmeta` SET `meta_value` = ROUND(`meta_value` * 1.24, 2) WHERE meta_key LIKE '%_price%' AND (meta_value > 0 or `meta_value` != '') AND `post_id` IN ( SELECT `ID` FROM `wp_posts` WHERE `post_type` = 'product' AND `post_status` = 'publish' AND `ID` = `post_id` );
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter