Ivan Milic - Networks expert Ivan Milic CEO Ivan Milic

Top Menu

× To post a question you must be signed in.

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!

Please Log in or Create an account to join the conversation.

18 Apr 2017 22:21 #2358 by Super User
Replied by Super User on topic Excel-Like Manager: Mass price update issue
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.

Please Log in or Create an account to join the conversation.

18 Apr 2017 22:46 #2364 by Johnny
Replied by Johnny on topic Excel-Like Manager: Mass price update issue
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!

Please Log in or Create an account to join the conversation.

19 Apr 2017 08:33 #2405 by Super User
Replied by Super User on topic Excel-Like Manager: Mass price update issue
Can you execute directly in DB:

DELETE FROM `wp_options` WHERE `option_name` LIKE '_transient_%';

Please Log in or Create an account to join the conversation.

19 Apr 2017 10:17 #2410 by Johnny
Replied by Johnny on topic Excel-Like Manager: Mass price update issue
Yes. It removed 422 rows of transient data, but unfortunately, that didn't fix it. Anything else I can try?

Please Log in or Create an account to join the conversation.

19 Apr 2017 10:25 #2412 by Johnny
Replied by Johnny on topic Excel-Like Manager: Mass price update issue
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!

Please Log in or Create an account to join the conversation.

19 Apr 2017 10:32 #2413 by Johnny
Replied by Johnny on topic Excel-Like Manager: Mass price update issue
P.S. I'm using WooCommerce 2.6.14

Please Log in or Create an account to join the conversation.

19 Apr 2017 14:56 - 19 Apr 2017 14:56 #2430 by Super User
Replied by Super User on topic Excel-Like Manager: Mass price update issue
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 )

Please Log in or Create an account to join the conversation.

19 Apr 2017 15:29 #2431 by Johnny
Replied by Johnny on topic Excel-Like Manager: Mass price update issue
I see missing data in the '_price' meta value

screenshot: www.screencast.com/t/Nsor2ZKggt

Please Log in or Create an account to join the conversation.

21 Apr 2017 20:10 #2436 by Super User
Replied by Super User on topic Excel-Like Manager: Mass price update issue
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;

Please Log in or Create an account to join the conversation.

23 Apr 2017 21:48 #2440 by Johnny
Replied by Johnny on topic Excel-Like Manager: Mass price update issue
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?

Please Log in or Create an account to join the conversation.

24 Apr 2017 07:28 #2443 by Super User
Replied by Super User on topic Excel-Like Manager: Mass price update issue
When you now (with fix) change price what happens ?

Please Log in or Create an account to join the conversation.

Time to create page: 0.045 seconds