Update prices from a supplier's file
Available onEstimatorBuilder
A supplier sends you a new price book, price list or quote. Instead of typing the new prices in one by one, upload the file and let the AI read it. It compares the file with the products you already have from that supplier and lists what it found. Nothing changes until you press Apply.
- Open Price lists and press Update from supplier file (AI) on the toolbar. You need the Edit price lists permission.
- Choose the supplier the file came from. If you are on the Products view filtered to one supplier, that supplier is already chosen.
- To update the open price list’s items as well, leave Also update prices of items in [price list] ticked. Untick it to update products only.
- Drop the file on the window, or click to choose it: a PDF, a photo (PNG or JPG), an Excel file (.xlsx, .xls or .xlsm) or a CSV, up to 25 MB. A spreadsheet with more than 600 rows is only read in part. The window tells you, and you can split the file and read the rest separately.
- Press Read with AI. It takes from a few seconds to a minute for a long document.
- Check what it found (see below).
- Press Apply. The result says how many product prices changed, how many products were added and how many item prices changed, and lists anything skipped and why.
What it found
Section titled “What it found”The results come in groups:
- Price changes to products you already have. Matched by SKU, manufacturer code or name, with the old price and the new one side by side.
- New products on the file. Products not yet in your list for this supplier. They are filed under that supplier.
- Price changes to items of this price list. Only when the box in step 3 is ticked.
- Lines the AI could not place. Shown so you can see what was skipped. Nothing is written for these.
Each row has:
- a tick box: unticked rows are left alone, and the tick box in a group’s heading ticks or unticks the whole group
- the SKU or code, the product or item, and the line as printed on the file
- the old price and the new price, which you can change
- an inc GST box: tick it when the figure on the file includes GST, because prices are kept ex GST
- how sure the AI is: Sure (a clear match and a clear price), Check (it matched by name or worked a number out, so look at it) or Guess (starts unticked; check it against the file)
Good to know
Section titled “Good to know”- Only the rows you tick are applied, and only when you press Apply.
- A product the AI names that is not one of this supplier’s products goes under Lines the AI could not place and is never changed.
- A price that is already the same as yours is not listed.
- If the file names a different business from the supplier you chose, you are warned before you apply.
- Every change goes into the price history the same way as a price typed by hand, so the Prices panel shows who changed it and when.
- SmarteBuild’s shared products and items keep their shared price. Your company’s own price is recorded against them, the same as setting a price in the Prices panel.
AI credit
Section titled “AI credit”Each read uses your company’s AI credit. The window shows the credit left before you start. A long price book uses more than a one-page quote. Applying the changes costs nothing. When the credit runs out, the window says so.
See also Keeping rates current.
