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'
  );