Price Lists: Why Yours Is Out of Date and What It Costs
The supplier put its prices up in February. The email was read, filed and forgotten. The price list on the website still shows what was set two years ago, and every order since has earned less than anyone thinks.
What a price list is
A price list states what a business charges for each product or service: the item, the unit, the price, and the date from which it applies. It is the reference a salesperson quotes from, a customer orders from and the accounts team invoices from.
In practice it is also several documents. There is the PDF sent to customers in the spring, the prices on the website, the figures in the accounting system, and a spreadsheet one salesperson trusts more than any of them.
How it goes out of date
| What changes | What does not | Result |
|---|---|---|
| A supplier raises its price | Your selling price | Margin shrinks on every sale |
| The master list is updated | The copy a customer holds | Orders arrive at the old price |
| A special price is agreed by phone | Any written list | Nobody else knows it exists |
| The website is edited | The accounting system | Invoices do not match what was advertised |
| A product is replaced | The old code stays on the list | Orders for something you no longer stock |
What a stale price costs
The figures are an illustration. A part costs $40 and sells for $60, a margin of about 33 percent. The supplier raises the cost to $46. The price list is not touched.
| Before | After the cost rise | |
|---|---|---|
| Cost | $40 | $46 |
| Selling price | $60 | $60 |
| Gross profit per unit | $20 | $14 |
| Margin | 33.3% | 23.3% |
At 2,000 units a year that is $12,000 of gross profit gone, on one line of the list, with no visible event to mark it. To restore the original margin the price would need to be about $69. Whether the market will bear that is a separate question. The point is that someone should be asking it, and this quiet loss is the pattern in where your margin goes.
What a good price list carries
| Field | Why it is there |
|---|---|
| Item code and description | So everyone means the same thing |
| Unit | Each, box of twelve, per hour, per metre |
| Price | In a stated currency |
| Quantity breaks | What changes at volume |
| Tax | Whether prices are before GST or HST |
| Effective date and version | So an old copy can be recognised as old |
| Validity | How long a quoted price holds |
The effective date is cheap to add. A list with a date on every page can be shown to be out of date. A list without one is simply the price list, for ever.
Where AI earns its place
Watching costs against prices. Each time a supplier invoice or a new supplier list arrives, compare the cost with the selling price and report the items that have fallen below your target margin. That check would have caught the example above, and it depends on costs being captured, as in purchase orders and the bill of materials.
Reconciling the copies. Website, PDF, accounting system and spreadsheet, compared item by item, with the differences listed. Four versions of one truth is a small case of data silos.
Producing customer lists from one master. Standard prices, less the terms agreed with that customer, generated when needed instead of maintained by hand.
Drafting the price increase letter. What is changing, from what date, and why, in a tone that suits the relationship.
Answering the question at the counter. What do we charge this customer for that item, drawn from the master and not from memory.
What stays with a person
Setting the price. Cost is one input. What customers will pay, what competitors charge and what the relationship is worth are judgments, discussed in dynamic pricing.
Honouring what was quoted. A price in a live quote or a contract holds until it expires, whatever the new list says.
Giving notice. Some customer agreements fix prices for a period or require notice of changes. Check before the letter goes.
Approving the list. One named person signs off each version. A tool proposes changes. It does not publish them.
The habit
Keep one master and treat every other copy as a printout of it. Review on a set date each quarter, and whenever a supplier changes a price. Date every version. A list that is reviewed four times a year cannot be more than three months wrong.
Frequently Asked Questions
What is a price list?
A document that states what a business charges for each product or service, with the item, unit, price and the date from which the price applies. It is the shared reference for quoting, ordering and invoicing.
What should a price list include?
An item code and description, the unit of sale, the price and currency, any quantity breaks, whether tax is included, an effective date and version number, and how long a quoted price remains valid.
How often should a price list be reviewed?
On a fixed schedule, such as quarterly, and whenever a supplier changes a cost that affects it. A dated review means the list can never be more out of date than the interval between reviews.
How does an out-of-date price list cost money?
When a cost rises and the selling price stays the same, the margin on every sale falls. In the example in this article, a cost increase from 40 to 46 dollars on a 60 dollar item cuts the margin from about 33 percent to about 23 percent, which is 12,000 dollars a year at 2,000 units.
How can AI help manage a price list?
It can compare supplier costs with selling prices and flag items below a target margin, find differences between copies of the list held in different systems, generate customer-specific lists from one master, and draft price increase letters. A person should approve each new version.
How do you tell customers about a price increase?
In writing, with the items affected, the new prices, the date they take effect and a short reason. Check existing quotes and contracts first, because prices already quoted or fixed by agreement continue to apply until they expire.
Catch margin slippage the month it starts
We link supplier costs to your price list and flag the items that have drifted below target, for a person to decide.
Related Articles
Follow-Up Emails: Why Yours Stop After the First One
Business Proposal: Stop Sending the Same One to Everyone
Value Proposition: Written in Your Words, Not Theirs
Ajan leads the ChatGPT.ca team: 200+ custom GPT builds and automation projects for 50+ businesses across 20+ industries. Based in Markham, Ontario. PIPEDA-compliant solutions.