When migrating to VM 2.0.18a all product are in wrong group

[Th.Pilegaard]

Have tried several times to upgrade/migrate my shop to Joomla 2.5 / VM 2.0.18a

All the times are products are marked as for wholesale, so prices is only shown for those in shoppergroup wholesale.

The solution for this is to use the following sql-command (I use phpMyAdmin)

UPDATE `database`.`j25_virtuemart_product_prices` SET `virtuemart_shoppergroup_id` = '0' WHERE `j25_virtuemart_product_prices`.`virtuemart_shoppergroup_id` = 5;

I hope this can help others with the same problem

[jenkinhill]

Or simply this to change all products to the anonymous group.

UPDATE ###_virtuemart_product_prices
SET virtuemart_shoppergroup_id=1

[Th.Pilegaard]

Or simply this to change all products to the anonymous group.

UPDATE ###_virtuemart_product_prices
SET virtuemart_shoppergroup_id=1

NICE