Magento Notes - Quick way to update pricing for all products
June 10th, 2010
Had a need to increase pricing for ALL products in the Magento store by $5.00, below is the script that I ran directly in phpadmin that takes care of this:
UPDATE catalog_product_entity_decimal val
SET val.value = (val.value + 5)
where val.attribute_id=’60′
Where 5 is the price increase, so you can adjust that number accordingly.

Thats a good trick. Good job