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.
Option 1 - Annual Price Changes
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
The steps here are assuming you already have the 2022 Price Sheet created. If not, then create it prior to following these steps.
- Navigate to Price Books under the Pricing tab.
- Open the Price Book that contains your annual pricing and open the 2022 Price Sheet.
- When the Price Sheet opens, look at the URL and note the ID number at the end.
- Now, open the 2021 Price Sheet.
- In the Price Sheet Details section, click Export to export your Price Sheet Details for 2021.
- Open the Excel spreadsheet that was created and make the following changes.
- Remove the IDs from column A – this allows creation of a new record.
- In the PriceSheetID column, change the ID to the one noted in step 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.
-
-
-
- Enter 1.05 in an empty cell and then copy that cell.
- Select the numbers in the Price column and then right-click and choose Paste Special (click the words, not the arrow).
- In the Paste section, mark Values.
- In the Operation section, mark Multiply.
- Click OK.
- Delete the 1.05 you typed in the empty cell.
-
-
- Save the changes to spreadsheet.
- Navigate back to the 2022 Price Sheet window.
- In the Price Sheet Details section, click Import and browse to the location of the file.
- When the import is successful, Save & Close the Price Sheet.
Your 2022 pricing is now set up and ready to use.
Option 2 – Change Percentage Discount
Price changes can go beyond the price listed in
- Navigate to Price Calculations under the Pricing tab.
- Open the Price Calculation you wish to change.
- Change the Amount or Percent of the calculation.
- Click Save & Close.
Option 3 – Price Based on Cost
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.
For more information on RPM, visit our