View Single Post
  #1   IP: 112.87.17.117
Old 2015-05-21, 06:30 AM
Altair Altair is offline
初级会员
 
Join Date: 2013-08-01
Posts: 2
Altair 现在声名狼藉
Default mass price change for all products in a specific category

If all of those Products use that Category's categories_id as their master_categories_id ...

You can backup your database and then run:
Code:
UPDATE products SET products_price = products_price * 1.15 WHERE master_categories_id = XX;
where XX is the master_categories_id for these Products ...

Then, go to the Tools ... Store Manager ... and click admin/store_manager.php, and run the:

Code:
Update ALL Products Price Sorter
 to be able to sort by displayed prices: Update
Reply With Quote