News:

Looking for documentation? Take a look on our wiki

Main Menu

Bulk price editing

Started by Nareh, May 07, 2014, 13:45:51 PM

Previous topic - Next topic

Nareh

Hi there.

Is there any way in Virtuemart to edit lots of prices together. Like I want to add  10dollars to 100 product's prices.

Thanks beforehand.

GJC Web Design

Directly in the table - run a query like

UPDATE `jos_virtuemart_product_prices` SET `product_price` = `product_price` + 10

you need to fine tune your query to exactly what you need  - and of course back up 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