![]() |
|
|||||||
![]() |
|
|
Thread Tools | Display Modes |
|
|
|
#1
IP: 112.87.17.117
|
|||
|
|||
|
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 |
|
#2
IP: 112.87.17.117
|
|||
|
|||
|
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 |
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Insert/ Update random date in MySQL | Illiopolis | MySQL | 1 | 2015-04-19 06:18 AM |
| MySql避免重复插入记录方法(ignore,Replace,ON DUPLICATE KEY UPDATE) | Langdon | MySQL | 0 | 2015-01-14 03:34 PM |
| How to update drupal core | topvip | Drupal | 0 | 2012-08-22 11:17 PM |
| Problem with site options update | smiling | Blog(博客)/Wiki(维客)/RSS/Cms | 2 | 2007-10-18 09:38 PM |