Adjust Prices by a Fixed Percentage

To update Price List items, you can use Pricing Calculations and update them using a fixed percentage. This can be done for:

Adjust Prices for an Entire Price List

  1. From the Main Menu search for and select Price Lists. The Price Lists page opens.
  2. Select the price list with the items for the price adjustment.
  3. Right-click and select Tools > Pricing Calculations. The Pricing Calculation window opens.
  4. Enter the necessary information:
    • Percent - Percentage increase or decrease. For a decrease you will need to put a minus (-) in front of the amount.
    • Percent Type - Price field to apply the increase or decrease to.
      • Markup - Increases or decreases the price from the base cost. This is putting a change against your Base Cost (not Base Price). If there is no amount on your Base Cost, this will have a $0 value after processing the calculation. 
      • Over Current - Increases or decreases the price from the current price. If selecting Standard (Step 5 below), this will change the Standard Price on your price list. 
    • Round To - Rounding preference.
  5. Check the boxes for the prices to adjust (Recalculation Advance Price, Recalculate Standard Price, Recalculate Late Price).
  6. Click OK.

Adjust Prices for a Group of Items on a Price List

  1. From the Main Menu search for and select Price Lists. The Price Lists page opens.
  2. Select the price list with the items for the price adjustment.
  3. Right-click and select Edit. The Edit Price List window opens.
  4. Select the Price List Items tab.
  5. Select the items that need the price adjusted. Use Ctrl+Click or Shift+Click to select multiple items.
  6. Right-click and select Tools > Pricing Calculations. The Pricing Calculation window opens.
  7. Enter the necessary information:
    • Percent - Percentage increase or decrease. For a decrease you will need to put a minus (-) in front of the amount.
    • Percent Type - Price field to apply the increase or decrease to.
      • Markup - Increases or decreases the price from the base cost. This is putting a change against your Base Cost (not Base Price). If there is no amount on your Base Cost, this will have a $0 value after processing the calculation. 
      • Over Current - Increases or decreases the price from the current price.  If selecting Standard (Step 8 below), this will change the Standard Price on your price list.
    • Round To - Rounding preference.
  8. Check the boxes for the prices to adjust (Recalculation Advance Price, Recalculate Standard Price, Recalculate Late Price).
  9. Click OK.

Adjust Price for a Single Item on a Price List

  1. From the Main Menu, search for and select Price Lists. The Price Lists page opens.
  2. Select the price list with the item for the price adjustment.
  3. Right-click and select Edit. The Edit Price List window opens.
  4. Select the Price List Items tab.
  5. Select the item which needs the price adjusted. 
  6. Right-click and select Tools > Pricing Calculations. The Pricing Calculation window opens.
  7. Enter the necessary information:
    • Percent - Percentage increase or decrease. For a decrease you will need to put a minus (-) in front of the amount.
    • Percent Type - Price field to apply the increase or decrease to.
      • Markup - Increases or decreases the price from the base cost. This is putting the change based on the Base Cost (not Base Price). If there is no amount on your Base Cost, this will have a $0 value after processing the calculation. 
      • Over Current - Increases or decreases the price from the current price. If selecting Standard (Step 8 below), this will change the Standard Price on your price list. 
    • Round To - Rounding preference.
  8. Check the boxes for the prices to adjust (Recalculation Advance Price, Recalculate Standard Price, Recalculate Late Price).
  9. Click OK.

Related articles

Comments

9 comments

Date Votes
  • Jason Allen

    This does not work, and doesn't do what you would generally expect from a recalculation. (I'm using v19.50K)

    If using the % over current, it actually places your xx.x % as a markup against base. So you are getting a base markup and not a recalcuation. And there appears to be no way to recalculate the base price, so you are never really updating prices, but just performing markup on base. If using % markup as the basis, then it reset your pricing back to 0.00 and leaves base price untouched.

    1 upvotes

  • Mark Meacham

    If using the** % over current to adjust pricing**, and you tick the boxes next to Advance and Late in the "Price List" section, the system will either increase or decrease the prices (Advance and Late) by the value entered in this field. And if you tick the checkbox to "Recalculate Standard Price", this will also adjust the Standard Price field by the value entered as well. 

    If using **% Markup to adjust pricing, **this will reset your pricing back to zero, and leave the base price at the original amout.

    0 upvotes

  • Jason Allen

    If you have a value for Base Price, and are using Adv %, Std %, or Late % markup values to set the Adv, Std, or Late prices, then how do you complete a price recalculation on the Base Price? Scenario: You copy 2013 price list into 2014 price list, and want to add x% to your Base Price for annual increase, which then also reflects in your Adv, Std, and Late prices as they have % markup.

    0 upvotes

  • Mark Meacham

    Currently, neither one of the options, "% Markup" or "% over Current" adjusts the base price.  The functionality of the copy price list was not designed to ever change or touch the base price, as the base price is used to determine the Advance, Standard, and/or late price.  Since, when choosing the % Markup is resetting the values to zero, we will explore what is causing this behavior and update this article. 

    0 upvotes

  • Mark Meacham

    Currently in v19.6/20.6, this is how the process works:

    1.  If using % over current, the system takes the percentage entered and updates prices based on the price that currently appears in the Advanced, Standard and late columns

    2.  If using % Markup, the system uses the Cost Price of the item(s) and changes the prices for Advance, Standard and Late to the Cost Price + the Markup.

    There currently is not a Markup over the Base Price, but will send this request to the Product Management team to be reviewed for a future release consideration.

     

    0 upvotes

  • Gardy Noel

    This is a useful tool, especially when setting up future price lists, or making wholesale changes to rates within a price list.  Will there be a part of that tool that allows us to change/increase a rate by flat number, as opposed to percentage? I feel like that's the only thing missing from this, as I've found myself having to increase rental rates in the past by a dollar amount, and not a percentage.


    Gardy

    1 upvotes

  • Megan Eve

    I am selecting multiple outlined in #4 but it doesn't work. It only edits the one I right clicked on. 

    0 upvotes

  • Maggie U.

    Hi Megan,

    I did a quick test on my end but didn't experience the same problem. However, there could be other factors in play so please enter a case with our Client Care Team and they can get more details and work with you on a solution.

    Thanks!

    Maggie

    0 upvotes

  • Karin van der Horst

    https://supportcenter.ungerboeck.com/hc/en-us/articles/204557808/comments/202841698 - There currently is not a Markup over the Base Price

    Mark, did product management follow up on your request?

    The point i sthat the base price stays as it is - being of influencee on the tierpricings and next year you want to add a new percentage , but the mark up is then calaculed over the marked up prices ( not giving the right amounts).

    At some point Base price should be the new base value - equal to standard price

    0 upvotes

Please sign in to leave a comment.