Electrical and Plumbing Supply Pricing: List, Column, Net and Job Quotes

In most categories, a price list tells you what you pay. In electrical and plumbing distribution it does not. There is a list price nobody pays, a multiplier or column that turns it into your cost, a net sheet that hides where the number came from, and a project quote that overrides all three for thirty days. Four layers, and the two that move most often are the two your price file doesn't show you.

The four layers

1. List price

The manufacturer's published book price. Essentially nobody pays it. Its job is to be a stable reference that every discount is expressed against, and it changes on the manufacturer's revision schedule rather than the distributor's.

2. Your multiplier or column

The number that converts list to your cost. It comes in two dialects. Some manufacturers publish a multiplier — list × 0.38 — and some publish columns, where an item's price is looked up in Col 1 through Col 5 or similar depending on your account's classification for that product group. Either way it is per manufacturer and often per product group, negotiated at agreement renewal, and expressed nowhere in the price file itself. The mechanics generalise to industrial price books of every kind.

3. The net price sheet

Some distributors skip the derivation and send you an account-specific net sheet: here is what each item costs you, full stop. It is far easier to consume, and it destroys information. When the number moves you cannot tell whether the manufacturer revised the book or your distributor moved your multiplier — and those two events call for completely different conversations.

4. Project and job pricing

A quoted price for a specific job, specific quantities, with an expiry and a quote number attached. It exists because the distributor went back to the manufacturer for support on that job. It is a real price and you really pay it, but it is not your cost, because it is not what the next unit will cost when you reorder.

What a book revision plus a multiplier change looks like

Four lines through one month where the manufacturer revised the book and the distributor adjusted two multipliers at renewal. Cost is list × multiplier; margin is (retail − cost) / retail.

The conduit body is the ordinary case: the book went up 7.3%, the multiplier held, the cost went up with it, and any diff would catch it. The panel is the case that looks worse than it is — a 9.4% book increase partly offset by a better multiplier, netting 5.2%. The strap is a book increase in per-hundred pricing, which is only 7.3% once you remember to divide.

The ball valve is the one that matters. Its list price did not change. Every number printed in the manufacturer's book is byte-identical to last month's, and the cost went up 6.8% because the multiplier moved from 0.44 to 0.47 at renewal. On a $59.95 retail that is 35.4% down to 31.0% — a floor breach on a line nobody would have looked at. Holding 35% would need 41.36 / (1 − 0.35) = $63.63.

The job-quote contamination problem

This one has cost more stores more money than any book revision, because it moves in the flattering direction and therefore nobody investigates it.

Take a fitting: list $12.40, your column multiplier 0.38, so your stock cost is $4.71. A contractor customer has a job; your distributor quotes 400 pieces at $3.85 for that project. You buy them, you sell them, everyone is happy. Then somebody updates cost per item to $3.85, because that is what the last invoice said.

The price is set once, on a cost that applied to 400 pieces of one job, and it stays on the site for the following two years while every unit you sell comes out of stock bought at $4.71. Shopify reports 45% throughout, because cost per item is one number with no history and no notion of where it came from.

The fix is a convention, not a system: job pricing never touches the cost field. Stock cost stays stock cost; the project margin is worked out on the quote, at the time, and lives with the job. If a quoted price is genuinely better than your standing multiplier on an item you sell constantly, that is not a reason to change your cost — it is a reason to go and renegotiate the multiplier, which is a conversation about the whole year rather than one project.

Units of measure, where the quiet errors live

Both categories price small parts in bulk units and large parts individually, in the same file:

• Per C — per hundred. Standard for straps, connectors, small fittings, wire nuts, fasteners.
• Per M — per thousand. Standard for wire and cable, and for very small components.
• Per foot vs per coil vs per reel — the same wire quoted three ways depending on the sheet, and a reel price is not a foot price times the reel length once cut charges enter.
• Each, with a box quantity — priced per piece but only sold in boxes of 10, 25, 50 or 100.

A per-C price misread as each is off by a factor of 100 and fails loudly: your cost looks absurd and someone notices within the hour. The dangerous direction is the reverse, and the truly dangerous case is a change of basis between editions — a manufacturer moving a small fitting from per-C to each, keeping a similar-looking number. Nothing in the file announces it, and the cost you compute is wrong by two orders of magnitude in the direction that makes everything look profitable.

That is why unit of measure belongs in the normalisation step before any diff runs, alongside pack size and cost basis. Comparing two prices that are quoted on different units produces confident nonsense rather than an error.

Rebates and growth programs are not cost

Both channels run volume rebates, annual growth programs and manufacturer spiffs. They are real money and they arrive as a cheque or a credit, typically quarterly or annually, long after the goods were sold.

The temptation is to net an expected rebate into cost per item so that margins "look right". Don't. A rebate is contingent on hitting a threshold you may miss, it is paid on aggregate purchases rather than per line, and once it is inside your cost field you can no longer compare a supplier's price file against your own numbers — every line is offset by an estimate. Keep rebates where they belong, as a separate line that improves the year, and keep cost per item as the price of the next unit. The threshold arithmetic itself — when crossing a volume band is worth more than negotiating — is a separate question, and one worth doing explicitly rather than folding into unit cost.

What to keep per SKU

Everything above reduces to a short list of fields. Most stores keep the first and last and wonder why price reviews are hard:

• Manufacturer and product group — because the multiplier attaches here, not to the item.
• List price and its book effective date.
• Multiplier or column, with the date it last changed.
• Unit of measure and pack quantity — each, per C, per M, box of 25.
• Net cost per selling unit — the derived number, and the one that goes into Shopify.
• Quote flag — whether the last price paid was a project price, and which quote number.

With those six, a monthly review answers the question that actually matters — did the book move, or did my deal move? — and the answer routes the work. A book revision is a repricing exercise on your side, worked through in recalculating margin and price after a cost increase. A multiplier change is a conversation with your distributor, and it is a conversation you can only have credibly if you noticed it in the month it happened rather than at the year-end review.

A realistic cadence

Manufacturer books in these categories revise on their own schedules, and a mid-size electrical or plumbing reseller carries enough manufacturers that something changes most months. Two habits carry most of the value:

1. Diff every file you receive, on the month you receive it — normalised to net cost per selling unit, sorted by floor breach rather than by size of increase.
2. Re-derive net cost after every agreement renewal, whether or not a new book arrived. This is the only moment the invisible layer becomes visible, and it is one recalculation across the affected product groups.

Commodity-driven lines deserve a third habit. Copper content in wire and in brass fittings, resin in PVC, and steel in strut and conduit all move on their own, and a manufacturer whose input costs have moved will issue an off-schedule revision without much notice. Those product groups want checking on the commodity's clock, not the book's.