Friday, 17 April 2026

Importing a supplier's price list: how trade businesses write quotes in half the time

Bleno Team
Cover image: Importing a supplier's price list – how trade businesses write quotes in half the time, with a supplier price list being imported into Bleno and taken into the quote

Writing quotes takes too long. That is what most owners of trade businesses say when asked what takes up the most time in the office. A large part of that time is not spent on actual thinking – but on retyping: copying item numbers from the paper catalogue, looking up prices, entering them in Excel or Word, checking everything again.

Importing the supplier catalogue solves exactly this problem. Instead of typing from the catalogue, you simply search – and take the item over with one click.

How most businesses enter materials into quotes today

Let's take a typical case: an installation business is creating a quote for renovating the heating system of an apartment building.

The master tradesperson or their office person opens the supplier catalogue – as a printed booklet, a PDF or a website. Then they look for the first material: copper pipe DN 22, 5 m length. They read off the item number and price, type them into the quoting program, check the unit and quantity. Then the next material. And the next.

20 line items at 2–3 minutes each: that is 40–60 minutes just for entering materials – for a single quote.

And if the supplier has raised its prices? Then the whole quote is no longer correct.

What a digital catalogue import changes

Once the supplier catalogue has been imported into Bleno, the same process works like this:

  1. Enter a search term: "copper pipe DN 22"
  2. Select the item – description, item number and purchase price are already stored
  3. Enter the quantity
  4. Done – next line item

What used to take 3 minutes now takes 15 seconds. And the price is correct – no reading off, no typos.

Step by step: from catalogue to quote

Step 1: Request the catalogue from your supplier

Most builders' merchants, wholesalers and specialist dealers can provide their catalogue in a machine-readable format – often as a CSV or Excel file. It is worth asking your sales representative: "Can you send me your catalogue as a file?"

Many suppliers are happy to do so – it makes ordering easier for them too.

Step 2: Import the catalogue into Bleno

The file is uploaded to Bleno and assigned to the relevant supplier. Bleno reads in the item description, item number, unit and price. After a few seconds, all items are searchable.

Step 3: Pull materials straight into the quote

When creating a quote, you simply search for the item you want. The item is selected with a click and the quantity entered – done. Item number, description and purchase price are taken over automatically.

Step 4: Update the catalogue when prices change

When the supplier raises its prices, a new catalogue file is imported. All items are up to date – without anyone having to maintain anything manually.

What an imported catalogue makes possible

Several suppliers, one search field

In Bleno, catalogues from several suppliers can be stored at the same time. When you search for materials, all suppliers that stock the item appear – with their respective prices. So you can see immediately who is cheaper.

Example: Three suppliers offer different prices for copper pipe. At a glance you decide who to order from – without separate price requests.

Costing certainty through stored purchase prices

If you cost from the catalogue, you know the purchase price is right. That gives you confidence in the quote. No guessing, no buffer out of uncertainty about the actual material price – the purchase price is the reliable basis.

And if a quote is accepted several weeks after it was created? Thanks to the current catalogue, you can quickly check whether the prices still hold.

Your own price lists as an internal catalogue

As well as supplier catalogues, you can also store your own price lists: hourly rates for different types of work, flat rates for standard services, material surcharges.

That makes quotes even faster: labour is also simply selected from your own price list – no typing, no mistakes.

Case study: a plumbing and heating business before and after the catalogue import

Before:

  • Quote for heating renovation: 22 material line items
  • Time for entering materials: ~55 minutes
  • Sources of error: misreading, typos in item numbers, outdated prices from last year's PDF
  • Result: two errors were only noticed after the order had been placed

After:

  • Quote for heating renovation: 22 material line items
  • Time for entering materials: ~8 minutes
  • Sources of error: none (prices and numbers directly from the current catalogue)
  • Result: quote correct in the first draft

Saving per quote: ~45 minutes. With 4 quotes a week: almost 3 hours a week – or a good 130 hours a year.

Frequently asked questions about the catalogue import

My supplier has no digital catalogue – what then?

In that case, items can be entered manually as your own price list – individually or as an Excel upload. It is a bit of one-off effort, but it pays off from the second quote.

Alternatively, it is worth asking the supplier: many provide an export file on request, even if they do not advertise it as standard.

How often does the catalogue need updating?

That depends on the supplier. With stable prices, updating once a year is enough. For volatile materials (copper, steel), more frequent updates are advisable – e.g. quarterly.

What about customer-specific discount prices?

Many suppliers grant regular customers individual terms. These can be stored in Bleno as a discount percentage or directly as a separate price list – so quotes are always costed with the actual purchase prices, not the list prices.

What the catalogue import has to do with costing

An imported supplier catalogue is not just a time-saver when writing quotes. It is the basis for precise costing.

If you create quotes from a catalogue with current purchase prices, you know exactly: between the purchase price and the quoted price lies the calculated mark-up. This mark-up is a deliberate choice – not a gut feeling.

And if at the end the job costing shows that the material costs exceeded the estimate? Then the cause no longer lies in the quoting process – the prices were right. It may lie in consumption, special orders or later changes to materials. This distinction is valuable: it shows where you really need to optimise.

Conclusion: import once, work faster for good

The catalogue import is a one-off investment of a few minutes – for an advantage that pays off with every quote. Less time spent retyping, fewer errors, more up-to-date prices and more certainty in costing.

Anyone still copying from paper catalogues or looking up prices manually is wasting time every day – and risking mistakes that cost money.

Try Bleno free for 14 days and import your first supplier catalogue today. Get started.

More about the feature: Supplier management in Bleno

Further reading: Supplier management in the trades: buying materials cheaper and faster