Skip to content
English
  • There are no suggestions because the search field is empty.

Advance Unit Import/Export

ServiceBox has introduced a new feature: Advanced Unit Import and Export. This feature improves how users manage unit data by allowing bulk import and export across multiple job sites and customers. In this article, we’ll walk through why it was introduced, how it benefits users, and how to use it effectively.

Why ServiceBox Introduced Advanced Unit Import and Export

Previously, ServiceBox allowed unit imports using a spreadsheet, but only at the individual job site level, a time-consuming process for customers with large data sets. To streamline this, the Advanced Unit Import and Export feature was developed, allowing users to upload or export all units in bulk, across jobs and customers.

Using the Advanced Unit Import and Export Feature

Step 1: Generate the File

  • Navigate to Advanced Unit Import Export in ServiceBox.

 

  • Click the Export button to download an Excel spreadsheet.

 

  • New Customers: The spreadsheet will be blank.

  • Existing Customers: Your current unit data will be pre-populated.

Step 2: Update the Spreadsheet

  • Open the exported file and click Enable Editing to make changes.

 

The spreadsheet contains columns for:

  • ID (auto-generated by ServiceBox – do not edit this)

  • Job Site Display Name

  • Customer Display Name

  • Unit Name

  • Description

  • Location
    Optional columns may include:

  • Contract Type

  • Contract Amount

Mandatory fields: Job Site Display Name, Customer Display Name, and Unit Name

 

Step 3: Find the Required Display Names

To ensure your import succeeds, the Customer Display Name and Job Site Display Name in the spreadsheet must exactly match what’s set up in ServiceBox.

To find the Customer Display Name:

  • Open the customer record in ServiceBox
  • Click the Edit button 

 

  • Copy the Customer Display Name from this screen and paste it into your spreadsheet

 

To find the Job Site Display Name:

  • Go to the Job Site tab

  • Open the Job Site and click Edit

 

  • Copy the Job Site Display Name from this screen and paste it into your spreadsheet

 

4. Add Unit Information

  • Fill in the Unit Name field.

  • Add other optional fields like description, location, or contract details as needed.

 

5. Save & Import the File

  • Save the file in the same format it was exported in.

  • Return to Advanced Unit Import Export in ServiceBox.

  • Click the Import button, choose your file, and upload it.

 

ServiceBox will:

  • Process the import

  • Email you confirmation or list any errors

  • Display newly imported units in the relevant Job Sites


Need Help?
If you run into any issues or have feedback, reach out to our support team at support@jobboxsoft.com — we’re happy to help!