View Full Version : Bulk Update Attribute Prices
Altair
2015-05-21, 06:31 AM
I have download products that are priced solely by attribute. Is it possible to change product-attribute prices by a percentage or fixed amount? It is possible to update 1 product's prices and then copy to the Category or to selected products but the latter is tricky because the interface relies on highlighting products in what could be a very long list...
Thanks
Ansley
2015-05-21, 06:32 AM
UPDATE `products_attributes` SET `options_values_price` = '15.0'
WHERE `options_values_price` = '10.0' AND `options_values_id` = '5'
UPDATE `products_attributes` SET `options_values_price` = '15.0'
WHERE `options_values_price` = '10.0' AND `options_values_id` = '6'
I looked in the table products_options_values for the options_values_id (products_options_values_id) and the corresponding products_options_values_name
vBulletin v3.8.7, Copyright ©2000-2026, Jelsoft Enterprises Ltd.