Top Menu

Excel-Like Manager: Mass price update issue

18 Apr 2017 21:58 #2356 by Johnny
When I do a mass price update, there are two issues I'm seeing:

1. if I increase a products price by 10%, then decrease the price by 10%, the price does not return to its original value. For example: Original price was $120, then I used mass update (+10%), then price went to $132 which is correct. But then I wanted to change the price back, so I reduced by 10% (-10%), but then the price wen't to $118.80, which is technically correct, but I would like a way to return the price back to its original value. Is this possible?

2. Another issue I'm seeing is that the prices are in the product database, but they are not showing up for some items. See video: www.screencast.com/t/1Q09wEyciaL

How do I fix this so the prices will "stick"

Thanks for your help!
18 Apr 2017 22:21 #2358 by Super User
Hi,

1. Hi, you will have to do turn on calculator :). We can not make something work like that.

2. It look like some caching issue. Search for some "transients cleaning" plugin.
18 Apr 2017 22:46 #2364 by Johnny
1. - I'll use a calculator. ;)
2. I used WP-Sweep to sweep the database and that didn't fix it. Is there something else I could try?

Thanks!
19 Apr 2017 08:33 #2405 by Super User
Can you execute directly in DB:

DELETE FROM `wp_options` WHERE `option_name` LIKE '_transient_%';
19 Apr 2017 10:17 #2410 by Johnny
Yes. It removed 422 rows of transient data, but unfortunately, that didn't fix it. Anything else I can try?
19 Apr 2017 10:25 #2412 by Johnny
I stumbled across this article which seems to explain the issue I'm having and a possible fix. LMK if this is helpful.

github.com/woocommerce/woocommerce/issues/9400

Thanks!
19 Apr 2017 10:32 #2413 by Johnny
P.S. I'm using WooCommerce 2.6.14
19 Apr 2017 14:56 - 19 Apr 2017 14:56 #2430 by Super User
Go to PELM settings and add 3 custom filed hooked to "Meta" properties as follow:

_regular_price
_sale_price
_price

Observe what they show and what you see in normal backend

(remember columns/custom fields you add change source type to meta )
19 Apr 2017 15:29 #2431 by Johnny
I see missing data in the '_price' meta value

screenshot: www.screencast.com/t/Nsor2ZKggt
21 Apr 2017 20:10 #2436 by Super User
Open:

wp-content\plugins\excel-like-product-manager-for-woocommerce-and-wp-e-commerce\shops\wooc.php

find this around line 1653:

$_price = $s_price ? $s_price : $r_price;

replace with

$_price = trim($s_price) ? $s_price : $r_price;
23 Apr 2017 21:48 #2440 by Johnny
Done! What should I do next?

P.S. I just saw there's an update to the plugin (v 2.0.87) - does this update include the above fix?
24 Apr 2017 07:28 #2443 by Super User
When you now (with fix) change price what happens ?
Time to create page: 0.059 seconds