Import or invite many customers at once
Press Import in Customers to bring in a spreadsheet or a CRM export. You see what every row will do before anything is saved. To invite customers to their portal, tick them in the list and press Invite…. The invitations go out from your own domain while you get on with something else.
Bringing a whole book of clients over? Import them from a spreadsheet, see what each row will do before anything is saved, then invite them to their portal in one go.
Import a spreadsheet
Open Customers and press Import.
Choose your file: an Excel workbook (.xlsx), a CSV, a tab-separated file or a CRM export, up to 25 MB. Or paste cells copied straight from your spreadsheet. Download the columns gives you a file with every heading it reads, ready to fill in.
Check the columns. They're matched by their headings, in the words people use (Business name for Company, Mobile for Phone). Tap a column's name to set it yourself.
If the file doesn't say how a new customer will use the platform, choose Self-serve or Managed campaigns for them.
Leave Email each new customer an invite to sign in ticked to invite them as they're added. Off, nobody is emailed, and you can invite them later.
Read the preview. Each row says what importing it does, and its result: New, Brought back, Updated, No change or Left out. Tap a result above the rows to see only those.
Press Import with the number, such as Import 240 customers. Keep the window open until it finishes.
It ends on Import finished, with what it did: Added 238 customers, brought back 1 and updated 4.
Rows that didn't import are listed with the reason. Download them gives you those rows in a file: put them right and import that file.
Importing the same file twice changes nothing the second time. If an import stops part way, import the file again to finish it.
What a file can hold
| Column | What it does |
|---|---|
| Finds the customer the row is about. With no email, a company name only one of your customers has. | |
| First name, Last name | A new customer needs both, and an email. A single name column is split in two. |
| Company, Phone, Address | The customer's details |
| Your word for a branch | Puts the customer in that branch. A branch you don't have yet is added, if you can set up branches. none takes them out of their branch. |
| Account manager, Backup, Production | Their account team, by email or full name. Production can also be a pool. none takes the place off their team. |
| Access | Managed or Self-serve |
A customer you'd archived comes back with their data, as Brought back. A row that asks for something that can't be done is left out whole, so nothing is ever half done.
Up to 5,000 customers a file. Split a bigger list into files of 5,000 or fewer.
A Numbers file can't be read: in Numbers, choose File › Export To › Excel, then choose that file. An OpenDocument sheet or an old binary .xls file: save it as an Excel workbook (.xlsx) or a CSV first.
Owners can import, and managers who look after every customer or a set of branches. A manager who looks after only their own customers adds them one at a time: Add a customer.
Invite many customers to their portal
In Customers, tick the customers you want to invite. On a computer or a tablet, a bar opens at the foot of the list.
To take everyone the list shows, tick them all on screen, then press Select all with the number. It takes up to 10,000.
Press Invite….
Press Send invitations.
Owners, managers and account managers can invite, for the customers they can change. Each one gets an email from your own domain, with a link to set up their sign-in. The link works for 7 days.
Left out: anyone already signed in, invited in the last day, archived, or with no email.
You can leave the page: the invitations keep going. A banner above the list follows them, such as 312 of 1,240 done and About 4 minutes to go, with Stop. When it's finished, it says how many were invited and who was left out. Owners and managers see every run on the team, with who started it.
Invitations go out from your own domain, so Invite… shows once it's set up. Customers you import or add before then are still added, with no invite: once your domain is set up, tick them and press Invite….
The same bar changes the ticked customers in one go: Account manager…, Production… and Move… to another branch. Clear unticks them.