Price Break Tables When Landed Cost Changes Mid-Quarter

Price break table maintenance is the job of re-deriving every volume tier whenever the landed cost underneath it changes. A price break table is not a list of prices. It is a set of margins, each one calculated against a cost on the day the table was written. When that cost moves and the table does not, every tier is quietly priced against a number that no longer exists.

We covered how to draw the breaks in the first place, and why a stale table bleeds hardest at the break quantity, in volume pricing tiers for wholesale distributors. This post is about the part that comes after: what has to be stored next to a table so it can be recalculated instead of guessed at, and what happens to the quotes and contract prices already out in the world when the cost moves.

Why does landed cost move more often than the price list?#

Landed cost is everything it takes to get a unit onto your shelf: the supplier's price, inbound freight, and duties, as of the day the goods arrive. Each of those three moves on its own clock, and in 2026 at least one of them moved for reasons that had nothing to do with your supplier.

Distribution Strategy Group laid out the pressure in April. A presidential proclamation signed April 2 and effective April 6 changed how Section 232 tariffs apply to steel, aluminum, and copper imports, so that in many cases duties are assessed on the full customs value of a covered import rather than only the value of its metal content. Even where the tariff rate did not change, the base it applies to did. That is a landed cost increase with no new supplier price letter attached.

The same piece captured how busy the supplier side has been. Grainger CEO D.G. Macpherson said on a 2025 earnings call that the company had gone through "over a thousand negotiations" with suppliers, and added that this was not normal. MSC Industrial told its own earnings call that tungsten, a key input for carbide cutting tools, was up more than 100 percent, and that it was taking mid- to high-single-digit price increases from suppliers.

Put those together and the maintenance problem is obvious. The supplier price, the freight, and the duty base can each change in a given quarter. A table that gets touched once a year is going to be wrong for most of it.

What does a stale table do to one part?#

Take one line, with every number here illustrative. A 6205-2RS sealed deep-groove bearing lands at $3.20 a unit. The table was built as margin on cost, the same convention we use in the discount authority ladder for sales reps, with a pricing floor of 30 percent margin on cost.

Then landed cost rises 8 percent, to about $3.46, from some mix of supplier increase, freight, and duty. Nobody touches the table.

Here is the part a margin report hides. The smallest tier actually lost the most points, 15 of them, and it still sits far above the floor. The 500-and-up tier lost fewer points, about 10, which is why it does not jump off a report. But it started only 10 points above the floor, so it ended up under it. Nothing about the sticker changed. The buyers ordering pallets are now buying below your own floor, and the table says everything is fine.

That is the general shape. A cost increase does not have to be big to push a deep tier through the floor, because the deep tier was built with the least room. The question worth asking is never "how much margin did we lose." It is "which tiers crossed the floor."

What should live next to every price break table?#

A table you cannot re-derive is a table you can only edit, and editing under cost pressure means guessing. Three things turn it back into arithmetic.

The cost basis and its effective date. Store the landed cost each tier was calculated from, not the supplier list price, and the date that cost took effect. Without it, nobody six months from now can tell whether a price is stale or deliberate.

The rule each tier was set by. Express every tier as a margin on cost, and store the floor beside it. Percent off list is what the buyer reads, and it is fine to show. Margin on cost is what the business protects, so it is what the table should be calculated from. When the cost changes, the rule recomputes the tier. With our illustrative bearing at about $3.46, the same rules produce a candidate table of $6.91, $6.05, $5.36, and $4.84.

That candidate table is a starting point, not an automatic publish. The pricing owner may decide to hold the small-quantity price for competitive reasons, or round a tier to a price the market expects. The point is that the decision now happens on purpose, against a known cost, instead of by default.

A review trigger. Pick a threshold, a percentage move in landed cost, and treat any move past it, or any tariff change touching the product, as the event that opens every table containing the affected SKUs. Reviewing on cost events rather than the calendar means the table gets looked at when it actually went wrong.

This is the one place generic B2B ecommerce suites retrofitted for distribution tend to fail distributors. They store the price and lose the cost basis it came from, so a table can only be overwritten, never re-derived.

How do open quotes and contract prices survive a cost change?#

The table is only the visible part. The harder exposure is everything you already promised.

Open quotes. A quote written against last month's table is a promise at last month's cost. Every quote needs a version and an expiry date that means something. When the table is re-derived, decide explicitly: either the open quotes honor their version until they expire, or they get repriced now. The failure mode is doing both by accident, where some reps reprice and others do not, and the same buyer gets two answers for the same part.

Contract prices. A negotiated price for a named account is the same problem with a signature on it. Know which agreements carry a cost adjustment clause and which are fixed for their term. Reprice on the clause, when the clause allows it and in the way it describes, rather than on how the quarter feels.

Exceptions. A rep who asks to hold the old price on a new cost is asking for a discount, whether or not they call it one. Route it the way any other discount is routed, through the same rungs and against the same floor. If holding the price takes the line under the floor, that is a decision for someone with the authority to make it, and it should be on the record.

Stellar Industrial Supply's Molly Langdon told Distribution Strategy Group that the tariff situation was a reminder that "we have to be quick, intentional, and accurate when it comes to protecting margin." A stored cost basis, a rule per tier, and an explicit decision on open quotes are what make all three possible at once.

Where does software help, and where does it not?#

For a distributor selling on Shopify, the price lists and volume pricing live in Shopify's own B2B features, and that is where the break table itself belongs. What Shopify does not have, on any plan, is quote negotiation.

That is the gap Copiara fills. Its quoting desk keeps negotiation rounds on one record with every version kept, enforces a margin floor on the server rather than by hand, and turns an accepted quote into a Shopify draft order with the agreed prices locked. You can see how it sits on top of Shopify on the quoting desk Copiara adds on top of Shopify B2B. Copiara is coming to the Shopify App Store and is not listed yet.

What no software will do for you: choose the floor, remember that a particular contract has a cost clause, or notice that a supplier renegotiated last Tuesday. Those stay with whoever owns pricing.

Questions pricing owners ask#

How often should a price break table be re-derived? Whenever the landed cost behind it moves past the threshold you set, or a tariff change touches the product. Not on a fixed calendar.

Should tiers be stored as percent off list or margin on cost? Show the buyer percent off if that is what they understand. Store and re-derive the table on margin on cost, with a floor.

What happens to a quote already sent? It honors its version until its expiry date, then reprices against the current table. If you choose to reprice sooner, do it for every open quote on that part, not rep by rep.

Does every cost increase need a new table? No. A small move may be one you choose to absorb. The discipline is making that choice deliberately, with the cost basis in front of you, instead of discovering it at quarter end.

Copiara is in early access. If you own pricing at a distributor and your break tables were last touched before the April tariff change, come talk to us.