Import your data
Bring your existing customers into Opero from a CSV file, or pull your records from QuickBooks.
You don't have to start from scratch. Opero can import your customers from a CSV file, and pull your records straight from QuickBooks Online.
Import customers from the customer list
Owners, admins, dispatchers and office staff can do this.
- Open Customers, click the ⋯ menu next to New customer and choose Import CSV.
- File: choose your CSV, up to 500 rows and 4 MB. The first row is treated as a header, and every row needs a customer name.
- Map columns: match each column to an Opero field, such as Customer name, Email, Phone, Tags, Last service date and the billing address. Set any column you don't want to Do not import.
- Review: choose what happens When a row matches an existing customer: skip the row (recommended), update the existing customer, or create it anyway. Then click Import. If some rows fail, Download the error report lists them with the reason.
Import from your Get started list
On Get started, the owner can bring lists in with Opero suggesting how your columns line up:
- Bring your customer list in → Upload a spreadsheet.
Drop in the file, check the matches Opero suggests (anything it's unsure of is under Worth a look), then click Import these rows. Nothing is written until you do. Each file can have up to 5,000 rows and be up to 4 MB.
What an import carries over
- Service address: a customer's address becomes their service property, so you can book a job without retyping it. This happens in both customer imports, for customers who don't have a property yet. If a row's address is incomplete, the customer is still imported without one, and the results tell you how many need an address.
- Last service date: map it in either customer import, as YYYY-MM-DD or M/D/YYYY. Opero counts it as the customer's last visit, so customers you haven't served in a while show as lapsed. A date in the future fails that row.
Import service-plan members and recurring jobs
On Get started, under Sell membership plans, add your customers and plans first, then:
- Import existing members puts customers who are already on a plan in your old system onto one of your plans. Each row needs the customer's name, email or phone, the plan name and a start date. The renewal date, billing (monthly, quarterly or annual), monthly price, auto-renew and Bill in Opero are optional. Opero only invoices a member when the row says yes to Bill in Opero, and only from the next billing date on. An imported plan renews a year at a time.
- Import recurring jobs brings in customers you visit on a schedule, from weekly to annual. Each row needs the customer, what the visit is, how often, and the next visit date. Each job becomes a visit schedule on a no-charge plan, so nothing is billed.
Neither import messages your customers. If a customer has more than one property, add a property address column so each row lands on the right one. A property can have only one active plan, so a member row for a property that already has one fails, and the results list it.
Clean up phone numbers and emails before you import. Opero uses them to spot duplicate customers and to reach customers later.
Texting consent
When you import customers from Get started and your file has a column saying which customers agreed to receive texts, Opero only uses it when you tick These customers agreed to receive texts from us. Leave it off and that column is ignored.
Import from QuickBooks
If you use QuickBooks Online, connecting it pulls your customers, items, invoices and payments. See connect QuickBooks for the steps and what syncs.
After the import
Imported customers show up under Customers straight away. Spot-check a few records, then create and schedule a job for one of them to confirm everything looks right.