Skip to content
All Trades Office Help Log in

Check the columns and bring it in

After you add your files: check how the columns were matched, look over the preview, and bring your records in.

Who can do this: Owner, Admin.

Last updated

Nothing is saved until you tap Bring it in, so it's safe to look around first.

Only an Owner or Admin can import.

Steps

  1. On Settings → Import your data, add your files. Each one shows what we think it holds. If it's wrong, pick Customers or Price book next to it.

    Step 1: On Settings → Import your data, add your files. Each one shows what we think it holds. If it's wrong, pick Customers or Price book next to it.
  2. Tap the list you want to bring in first, like Jobber Customers.

    Step 2: Tap the list you want to bring in first, like Jobber Customers.
  3. Check the columns. Each of our fields shows the column we matched from your file and an example from it. Change any that look wrong, or pick Not in my file.

    Step 3: Check the columns. Each of our fields shows the column we matched from your file and an example from it. Change any that look wrong, or pick Not in my file.
  4. Choose what happens when a record is already here: Keep what I have, Fill in blanks only, or Bring them in as new. Then tap Preview the import.

    Step 4: Choose what happens when a record is already here: Keep what I have, Fill in blanks only, or Bring them in as new. Then tap Preview the import.
  5. Look over the preview: new records, matches with ones you already have (and how they matched), rows that repeat in your file, and rows that won't come in.

    Step 5: Look over the preview: new records, matches with ones you already have (and how they matched), rows that repeat in your file, and rows that won't come in.
  6. Tap Bring it in. Keep the page open until it says Done.

    Step 6: Tap Bring it in. Keep the page open until it says Done.
  7. Your import shows under Past imports, with what came in and an Undo button for 30 days.

    Step 7: Your import shows under Past imports, with what came in and an Undo button for 30 days.

How we spot a customer you already have

We check in this order and stop at the first match:

  1. The same ID from your old app (from an earlier import).
  2. The same email.
  3. The same phone number.
  4. The same name and street.

Rows in your own files that repeat each other (like one client with two properties) become one customer with all of their addresses and tags.

Good to know