VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product pricing => Topic started by: okewaja on April 11, 2016, 17:31:44 PM

Title: Prices: Available for all (no shopper group)
Post by: okewaja on April 11, 2016, 17:31:44 PM
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
Title: Re: Prices: Available for all (no shopper group)
Post by: jenkinhill on April 11, 2016, 23:22:01 PM
Edit the shopper group field directly in the database.
Title: Re: Prices: Available for all (no shopper group)
Post by: okewaja on April 12, 2016, 10:24:54 AM
Hm... never done it. Do I need phpmyadmin for that? Do I need to know php to do it?
Title: Re: Prices: Available for all (no shopper group)
Post by: GJC Web Design on April 12, 2016, 10:31:18 AM
google is your friend...

any db tool

UPDATE `#__virtuemart_product_prices` SET `virtuemart_shoppergroup_id`= 0

backup, backup and backup first