VirtueMart Forum

VirtueMart 1.1.x [ Old version - no longer supported ] => Products, Prices, Tax and Categories VM 1.1 => Topic started by: MrVon on May 09, 2010, 19:59:08 pm

Title: Edit option for multiple products at once?
Post by: MrVon on May 09, 2010, 19:59:08 pm
I want to change certain option for multiple products in inventory at once. e.g. "Unit of Measure" from inch to meters or any other option,  so i don't have to open each product and do it manually. How this can be done?
Title: Re: Edit option for multiple products at once?
Post by: rb on May 09, 2010, 23:46:00 pm
Mass updates to tables in the database can be done more easily with the CSV-Improved component:  http://www.csvimproved.com/

Or if you're comfortable with phpMyAdmin, you can use a single MySQL "UPDATE" statement similar to this:

Code: [Select]
UPDATE jos_vm_product SET product_lwh_uom = 'meters'