Importing clinics from a CSV file
The Import CSV button on Qualiphy → Locations creates clinics and their staff in bulk from one spreadsheet. You see a summary before anything is saved, and running the same file again doesn't create duplicate clinics.
Columns
Download the template from the import window, or use these headers:
| Column | What goes in it |
|---|---|
| external_id | Optional. Your own ID for the clinic, used to match it on later imports. |
| name, city | Required on a clinic row. |
| state | Required on a clinic row: a two-letter US state code, such as TX. |
| Required on a clinic row: the clinic's notification email, where its sale emails go. | |
| address_line1, address_line2, zip, phone | Optional. |
| user_first_name, user_last_name, user_email | A staff member for the clinic. user_email must be a valid email. |
| api_key | The clinic's own Qualiphy API key. Used only when the Locations: Qualiphy API add-on is on; otherwise ignored. |
Headers aren't case-sensitive, extra columns are ignored, and the staff columns can be left off. Without a name, email, city or state column, the upload stops with "Required column missing: …". Save the file as a plain UTF-8 CSV.
Clinics with more than one staff member
A row with a name starts a clinic. Rows directly under it with only the user_ columns filled in add more staff to it. The first staff member listed becomes the clinic's primary contact.
| external_id | name | city | state | user_first_name | user_last_name | user_email | |
|---|---|---|---|---|---|---|---|
| LOC-001 | Westside Med Spa | Austin | TX | [email protected] | Dana | Lee | [email protected] |
| Sam | Ortiz | [email protected] | |||||
| LOC-002 | Harbor Clinic | San Diego | CA | [email protected] | Ari | Chen | [email protected] |
Here Dana becomes Westside's primary contact, Sam joins Westside as staff, and Ari becomes Harbor's primary contact. A staff row with no clinic row above it isn't imported ("Staff row appeared before any clinic row — no clinic to attach to."). Blank rows are skipped.
Re-importing and duplicates
- A row with an external ID matches the existing clinic with that ID.
- A row without one matches a clinic with the same name, address lines, city, state and ZIP, ignoring capital letters and spaces at either end.
- A matched clinic's details are never updated from the file. Its new staff are added and staff already assigned are skipped. Change details on the clinic's edit screen.
- A clinic that already has a primary contact keeps that person.
So re-running a file is safe. Use external IDs if you'll import more than once; without them, a small spelling difference in a name or address creates a second clinic.
The summary and the invite toggle
After you upload, the import window shows a preview of the first rows and the counts: clinics to create, clinics matched, staff to invite and to assign, API keys to import, and staff rows without a clinic above them. Check them, then start the import.
Send Staff Invite Email is on by default. Turn it off to create accounts without emailing anyone yet: "When off, new staff accounts are still created but no invite emails are sent." Send the emails later with Send Invites on the Locations list.
While it runs
Rows import in batches so large files don't time out; keep the tab open until the import finishes. Invite emails are queued and sent in the background, up to 50 per minute, using WordPress's scheduled tasks (WP-Cron). If staff still show "Password not set yet — no invite sent" long afterwards, send their invites with Send Invites. That also takes them out of the queue, so nobody gets two emails.
Clinic API keys in the file
- Each key is tested with Qualiphy as its clinic is imported. A key that passes makes the clinic available to customers straight away.
- A new clinic keeps its key even if the test fails, but stays hidden from customers until the key is verified. The error report says "The clinic's API key was saved but did not pass its test: …".
- An existing clinic without a verified key gets the key only if it passes. Otherwise: "The clinic's API key was not saved: …".
- A clinic's verified key is never replaced by the file.
- Keys show only as stars plus their last 4 characters in the summary and the error report.
The error report
When the import finishes, the summary shows how many rows failed, with a Download error report button. The common reasons:
Related
Still stuck? We're quick to respond.
Email [email protected]. Available 7 days a week, 7 AM to 6 PM PT.