Woo LS POS - Update parent SKU w/ ls matrix id
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);
Comments
0 B
|0 š
/0 š
0 B
|š
/š