View Single Post
  #2   IP: 112.87.17.117
Old 2015-05-21, 06:27 AM
Alberton Alberton is offline
初级会员
 
Join Date: 2009-10-17
Posts: 1
Alberton 现在声名狼藉
Default

You could do this with an UPDATE command via the Insert SQL Patch if you know the master_categories_id ...

Code:
UPDATE products SET products_price = products_price + 5.00 WHERE master_categories_id = 32;

NOTE: be sure to backup your database before attempting this ...

When done, you would want to run the Tools ... Store Manager ... for updating the products_price_sorter ...

Also be aware of the implication on Specials ...

admin/store_manager.php
Reply With Quote