VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: Th.Pilegaard on January 24, 2013, 15:33:36 PM

Title: When migrating to VM 2.0.18a all product are in wrong group
Post by: Th.Pilegaard on January 24, 2013, 15:33:36 PM
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
Title: Re: When migrating to VM 2.0.18a all product are in wrong group
Post by: jenkinhill on January 24, 2013, 15:55:33 PM
Or simply this to change all products to the anonymous group.

UPDATE ###_virtuemart_product_prices
SET virtuemart_shoppergroup_id=1
Title: Re: When migrating to VM 2.0.18a all product are in wrong group
Post by: Th.Pilegaard on January 24, 2013, 16:41:43 PM
Quote from: jenkinhill on January 24, 2013, 15:55:33 PM
Or simply this to change all products to the anonymous group.

UPDATE ###_virtuemart_product_prices
SET virtuemart_shoppergroup_id=1

NICE