-
- Managing Leads & Inquiries
- Adding Customer Inquiries
- Website Lead Capture Form
- Customer Portal Inquiry Form
- View Inquiry Details
- Edit Inquiry Details
- Deleting Inquiries
-
- Booking Management
- Create a New Booking
- Managing Existing Bookings
- Edit Booking Details
- Repeat / Recurring Bookings
- Delete Bookings
- Export Booking as PDF
- Booking Timeline
- Booking History Log
- Fieldworker Availability Finder
- Nearby Bookings Locator for Proximity Scheduling
- Allocate Multiple Fieldworkers to Booking
- Fieldworker Payroll Management
- Manage Fieldworker Payment for Bookings
- Setting Fieldworker Payment Per Service
- Accept Booking Request On Behalf of Fieldworker
- Admin Approval for Fieldworker Changes
- Manual Push to Google Calendar
- Change Booking Owner
- Contact Fieldworker Regarding Booking
- Contacting Customer Regarding Booking
- Sending Emails for a Booking
- Pause/Resume automated emails
- Pause/Resume automated SMS
- Sending Booking Confirmation
- Service Reminder Automation
- Request Fieldworker Updates
- View Booking Discussion
- Add a comment to a booking discussion
- Add Complaint to a booking
- Adding Booking Attachments
- Adding Images to Bookings
-
- Creating New Quotes
- Edit Quote Details
- Edit Quote Number
- Claiming Quote Ownership
- Export Quote PDF
- Deleting Quotes
- Manage Quote Follow Up Date
- Adding Issues / Complaints to a Quote
- Adding Labels to Quotes
- Adding Attachments to a Quote
-
- Invoice & Billing Management
- View Invoice Details
- Edit Invoice Breakdown
- Change Invoice Number
- Convert Invoice to Draft
- Convert an Invoice to Void
- Claim Invoice Ownership
- Deleting Invoices
-
- Managing Fieldworkers
- Fieldworkers & Subworkers
- Fieldworker Industry Label
- Managing Fieldworkers Lists
- Fieldworker Booking Summary
- Fieldworker Activity Log
- Adding Fieldworkers
- Edit Fieldworker Details
- Update Fieldworker Profile
- Manage Fieldworker Profile
- Fieldworker Email Verification
- Fieldworker Active Services
- Fieldworker Service Areas
- Fieldworker Working Hours
- Manage Fieldworker Availability
- Fieldworker Bank Details
- Activate/Deactivate Fieldworkers
- Blocking / Unblocking Fieldworkers
- Contacting Fieldworkers
- Sending Emails to Fieldworkers
- Sending SMS to Fieldworkers
- Fieldworker Received SMS
- Sending Messages to Fieldworkers via App
- Sending Messages to Fieldworkers Regarding Booking
- Fieldworker SMS Log
- Fieldworker Email Log
- Fieldworker Payment Agreement
- Fieldworker Payment Per Service
- Fieldworker Service Commission
- Fieldworker Payroll Management
-
- Business Email Authentication
- Viewing company information
- Company Logos Setup
- Manage Trading Names
- Define Fieldworker Operational Locations
- Third-Party API Integrations
- Google Calendar Integration
- Google Maps API integration
- Display Google Reviews
- Terms and Conditions
- Booking Location Types
- Fieldworker Industry label
-
- Managing Services Offering
- Creating a New Service
- Managing Service Categories
- Implement Bulk Discounts / Volume Pricing
- Geographical Pricing
- Creating a Service Package
- Managing Products List
- Creating Custom Fields
- Grouping Custom Fields
- Custom Field Types
- Short Text Input (Text Field)
- Long Text Input (Text Box)
- Date Selection Input
- Time Selection Input
- Increment/Decrement Button (+/-)
- On/Off Selector (Toggle)
- Single Choice Button Display (Button Group)
- Single Choice Selector (Radio button)
- Single Choice Selector (Dropdown)
- Single Selection List Option Field
- Multi-Option Selector (Checkbox)
- Multi-Option Checkbox Button (Checkbox)
- Signature Custom Field
-
- Booking Settings Configuration
- Fieldworker Job Assignment Methods
- Fieldworker Permissions
- Fieldworker Profile Customization
- Customer Profile Customization
- Customer Dependents / Properties
- Importing Customer Dependents
- Managing Booking Status
- Complaint / Issue Status List
- Issue / Complaint Types
- Lead Sources List
- Decline Job Request Form
- Property Type List
- Label Management
- Creating Forms & Checklists
- Forms & Checklist Introduction
- Setting Up Forms & Checklists
- Forms & Checklists Usage
- Forms & Checklists Fields Types/Elements
- Forms & Checklists: Use Cases
Importing Customers
Make your transition to OctopusPro easy by importing your existing data. OctopusPro allows you to easily import your existing customers onto the system, using one file with a few simple steps by downloading a template that is easily customized from the settings.
If you have set up customer properties for your account, you can also easily import your customers and their properties onto the system by following the same steps.
Table of Contents
- How to import existing customers?
- Importing customers and their customer properties
- What happens when you import customers that already exist in your database?
- How to import customers that have custom fields added?
- What happens if the list you are importing has duplicate customers?
- Importing customers by syncing your QuickBooks account
- Importing customers by syncing your Xero account
How to import existing customers?
- To import existing customers, go to Customers > All Customers
- From the customers’ list page, click on Import customers
- A pop-up window will appear, follow the instructions for importing your customer’s file.
Before uploading the CSV file, make sure all the below requirements are met:
First, click on “Download template” and fill in the information you want to import.
- All fields with ( * ) are required fields and can’t be empty
- The password field in the file should not be encrypted, so enter the actual password text and it will be encrypted during the import
- The “Customer title” field can be only one of the following: Dr, Mr, Mrs, Miss or Ms
- The fields “first_name2”, “last_name2”, “first_name3” and “last_name3” fields are secondary values for the same contact
- The fields “mobile2”, “email2”, “phone2”, “mobile3”, “email3” and “phone3” fields are secondary values for the same contact
- The “Date joined” field must be in the date format “YYYY/MM/DD” e.g. “2018/05/12”
- The “Customer type” field value can be either “Personal” or “Business”
- The business name field should be used to enter the business name of the customer when the customer type is business
- Your file may contain some states with different spelling, so you can check the list of states in your country to make sure that the states are matched.
- The city is a required field so if you leave it empty in the file, we will take the city of your company as a default one, in case you entered the state but the city is empty we will take the first city in this state.
- The maximum allowed number of rows in the CSV file is 2500. If your list is longer than this, break it into multiple files and upload them separately
- After downloading the template, log into your Google Drive account and upload the file. You can then edit the template by adding the required customer information in the cells.
- After filling in the template, click on “Upload file” to upload your customers onto the system. Make sure the file is saved as CSV to upload it successfully.
- After uploading the file, a message will appear confirming that the file has been imported successfully and you will be able to see how many rows have been imported. If there are any fields that failed to be imported, they will be shown in the section ‘Failed Rows Details’, so you can edit them and re-upload the file.
- After importing the file, your customers will be imported into the system on the customer list page and you can search, view, or edit them easily.
Alternatively,
- You can also import customers by navigating to Settings > Company Settings > Import Data
- Click on “Import Customers”.
- A popup window will appear, click on “Download template”.
- After downloading the template, log into your Google Drive account and upload the file. You can then edit the template by adding the required customer information in the cells.
- After filling in the template, click on “Upload file” to upload your customers to the system. Make sure the file is saved as CSV to upload it successfully.
- After uploading the file, a message will appear confirming that the file has been imported successfully and you will be able to see how many rows have been imported. If there are any fields that failed to be imported, they will be shown in the section ‘Failed Rows Details’, so you can edit them and re-upload the file.
- After importing the file, your customers will be imported into the system on the customer’s list page and you can search, view, or edit them easily.
Importing customers and their customer properties
- In the case that you have set up customer properties on your account, you can import them while importing your customers. To learn more about setting up customer properties, click here.
- To import your customers and their customer properties, go to Customers > All Customers
- From the customers’ list page, click on “Import customers”.
- A pop-up window will appear, follow the instructions for importing your customer’s information file.
- First, click on “Download template” and fill in the information you want to import.
After downloading the template, log into your Google Drive account and upload the file on Excel Sheets. You can then edit the template by adding the required customer information in the cells.
When adding your customer’s details, make sure all the below requirements are met:
- All fields with ( * ) are required fields and can’t be empty
- The password field in the file should not be encrypted, so enter the actual password text and it will be encrypted during the import
- The “Customer title” field can be only one of the following: Dr, Mr, Mrs, Miss, or Ms
- The fields “first_name2”, “last_name2”, “first_name3” and “last_name3” fields are secondary values for the same contact
- The fields “mobile2”, “email2”, “phone2”, “mobile3”, “email3”, and “phone3” fields are secondary values for the same contact
- The “Date joined” field must be in the date format “YYYY/MM/DD” e.g. “2018/05/12”
- The “Customer type” field value can be either “Personal” or “Business”
- The business name field should be used to enter the business name of the customer when the customer type is business
- Your file may contain some states with different spelling, so you can check the list of states in your country to make sure that the states are matched.
- The city is a required field so if you leave it empty in the file, we will take the city of your company as a default one, in case you entered the state but the city is empty we will take the first city in this state.
- The maximum allowed number of rows in the CSV file is 2500. If your list is longer than this, break it into multiple files and upload them separately
- Do not leave any empty rows between rows, as it will be considered the end of the file.
You can then edit the template by adding the required customer information in the cells.

Once you have set up customer properties for your account, the customer properties field labels will be added as fields on the sheet, which you can fill in with your customer properties input.

- After filling in the template, download the file and click on “Upload file” to upload your customers and their customer properties onto the system. Make sure the file is saved as CSV to upload it successfully.
- After uploading the file, a message will appear confirming that the file has been imported successfully and you will be able to see how many rows have been imported. If there are any fields that failed to be imported, they will be shown in the section ‘Failed Rows Details’, so you can edit them and re-upload the file.
- After importing the file, your customers and their customer properties will be imported into the system on the customer list page and you can search, view, or edit them easily.
What happens when you import customers that already exist in your database?
If you try to import a file that includes customers that already exist in your database, the rows of these customers will fail to upload, and they will be listed for you under Failed Rows Details.
How to import customers that have custom fields added?
- If you want to import customers that have custom fields added:
- First, you have to make sure that you have custom fields added to your account.
- To add a new custom field, navigate to Settings > General Settings > Customer Profile
- Click on “+Create New”.
- Enter the Field label and Field ID then click “Save”. To learn more about customer custom fields click here.
- After adding a new custom field, go to Customers > All customers
- From the customer’s list page, click on “Import customers”
- On the bottom of the popup window, click on “Download template”.
- After downloading the template, your custom field/s title will be added as a new column, where you can add the customer custom field related to each customer.
- After filling in the template, click on “Upload file” to upload your customers and their custom fields on the system. Make sure the file is saved as CSV to upload it successfully.
- After uploading the file, a message will appear confirming that the file has been imported successfully and you will be able to see how many rows have been imported.
- If there are any fields that failed to be imported, they will be shown in the section ‘Failed Rows Details’, so you can edit them and re-upload the file.
- After importing your file, your customers will successfully be imported on the customer’s list page including their custom field/s.
What happens if the list you are importing has duplicate customers?
If the list you are importing has duplicate customers, the duplicate customers will not be imported and they will be listed under Failed Rows Details.
Importing customers by syncing your QuickBooks account
- You can easily import your existing customers to your OctopusPro account by syncing your QuickBooks account.
- To do that: Navigate to Settings > Financial Settings > QuickBooks Integration
- After syncing your QuickBooks account, click on “Pull from QuickBooks”.
- After syncing, your customers will be imported onto OctopusPro and you will be able to see how many customers have been synced and how many have not been synced. You can then view all your synced customers from your customer list page.
Importing customers by syncing your Xero account
- You can easily import your existing customers to your OctopusPro account by syncing your Xero account. To do that: Navigate to Settings > Financial Settings > Xero Integration
- After syncing your Xero account, click on “Pull from Xero”.
- After syncing, your customers will be imported onto OctopusPro and you will be able to see how many customers have been synced and how many have not been synced. You can then view all your synced customers from your customer list page.