Let's say you want to put every price up in your catalog. Or maybe even down.
- You can do it by installing an extension.
- You can also do it by exporting all of you products and remimporting them with the price difference.
- You can also do it by an SQL command that we show below
Increase all prices by X%
UPDATE catalog_product_entity_decimal val SET val.value = (val.value * 1.10`) WHERE val.attribute_id = ( SELECT attribute_id FROM eav_attribute eav WHERE eav.entity_type_id = 4 AND eav.attribute_code = 'price' );
Decrease all prices by X%
UPDATE catalog_product_entity_decimal val SET val.value = (val.value / 1.10) WHERE val.attribute_id = ( SELECT attribute_id FROM eav_attribute eav WHERE eav.entity_type_id = 4 AND eav.attribute_code = 'price' );
In each of the above commands just change the 1.10 to suit the percentage increase or decrease you want.
You can also do the same with MagManager custom SQL. The difference being we use the prefix macro and also a custom variable that will ask for the amount when you run the script.
Increase all prices by X% in MagManager
UPDATE /*PREFIX*/catalog_product_entity_decimal val SET val.value = (val.value * :`deci.1.10`) WHERE val.attribute_id = ( SELECT attribute_id FROM /*PREFIX*/eav_attribute eav WHERE eav.entity_type_id = 4 AND eav.attribute_code = 'price' );
Decrease all prices by X% in MagManager
UPDATE /*PREFIX*/catalog_product_entity_decimal val SET val.value = (val.value / :`deci.1.10`) WHERE val.attribute_id = ( SELECT attribute_id FROM /*PREFIX*/eav_attribute eav WHERE eav.entity_type_id = 4 AND eav.attribute_code = 'price' );