How to Add & Manage a Client Price Plan on Mercury Network®

Overview

The Mercury Network® platform allows you to create and manage client price plans through the Fees Module. Client Prices are automatically calculated based on data points such as product type, geographic area, and property value. This module enables customers to self-manage client prices through a user-friendly interface. These plans apply to UAD 3.6 products.

How to Add a Client Price Plan

Price plans allow you to set baseline client prices to be charged to the client for any product in any geographic area.

Note: These plans apply to UAD 3.6 orders.

1. Navigate to the top navigation bar and select Preferences.

2. Select Fees in the dropdown menu.

3. Click the double arrow icon at the top of the sidebar to open the left navigation, then select Client Price Plans.

   Note: You must configure value tiers before creating fee plans. Tiers are determined by the property’s Sales Price or the Owner’s Estimate of Value. For detailed instructions, refer to the article: How to Create New Value Tiers in Mercury Network®®.

4. On the VMP Client Price Plans page, select Create New Plan.

   1. Select Bulk Upload. The bulk spreadsheet method is the primary way to create multiple fee plans.

   2. Enter a plan name in the Fee Plan Name field.

   3. Select Manually add fees as the Base Fees methodology for the plan.

   4. Click Next.

5. On the Upload Plan Details section, click on the Instructions to view the file requirements.

   1. Download the Client Price Plan template.

6. Populate the fee plan spreadsheet.

   1. On the Plan tab:

      1. List every combination of products and geographic areas your fee schedule requires.

      2. For each product, include a base price for each configured Value Tier.

      3. Specify add-on fees for any order data points that, when true for the order, increase the fee. The total client price for an order is calculated by adding the base fee + any applicable add-on fees.

      Note: Required fields on the spreadsheet template have column headers highlighted in Red, while optional fields have column headers highlighted in Green. You must populate both the Plan and the List tab. Add-on fees are optional.

7. Upload your fee plan spreadsheet.

   1. Click Browse file to upload the completed template back into the system. You may assign any name to your file; the system does not require a specific naming convention.

   2. Click Save Fee Plan.

8. On the VMP Client Price Plans page, click View Fees to monitor your spreadsheet upload status and confirm the plan passed validation.

   Note: You can click the “History Log” button to the left of the “Create New Plan” button to see every successful and attempted upload in your current profile. If there was a validation error during your upload, the reason will be outlined here. 

9. If the plan validation fails, the user who uploaded the spreadsheet will receive an email notification.

   1. In the Fee Plans section, a failed icon 🚫 will display in Status column.

      

   2. Click Delete to remove the plan, then update the spreadsheet template to resolve the errors.

   3. Create a new plan using the corrected spreadsheet template. If you need to specify different fees for specific clients, refer to the article How to Create Exception Price Plans in Mercury Network®®.

How to Manage Client Price Plans

1. Navigate to the VMP Client Price Plans section.

2. Locate a plan using the Search field or by filtering by Plan Name, or Status.

3. To view or edit an existing plan, click View Fees. To remove a plan, click Delete.

4. From the existing fee plan page, click the Edit (pencil) icon to rename the Client Price Plan if necessary.

5. Use the Product and Locations filters to narrow your search for items.

6. To edit an existing fee plan, click Export, and update the data in the spreadsheet as required.

   1. Click Modify Plan to upload your updated spreadsheet and replace the existing price plan.

   2. Click Browse file to upload the spreadsheet into the system.

   3. Click Update Fee Plan.

   4. Monitor your price plan to ensure it does not encounter any validation errors.

Outcome

You have now configured price plans that automatically calculate the correct total client price for an order using base fees and add-on fees. You can differentiate pricing between products like the Traditional Appraisal - Single Family and the Traditional Appraisal - Single Family requiring a rent schedule by configuring add-on fees. If you need to specify different fees for specific clients, refer to the article How to Add & Manage Client Exception Price Plans.