[solved] Panic mode: after last update... Some prices displayed call for price

[xoxolo]

Hi everyone,
After making the update to the last release on a working state install, some price aren't displayed, instead, I have Call for price...
In the back end, everything looks perfect.
Can't see any solution, help...

Thanks a lot! For your time and answer!

Olivier

[Milbo]

Check the products, do NOT enter any shoppergroup if you use only one price.
Virtuemart rule #1 if you mean "all", enter "nothing".

[xoxolo]

Thanks for your update Milbo, after a close check, all my products are set exactly the same.
No shoppergroup set.
Any other clue?

Thanks for your time!

Olivier

I can post screenshots if needed.

[gpessoa]

I had the same problem and solved it with a SQL update on DB
I had set shoppergroup on virtuemart_product_prices to null

[xoxolo]

Hello gpessoa,

Thanks for your input, love what I read!!!
Can you help me a bit throughtout the process?

Thanks a lot!

Olivier

[gpessoa]

Use phpMyAdmin or other tool. You may/ can find it on your cpanel
Go to your DB, and run the following SQL command:
UPDATE `jos_virtuemart_product_prices` SET `virtuemart_shoppergroup_id` = NULL

[xoxolo]

I own you 1 guys, thanks a lot, special mention to gpessoa, you rock!
Made my day, probably my week!!!
Thanks a lot!

Olivier

[xoxolo]

@gpessoa

Everything works well based on my original question, now my shopping cart doesn't work, is it logical?
Thanks for your help!

Olivier

[xoxolo]

Activating the SEO of Virtuemart did it...
Thanks anyway.

Olivier