Background

Many industries operate pricing based on the “Multiplier” of the customer, which is the percentage discount off of net price the customer would normally pay.   For example, if the customer or distributor has a product with list price of $10, and they have a .6 multiplier, the price they would pay to purchase the product would be $6.   As long as you store product pricing and multipliers,  Repfabric supports properly selecting the correct multiplier when quoting based on the combination of customer, manufacturer/product line, and price group that the specific model number falls within.   This tutorial explains where to load and configure the multiplier pricing for specific customers. 

Prerequisites

  •  A list of products from your manufacturer
  • A list of multipliers for each of your customers from the manufacturer
  • If the same customer can have different multipliers based on a product family (or code), you must have a list of parts the belongs to specific product codes.

There are 2 steps to setting up Multiplier Pricing:

  1.  Import parts list or reimport parts list with “Price Code” column filled in.   This adds the necessary price code to the part numbers.  It should be a generic price code for all parts for that manufacturer.
  2. Import “Customer Price Code” sheet that lists Customers/Manufacturer/Price Code Name/Multiplier.  This adds the “Price Code” into the Subtable for “Price Codes” and the specific multiplier to each Customer.  So, on one sheet we could list more than one customer using the same “Price Code” but the multiplier can be different for each customer if necessary.

How it works

Web Portal Quotes

Once the product price codes and customer-specific multipliers are set, your multiplier will be set automatically when generating the quote.<This screen shows the quote line item detail tab>

Email Addin for Quotes

It functions similarly for quote line item creation in the email addin as well (Outlook shown).

Setting up your Multiplier Pricing

Overview

When entering a part number in a quote or PO, the multiplier selection logic works as follows:

  1. For the part selected on the quote, look at the product master table to gather the price code field.  
  2. Query the Customer Price Codes table to find a matching customer, line, and price code combination, and if found, return the multiplier listed to the quote to calculate totals.

A quick example:

If you quote Acme Mfg (line) to Ace Supply for Part ABC123, the system first checks the price code for part ABC123 in the product master and gets price code “Preferred”. Then it looks on the Customer Price Codes table to see if Ace Supply for Acme Mfg has a price code for “Preferred” and finds multiplier “.4” which it returns to the quote.  If the list price was for $10 on the product master, Ace Supply would get a .4 multiplier and thus have to pay $4 on the quote calculation.

How to set up Multiplier Pricing step-by-step

  • Import the “Customer Price Code” which adds the “Price Code” to the subtable and assigns a specific “Price Code” with the “Multiplier” to a specific customer.
  • Make sure existing products have the “Price Code” you are using for this Manufacturer. If not, import a new “Product Template” and add the “Price Code” to all part numbers for that Manufacturer.
  1. Go to “Data Management” > “Import CRM Info” > “Customer Price Codes.”
  2. Click the blue question mark and download “Customer Price Codes” template.

3. Fill in your customer price codes template with your multipliers for each customer.
*If you only have a few, you can do this by hand in the “Price Code” subtable, and in the customer using the “Price Groups” button in top right corner of the company record.

4. Import your file “Select File” > find your file > “Import”

5.. Proceed to “Aliasing”

Now you will need to load or re-load a list of part numbers that will use the price code “Tiger.”

6. Download the “Products” template and make sure to put the price code “Tiger” in the last column.

7. Import your file “Select File” > find your file > “Import” > Alias > Absorb (just like above)

Now when you create a PO or Quote, the pricing multiplier will automatically show up in the line item.

Maintaining your Pricing Information

As your pricing changes over time, you can simply reload a new “Products Template” file with the updated “Price” for the part numbers. If the Customer’s multiplier changes, you will upload a new “Customer Price Code” file with the new multiplier for one or more Customers.