![]() |
Bulk Update Attribute Prices
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 |
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 |
| All times are GMT +8. The time now is 09:21 PM. |
Powered by vBulletin Version 3.8.7
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.