Update supplier prices in your ERP: practical guide

Updating supplier prices in the ERP means keeping the rates your suppliers send you (Excel files, PDFs, emails, or web catalogs) synchronized with your product records and purchase prices. Done right, it prevents working with outdated costs, protects your margin, and frees your administrative team from repetitive tasks that eat up between ten and forty hours a month in distribution and B2B companies.

Why supplier prices go stale so quickly

In most B2B and distribution companies, supplier price lists change several times a year: raw material increases, CPI adjustments, quarterly agreements, or volume-based changes. If your ERP doesn't absorb them, three things happen that show up on the income statement:

• The cost in the record becomes outdated and the real margin stops being real, so you make commercial decisions on made-up figures.
• Quotes are made at old prices and you either lose money when you sell or lose the deal by not adjusting in time.
• The purchasing team ends up patching manually each new rate, a mechanical task that repeats month after month.

How to update supplier prices in the ERP: three methods

1. Manual method: the classic Excel-to-ERP approach

This is the most common scenario in SMBs: the supplier sends a PDF or Excel by email, someone opens it, cross-references it with the item master, and types the new prices into the ERP. It works with small catalogs, but it breaks down past a few hundred references and whenever the supplier sends the list in a reasonable format.

Typical errors we see in real projects:

• SKUs mistyped or with leading zeros that get lost when pasting.
• Different units of measure between the supplier and your master (box, pallet, unit, kilogram).
• Different currencies without conversion or with an outdated exchange rate.
• Taxes applied twice or at the wrong rate when passing the column.
• New products from the supplier that don't exist in your master and get ignored.

2. Semi-automatic method: assisted import

Most modern ERPs (Odoo, SAP Business One, Holded, Sage, or Dynamics 365) include a rate importer for CSV or Excel. The usual flow is:

1. Download or receive the supplier's rate list in a standard format.
2. Map columns: supplier reference, internal reference, price, currency, purchase unit, and effective date.
3. Validate duplicates, create new products, and update existing ones.
4. Apply rounding and margin rules before impacting sales.
5. Generate a difference report and have it signed for audit purposes.

If you work with Odoo, you may be interested in this step-by-step guide: import supplier rates into Odoo.

3. Automatic method: an AI agent connected to the ERP

The next level is an AI agent that receives the supplier's rate list (by email, shared folder, API, or even scanning a PDF) and takes it to the ERP without anyone typing anything. The usual flow is:

1. The supplier sends their new list to the inbox rates@yourcompany.com.
2. The agent detects the attachment, identifies the supplier, and extracts products, prices, units, currency, and effective date.
3. It cross-references with the item master and proposes the update row by row.
4. It sends a summary to the responsible person for final approval.
5. Only when there is human approval does it write the new prices in the ERP.

The starting cost of an agent connected to the client's systems starts at €99/month (plus VAT) and you can add the WhatsApp channel for an additional €49. If the agent only automates internal tasks without touching your systems, it starts at €49/month. At AizuaLabs we work with custom projects and each case is evaluated after an audit, because the real price depends on the number of suppliers, formats, and validation rules.

What you need to be clear about before automating the update

Before plugging in any automation, it's worth reviewing five points that make the difference between a stable process and a project that breaks on the third rate list:

• Clean item master: unique SKUs, consistent units, main supplier assigned per product, and well-defined categories.
• Stable supplier identifier: EAN, manufacturer reference, or internal code. Without this field, the cross-reference between the supplier's rate list and your master always fails.
• Margin and rounding rules: if the rate list comes in raw, it can break your commercial policy, so it's worth defining rounding (to €0.05, to €0.10) and minimum margins by family.
• Change history: the ERP must record who changed what price and when, for internal audit and to revert if a rate list arrives with an error.
• Clear exceptions: products on promotion, special agreements, customers with agreed prices, or products with rates locked by contract.

Common mistakes when updating supplier prices in the ERP

Even though the operation may seem trivial, these are the most repeated failures in real projects and the ones that have the biggest impact on the income statement:

• Overwriting without history: losing traceability of the change and being unable to revert when a rate list arrives with an error.
• Confusing purchase price with cost price: the first one comes from the supplier, the second includes logistics, tariffs, shipping, and shrinkage.
• Not updating sales price lists: having the new cost and the old sales price destroys the margin without anyone noticing.
• Forgetting currency conversion: with suppliers in USD, GBP, or CNY, a bad conversion or an outdated exchange rate wipes out the margin.
• Applying the change massively without validating: a poorly mapped column can change thousands of prices at once and leave you without competitive stock.
• Not communicating the change to sales: the salesperson keeps promising old prices and the customer ends up complaining.

When it makes sense to set up an AI agent and when it doesn't

The decision is economic, not technological. If you receive one or two rate lists a year from three suppliers, a manual Excel importer is enough and the investment in AI is not justified.

If you receive monthly or weekly rate lists, from more than five suppliers, in different formats (PDF, Excel, email, web portal, API) and with thousands of references, automation saves between 10 and 40 hours a month. That is when a dedicated agent pays off, because the cost of the agent is covered by the hours freed up from the administrative team.

In regulated sectors (tax, legal, health, food, pharmaceutical) AI assists in extraction and proposes changes, but the final validation is always done by a person with professional judgment. The tool does not replace the purchasing manager or the tax advisor; it only eliminates the prior mechanical work.

How this fits with the rest of your operations

Updating supplier prices in the ERP doesn't stand alone: it's the entry point of a broader flow. When the cost is up to date, you can also:

• Recalculate sales prices with margin rules configured by family or by customer.
• Detect products that have risen more than X% and automatically notify sales.
• Pass the increase to the sales price without manually touching each record.
• Review the profitability of each supplier with real data and not with the last remembered price.

If you're interested in taking the next step and want to know what to look for when choosing a provider of this type of automation, in this article we explain how to implement AI agents without a technical team.

To build an agent that connects to your ERP and processes documents, we usually rely on models like Claude, whose cost per token is worth understanding to size the project: you can review it at Claude Sonnet 5 pricing.

Frequently asked questions