Archive

Posts Tagged ‘update pricing’

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.

blog posting , , ,