Support Forum

Content of the article

You need to log-in to create request (topic) to the support

Woocommerce price update in SQL issue

This support system is for all types of the plugins as for premium versions, so for free ones! If you have premium version do not forget in the private data of the request (!!not in the text of the support request!!) after its publishing insert purchase code please (see green button on the right side) and press Save button.
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. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only 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