Bulk Importing Locations

Derek Torres
Derek Torres
  • Updated

This is a reference for bulk importing Locations into ServiceTrade.

Before you get started on completing your Location import template, you should:

Note: It is important to test your bulk Imports. All of our customers should have a Demo ServiceTrade Account. Use your Demo Account to test the import first, to avoid duplication or creating errors in your Production Account. It is not possible to delete in bulk in ServiceTrade.
If you do not know what your Demo Account credentials are, please reach out to Customer Support.


How to Download the Locations Import Template

  1. On the Nav Bar, click Customers.
  2. Then click Bulk Import.
  3. Then click the Location tab.
  4. Click the location import template link. This will download a csv. file to your computer.

Location Import Template Field Definitions

Below is a list of the Field Names and Definitions used in the Location Import Template.

Field Name

Field Definitions


The name of the Job site, such as "Buc-ee's (Florence)".


The physical address of the Location. For best results, this address should be searchable using Google Maps.

Note: If you have multiple address lines, merge them all into one cell before pasting them here. Multiple address lines for Locations are not supported.


The city of the Location.


The state of the Location.
Format: Must be abbreviated to 2 characters, such as "TX".

postalcode The zip or postal code of the Location.
latitude The number of degrees north (+) or south (-) of the equator for this Location. You would use this if the Location does not have an address.
How do I find the latitude and longitude of a Location?
longitude The number of degrees east (-) or west (+) of the Prime Meridian for this Location. You would use this if the Location does not have an address.
How do I find the latitude and longitude of a Location?
phone The Location's main phone number.
primary_contact The name of the person who is the primary contact for this Location.

The general kind of contact that this person is.

Format: Below is a list of ServiceTrade designated contact types. You may also enter a custom type, but these designated contact types can be utilized when messaging your customers in bulk. We recommend using the list below:

  • financial
  • management
  • onsite
  • owner
  • sales
  • scheduling
primary_contact_phone The best phone number for the primary contact.
primary_contact_mobile The mobile phone number for the primary contact.
The backup or alternate phone number of the primary contact.
primary_contact_email The email address for the primary contact.
email A generic email for the Location. This does not have to correspond to any individual contact.

A comma-separated list of abbreviations for service lines that you wish to have enabled at this Location.

A good place to see all of the available Service Line abbreviations is on the bottom right of the My Account page in ServiceTrade.

Format Example: Entering the abbreviations


would enable the Equipment Maintenance, Planning, Programming, and Shop Service Lines for this Location


General comments for the Location that are not specific to a Job.

Example: "COD Customer"


General comments for the Location that are not specific to a Job, and that you want to be visible to your Techs on the ServiceTrade Mobile App. The comments are not visible to customers.

Example: "Gate Code 4598"


General comments for the Location that are not specific to a Job, and that you want to be visible to your Schedulers and Dispatchers.
These comments show prominently when using our scheduling and dispatch tools and are not visible to customers.

Example: "They prefer that we schedule on Wednesdays before 10 am"


General comments for the Location that are not specific to a Job, and that are of particular interest to Users managing Invoices.

These comments will be visible to customers when creating Invoices or on Invoice Links if marked as a "Public" comment.


Defines which offices a Location belongs to. Leave blank for default office.

Format: If a Location is assigned to multiple offices, list each office and separate them with commas.


The bill-to company name for this Location.  Can be new or existing.

Format: If the Company already exists, then all company-specific fields must match the existing company. If not, you will get duplication.


The bill-to address for the Company.

Format: Can be a P.O. Box or other non-mappable address.
How do I import a multi-line street address for a Company (bill-to)?



The city of the Company.


The state of the Company.
Format: Must be abbreviated to 2 characters, such as "TX".

company_postalcode The zip or postal code of the Company.
company_phone The main phone number for the Company.


Comma-separated list of tag names for the Location.
Creating and Managing Tags


Designate whether the Location is active, pending, or inactive.

Note: If the status column is empty (or if the column is not included), then the imported Location's status will be active by default.


Indicate whether or not you would like the Location listed as taxable.

  • Enter "1" for taxable.
  • Enter "0" for non-taxable.
  • If blank, then it will default to the tax status of your default Location taxability settings in your ServiceTrade Account Settings.

The tax group's code (maximum of 40 characters). See Sales Tax Groups for more details.

  • Taxable must be set to "1", then you can enter the Tax Group Code in the new field.
  • Note: Tax Group Codes must be unique and not used for another tax group in your account.

You can use this field to add an external id to this company. This allows you to distinguish between seemingly identical companies by their external IDs during the bulk importing process.

The "*" should be the system_name of the external system you created for your account that you want applied.



How do I import (International) addresses outside of the U.S. or Canada?

You must include latitude and longitude for us to properly map the Location and you must include a two-character abbreviation for the state, province, or region.


How do I find the latitude and longitude of a Location?

You may want to import a Location that doesn't have a mappable address. This is common when your service Location is in a rural area (campsites, wind turbines, electric lines, etc.)

The below image shows you how to use Google Maps to find the latitude and longitude of a Location.


I have additional columns in my import template, that are not defined above. What do I put there?

Any additional column not explicitly mentioned above is almost certainly an External ID. These extra fields are not required for the import to work.

However, they may be very important to your accounting systems or other integrations.

You can learn more about External IDs in this article.

Ask your manager or ServiceTrade admin for more information, and for guidance on what to put in this field.


How do I import a multi-line street address for a company (bill-to)?

ServiceTrade allows you to bulk import multi-line street addresses using the Locations Import Template. Follow these steps to import multi-line Company addresses.

  1. On the company_street column, enter your multi-line street address using line breaks.
    Example Below:
  2. Follow the steps to import the Locations file.
  3. Your imported Company in ServiceTrade will now display with a multi-line address.
    Example below:

Was this article helpful?




Please sign in to leave a comment.