Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE `wp_zz_postmeta` AS pm
- JOIN `wp_zz_posts` AS p ON pm.post_id = p.ID
- JOIN `wp_zz_wclsi_items` AS ls ON pm.meta_value = ls.system_sku
- SET pm.meta_value = ls.item_matrix_id
- WHERE pm.meta_value REGEXP '^[0-9]+$'
- AND pm.meta_key = '_sku'
- AND p.post_type = 'product'
- AND p.post_status = 'publish'
- AND EXISTS (
- SELECT `post_id` FROM `wp_zz_postmeta`
- WHERE `post_id` = p.ID);
Advertisement
