OroCommerce Forums

Covering OroCommerce topics, including community updates and company announcements.

Forums Forums OroCommerce How to massively update prices

This topic contains 2 replies, has 2 voices, and was last updated by  Mauro Chojrin 1 year, 3 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
  • #38279

    Mauro Chojrin


    I need to update the prices for all the products in my main price list (I live in a country with high inflation :( ).

    Is there a way to do it in a single operation from the admin console? I’d like to issue something like update products set price = price * 1.05;


Viewing 2 replies - 1 through 2 (of 2 total)
  • Author
  • #38281

    2 options:

    • Export prices, edit using MS Excel/OpenOffice Sheet, import them back
    • Try a setup with 2 price lists: “Original Prices”, “Current Prices”. The prices in the “Original Prices” will never be updated. “Current Prices” price list will containt only the formula (where 1 is the ID of the “Original Prices” price list):

      Price For Quantity (quantity input field): pricelist[1].prices.quantity
      Price For Quantity (unit input field): pricelist[1].prices.unit
      Price For Quantity (currency input field): pricelist[1].prices.currency
      Calculate As: pricelist[1].prices.value * 1.05

      And use this “Current Prices” pricelist everywhere (system configuration, etc.) instead of the “Original Prices”. Update the “Calculate As” formula when necessary.

      Make sure to check the prices generated by these expressions and formula when setting this up.


    Mauro Chojrin

    Hi Michael:

    Thanks for your suggestions… I have to say, I was kind of hoping there was another way :(

    I had thought about the second option (not the prettiest one but I guess it could do the job…).


Viewing 2 replies - 1 through 2 (of 2 total)

The forum ‘OroCommerce’ is closed to new topics and replies.

You will be redirected to [title]. Would you like to continue?

Yes No