Lowest price for 30 days: {price}.

Hello,

I am experiencing the same problem as OP.

Whenever there is a change in the product (no matter what you change) the new lowest price shows 0 in the shop. In the product edit page in the backend, the ombibus column shows the correct price.

An example:
1. A product shows 100 $ with correct lowest price last 30 days 100 $
2. Edit the product: ex the short description and save
3. Frontend shop now displays lowest price 0 $, in the backend it still shows 100 $.

Allow me to post screens with the example from my website:

Before Changes

View post on imgur.com

After changes

View post on imgur.com

View post on imgur.com

The key here is the saving of the new changes which “breaks” the lowest price showing correctly.

It seems the problem started after the recent update (and migration of database). Has there been an error with the update which makes the pulling of the lowest price in the frontend linking to a wrong/old column?

• This reply was modified 9 months ago by useremil. Reason: Added example with images

We’re seeing similar issues where the lowest price either shows the current sale price, doesn’t show up at all or shows zero. All of which are wrong.

Store I debugged this with has only variable products, not sure if this is the case for others too.

I noticed that there are no new database entries for the product after saving it with different price. I tried both ways of saving variations, neither worked.

I looked at the action_save_post_product function that’s hooked to save_post_product. I think it should be using woocommerce_update_product instead. When saving variations via ajax it didn’t seem to trigger at all and when saving whole product both $product->get_regular_price() and $product->get_sale_price() functions return empty, causing the “update if needed” check to fail.

Overall the plugin seems rather buggy at the moment. As a sidenote, I think the migration should’ve been done to custom table, not posts. That would’ve improved performance even more and kept the posts table cleaner. ??

HI @tuomonurkkala

Thank you for your submission. Please upgrade to 3.0.1 – it should be works now.

Could you give ma a feedback too?

Thank you in advance.

Marcin

Hello @iworks

I’m not the original poster, but I want to let you know it worked with updating to 3.0.1.

Thanks!

I’m not the original poster, but I want to let you know it worked with updating to 3.0.1.

@useremil

Thank you!