I Stopped Telling Suppliers They Were Too Expensive. Now I Show Them How Much More Expensive

Every negotiation with a supplier has an awkward moment. You tell them their product is expensive and they answer that this is just the market, that freight went up, that the dollar did. Since nobody at the table has a better number, the conversation ends right where it started.

In the Chilean eCommerce business I built this purchasing dashboard for, the team walked into those meetings with spreadsheets and opinions. On top of that, there was money sitting idle in the warehouse that nobody saw in full, out-of-stock products that kept getting reordered, and purchases negotiated by email, with no record of what was ordered or why it was accepted.

---

Two ideas behind it

• The supplier negotiates against data, not opinions. You don't argue "it's expensive"; you show "it costs us 12% more than comparable brands."
• What the supplier sees is frozen at publication. The numbers don't change during the meeting.

That way, the dashboard does two jobs: supplier reports to win discounts, and a single purchase flow, from quote to ERP order.

---

The dashboard reads like an argument

It's laid out like a line of reasoning: first what's tied up (a reason not to buy), then what you lose by not having stock (a reason to buy now), then pending decisions, and finally, whether you can trust what the screen says.

• Idle money in the warehouse: capital at cost sitting in the warehouse (ERP cost plus freight and customs), also expressed in months of sales.
• Capital held over a year and overstock: in supplements, that means expiration risk.
• Unbilled sales per month: what out-of-stock products stop selling, with the purchase list sorted by what costs the most.
• Pending decisions: quotes awaiting a decision, accepted purchases that haven't reached the ERP, and reports the supplier never opened.
• Data health: how long ago each source arrived and which ones have errors.

---

A margin you can trust

The ERP cost is the weakest data point. Every night the dashboard compares it with the actual selling price over the past year: if the cost is absurd, the product is flagged as "inflated cost" or "zero cost" and left out of the averages. The company's margin is calculated only with consistent costs, states what share of sales it covers, and subtracts shipping and each channel's commissions. A margin on 98% of sales is a fact; the same margin on 40% would be an anecdote. Doubtful costs form a queue, "Costs to review," which gets fixed in the ERP.

---

What to buy, and how much

The replenishment queue is sorted by the margin each product stops earning for every month it's missing. Each row says how much to buy, what it costs and why.

• Each supplier's lead time is measured on their actual shipments, not on what they promise.
• You buy to cover 60 days plus a 15-day buffer (configurable), adjusting demand for trend.
• What's already on its way is not bought again.
• Each product ends up as Urgent, Soon or Watch, with its investment and how many months it takes to pay back.

---

Compare without exposing anyone

To say "more expensive than other brands," you have to know what's comparable. The ERP doesn't, so the team curates the brands (confirms the ones coming from the stores and merges misspelled variants) and builds comparison groups like "isolate protein 5 lb," aggregating products by volume. A product with no brand doesn't enter any comparison.

The key rule is the anonymityrule: the comparison only appears if the group has at least two brands other than the supplier's. With just one, we'd be handing over a competitor's cost. The system enforces it, not anyone's memory.

Each product's sheet adds margin against averages, price against the competition and an estimate of price-demand elasticity, flagged as a correlation and not an experiment.

---

The supplier report

You pick the supplier, the period and the products, and for each card only the metrics that argue in favor of the discount: sales, margin, cost against other brands, turnover, market price. Each product carries a mission with a target ("cut cost 15%"), which the next report shows again.

• Preview identical to the supplier's.
• Only management publishes: the figures are frozen and each contact gets a personal link, with no username or password.
• It records who opened it and when, and links expire or can be revoked.
• A published report can't be edited: if something changes, a new one is issued.

---

A purchase from start to finish

The purchase request replaces the back-and-forth of emails. Every step is kept in the history.

• Up to 60 lines, with an internal target cost that the supplier never sees.
• The supplier quotes from their phone: price, quantity, lead time and any products they want to offer.
• You counter per line with a price, a quantity or a note, as many times as needed.
• If the email doesn't reach anyone, the request automatically goes back to draft.
• For open purchases, a request is published to all suppliers and the offers arrive in plain view.

To decide, each line shows the current and proposed cost, the projected margin with the quoted cost and stock health: an overstocked product isn't bought even if the price is good.

What's accepted reaches the ERP as a draft purchase order: the dashboard never confirms anything. The import can be repeated without duplicating, and if the ERP is down the dashboard keeps working.

Who decides what

• Buyer: builds reports, negotiates, makes counteroffers and imports to the ERP.
• Management: also publishes reports and accepts purchases above the threshold.
• Settings: approval threshold, low-stock (15 days) and overstock (90 days) limits, cost tolerance and replenishment assumptions.

---

What the business gains

The negotiation changes tone: it's no longer an argument over whether something is expensive, but a conversation about a number both sides can see, with a specific order and its follow-up. And every purchase is recorded with the figures that were in view when the decision was made. Real lead times come from the imports dashboard, and what's expiring in the warehouse is watched by the turnover and expiration system.