OroCommerce Forums

Covering OroCommerce topics, including community updates and company announcements.

Forums OroCommerce How to massively update prices

This topic contains 2 replies, has 2 voices, and was last updated by  Mauro Chojrin 4 months, 2 weeks ago.

  • Creator
    Topic
  • #38279

    Mauro Chojrin
    Participant

    Hi:

    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;

    Thanks

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

    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.

    #38282

    Mauro Chojrin
    Participant

    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…).

    Thanks!

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

You must be logged in to reply to this topic.

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

Yes No