Skip to main content
Try for free

Record vendor pricing

Record what a vendor charges at each quantity.

Updated Nov 5 2026

Who this is for

Buyers record what each vendor charges at each quantity. Engineers and estimators rely on the same prices when they cost a build.

Applies to
Purchasing

Why it matters: Cetec fills the cost on every new PQuote line from these prices. A missing or expired price means the buyer retypes it from an email, and a stale one means POs go out at the wrong price.

  1. Decide which kind of break you are recording

    1. A vendor's own break is the price one vendor charges. Use it when you buy the part from more than one vendor.
    2. A part break is the price regardless of vendor. Use it when there is one price for the part.
    3. Know the order Cetec uses on a PQuote. It looks for the PQuote vendor's own break first, then a part break, then what you last paid, then the part's last resort cost. A cost you type on the line always wins.
  2. Open the part's pricing

    1. Open the part: Parts > Lists > Part List, then click the part.
    2. In the left-hand menu, open PRICE/COST and click Pricing.
  3. Enter the cost breaks

    1. On the part's PRICE/COST > Pricing screen, for a vendor's own price, go to Create Cost Breaks for Vendor, type the vendor's name in the search box, pick the vendor from the list, and click Add. A table for that vendor opens with one row.
    2. For a part price, use Cost Qty Breaks.
    3. On the row, set the Location, From Qty, To Qty and cost. Breaks are per warehouse location. A row left on All applies to every location, so set one location per row when the price differs by warehouse. Leave To Qty at 0 on the last break for "and above".
    4. Set Date Active and Date End if the price is only good for a while. When a price ends, set its Date End rather than deleting it, so the history stays.
    5. For the next quantity break, click Add Break? and fill in the new row. Its From Qty starts where the last row ended.
    6. Click Update.
  4. Check a PQuote picks the price up

    1. Start a PQuote for the vendor (see Raise a purchase order) and add a line for the part at a quantity inside one of your breaks. Don't type a cost.
    2. Check the line's cost matches the break. Cetec fills it in as soon as you pick the part.
    3. To see what you actually paid in the past, use Purchasing > POs > PO Cost History, or the PO Price History section at the top of the part's Pricing screen.

Other ways to do this

Import breaks from a spreadsheet

For a vendor's price list covering many parts.

  1. Open Parts > Pricing > Cost / Resale Break Import. The screen is titled Import Cost & Resale Breaks.
  2. Choose the file (.xls or .csv) and click Import File. To load several breaks for the same part and vendor in one row, add extra quantity, cost and lead time columns for each break. Show Multiple Price Breaks Example shows the layout.
  3. On the preview, set a PRC, Location or Vendor to apply to every row if they are not in the file, and match the columns.
  4. Click Update to re-check after any change, and click Finish.

Pull prices from CalcuQuote

If your company has CalcuQuote set up, CalcuQuote Pricing pulls vendor prices for you.