Skip to content
CH 19 · Part D: Vendors and pricing

How to add a vendor and upload their price list

Set up your categories, add a vendor with the currency they quote in, upload their price list with its expiry date, and check what TrueQty read before you rely on it.

Who can do this
JuniorTeam leadProcurementAdmin

In this guide

  1. 01Categories first
  2. 02Add the vendor
  3. 03Upload the price list
  4. 04Check what it read

Categories first

  1. Open Vendors and price lists, and scroll to Categories at the bottom, such as access control, cable, camera, network and rack.
  2. Add any you need with Add category.

A BOQ line is priced only from items in the same category: cameras against cameras, cable against cable.

Add the vendor

  1. Click Add vendor.
  2. Type the vendor name, such as Gulf Vision Trading.
  3. Type the currency it quotes in. Three letters, like AED, USD or EUR. The code is checked as you type, so a slip such as UDS says at once that it is not a currency code.
  4. Enter the rate if it asks. A currency your workspace has no rate for shows Exchange rate needed, with a box for 1 USD = how many AED and the date of the rate. Rates are typed by hand, never looked up. The dollar starts at the dirham's peg, 3.6725. The rate you type is used for every vendor in that currency.
  5. Click Add vendor.

Upload the price list

  1. The vendor's page opens at Price lists. Under Vendor details, Edit details adds a contact name, email and phone.
  2. Drag the vendor's file onto Upload a price list, or click Choose file. CSV, Excel or PDF all work. Excel works best, and every sheet is read.
  3. Name it if you like, and set Valid until to the date the quote expires. After that date the list stops pricing. Leave it blank if the vendor states no expiry.
  4. Click Upload. It says Price list uploaded. TrueQty is reading it. Reading usually takes a minute or two, longer for big PDFs, and the page updates itself.

Check what it read

  1. When the list says Pricing, open it. A list that says Needs a look has a Check N lines button that opens it on those lines.
  2. Read the facts at the top: lines read, lines that price, how many need a look, and the valid-until date.
  3. Read the items below: item, code, category, unit, price, currency, lead time and stock. Check them before you rely on them, and correct anything wrong: see Check and correct a price list.
  4. For a spreadsheet, check the columns. If prices or names landed in the wrong place, Which column is which lets you say which column holds what, and read the file again by your choice.
  5. Do the same for every vendor. Each BOQ line is priced from the cheapest vendor who stocks it.

Switching a vendor off

On the vendor's page, More, then Switch vendor off, stops all of its prices being used, without deleting anything. Switch vendor on brings them back.

Watch it done

Open on YouTube

The same steps, on the sample tender, in 2:24.

TrueQty Academy/CH 19/Add a vendor and a price list

Finished this guide?

Mark it done to track your way through the Academy.

Follow along on your own tender. Every guide works the same on a real drawing.

Start free trial