Skip to content

Instantly share code, notes, and snippets.

@ivandoric

ivandoric/gist:cdb91e98a3d6821c6987

Last active August 29, 2015 14:01
Show Gist options
  • Save ivandoric/cdb91e98a3d6821c6987 to your computer and use it in GitHub Desktop.
Save ivandoric/cdb91e98a3d6821c6987 to your computer and use it in GitHub Desktop.
Download ZIP
magento: Update all prices by percent
Raw
gistfile1.sql
--Check the attribute id for price first - in this case it's 75
update catalog_product_entity_decimal set value = (value*.05)+value where attribute_id=75
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment