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 Jobber | From Housecall Pro | |
|---|---|---|
| Customers and contacts | Yes — connected account or client CSV export | Yes — customer CSV export |
| Service addresses | Yes — every property becomes a service location | Yes — every address block becomes a service location |
| Customer notes and tags | Tags (up to 5) from a connected account; notes and tags from the CSV | Notes and tags, kept in the customer's notes |
| Price book | Yes — imported directly; Jobber sync can keep running | Via CSV with Pricebookr's column names |
| Jobs, visits, quotes, invoices, open balances, payments, equipment, memberships, photos | No. 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 optionallysku,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
- Set up payments: Set up card and bank payments.
- 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.
- Pick the date you'll send new quotes from Pricebookr. Finish open jobs and collect open invoices where they started.
- 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 see | Fix |
|---|---|
| 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 read | Add the remaining properties for that client by hand. |
Questions: [email protected].