Updating Prices Can Be Easy

Price changes are a common part of any business to keep up with inflation and changing item costs. Making these price changes as simple as possible is key to managing your pricing. Rockton Pricing Management (RPM) makes price changes easy to do. Not to mention, there is usually more than one way to accomplish what you need. Let’s look at some different examples on how to easily change your prices.

In this example, let’s say you have set up your pricing based on the calendar year through Price Sheets in a Price Book. You have a Price Sheet for each calendar year. Every January 1st you increase your pricing by 5%. With RPMyou can set up your new pricing in advance, so it automatically goes into effect on the 1st of January. No need for you to go in and activate the pricing right at midnight. It’s based on date and RPM knows exactly which one to use.

The steps here are assuming you already have the 2022 Price Sheet created. If not, then create it prior to following these steps.

  1. Navigate to Price Books under the Pricing tab.
  2. Open the Price Book that contains your annual pricing and open the 2022 Price Sheet.
  3. When the Price Sheet opens, look at the URL and note the ID number at the end.

  1. Now, open the 2021 Price Sheet.
  2. In the Price Sheet Details section, click Export to export your Price Sheet Details for 2021.

  1. Open the Excel spreadsheet that was created and make the following changes.
    1. Remove the IDs from column A – this allows creation of a new record.
    2. In the PriceSheetID column, change the ID to the one noted in step 3.
    3. In the Price column, adjust the prices by 5%.

Note: There is an easy way to update the pricing by 5% in the spreadsheet.

        1. Enter 1.05 in an empty cell and then copy that cell.
        2. Select the numbers in the Price column and then right-click and choose Paste Special (click the words, not the arrow).
        3. In the Paste section, mark Values.
        4. In the Operation section, mark Multiply.
        5. Click OK.
        6. Delete the 1.05 you typed in the empty cell.
  1. Save the changes to spreadsheet.
  2. Navigate back to the 2022 Price Sheet window.
  3. In the Price Sheet Details section, click Import and browse to the location of the file.
  4. When the import is successful, Save & Close the Price Sheet.

Your 2022 pricing is now set up and ready to use.

Price changes can go beyond the price listed in RPM. You might have your Price Schedule get the base price from a Price Book, the ERP, or some other source but then use Price Adjustments to calculate a discount or add a fee that affects that base price. This example shows you how you can easily do this by simply changing the Price Calculation.

  1. Navigate to Price Calculations under the Pricing tab.
  2. Open the Price Calculation you wish to change.
  3. Change the Amount or Percent of the calculation.
  4. Click Save & Close.

You can really keep pricing simple by not having to even do price changes. Let an increase in cost manage your increase in price. With RPM you simply base your pricing on the Item Cost. When you enter the item on a transaction, the price is calculated for you. If the item cost increases, your price increases. There is nothing more you need to do.

RPM has many ways to set up pricing, therefore, you also have many ways to adjust those prices. Whatever method you choose, RPM makes your work simpler and easier®.

For more information on RPM, visit our website. If you would like a demo, contact [email protected].

Leave a Comment