Author Topic: Prices: Available for all (no shopper group)  (Read 898 times)

okewaja

  • Beginner
  • *
  • Posts: 13
  • A beginner
Prices: Available for all (no shopper group)
« 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

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27541
  • Always on vacation
    • Jenkin Hill Internet
Re: Prices: Available for all (no shopper group)
« Reply #1 on: April 11, 2016, 23:22:01 pm »
Edit the shopper group field directly in the database.
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

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

Currently using VM 3.6.3.10163 on Joomla 3.9.12 PHP 7.0.33

okewaja

  • Beginner
  • *
  • Posts: 13
  • A beginner
Re: Prices: Available for all (no shopper group)
« Reply #2 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?

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9139
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.4.2
Re: Prices: Available for all (no shopper group)
« Reply #3 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
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation