I have a shop selling alcohol products and here in the UK, there is a tax duty price increase on all bottles of 0.15 (15 pence)
So using phpmyadmin (and my limited sql knowledge) I think I can use the following sql to bulk increase the prices across the entire database:
UPDATE 'products' SET 'products_price' = products_price+0.15;
will this work?
Edited by stevegos, 19 April 2011 - 12:20 PM.