PluginUs.Net - Business Tools for WooCommerce and WordPress

[realize your idea - make your dreams come true]

Support Forum

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

Woocommerce price update in SQL issue

The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page please
If you not got email within 24~36 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.
william(@william)
8 Posts
Customers
October 1, 2019, 12:54

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\_%')

#1
Pablo Borysenco(@pavlo_borysenco)
34,196 Posts
October 2, 2019, 10:47

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

#2