更新Woocommerce可变产品的所有产品差异销售价格

尝试以下操作（第AND p.ID = 19==> 19行是您的可变产品ID）：

UPDATE wp_postmeta as pm
JOIN  wp_postmeta as pm2 ON pm.post_id = pm2.post_id
SET pm.meta_value = ( pm2.meta_value - 350 )
WHERE pm.meta_key LIKE '_sale_price'
  AND pm2.meta_key LIKE '_regular_price'
  AND pm.post_id IN
    ( SELECT p2.ID
     FROM wp_posts AS p
     JOIN wp_posts AS p2 ON p2.post_parent = p.ID
     WHERE p.post_type = 'product'
       AND p.post_status = 'publish'
       AND p.ID = 19
       AND p2.post_type = 'product_variation'
       AND p2.post_status = 'publish' );

经过测试并可以正常工作（始终进行备份）

因此，在此SQL查询中，定义了一个可变产品ID，它将用正常价格减去350来替换所有产品变体销售价格…

如您所见，它有效……没有错误