Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE `wp_postmeta`
- SET `meta_value` = ROUND(`meta_value` * 1.30, 2) --- for example 30%
- 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 `post_date` LIKE '%2020-01-15%' --- for example only products I added on this date
- AND `ID` = `post_id`
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement