1. How to import customers

How to import customers

HOW TO IMPORT CUSTOMERS INTO SERVCRAFT

OVERVIEW

Keep track of important customer details whether you’re at the office, on the way to a job, or out in the field.

All of your customer details in one place easily linked to your jobs. You and your team keep track of them at the office, on the way to a job or out in the field. 

One of the quickest ways to bring your customers into ServCraft is by importing them  in an excel workbook. This is much faster than manually adding customers one-by-one.

Another fast way to bring in customers to ServCraft  is by synchronising customers from Xero, QuickBooks or Sage Online. If you have customers in any of these online systems, to avoid creating duplicate customers it’s best to first switch on an integration and do a sync from them to bring those customers into ServCraft. Find out more here.

In this guide we will show you how to import customers into ServCraft from an excel spreadsheet. 

SUPPORTED COLUMN HEADERS

Note: Don’t remove any columns from the template, you can leave the non-required columns blank if it does not apply to you.

These are the fields that we can import via the spreadsheet. There are lots of fields but only some that might be relevant to you. Set up each of these fields as a column header to import data into these fields:

  • CustomerCode (If you leave this blank, ServCraft will auto generate a code for you)
  • CustomerName
  • CustomerStatus
  • Class ()
  • CustomerType
  • MediaType
  • IndustryType
  • VATNumber
  • CompanyNumber
  • CustomField1
  • CustomField2
  • CustomField3
  • CustomField4
  • Country
  • FirstName
  • LastName
  • HomeNumber
  • WorkNumber
  • MobileNumber
  • FaxNumber
  • EmailAddress
  • SendEmail
  • SendSMS
  • LocationDescription
  • AddressPhysical1
  • AddressPhysical2
  • AddressPhysical3
  • AddressPhysical4
  • AddressPhysical5
  • PostalDescription
  • AddressPostal1
  • AddressPostal2
  • AddressPostal3
  • AddressPostal4
  • AddressPostal5

Tip: Check out our sample file to use as a guide.

 

IMPORTING A CUSTOMER LIST

To import your Customer list, go into Customers, Customer List and in the top right corner, click the Import button. Then click the Choose File button.

Browse and select the file you want to import. Once selected click the Import File button.

 

IMPORTING MULTIPLE CONTACTS OR PROPERTIES FOR THE SAME CUSTOMER

To create multiple contacts or properties for a customer, add a new row in your spreadsheet for each contact or property you’d like to create for the customer. Each row for the customer should have the same customer details like customer code and customer name. To create another contact, change the fields such as first name, last name, mobile number, email address etc. To create another location, change the fields such as location description, address physical 1 etc. You can leave the other fields the same.

Was this article helpful to you? Yes No 1

How can we help?