Prices: Available for all (no shopper group)

[okewaja]

Hi,
I've created 300 prodcuts with CSVI and assigned prices with Mass Update. All prices have been saved for "default shopper group". How could I change them to "available for all"? Or make them default as "available for all"??

I have hundrets of products to create, I can't just change every product from administrator panel...


Thx!
Matt

[jenkinhill]

Edit the shopper group field directly in the database.

[okewaja]

Hm... never done it. Do I need phpmyadmin for that? Do I need to know php to do it?

[GJC Web Design]

google is your friend...

any db tool

UPDATE `#__virtuemart_product_prices` SET `virtuemart_shoppergroup_id`= 0

backup, backup and backup first