Skip to main content

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​

  1. Settings → Company → Imports → + New Import
  2. Select Import Type: Customer
  3. 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.
  4. Fill in the template with your customer data (do not change column headers)
  5. Save the file as .xlsx or .xls
  6. Back in ServCraft: click Select Your Import File
  7. Select your filled-in file
  8. Click Create Import
  9. ServCraft processes the file in the background
  10. 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):

ColumnNotes
CustomerCodeOptional — auto-generated if blank
CustomerNameRequired on every row
Class"Individual" or "Company" (leave blank to keep the existing value)
CustomerType / CustomerStatusMust match existing names set up in Settings
IndustryType / MediaTypeMust match existing names set up in Settings
VAT Number / Company NumberOptional
Custom Field 1–4, Custom Number 1–2, Custom Date 1–2Business-specific custom values
StoreOptional — must match an existing store name or code if filled in
Contact columnsFirst Name, Last Name, Email Address, Mobile/Home/Work/Fax Number, Receive Emails, Receive SMS
Location columnsLocation 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:

ErrorCauseFix
"Customer name required."Every row needs a customer nameFill 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 personAdd 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 formatCorrect the email address
"Store must exist if specified."The Store value doesn't match any store name or codeFix 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​

  1. Connect the accounting integration (Settings → Company → Integrations)
  2. Set Customer Direction to "From" (accounting system → ServCraft) or "Bidirectional"
  3. ServCraft begins syncing customers from the accounting system in the background
  4. 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:

  1. Either create them manually in ServCraft, or
  2. 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?​

SituationRecommended Method
No accounting system, have a spreadsheetExcel import
New ServCraft + existing Xero/Sage/QB with customersAccounting system sync (set Direction to "From")
New ServCraft + empty accounting systemCreate manually or Excel import, then sync "To" accounting system
Moving from another field service systemExcel 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: