Raw material prices change. That is nothing new. Anyone who works in technical sales has been living with it for years. The question is not whether prices change — but whether your team notices in time.
In most sales teams, pricing knowledge is scattered: in heads, in Outlook folders, in Excel files that everyone maintains differently. One person remembers the last price for customer A. Another has a spreadsheet they last updated three months ago. The third asks a colleague — if they happen to be available.
That works day to day. Until it doesn't.
What happens when price history is missing
Imagine a typical situation: an enquiry comes in. A product you quote regularly. You roughly remember what you last quoted — but not exactly. You remember the price from last quarter, but since then material costs have changed twice. You send a quote that feels right.
Two weeks later you learn that your colleague offered the same customer the same product at 8% less. Or you win the order — and only realise during the post-calculation that you sold below margin because your reference price was outdated.
These are not isolated cases. This is the normal state in teams that work without a shared price history. Not because someone calculates poorly — but because the data foundation is missing.
What price history actually means
Price history sounds like an archive. Like old invoices sitting somewhere in the ERP. But that is not what we mean.
A useful price history answers three questions in real time:
What was sold when, to whom — at what price, in what quantity? That is the foundation. Not the list price, not the purchase price, but the actual selling price your team achieved in the market.
How has the price for this product developed over time? Is it rising, falling, stable? Not over years — over weeks and months. In volatile markets, the average price can shift noticeably within a quarter.
Where does my price stand compared to the team? Am I above average, below, right in the range? This is not a control instrument — it is context. Like checking fuel prices before filling up. You can still go somewhere else. But you know what the market looks like.
Why Excel and ERP cannot answer these questions
The data exists in every company. Quotes were written, orders were processed, invoices were issued. The problem is not the absence of data — but that it sits in different places and nobody brings it together.
Excel lists are maintained manually — conscientiously by some on the team, not at all by others. After a few months, everyone has their own version. Which one is correct?
ERP systems store order data reliably. But they do not show you what was quoted — only what was ordered. They show no price trends, no team comparison, no customer history in the quoting context. And they are not where you work when the enquiry comes in.
The result: the data is there but not usable. Not at the right moment, not in the right format, not for the right person.
How a current price history changes daily work
When your team has a shared, current price history, three things change fundamentally:
Pricing becomes more confident. You see during calculation what your team is currently achieving for this product — filtered by time period and quantity. You no longer rely on memory. Your price is based on current market data from your own team.
The reaction to price changes becomes faster. When material costs rise, you see it in the average price — because your colleagues are already pricing accordingly. You don't have to wait for a memo from management. The data shows you.
Margin becomes visible. Not as an abstract controlling topic, but as context with every calculation. You see whether your price is in the range — before the quote goes out. Not only in the post-calculation.
Building price history — without a mammoth project
Many teams think building a clean price history takes months. Data needs to be exported, cleaned, imported. In practice, it is faster than most expect.
At PipeGenius, our in-house technology processes your existing sales data. In under an hour, the pricing foundation is in place — per product, per customer, with quantities and time periods. From that moment, the data grows automatically with every quote and every order your team creates.
No manual maintenance. No Excel lists. No IT department. The price history emerges from your daily work — and it is visible where you need it: in Outlook when quoting and in the web app for the overview.