Importing customers, pets and bookings
Bring customers, pets, vaccinations, package balances, gift vouchers and bookings across from any booking system or spreadsheet.
Moving to Wagday from another booking system or a spreadsheet? Settings → Import brings your records across in two parts: Customers and pets first, then Bookings. Only Admins can run an import, and nothing is saved until you approve it.
Get your file ready
Export your customers and pets from your current system as a CSV or Excel (.xlsx) file, with one row per pet. Comma, semicolon and tab separated files all work, and notes that run over several lines are fine. If you're starting from a spreadsheet, use Download template: its column names match Wagday's fields, so every column matches itself.
A file can hold up to 10,000 rows and 1.5 MB. Split a bigger export into several files.
Dates
Dates can be written day first (31/12/2026), year first (2026-12-31) or with the month as a word (31 Dec 2026). Files from US systems often put the month first (12/31/2026). Wagday works out which order your file uses: if any date only makes sense one way, such as 25/03/2026 or 03/25/2026, it reads the whole file that way. If every date could be read either way, such as 03/04/2026, Wagday reads them day first and shows you an example after the check, with a choice to switch to month first. The review step also shows each vaccination's expiry date, so you can see how the dates were read before you approve. The bookings import works out the order the same way.
The four steps
- Upload: choose your file. Wagday reads the column names and suggests a Wagday field for each one. PetManager exports are recognised automatically.
- Match columns: check each column against the Wagday field it should become. Each column shows a few example values from your file, and the fields are grouped (Customer, Emergency contact, Pet, Vaccination, Package balance, Gift voucher, Past booking). Leave anything you don't need as Don't import this column.
- Check: Wagday checks every row and lists any problems by row and column, with a count per column. Fix them in your file and upload it again, or choose Skip (for example Skip 3 rows and import the other 97) to bring in everything else now and the skipped rows later. Download problems as CSV gives you the full list to work through.
- Review and import: see how many customers, pets, bookings and other records will be created, any values Wagday has to fill in, and a sample of rows. Approve to start the import. It runs in the background, and you can leave the page and come back.
What each import brings across
Leave a column unmatched, or a cell blank, and nothing changes.
- Customers: name, email (required), phone, street address, suburb, state and postcode, and an emergency contact's name, phone, email and relationship. A customer already in Wagday (matched by email) keeps their details. Tick Fill in missing details for customers already in Wagday to fill their blank address and emergency contact fields; anything already there is never changed.
- Pets: name (required), breed, birth date, sex, desexed, notes, microchip number (15 digits; spaces and dashes are fine), weight in kilograms, colour, and vet clinic name and phone. A filled cell updates an existing pet; a blank cell never clears what's there. A microchip already on another pet stops that row with a message naming the number. A new pet needs a birth date and sex: without them it's recorded as born 1 January 2015 and male, and the review step tells you how many pets that applies to.
- Vaccinations: one vaccination per row, with its name, the date it was given and its expiry date. For more vaccinations, repeat the customer and pet on another row. Combination names such as C5, C3 or F3 count towards every vaccination they cover. A vaccination the pet already has, with the same name and dates, isn't added twice.
- Package balances: the package name and the passes remaining, plus an optional expiry date. Create each package under Packages first, with the same name; the import matches it by name. The balance comes across without a payment, so redeeming it records no new revenue. Importing the same customer again, or one who already has a free balance of that package, leaves that balance untouched.
- Gift vouchers: the voucher code and its remaining dollar balance, plus an optional expiry date. Each becomes a single-use voucher code for that amount, which the customer enters at checkout. A voucher comes off one booking or order, and anything left over is not carried forward, so tell customers with a large balance to use it on a booking of at least that value. A code Wagday already has is left as it is. For an account credit with no code, give it one in the file (for example
CREDIT-SMITH) and let the customer know.
Bookings
Import bookings after your customers and pets, from Import → Bookings. Each row is matched to an existing customer, pet, service and location, with start and finish times, and the preview shows every row's outcome before anything is created. Importing bookings doesn't message your customers.
The customers and pets import can also carry past bookings, which are recorded at your first location from 9am to 5pm. Use the Bookings import for anything upcoming.
Reading the result
When an import finishes you'll see how many rows were imported, skipped and had errors, and a row report naming each row that didn't import and why. Download row report saves it as a CSV.
Recent imports lists your last 15. Choose Continue on one you haven't finished to pick up where you left off, or open it and choose Discard upload to remove a file you don't need. Uploads are kept for 30 days.
Undoing an import
If a customers and pets import went wrong, choose Undo this import on its result or in Recent imports. Undo removes everything that import added: customers, pets, vaccinations, package balances, gift vouchers and past bookings. Customers and pets that were already in Wagday stay, along with any details the import filled in for them.
Undo is all or nothing. If anything the import added has been used since, such as a booking, payment, invoice, message or note, nothing is removed and Wagday tells you which records are in use. Bookings imported from Settings → Import → Bookings aren't covered.
Tips for a clean import
- Upload a fresh export unchanged where you can; editing column names can stop them matching.
- Use the same email for a customer on every row, so their pets end up on one customer.
- Check the counts on the review step against what you expect before you approve.
What's next?
- Get set up end to end: Getting started
- Start taking bookings from your own site: Taking bookings from your own website