Bulk Importing Recurring Services

The abbreviation of the Service Line for this Service.

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

The description of the work to be done.

Note: Service Descriptions are visible to Technicians, office staff, and customers.

The date that the first instance of this Service will be due.

Format: YYYY-MM-DD
*required

Is the time that either the customer or the office prefers that Appointments for this service be Scheduled.
Leaving the field blank is treated as having no preferred start time.

Format: Must be in military time format (e.g. "13:00" for 1:00 pm) Only 15-minute increments of time are supported

(13:15, 13:30, 13:45)

Is the Tech or Techs that will automatically be assigned to the Appointments for this Service.

Format: Must be a comma-separated list of active usernames.
Usernames, if not known, are best retrieved from My Account > Users.

The estimated price in USD that the Customer will pay for this Service.
Estimated Price is primarily a visual, scheduling, and forecasting aid, and does not translate directly to the invoice.

Format: Must be formatted 0.00 with no commas.
(e.g. "24003.72" for $24,003.72 USD)

The estimated time that the Service will take to complete.

Format: Must be formatted 0.00 in quarter-hour increments.
(e.g. "12.25" for 12 hours 15 minutes.)

The exact name of the Location to which this Service will be assigned.
*required

The asset ID that you wish to associate this Service with.
Asset IDs are best found via exporting "Locations with Assets" or exporting Assets.

The contract ID of the contract you want to be associated with this service.

This is the frequency in which you want this Service to repeat. Used in combination with interval to create any variation of schedule recurrence.

Format: Must be:

• daily
• weekly
• monthly
• quarterly
• semiannually
• yearly
  *required

Is the multiplier that applies to the frequency. Used in combination with frequency to get any variation of schedule recurrence.

Format: Must be a whole number and greater than 0.
*required

The size of the due window.

Format: Must be:

• day
• week
• month
• an integer representing the number of days.

Example: Entering "month" indicates that the service due window is the whole month and that scheduling the service anytime during the month is acceptable.
*required

Indicates if you want the Service to repeat only on weekdays.

Format:

• Enter "1" to indicate that monthly services repeat on the nth weekday (e.g. third Monday.)
• Enter "0" to indicate repetition by nth day of the month. In either case, the value of n is inferred from the service_start_date.
• If blank it defaults to "0"

The name of an existing service template that you wish to use for this service.

Note: If you use this field to apply a Service Template, then only the location_id, asset_id, service_start_date, window_size, and template_name fields should be filled out, along with any external IDs if applicable.
If you have a template_name + the other fields not listed above, the row will fail to import and we will append an error explanation to the downloadable import failures file.

Service Templates are not the same thing as Recurring Services Import Template CSV files.