Custom Field - Bulk Price Update

[davies401]

Hi,
I have about 300 products, all of which have the same prices for small medium and large. I created a lot of the products using cloning and now I notice that I have the wrong price in the "medium" size, on about two thirds of my products. Is there a simple solution using PHPmyAdmin to update the custom field value from xx.xx to what is should be =14.95, or should I simply go back through and change each manually.

Grateful for any advice.

Using VM 2.6.12 and J2.5.27

regards
Alan

I found the table and was able to run the phpMyAdmin SQL command ok (after taking and testing the backup!)
"SELECT * FROM `#__virtuemart_product_customfields` WHERE `virtuemart_custom_id` = 3 AND `custom_price` = 24.95"
Problem Solved!

[Keddy Logern]

No My good friend,

Manually ? No Never
You can update a million products and create new -  Just use  excel file to upload / update all  at once .

for $20  In can give you a sofware that will help you update all of that CSV- advanced   all your would need is to export the product via this system and then edit wat youwant after - upload that easy.

of coures there are also more robust system for offline use but cost more.

[jenkinhill]

Yes, as you have found out, multiple updating of "identical" data is easy with SQL.