Top Menu

Welcome, Guest

TOPIC: Excel-Like Manager: Mass price update issue

Excel-Like Manager: Mass price update issue 18 Apr 2017 21:58 #2356

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!
The administrator has disabled public write access.

Excel-Like Manager: Mass price update issue 18 Apr 2017 22:21 #2358

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.
The administrator has disabled public write access.

Excel-Like Manager: Mass price update issue 18 Apr 2017 22:46 #2364

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!
The administrator has disabled public write access.

Excel-Like Manager: Mass price update issue 19 Apr 2017 08:33 #2405

Can you execute directly in DB:

DELETE FROM `wp_options` WHERE `option_name` LIKE '_transient_%';
The administrator has disabled public write access.

Excel-Like Manager: Mass price update issue 19 Apr 2017 10:17 #2410

Yes. It removed 422 rows of transient data, but unfortunately, that didn't fix it. Anything else I can try?
The administrator has disabled public write access.

Excel-Like Manager: Mass price update issue 19 Apr 2017 10:25 #2412

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!
The administrator has disabled public write access.

Excel-Like Manager: Mass price update issue 19 Apr 2017 10:32 #2413

P.S. I'm using WooCommerce 2.6.14
The administrator has disabled public write access.

Excel-Like Manager: Mass price update issue 19 Apr 2017 14:56 #2430

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 )
Last Edit: 19 Apr 2017 14:56 by Super User.
The administrator has disabled public write access.

Excel-Like Manager: Mass price update issue 19 Apr 2017 15:29 #2431

I see missing data in the '_price' meta value

screenshot: www.screencast.com/t/Nsor2ZKggt
The administrator has disabled public write access.

Excel-Like Manager: Mass price update issue 21 Apr 2017 20:10 #2436

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;
The administrator has disabled public write access.

Excel-Like Manager: Mass price update issue 23 Apr 2017 21:48 #2440

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?
The administrator has disabled public write access.

Excel-Like Manager: Mass price update issue 24 Apr 2017 07:28 #2443

When you now (with fix) change price what happens ?
The administrator has disabled public write access.
Time to create page: 0.051 seconds