Skip to main content

Scenario

 

TechNest, a mid-market SaaS provider of enterprise collaboration tools, operates a multi-tier sales model:

  • Sales Reps can offer limited discounts.
  • Managers and VPs can approve deeper discounts for strategic accounts.

However, rather than approving based on a discount percentage, TechNest sets absolute floor prices per SKU. For example, while the list price for the “Collaboration Suite Pro” is $100/user/month, Sales Reps must not go below $80, and Managers must not approve less than $70.

DealHub’s standard approval workflows rely on discount percentage thresholds—not specific price points.

To meet this requirement the team implemented a flexible floor-price-based approval system using DealHub’s product and proposal attributes, assignment rules, and general workflows, outlined below.

 

Solution

 

PRODUCT ATTRIBUTE

  1. In Products, click on Actions, then click on Settings, then select the “Product Attributes" tab. 
  2. Click Add Attribute and change Type to “Number”

AD_4nXd5ObdgB-LubGrWkeM3omJtQZkPa6eeQf66FINFY0kBFqvZP_8nmtiVpbZjq3AebXErnKJvK1-gfvpXLH6dRuwQoRrGRz-3Q-xcQmsAz-SSGJvHN1PGAyAeoUkJZQwBiUgIpO2fewMO9E95AZRsRI0?key=NgKa4-ZRntoX9c502TaWyA

  1. Label this attribute “Floor Price”
    1. Note, you can create as many of these “Floor Price” levels as you need. For example, if you have a floor price for sales and a different one for managers, you can create two (2) separate Attributes.

AD_4nXfY-GF0DfcxT-Ct2d2LAjSp0dDw78i4Y1ugMfkZgJ16XAKZvnaaSDxH2PiSYDupCZwTdaQpOBtLyxClLxSV3YaEt3rOkvONjT4zrtjP3YvDqu1Szh455rTtFxQOarT9IEq13XfAGZrmMMZwIgifuJU?key=NgKa4-ZRntoX9c502TaWyA

  1. After saving the new attributes, populate their values. You can do this manually by double clicking on each product, or by using DealHub’s excel bulk export/import functionality.

AD_4nXd0wFBuguGM-2gk8J8OrlxxBHYdY1xmzGRNGv9R42IxCYsrsN7CTBGYksPIopYwwx3zLLJcKYzW3YUzvNc7KGDlxbBjXguLENurIZx5TNGBHv-eCHhNPu-vHMfeF4m1RrQTXTJBTFGjg6jGHZs1aSk?key=NgKa4-ZRntoX9c502TaWyA

 

PROPOSAL ATTRIBUTE 

  1. In Products, click on Actions, then click on Settings, then select the “Proposal Attributes" tab. 
  2. Click Add Attribute and change Type to “Currency.”
  3. Label this attribute: “Floor Price Difference.” Mark as read only and hidden. 
    1. Note: Create as many of these proposal attributes per floor price type. For example, if you have a floor price for sales reps and another floor price for managers, create 2 proposal attributes: “Floor Price Difference - Sales Rep” and “Floor Price Difference - Manager”

AD_4nXccrRpyRw1KE85Y28gWUDX8bZi01x__3W6MtQ4_Cdxj8rmE6NSSGHBB70dvmJJobFp-ZTaWfZMc9QeKw8iPUjyfHhQutql1gd2-K2HKH0fMLNCKloerqdpj1wNwElz_pzlB7hXu1RTf7PldTOllVac?key=NgKa4-ZRntoX9c502TaWyA

  1. In the assignment rules of each product, find the new proposal attributes you created for the floor prices and enter in the following formula in the field: eItem.net_price] - ProductAttribute.Floor_Price] 
    1. *Please note that the Product Attribute field should be the one that matches your proposal attribute. For example, if you’re filling in information for the Floor Price Difference - Manager proposal attribute, then your formula would be: aItem.net_price] - rmatching proposal attribute for manager floor price]

AD_4nXe4ES7ZmaBk2XG3UWF-mv7IF66WwFHC4IA_ekYyQrqQxhX_Cf0bIpn1KZRdzKQM0fCARVFf1tTkd79898nMup7rCCfnWZUMmQUYUJcvR8docOZQdAPN7o577zQfLBpT6jd_onS-goLMga2_DBsbfgM?key=NgKa4-ZRntoX9c502TaWyA

 

TAG

  1. Add the Tag “Floor Price” to all of your products that will be affected by the floor price approval workflow.

AD_4nXf7Ulni5KlJLWeDtepj1eZl75aGQMzghjO6V15L74mlATq3u4soVB4-Vl-VubEhqVyx3nGVLT96jIsqFAo0LPffP8gGdcgPLWKsTgc1R9nfjtSmTFl7F4rjS2mqhaykV1ZuSEVAgasLqrGgOd3Pdg?key=NgKa4-ZRntoX9c502TaWyA

 

APPROVAL WORKFLOW

  1. In Approval Workflow & Validations → General Workflows, create a new workflow with the following settings:
    1. Description: Floor Pricing rinsert role of pricing floor]
      1. Example: Floor Pricing Sales Rep OR Floor Pricing Manager
    2. Active when: true
    3. Approval value:
      1. Note: Use the total proposal attribute for the floor price difference proposal attribute that matches the role in your description. So if you wrote Floor Price Sales Rep in the description, use the Floor Price Difference Sales Rep proposal attribute total here.
    4. Direction: Descending
    5. Immediately present for approval to all levels: TRUE
    6. Evaluate each product separately: TRUE
    7. Roles:
      1. Set your first row’s role to the role of the floor price (Description = Sales Rep, Role = Sales Rep)
      2. Add the “floor price” tag to the table via the “Add Tag” button
      3. Mark the first row as 0 under the Tag “Floor Price”
      4. Mark the last row of the table as -99999999999

AD_4nXc_ar4UZg5jqFxgFqFKP-jAox_EHZ2ajD1m2vanNCRk0ynw9HfN_iS9B7d2m9fhvKD0Rm6t1qHWPNWzElBM1PiO9Vrg7Fsfw96ORsPEcKhAb87gBeHd6f_VmTZdJMuAgG9L5eOG4l81432OkmmjfA?key=NgKa4-ZRntoX9c502TaWyA

 

Be the first to reply!

Reply