News:

Looking for documentation? Take a look on our wiki

Main Menu

Prices: Available for all (no shopper group)

Started by okewaja, April 11, 2016, 17:31:44 PM

Previous topic - Next topic

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.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation