Docs › CRM setup

Import your customers and price book

Customers and their service addresses come over from Jobber (connected, or its client export) or from Housecall Pro's customer export. Your price book comes over from Jobber directly or from a CSV. Jobs, invoices, balances, equipment and memberships don't come over, so plan to finish open work where it started. Plan an evening for a few thousand customers.

What comes over

From JobberFrom Housecall Pro
Customers and contactsYes — connected account or client CSV exportYes — customer CSV export
Service addressesYes — every property becomes a service locationYes — every address block becomes a service location
Customer notes and tagsTags (up to 5) from a connected account; notes and tags from the CSVNotes and tags, kept in the customer's notes
Price bookYes — imported directly; Jobber sync can keep runningVia CSV with Pricebookr's column names
Jobs, visits, quotes, invoices, open balances, payments, equipment, memberships, photosNo. Finish open jobs and collect open invoices where they started, and re-create memberships in Pricebookr.

1. Bring your price book

  • From Jobber: Settings → Integrations → Jobber connection → Connect Jobber, then Import from Jobber. Names, descriptions, unit prices and any costs come over; prices start as hand-set so nothing is repriced without you. See Import your catalog from Jobber.
  • From Housecall Pro or a spreadsheet: Catalog → Import CSV. Rename your columns to name, price, cost (and optionally sku, category, unit) — Download template shows the layout. See Import from CSV.

You'll know it worked when your items are in the Catalog with the prices you expect.

2. Export your customers

  • Jobber, connected: nothing to export — skip to step 3.
  • Jobber, file: Clients → Export.
  • Housecall Pro: Customers → Export. It downloads an .xlsx; open it and Save As CSV. Pricebookr only reads CSV.

3. Preview the import

Go to CRM → Customers → Import customers (admins only). Either drop your CSV on the box, or click Import clients from Jobber if Jobber is connected — that reads your clients and properties and writes nothing back to Jobber.

The preview tells you how the file was read (Read as a Housecall Pro export, Jobber or spreadsheet) and counts new customers, service locations, already exist and can't import. Open Column mapping to see which column went where and which were ignored.

You'll know it worked when the sample rows show the right names, phones, emails and addresses. Check the can't import list before going on.

4. Decide what to do with customers you already have

A customer counts as already here when the name matches and at least one phone, email or ZIP matches. For those, choose:

  • Leave them alone — nothing changes for them (the default).
  • Add missing addresses — only new service locations are added; names and contact details stay as they are.
  • Import all as separate customers — for when the match is wrong.

5. Import

Click Import N customers. It keeps running if you close the window; a few thousand records take a few minutes. You can Stop at any point — customers already written stay saved, and running the import again skips them.

You'll know it worked when it reports N customers and N service locations imported.

6. Start sending quotes from Pricebookr

  1. Set up payments: Set up card and bank payments.
  2. Connect QuickBooks if you use it: Connect QuickBooks Online. If QuickBooks already holds your customers, import from there instead of a CSV so the records are linked from the start.
  3. Pick the date you'll send new quotes from Pricebookr. Finish open jobs and collect open invoices where they started.
  4. Re-create maintenance plans under memberships (Pro) and sign members up again.

If you use Jobber, the price book sync keeps running either way: you can keep quoting in Jobber and push prices to it from Pricebookr for as long as you like.

Troubleshooting

You seeFix
Please choose a .csv file. Housecall Pro exports an .xlsx — open it and Save As CSV first.Open the export in Excel, Numbers or Google Sheets and save it as CSV.
no name column found (expected Name, First Name/Last Name, or Company)Rename a column to Name, or First Name and Last Name.
Jobber's API rate limit. Waiting a minute and trying again usually clears it.Wait a minute and start again; customers already imported are skipped.
The import stopped or expired. Read a fresh preview before importing.Load the file again. Anything already imported is skipped.
has more addresses in Jobber than could be readAdd the remaining properties for that client by hand.

Questions: [email protected].

Try Pricebookr free for 14 days.
The CRM and the price book are open during the trial. Pushing prices to Jobber and exporting require a paid plan.
Start your free trial

More guides

Set up card and bank payments (Stripe)

Set up a Stripe account in your name so customers can pay deposits and invoices online by card or bank transfer. About 15–30 minutes.

Connect QuickBooks Online

Send invoices, payments, refunds and Stripe payouts to QuickBooks Online so the deposit matches your bank feed to the cent. About 15 minutes.

Get started with the HVAC CRM

What each CRM screen is for, who on your team sees it, and a first-week checklist to get a 1–2 truck shop running.