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!
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.
Yes, as you have found out, multiple updating of "identical" data is easy with SQL.