(916) 802-5127 Get pricing

CFE guide · Ordering and material

Check a Vendor Import Before You Save It

Step 3 of Import vendors, Check the vendors, shows every line of your file before anything is saved. The tiles count the new vendors, extra reps, vendors already in your list, lines that need fixing and lines not imported. Click a chip such as Warnings or Needs fixing to see only those, fix them with the pencil, then import.

  • 5 minutes
  • Beginner
  • CFE BidWise Business
CFE BidWise Import vendors Warnings: no account number yet, rep email moved to notes, and a line that needs a category
Video walkthrough · 3:48 · Guide 102 of 110

Why check the import?

A vendor list built over ten years has a bit of everything: a mill typed twice with two reps, a phone number in the email column, a closeouts tab nobody remembers. Imported blind, that becomes duplicate vendors and orders sent to the wrong rep.

The check step shows each of those before anything is saved, so you fix the list once, on one screen.

The six steps

  1. Read the five countsNew, extra reps, already there.
  2. Extra repsOne vendor, Other reps.
  3. Read the warningsYellow: read, then import.
  4. Fix what needs fixingRed: fix it, or it stays out.
  5. Vendors already in your listFill in, use the file, or leave it.
  6. What can go wrongPending vendors, a wrong import.

1Read the five counts

CFE BidWise Check the vendors: 15 new vendors, 1 extra rep, 5 already in your list with 1 getting updates, 1 needs fixing, 1 line not imported
15 new, 1 extra rep, 5 already in your list, 1 needs fixing, 1 line not imported.

Step 3, Check the vendors, starts with five tiles. New vendors, 15, are added to Client Info › Vendors. Extra reps, 1, is the same vendor on another row. Already in your list, 5: 1 gets updates and 4 are left as they are.

Needs fixing, 1, is not imported until it is fixed. Lines not imported, 1, are titles, section names or the headings again. Click any tile, or a chip under it, to see only those lines.

2See extra reps kept on one vendor

CFE BidWise Import vendors Extra reps: Mohawk Group on row 5 with Dana Whitfield, added to Mohawk Group on row 4
Mohawk Group on row 5: an extra rep, added to row 4.
CFE BidWise vendor profile Mohawk Group after the import: account MG-55102, lead time 18 days, rep Chris Patel, Other reps Dana Whitfield, approved by Jordan Reyes
After the import: Chris Patel is the rep, Dana Whitfield is under Other reps.

Click Extra reps. Mohawk Group is on row 4 with Chris Patel, and again on row 5 with Dana Whitfield. BidWise does not make a second Mohawk. Dana is added to Mohawk Group as an extra rep.

After the import, the Mohawk profile has account MG-55102, Chris Patel as the rep, and Dana Whitfield, her phone and email under Other reps.

3Read the warnings

CFE BidWise Import vendors Warnings 4: J+J Flooring no account number yet, Healthier Choice Cushion rep email moved to notes, Emser Tile no account number yet, Floor Liquidators Direct needs fixing
Four warnings: no account number yet, and an email that was not an email.

Click Warnings. There are 4. J+J Flooring and Emser Tile have no account # yet. Healthier Choice Cushion had something in the email column that is not an email, so it was moved to notes instead of lost.

A warning does not stop the import. Fix it now with the pencil at the end of the line, or later on the vendor’s profile.

4Fix the lines that need fixing

CFE BidWise Import vendors Needs fixing 1: Floor Liquidators Direct from the Closeouts tab, needs a category, pick a category, no account number yet
Floor Liquidators Direct needs a category.

Click Needs fixing. Floor Liquidators Direct came from the Closeouts tab, which has no category, so it says Pick a category.

Pick one in its Category box, or click the pencil to fix the line. Until it is fixed, that vendor is not imported, and everything else still is.

Quick Tip

Use Print table or Export on this screen to hand the list of warnings to the person who keeps the vendor accounts. They can call for the missing account numbers while you import.

5Choose what happens to vendors you already have

CFE BidWise Import vendors: when a vendor is already in your list, fill in only what is empty, use the file, or leave it as it is, then Import 16 vendors
Fill in only what is empty, Use the file, or Leave it as it is.

When a vendor in the file is already in your list, pick one of three. Fill in only what is empty keeps what you typed in BidWise and adds what was missing. Use the file lets the file win wherever both have a value. Leave it as it is changes nothing.

Shaw Contract was already there without a fax, so with the first choice it only gets the fax. Then click Import.

6What can go wrong, and how to fix it

CFE BidWise vendor Metro Underlayment Supply pending approval, with the note to check that your company has an account, and the Approve, On hold and Not approved buttons
A pending vendor: check the account, then Approve.

Some vendors came in as Pending approval. Those had no account number. Click Show the 2 pending on the summary, type the account number, and click Approve. Until then Ordering does not offer them.

A vendor came in twice. The second row had a different name, such as Shaw and Shaw Contract. Fix the name in your file and import again, or delete the extra one.

The import went wrong. Click Undo this import, fix the file, and import it again.

Worked example: 21 lines, checked

The check step for Northgate-vendor-list.xlsx:

LineWhat happensAction
Shaw ContractUpdates one in your listGets its fax
Mohawk Group, row 5Extra repDana Whitfield on Other reps
J+J FlooringNew, no account # yetPending approval
Healthier Choice CushionNew, email moved to notesFix the rep email later
Floor Liquidators DirectNeeds fixingPick a category
MillikenAlready in your listLeft as it is

Two minutes of reading, and no duplicate vendors.

What to do next

Next, see what to do when the GC approves a pay app for less.

Import your vendors without the mess

Vendor import is part of CFE BidWise Business. Start with the 30-day free trial, no credit card.

Download Free for Windows64-bit · 30-day free trial · no credit card

Frequently Asked Questions

Is anything saved during the check?

No. Nothing is saved until you press Import, and you can undo the import afterwards.

What is an extra rep?

The same vendor on a second row with another sales rep. It is kept on the first vendor as Other reps, not imported as a second vendor.

Why is a vendor Pending approval?

It has no account number. Type the account number and the Master user approves it, or tick Also approve the ones with no account number before importing.

Cristian Valcu, founder of Commercial Flooring Estimating LLC

Written by

Cristian Valcu – Founder & CEO, Commercial Flooring Estimating LLC

Cristian has estimated commercial flooring for over 20 years and built CFE BidWise around the way flooring contractors actually price, propose and track their bids.