Text only | Text with Images

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Templating & Layouts => Topic started by: Nareh on May 07, 2014, 13:45:51 PM

Title: Bulk price editing
Post by: Nareh on May 07, 2014, 13:45:51 PM
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.
Title: Re: Bulk price editing
Post by: GJC Web Design on May 07, 2014, 14:36:45 PM
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
Text only | Text with Images