Importing Customers
There are two ways to bring customers into ServCraft in bulk: Excel import (for any situation) and pulling from an accounting system (when an integration is connected). This page covers both.
Method 1: Excel Import
Use this when you have a spreadsheet of customers to load — from a previous system, a CRM export, or an Excel database.
Step-by-Step
- Settings → Company → Imports → + New Import
- Select Import Type: Customer
- Click Download Blank Template to get the import file
- Or click Download Template With Existing Data if you want to see current customers in the template format (useful for checking what's already there). This option also requires the Exports permission.
- Fill in the template with your customer data (do not change column headers)
- Save the file as .xlsx or .xls
- Back in ServCraft: click Select Your Import File
- Select your filled-in file
- Click Create Import
- ServCraft processes the file in the background
- Go to Settings → Company → Imports to monitor progress
Required Fields for Import
Important: Every row needs a Customer Name. If any contact details are provided on a row, the contact needs at least one way to reach them — a home number, work number, mobile number, or email address. Rows missing these are flagged as errors.
What Gets Imported
The template columns for a Customer import include (download a fresh template for the exact current list):
| Column | Notes |
|---|---|
| CustomerCode | Optional — auto-generated if blank |
| CustomerName | Required on every row |
| Class | "Individual" or "Company" (leave blank to keep the existing value) |
| CustomerType / CustomerStatus | Must match existing names set up in Settings |
| IndustryType / MediaType | Must match existing names set up in Settings |
| VAT Number / Company Number | Optional |
| Custom Field 1–4, Custom Number 1–2, Custom Date 1–2 | Business-specific custom values |
| Store | Optional — must match an existing store name or code if filled in |
| Contact columns | First Name, Last Name, Email Address, Mobile/Home/Work/Fax Number, Receive Emails, Receive SMS |
| Location columns | Location Description, physical and postal address lines, Country |
Always download a fresh template before each import. Field names may be updated, and using an old template can cause validation errors.
Import for Customer Contacts and Locations
Contacts can also be bulk-imported separately using Import Type: Customer Contact, and locations using Import Type: Customer Location. These import the records and link them to existing customers.
Handling Errors
If any rows fail validation, the import will show an error status. Click into the import to see which rows failed and why.
Common import errors:
| Error | Cause | Fix |
|---|---|---|
| "Customer name required." | Every row needs a customer name | Fill in the CustomerName column on all rows |
| "Customer contact requires at least one method of contact (Home, Work, Mobile or EmailAddress)" | Contact details given, but no way to reach the person | Add at least one phone number or email |
| "Duplicate existing customer found with Code … and Name …" | The row matches an existing customer (may be inactive or archived) | Remove the row or change the code/name |
| "Email address is not in a valid format" | Email doesn't match the expected format | Correct the email address |
| "Store must exist if specified." | The Store value doesn't match any store name or code | Fix the store name, or leave blank for the default store |
After fixing errors, you can re-import the corrected file.
Method 2: Import From Accounting System
When an accounting integration (Xero, Sage One, or QuickBooks) is connected with the Customer Direction set to "From" or "Bidirectional", ServCraft pulls customers from the accounting system.
This is not a one-click bulk import — it's an ongoing sync. But understanding how it works helps you manage the first connection properly.
How It Works
- Connect the accounting integration (Settings → Company → Integrations)
- Set Customer Direction to "From" (accounting system → ServCraft) or "Bidirectional"
- ServCraft begins syncing customers from the accounting system in the background
- Customers appear in ServCraft as they're processed
Rate and timing: This is not instant. Depending on the number of contacts in the accounting system, it may take minutes to hours for all customers to appear.
Xero Contacts: The Important Gotcha
In Xero, a "Contact" is just a record — it doesn't become a "Customer" until it has at least one transaction (invoice, credit note, etc.).
What this means for import:
- Only Xero contacts who have had at least one Xero invoice will sync into ServCraft as customers
- Contacts with no transactions are NOT automatically imported
- If a customer exists in Xero as contact-only (no transactions), they won't appear in ServCraft automatically
To import contact-only customers from Xero:
- Either create them manually in ServCraft, or
- Create a transaction in Xero for that contact (even a zero-value invoice) to make them a Customer type, then re-sync
For full detail, see Accounting Integrations — The Xero Contact Gotcha.
Using the Contact Matching Report
Before syncing customers from an accounting system (especially when both systems have data), use the Contact Matching Report to preview matches and prevent duplicates.
Settings → Company → Integrations → [select your integration] → Generate Contact Matching Report
The report shows:
- Which accounting contacts match existing ServCraft customers (by email, phone, or name)
- Which accounting contacts have no match in ServCraft (will be created as new customers)
- Which ServCraft customers have no match in the accounting system
Review this carefully before enabling bidirectional sync, especially if both systems already have customer data.
Which Method Should I Use?
| Situation | Recommended Method |
|---|---|
| No accounting system, have a spreadsheet | Excel import |
| New ServCraft + existing Xero/Sage/QB with customers | Accounting system sync (set Direction to "From") |
| New ServCraft + empty accounting system | Create manually or Excel import, then sync "To" accounting system |
| Moving from another field service system | Excel import using data exported from old system |
| Small number of customers (< 20) | Create manually for best control |
After Import: Checking Your Data
After any bulk import, spot-check a sample of records:
Related Topics
- Creating Customers
- Managing Customers
- Accounting Integrations