Price list management: how to keep thousands of prices current

By Ranjit Bhinge, founder of Blur Studio · Updated · 7 min read

Short answer: Price list management is the work of creating, approving and updating the prices your customers pay, with a start date and a record of each change. For a distributor the hard part is the supplier price file: it arrives as a spreadsheet or PDF, with thousands of rows, and every changed cost can change a customer price. The safe routine is to load each new file into a draft, compare it with the last one, apply your margin rules, review the changes, and publish on an effective date. Your ERP (the system that runs orders, stock and accounting) usually has price lists built in, and AI can help read the files, but a person should approve what goes live.

Ranjit Bhinge

Your suppliers change prices all the time, and you need thousands of customer price lists to follow without a week of copying and pasting.

I'm Ranjit, and I run Blur Studio: 15+ years building software, 120 apps taken live, and clients who have gone on to raise $10M+. I build AI systems and processes that help businesses do a lot more with a lot less time. I also work differently from most of what else is out there, more on that further down this page. Say hello.

What is price list management?

A distributor really has two sets of prices. Supplier costs come in. Customer prices go out. Price list management is the process that connects them: when a cost changes, someone decides what the selling price becomes, checks it, and publishes it so quotes, orders and the website all use the same number.

The word "price list" hides several things. There is the supplier's price file. There is your list price. There are tier lists, such as a Dealer list. And there are customer-specific prices, which I cover in my guide to customer specific pricing. Each can change on a different schedule.

One thing to keep apart: a price list generator, including the many "AI price list maker" tools, makes a nicely formatted price sheet to hand to a customer. That is a document. Management is the data and approval behind it. You need the second before the first is worth much.

What goes wrong without a process?

  • Stale prices. Say a supplier raises costs 6% in March and you are still selling at the old price in June. You pay for it on every order.
  • Mismatched copies. The ERP, the website and the quote sheet show three prices for the same part.
  • Silent errors. A formula copied down one row too far, or a column shifted in the supplier's file, turns a $4.20 part into $42.00.
  • No audit trail. A customer says you quoted last month's price and nobody can show what the price was or when it changed.
  • Update lag. Updating takes a week, so every price change is already late when it publishes.

How do I update prices when a supplier sends a new file?

Use the same steps every time.

  1. Save the original file. Never edit the supplier's file. Keep it as proof of what they sent and when.
  2. Load it into a draft. A draft is a holding area. Nothing in it affects live prices.
  3. Match the parts. Match the supplier's part numbers to your own SKUs (stock keeping units). Flag any part that is new, dropped, or renumbered.
  4. Compare with the last file. List every cost that moved and by how much. Sort by biggest change first.
  5. Apply your margin rules. For example, selling price equals cost plus 25%, rounded to the nearest cent, with a floor on low-cost parts.
  6. Review the exceptions. Look at changes over 10%, new parts, prices that fall, and anything where the margin drops below your minimum.
  7. Publish on a date. Pick an effective date. Tell the sales team and warn contract customers whose terms need notice.
  8. Keep the record. Store what changed, who approved it and when.

A worked example with made-up figures

A supplier sends a file with 4,000 parts. Of those, 3,100 rose by 5% to 7%, 600 did not change, 200 are new, and 100 fell. Your rule is cost plus 25%. Applying it to the 3,100 takes minutes in a spreadsheet or a system. The value is in the 300 you must look at: 200 new parts with no selling price yet, and 100 price drops you may or may not want to pass on. Without the compare step, you would never see those 300 among the 4,000.

How far can I go with Excel?

Shopify, a store platform, handles web prices differently: its B2B catalogs apply a percentage adjustment or fixed prices to a set of products, so a store catalog is a separate place to keep in step with your ERP. Excel works if one person owns the list and the list is small. Add an effective date column, a status column (draft, approved, live) and a change log tab. My supplier price list template shows the columns.

It starts to fail when:

  • Several people edit copies of the same file.
  • You hold more than a few thousand rows, and lookups slow down or break.
  • Customer-specific prices multiply across tabs.
  • Other systems, like a website or quote tool, need the same prices and someone copies them over by hand.

At that point the spreadsheet is a risk, not a tool. Move the prices into a system where a change is recorded, dated and visible to everything that needs it.

What do ERP price lists do?

Most ERPs include price lists. Two examples show what to expect.

NetSuite, a cloud ERP, uses price levels, and you can set up to 1,000. You assign a level to a customer or to items on a customer's record, and item-level levels override the customer's general level.

Acumatica, another cloud ERP, uses sales price worksheets, and MYOB's help for its Acumatica-based product describes how they work. A worksheet is a draft of price changes. You can load rows from an Excel file, or have the system calculate pending prices from a price basis you choose. Nothing changes until you release the worksheet, and the prices go live on the effective date you set. Regular prices for the same item, unit and currency cannot overlap in time, which stops two conflicting prices going live at once.

That draft-then-release pattern is exactly the process above, built into the software. If your ERP has it, use it before you buy anything else. If it does not, or if the ERP is not where your website and quotes get their prices, you need something that does.

How do Odoo and Business Central handle it?

Odoo is an open-source business suite. Its pricelists hold rules that are a fixed price, a percentage discount, or a formula (a discount, a rounding step and an extra fee). A rule can need a minimum quantity and can have start and end dates. A rule such as 20 percent off with rounding to 10 and an extra fee of -0.01 gives prices ending in 9.99. Odoo's documentation says a pricelist only suggests a price, and it can always be overridden on the sales order, so decide who is allowed to do that.

Microsoft Dynamics 365 Business Central is Microsoft's ERP for small and mid-sized firms. New price lists start as Draft and are left out of price calculations until you set them Active. You can price by customer, customer group, item, unit of measure, minimum quantity and dates. To raise many prices, you copy lines from an existing list into a new Draft list and enter an adjustment factor, where 1.15 means a 15 percent increase. The Edit in Excel action lets you change many lines in a spreadsheet and publish them back. Business Central also refuses two lines with the same settings and different prices, which catches duplicates before they go live. By default it picks the lowest price with the highest line discount allowed on the date.

Both follow the same pattern as the eight steps: draft, review, activate on a date. The difference is how much of the supplier-file loading you must do yourself.

What are the options for price list software?

OptionGood forWatch out for
SpreadsheetOne owner, a few hundred to a few thousand partsCopies, no audit trail, manual updates
ERP price listsDistributors whose ERP already holds orders and stockLoading messy supplier files, limits in older or smaller ERPs
Ecommerce platform price listsWeb store pricingOnly covers the store, so quotes and orders can differ
Dedicated pricing toolComplex rules across many channelsAnother monthly fee, another system to keep in sync
Custom pricing layerOdd rules or many systems reading one set of pricesNeeds a clear spec, and ongoing care

When you compare any price list management software, ask each vendor three things. How does it load a supplier file? How does it show me what changed? How do my quotes and website read the prices? Software that cannot answer the first two clearly will not save you time.

Where does AI help with price lists?

AI tools are good at the reading step. They can open a supplier's PDF or messy spreadsheet, pull out part numbers and prices, and put them into a clean table, even when each supplier lays out the file differently. They can match supplier part numbers to your SKUs, suggest likely matches for a person to confirm, and draft the compare list. I cover the details in my guides to using AI to read supplier price lists and AI document processing.

They are not good at the approval step. AI can read 4,000 rows and still misread a decimal on one of them. So use it to draft, and let a person check the exceptions before anything goes live. For stores that push prices to several sales channels, see my guide to supplier price list automation.

How does this tie to one product and pricing system?

Prices are only useful if every place that shows one reads the same data. That means your item records, stock and prices should live together. My guide to an inventory management system covers the product side. When the item record and the price sit in one system, a cost change flows to quotes, orders and the website once, rather than being copied three times.

How I'd approach this

I would start with the process, not the tool. Take your three biggest suppliers and run the eight steps above on their next price files, even if you do it in a spreadsheet. You will learn where your parts do not match, which margin rules you actually follow, and which customers need notice.

Then look at your ERP. If it has draft prices and release dates, set that up properly and load supplier files through it. If your quotes or website sit outside the ERP, the next fix is one place all of them read prices from. For a distributor with thousands of parts and several systems, I usually build a small pricing layer with an AI file reader in front of it and a human review screen, because that matches how the work already happens. If that sounds like your business, I am happy to talk it through.

Questions people ask

What is price list management software?

It is software that stores prices by item, customer, quantity and date, and controls how changes are approved and published. Most ERPs include a version of it.

How do I keep supplier price changes from breaking customer prices?

Load the new supplier file into a draft, compare it with the last one, apply your margin rules, review the exceptions and publish on an effective date. Never overwrite live prices directly.

Can I manage price lists in Excel?

Yes, if the list is small and one person owns it. Add effective dates, a status column and a change log. Move to a system when many copies, many customers or many tools make errors common. My supplier price list template shows the columns.

Can AI update price lists?

AI can read supplier files, match parts and draft new prices. A person should approve the changes before they go live. See my guide on AI and supplier price lists.

What are the best price list management tools?

It depends on your ERP and size. Start with your ERP's own price lists. Compare dedicated pricing tools only if you need rules the ERP cannot hold, and ask each vendor how it loads supplier files and shows what changed.

How often should I update price lists?

Update whenever a supplier changes costs, and review the full list at least quarterly. Set a standard turnaround, such as within five working days of a new supplier file.

More in this topic: B2B: quotes, CPQ and pricing (8 guides) →

Sources

Ready for the next step?

A 30 minute call. If you do not need me, I will tell you.

Ranjit Bhinge You talk to me, Ranjit. I reply within a few hours.

Not sure what you need? Tell me what is going on. I will point you the right way, even if it is not me.

Blur Studio · 30 minute call

Book a 30 minute call

You talk to me, Ranjit. If you do not need me, I will tell you.

  • We talk about your business and what is going on.
  • You leave with a clear next step, even if it is not me.
  • I reply to every message within a few hours.
Loading the calendar…