wordpress - Woocommerce 价格缓存

Question

UPDATE wp_postmeta SET meta_value =(ceil(meta_value*0.9) - 0.1 )WHERE meta_key = '_regular_price' AND meta_value != ''AND meta_value > 10;
UPDATE wp_postmeta SET meta_value =(ceil(meta_value*0.9) - 0.1 )WHERE meta_key = '_sale_price' AND meta_value != ''AND meta_value > 10;
UPDATE wp_postmeta SET meta_value =(ceil(meta_value*0.9) - 0.1 )WHERE meta_key = '_price' AND meta_value != ''AND meta_value > 10;
UPDATE wp_postmeta SET meta_value =(ceil(meta_value*0.9) - 0.1 )WHERE meta_key = '_regular_price_tmp' AND meta_value != ''AND meta_value > 10;
UPDATE wp_postmeta SET meta_value =(ceil(meta_value*0.9) - 0.1 )WHERE meta_key = '_sale_price_tmp' AND meta_value != ''AND meta_value > 10;
UPDATE wp_postmeta SET meta_value =(ceil(meta_value*0.9) - 0.1 )WHERE meta_key = '_price_tmp' AND meta_value != ''AND meta_value > 10;
UPDATE wp_postmeta SET meta_value =(ceil(meta_value*0.9) - 0.1 )WHERE meta_key = '_min_variation_price' AND meta_value != ''AND meta_value > 10;
UPDATE wp_postmeta SET meta_value =(ceil(meta_value*0.9) - 0.1 )WHERE meta_key = '_max_variation_price' AND meta_value != ''AND meta_value > 10;
UPDATE wp_postmeta SET meta_value =(ceil(meta_value*0.9) - 0.1 )WHERE meta_key = '_min_variation_regular_price' AND meta_value != ''AND meta_value > 10;
UPDATE wp_postmeta SET meta_value =(ceil(meta_value*0.9) - 0.1 )WHERE meta_key = '_max_variation_regular_price' AND meta_value != ''AND meta_value > 10;
UPDATE wp_postmeta SET meta_value =(ceil(meta_value*0.9) - 0.1 )WHERE meta_key = '_min_variation_sale_price' AND meta_value != ''AND meta_value > 10;
UPDATE wp_postmeta SET meta_value =(ceil(meta_value*0.9) - 0.1 )WHERE meta_key = '_max_variation_sale_price' AND meta_value != ''AND meta_value > 10;

DELETE FROM `wp_options` WHERE `option_name` LIKE ('%\_transient\_%')

试图在 MySQL 中更新价格，删除了整个临时选项，没有安装 w3 总缓存或其他缓存插件。然而，UI 仍然显示旧值，但有趣的是管理产品编辑显示新值，只有在我再次单击更新后，UI 才会更改。为什么 ？

标签： wordpresswoocommerce