Support Forum

Content of the article

WPBE - WordPress Posts Bulk Editor Professional
You need to log-in to create request (topic) to the support

Woocommerce price update in SQL issue

(new from 01-07-2019)
If you not got email within 24 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here.
The support doesn work on saturdays and sundays, so some Friday requests can be answered on Monday.

This plugin cause the price update to show wrong value, this update should decrease the price, but this plugin causes the price to increase. Any ideas why ? I have no cache plugin. But this plugin seems to cache prices, I have to deactivate and activate again this plugin to see the changes.

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

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

Hello

Read  this  please - https://currency-switcher.com/currency-recounts-wrong-double-zero-and-others/

It looks like a conflict with a third-party plugin