By Enrico Sieni · Revify Analytics · 2026-09-08 · ~13 min read
Table of Contents
Matrix pricing is a set of rules within your ERP that automatically determines what each customer pays for each product. It functions as a decision engine, not a static list, and applies to every order line.
This guide is for manufacturers and distributors who have inherited a pricing matrix and suspect it is eroding margins. It explains the four essential dimensions, the appropriate rule types and their placement, the resolution order, and how to audit for rules pricing below your margin floor.
According to the National Association of Wholesaler-Distributors, 40 to 70 percent of distributor revenue is often priced through ad hoc decisions rather than the system, resulting in margins about 1,000 basis points lower than system pricing.
No one intends to create thousands of price rules.
These rules accumulate gradually: a regional manager offers a better price on a product group, a seller secures a deal with a fixed net price, or a consultant imports legacy pricing during implementation. Over time, the matrix grows larger than the item master, lacks clear ownership, and has a resolution order that no one can easily explain.
Fortunately, matrix pricing is a governance issue, not a software issue. All recommended fixes can be implemented within your existing ERP, by your current team, within a quarter.
ALT: Anatomy of a distributor price rule showing scope, rule type, value, effective window, and owner
What is matrix pricing, and what does it decide?
Matrix pricing sets prices by rule instead of by row. Rather than storing one price for every combination of customer and product, you store a small number of rules that combine two or more dimensions, usually a customer attribute and a product attribute, and let the system calculate the price at the moment the order line is entered.
For example, rather than managing 3.7 million price combinations for 900 customers and 4,100 items, you can create a rule: customers in the Contractor Tier 2 group purchasing items in the Fittings product group receive 18 percent off list. This single rule covers thousands of scenarios and is easy to review.
Every major distribution ERP implements matrix pricing with its own vocabulary. Epicor Prophet 21 and Epicor Kinetic call them price lists and price breaks. Infor SX.e uses price types and rebate records. NetSuite uses price levels and pricing groups. Acumatica uses sales price worksheets. SAP calls them condition records. The vocabulary changes, the approach is the same.
Matrix pricing versus a price list
A price list presents a stated price in a published document with an effective date and version. A pricing matrix determines the price behind the scenes and is typically only visible within the pricing system.
This lack of visibility is a key challenge. While outdated price lists are easily identified, outdated matrix rules often go unnoticed until a margin report reveals significant discrepancies.
Here is the size of the thing you are governing. A composite mid-market distributor we will use throughout this guide, with roughly 60 million dollars in revenue, 4,100 active SKUs, and 900 active customers, carried 61,000 active price records when the matrix was first counted. Thirty-eight thousand of those were customer-specific, and one exception was added at a time since go-live. No single person had ever seen the whole set.
What dimensions belong in a pricing matrix?
Rule 1. Pick four dimensions, not fourteen.
Every dimension you add to matrix pricing multiplies the number of cells somebody has to maintain. Most distributor matrices need four, and only four:
▪ Customer group. Not a customer. Group. Contractor, OEM, national account, counter trade. Four to six groups cover almost every mid-market book.
▪ Product group or price class. Grouped by how buyers shop and how competitive the item is, not by which vendor supplies it. Ten to fifteen groups are normal.
▪ Quantity break. Two or three breakpoints, tied to a real cost-to-serve difference in picking, packing, or freight.
▪ Effective window. A start date and an end date on every rule. This is a dimension, not an afterthought, and leaving it blank is how a 2023 price survives into 2026.
Four customer groups, twelve product groups, and three quantity breaks result in 144 manageable cells. This is a volume one person can review in an afternoon. In contrast, no one can effectively review 61,000 records.
There is often pressure to add more dimensions, such as branch, ship-to, sales representative, or brand. Each additional dimension increases complexity and maintenance. Only add a new dimension if it is essential, and remove another to keep the total manageable. The key is to maintain a matrix size that can be audited by a person.
Defining groups requires the same discipline as designing wholesale tiers: each tier must reflect a meaningful distinction, and boundaries must be justifiable to customers.
Which rule type belongs at which level?
Rule 2. One rule type per level, chosen deliberately.
Most matrix pricing systems include a mix of rule types that were inherited rather than intentionally selected. There are four main types, each with its own potential failure mode.
▪ Fixed net price sets an absolute price per unit. It belongs on contract lines and single items, on short terms with an end date. It fails when cost moves and the price does not, so every cost increase is absorbed silently.
▪ Discount off list sets a percentage off the current list price. It belongs to the customer group crossed with the product group at the workhorse level. It fails by inheriting the list price’s staleness, because a stale list makes every discount wrong at once.
▪ Cost plus markup sets the cost multiplied by one plus the markup. It belongs to volatile-cost commodities and pass-through items. It fails when the cost field is not a landed cost, and when markup is quietly read as margin.
▪ Margin target sets price at cost divided by one minus the target margin. It belongs on floors and guardrails, not on everyday pricing. It fails when the target is set once at implementation and never reviewed against the market again.
The cost-plus approach often leads to a common arithmetic error: a 30 percent markup does not equal a 30 percent margin; it results in a 23.1 percent margin.
Formula. Margin percent = markup / (1 + markup). A 30 percent markup gives 0.30 / 1.30, which is 23.1 percent.
This results in a loss of seven margin points on every line where markup and margin are confused. If your matrix includes cost-plus rules, verify the original intent, as errors in cost-plus pricing often go unnoticed.
The recommended approach is straightforward: use discount off list at the group level for scalability and clarity; reserve margin targets for the floor; apply cost-plus only when costs change faster than you can update the list; and use fixed net prices only as exceptions, with an end date and contractual justification.
ALT: Matrix pricing rule resolution order for distributors, most specific rule first
What happens when two pricing rules match the same order line?
Rule 3. Write the resolution order down before you write another rule.
This is the question that separates matrix pricing that holds from matrix pricing that surprises people. On a typical order line, three or four rules can legitimately match at once: a customer-specific price, a customer group discount, a quantity break, and the list price. Something has to be decided.
Most ERPs resolve most specific first, and stop at the first match. That is a reasonable default, and it has a consequence people miss: a customer-specific rule beats every improvement you make at the group level. Raise the Contractor Tier 2 discount structure all you like. The 212 accounts carrying their own fixed net price will never see it.
Here is the order, most specific first. Write it on one page and give it to every seller:
1. Customer plus item. Contract lines and negotiated exceptions. Beats everything below it.
2. Customer plus product group. Account-level category deals. Beats levels 3 to 6.
3. Customer group plus item. Promotional or competitive items. Beats levels 4 to 6.
4. Customer group plus product group. The workhorse rule, where most of your pricing should live. Beats levels 5 and 6.
5. Quantity break table. Volume incentives are applied after the base rule has resolved. Beats level 6.
6. List price. The default when nothing else matches. Beats nothing.
Two practical steps follow: first, verify that your ERP’s resolution order matches this structure by testing actual order lines rather than just reviewing documentation. Second, address pricing issues at the lowest applicable level to avoid creating permanent exceptions for temporary problems.
Why does every price rule need an owner and an expiry date?
Rule 4. No owner and no end date means no rule.
Two fields—owner and expiry date—are simple to implement but have a significant impact.
An owner should be a specific individual, not a department. When account margins decline, exception reports must be directed to a responsible person. In our example, 38,000 customer-specific records lacked an owner, turning every inquiry into a research task.
An expiry date ensures that each rule is periodically reviewed. Set a default of twelve months; when a rule expires, the account reverts to its group rule unless renewed. This simple field transforms a permanent concession into an annual negotiation and is an effective governance tool.
This matters more than it sounds because manual processes are still the norm. The 2025 Revenue Growth Analytics Maturity Report found that 61 percent of companies still rely on manual, inconsistent processes for deal discounting, and 50.7 percent have no price waterfall at all. If the discount is manual and the rule never expires, nothing in the system will ever correct it. A person has to.
The accounts to start with are those that appear in a customer profitability analysis at the bottom of the book. That is usually where the oldest rules are hiding.
How do you stop the matrix pricing below your floor?
Rule 5. A floor that warns is not a floor.
Every matrix pricing system should include a clearly defined, arithmetic-based floor.
Formula. Floor price = cost / (1 – minimum margin). At a 7.30 dollar landed cost and a 27 percent minimum margin, the floor is 7.30 / 0.73, which is 10.00 dollars.
Two factors determine whether the floor is effective.
The first is which cost you use. Standard cost, last cost, and average cost all reside in the item master, and each is wrong for this purpose. The floor has to be built on landed cost, including freight, duty, and handling, or you are protecting a margin you never actually earn.
The second factor is the system’s response when a rule price is below the floor. Most ERPs issue a warning that can be bypassed, often ignored by sellers. Instead, implement a hard block requiring approval from a designated approver. The resulting list will identify your remediation priorities.
ALT: Price waterfall showing a customer-specific price 85 cents below the margin floor
Where does matrix pricing leak margin?
Rule 6. Audit the overrides monthly, ranked by margin given up.
Overrides are where matrix pricing stops being the pricing system. The National Association of Wholesaler-Distributors puts the scale plainly: at many distributors, 40 to 70 percent of revenue dollars come from on-the-fly pricing decisions rather than from system pricing, and those overridden lines carry margins roughly 1,000 basis points below system-priced lines.
This can result in a loss of ten margin points on up to seventy percent of revenue.
Overrides are not inherently problematic, as competitive situations do occur. The issue arises when overrides are not reviewed, as they can become precedents and eventually permanent customer-specific rules with no clear rationale. The monthly exception report is four columns and takes an analyst an hour to build:
1. The line. Customer, item, quantity, date, seller.
2. The two prices. What the matrix said, and what was invoiced.
3. The money. Margin dollars given up, which is the gap multiplied by the quantity. Sort the report by this column, descending.
4. The reason code. A short list, chosen from a menu, is never free text.
Prioritize overrides by margin dollars given up, not by frequency. Numerous small overrides may be insignificant, while a few large overrides on key accounts can have a substantial impact. This approach applies across all sales channels.
What does a worked example look like?
Follow one item through the composite distributor, and the whole failure becomes visible in five steps.
▪ Landed cost, 7.30 dollars. Freight, duty, and handling included.
▪ List price, 12.40 dollars. A 41.1 percent margin. The published number.
▪ Contractor Tier 2 rule at 18 percent off list, 10.17 dollars. A 28.2 percent margin. This is the level 4 rule that should be governing the account.
▪ Margin floor at a 27 percent minimum, 10.00 dollars. That is 7.30 divided by 0.73.
▪ Customer-specific fixed net price set in 2023, 9.15 dollars. A 20.2 percent margin. A level 1 rule, with no expiry date and no owner.
The customer-specific price was 85 cents below the floor, and no action was taken because the system only issued a warning. The account purchased 14,800 units of this item over the year.
This resulted in $12,580 of margin lost on a single item for one customer: (10.00 – 9.15) x 14,800 = $12,580.
An audit revealed 3,140 rows priced below the floor across 212 customers, resulting in an annualized margin loss of approximately $410,000, or about 0.7 gross margin points.
Costs made it worse while nobody was looking. Producer prices for final demand rose 4.7 percent over the 12 months ended July 2026, according to the Bureau of Labor Statistics. Every one of those 3,140 fixed net prices absorbed that increase in full, because a fixed net price is a promise to hold a number while your costs do whatever they want.
None of these solutions required new software. The fixes included publishing the resolution order, adding expiry dates to all customer-specific rules, converting the floor from a warning to a block, and implementing a monthly exception report sorted by margin dollars. All were completed within one quarter, with no additional staff.
The benefits of effective matrix pricing are significant. Revify’s analysis of over 2,000 public companies found that a 1 percent increase in net price raises operating profit by a median of 6.4 percent. Recovering 0.7 margin points is substantial and delivers ongoing value as rules remain well-governed.
ALT: Rule sprawl compared with a governed pricing matrix of 144 cells for a mid-market distributor
Is customer-by-customer pricing legal in the United States?
Yes, with a defensible basis, and any distributor running matrix pricing should understand it properly rather than avoid it.
The Robinson-Patman Act prohibits a seller from discriminating in price between competing buyers of commodities of like grade and quality where the effect may be to injure competition. The Federal Trade Commission’s guidance on price discrimination also sets out the recognized defenses: a price difference justified by differences in the cost of manufacture, sale, or delivery, and a price offered in good faith to meet a competitor’s price.
Read against matrix pricing, which translates into something operationally useful. A quantity break tied to real picking and freight economics has a cost justification. A customer group built on an order profile and cost-to-serve has a cost justification. A fixed net price set in 2023 by a sales manager who has since left the business, with no recorded reason and no end date, has nothing behind it.
Governance and legal defensibility turn out to be the same work. The reason code, the owner, and the effective window are what a documented basis looks like in practice. This is general information rather than legal advice, and specifics for your business belong with your counsel.
What mistakes wreck a pricing matrix?
▪ Believing more matrix pricing rules means more precision. More rules mean more places for a stale price to hide. Precision comes from choosing the right dimensions, not from adding more of them.
▪ Treating the floor as a warning. If a seller can click past it, it is a suggestion. Make it a block with a named approver.
▪ Assuming cost plus rules are self-correcting. They correct only if the cost field is “landed cost” and only if the markup is not read as margin. A thirty percent markup is a 23.1 percent margin.
▪ Calling customer-specific prices a service. Many were set once for a single order and never removed. Ask how many of those customers could still name the price they were promised.
▪ Avoiding differentiated pricing because it feels legally risky. Different prices are lawful when supported by a defensible basis. The risk sits in undocumented differences, not in differences.
Frequently asked questions
What is matrix pricing?
Matrix pricing is a method of setting prices by rule rather than by row. Rules combine a customer dimension and a product dimension, usually with a quantity break and an effective date, and the ERP calculates the price when the order line is entered. It replaces millions of possible customer-item price combinations with a few hundred readable rules.
What is the difference between matrix pricing and a price list?
A price list states a price in a published document with a version and an effective date that a customer can hold. A pricing matrix determines a price using rules within the ERP that most people never see. The list is the output. The matrix is the machinery. A distributor usually needs both, and they have to agree with each other.
How many pricing rules should a distributor have?
Enough to cover your dimension math, and no more. Four customer groups, twelve product groups, and three quantity breaks give 144 governable cells. Add contract exceptions on top, each with an owner and an expiry date. If your record count is in the tens of thousands, the number is not evidence of precision; it is evidence of accumulation.
Is it legal to charge different customers different prices?
In the United States, yes, when there is a defensible basis. The Robinson-Patman Act restricts price discrimination between competing buyers of like goods, and the FTC recognizes two central defenses: cost justification, where the difference reflects the real cost of sale or delivery, and meeting a competitor’s price in good faith. Document the basis, the owner, and the date on every exception. Take your specifics to counsel.
How often should you audit a pricing matrix?
Monthly for overrides and below-floor lines, sorted by margin dollars given up. Quarterly for the floors themselves, against the current landed cost. Annually, for a full rebuild of the group structure. Any rule without an owner or an end date should be treated as expired at the next monthly review.
The principle underneath all of it
Matrix pricing is the only part of a distributor’s commercial policy that executes on its own. The strategy deck gets read once. The margin target gets discussed quarterly. The matrix answers a question every few seconds, all day, on every order line, and it answers it exactly the way somebody configured it years ago, whether or not that person still works here and whether or not the reasoning still holds.
That is why the fix is never a better spreadsheet. It is a resolution order somebody can recite, a floor that says no, an owner with a name, and a date that forces the decision to be made again. Four conditions. None of them requires a pricing team. All of them require someone to decide that the matrix is a system with rules rather than a filing cabinet with contents.
Most distributors possess all the necessary data; what is often missing is dedicated oversight.
Begin your Profit Diagnostic: we analyze your live pricing matrix, identify rules lacking an owner or an expiry date, and quantify the margin lost due to below-floor pricing. You receive an exception list ranked by margin impact, along with a summary of your ERP’s actual resolution order.
About the author: Enrico Sieni is Co-Founder of Revify Analytics. With over two decades of experience leading pricing for manufacturers and distributors, he has built three pricing teams and now advises mid-market companies on practical pricing solutions. His expertise includes rule design, floor management, exception reporting, and seller-level tracking to ensure pricing policies are reflected in financial results.
