Skip to main content

Creating Custom Price Levels in the Product Grid

In this video, we demonstrate how to create custom pricing levels using RPS. I show examples of price levels based on MAP pricing and explain the process step by step. By creating these price levels, you can easily customize pricing based on different parameters like MSRP and MAP.


How to Create Custom Price Levels in RPS

This guide shows you how to create custom price levels in RPS so you can see alternative pricing — like discounts or commission price breaks — instantly, without manually calculating off MSRP, MAP, or cost.

Overview

Price levels let you generate customized pricing views based on Cost, MAP, RDC, MSRP, List Price, Sale Price, Salesperson Cost, or UMRP. For example, you can create a price level for "MAP minus 10%" or "MSRP minus 10%" and RPS will calculate it automatically for every product, so you don't need a calculator to figure out discounted or marked-up pricing at a glance.

Prerequisites

  • Admin or settings access in RPS to reach Site Settings

  • Knowledge of which base price (Cost, MAP, MSRP, etc.) you want to build your new price level from

Steps

1. Open Site Settings

Click the Site Settings icon.

2. Go to Cost

Click Cost. This is where all existing price levels are listed and managed.

3. Add a new price level

Click Add Price Level.

4. Name the price level

Give it a clear, descriptive name (for example, "MSRP minus 10%").

5. Choose the product group

Select the product group this price level should apply to (for example, Appliances).

6. Select the base price to calculate from

Choose which price this level is based on:

  • Cost

  • MAP

  • RDC

  • MSRP

  • List Price

  • Sale Price

  • Salesperson Cost

  • UMRP

7. Choose margin or percent

Decide whether the adjustment should be calculated by margin or by percent.

8. Enter the adjustment amount

If calculating by percent, enter the percentage (for example, 10%). If calculating by dollar amount, enter the dollar value instead.

9. Confirm the price level

Click the checkbox to finalize the price level's calculation settings.

10. Set rounding rules (optional but recommended)

Configure how RPS should round the calculated price:

  • Dollar Round: Rounds the final price up to the nearest $1, $9, or $10.

    • Example: $247.65 rounded by $1 → $248

    • Example: $247.65 rounded by $9 → $249

    • Example: $247.65 rounded by $10 → $250

  • Upper Round: Rounds the price up to a specified cents value if the price is above that value (e.g., rounds up to 99 cents).

    • Example: $247.65 upper rounded to 99 cents → $247.99

  • Lower Round: Rounds the price down to a specified cents value if the price is below that value (e.g., rounds down to 50 cents).

    • Example: $247.45 lower rounded to 50 cents → $247.50

Note: Upper and lower rounding work off a 50-cent threshold — amounts round up or down depending on whether they fall above or below the halfway point you configure.

11. Save your changes

Click Save at the top of the screen. This step is required — price levels will not apply anywhere in RPS until saved.

Verify It Worked

  1. Go back to Product Data.

  2. Your new price level column will appear at the far right end of the row.

  3. Click and drag the column header to reposition it next to your other pricing columns for easier viewing.

You should also be able to find your new price level in these locations:

  • Anywhere you're adjusting a price

  • Open Orders

  • The Price and Calculator tool (click the price to open it)

  • Product Information → Levels tab

Common Issues

  • New price level column isn't visible on Product Data: It's added to the far right end of the row by default — drag it into position manually.

  • Price level doesn't show up anywhere: Confirm you clicked Save at the top of the screen after creating the price level. Unsaved price levels won't appear in the calculator, open orders, or product information.

  • Calculated price looks off: Double-check whether you selected margin vs. percent, and confirm your rounding settings (Dollar Round, Upper Round, Lower Round) are configured as intended.

Did this answer your question?