Author Topic: Edit option for multiple products at once?  (Read 2949 times)

MrVon

  • Beginner
  • *
  • Posts: 43
Edit option for multiple products at once?
« 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?

rb

  • Advanced
  • Full Member
  • *****
  • Posts: 1503
Re: Edit option for multiple products at once?
« Reply #1 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'