mysql 中提高产品单价_Woocommerce MySQL更新特定类别产品的价格

这是一个MySQL查询,可以满足您的目的.

更新_regular_price

UPDATE

`wp_postmeta`

SET

`meta_value` = ROUND(`meta_value` * 1.40, 2)

WHERE

meta_key = '_regular_price'

AND `post_id` IN (

SELECT

`object_id` AS product_id

FROM

`wp_term_relationships`

WHERE

term_taxonomy_id = 376

AND `object_id` IN (

SELECT

`ID`

FROM

`wp_posts`

WHERE

`post_type` = 'product'

AND `post_status` = 'publish'

AND `ID` = `object_id`

)

);

更新_price

UPDATE

`wp_postmeta`

SET

`meta_value` = ROUND(`meta_value` * 1.40, 2)

WHERE

meta_key = '_p