Background
Customer-specific pricing is needed when a customer requests quotes or purchases products from your lines. Repfabric has the ability to adjust quote pricing and purchase order pricing for each customer based on pricing information you store in Repfabric. Additionally, while entering Purchase Orders, customer-specific pricing can be stored as well. This article discusses how to configure customer specific pricing for your system. A price a customer pays can be chosen:
- by quantity
- by price specifically stored for that customer
- by the customer’s multiplier for the product group of the manufacturer/product line
- by buying group (or Contract pricing)
- by customer tier
These classifications are stored on the company record if they are buying group or tier-based. All others are stored in customer specific pricing tables in the Data Management menu path.
Creating Customer-specific Price tables (Manually)
We recommend manually inputting configuration and actual pricing for customers in order to test and understand the associated functionality prior to loading large amounts of pricing data. This section demonstrates the components of creating customer-specific pricing.
- Determine what pricing method you will use: set the price individually for each customer, set the multiplier by product price code, or buying group or tier based pricing per product line (manufacturer).
- If using buying group or tier, create your “Buying Groups” or “Tiers” by following the menu path Settings > Subtables > Company Buying Group or Company Tier.
2.a. Assign the companies affiliated with the Buying Group or Tier on each company’s master record under the “Price Groups” tab. To do this in bulk, please export a list of companies and create a new column for each combination of buying group or tier. Please mark the column whose buying group or tier you want to associate to that particular company.
3. Add customer specific pricing from the menu path Data Management > Customer Pricing.
In this example, we are setting the part number XL-1222 for manufacturer “Acme Explosives” to have a $105 dollar price for any member of the “Sphere 1” buying group. In the same manner, we can choose “Customer” instead of “Buying Group” to fix a specific customer’s price for XL-1222. Similarly, we could choose “Tier” to set a customer’s pricing that belongs to that Tier of pricing.
Quantity-based pricing is supported for all three options, including Customer, Buying Group and Tier. If no quantity is entered for a part’s price, that particular price will be used for any quantity. If a quantity is chosen that falls within a range that has a specific price, the price of that range will be used. If the quantity range is not found, it will default not suggest a price unless another pricing type is found.
The Line Item Ordered Quantity in the Purchase Order screen is used to set the quantity-based price.
Pricing Selection Logic for a specific Customer
What if you have a customer that has a combination of buying group, tier assignment and customer specific pricing just for themselves? Which price will be suggested or which price “wins”?
Pricing is stored for each customer in the following manner:
Step 1: Search for customer specific price
– Search for the price defined for Principal, Part No, Customer and Quantity range. If a price is found, proceed with that price
– Search for the price defined for Principal, Part No, Customer without considering the Quantity. If a price is found, proceed with that price
– If a customer specific price is not found, get the Buying Group and Tier for the Principal for that customer, If neither Buying Group nor Tier is defined, proceed with the Product master standard price.
Step 2: Search for customer-specific, product-specific multiplier pricing
If you have set up a specific multiplier price for a customer and manufacturer/product line part’s price codes, the system will search for this pricing next.
For a tutorial on how to set this up, please see Setting Up Multiplier Pricing tutorial.
Step 2: Search for Buying group price
If a Buying group is not defined for the Customer for this principal skip to Step 3.
– Search for the price defined for Principal, Part No, Buying group and Quantity range. If a price is found, proceed with that price
– Search for the price defined for Principal, Part No, Buying group without considering the Quantity. If a price is found, proceed with that price
– If a Buying group price is not found, and Tier is not defined for this customer and principal, proceed with the Product master standard price.
Step 3: Search for Tier price
– Search for the price defined for Principal, Part No, Tier and Quantity range. If a price is found, proceed with that price
– Search for the price defined for Principal, Part No, Tier without considering the Quantity. If a price is found, proceed with that price
– If a Tier price is not found, proceed with the Product master standard price.
Creating Customer-specific Pricing Tables using Imports (Automatically)
At this time, pricing data for each customer, part number and product line (manufacturer) does not have an automatic import (which is currently being written). However the Repfabric Data Team can upload your pricing tables if they fit into this Excel format.
Please make sure that company names match, buying group and tier names also match in Repfabric and all quantities are covered if you are going to use quantity-based pricing.