A UK company Built and supported in the United Kingdom Help in UK hours Hosted sites kept in London

Import data with the Wizard (step by step)

The Import Wizard brings your existing data in safely: upload a file, map the columns, run a non-destructive test, then import. Nothing is written until the final step. Recognised columns by type — Clients: name (required), email, phone, address, cats, home notes. Pets: pet name (required), owner (email or name), species (dog/cat/other), breed, weight, vaccine expiry, medical notes. Services: name (required), module (groomer/walker/sitter), base price, duration, max pets, deposit type (none/fixed/percent), deposit value. Bookings: pet (required), service (required), start date & time (required), client, end, status (pending/confirmed/completed/cancelled), price. Expenses: date (required), amount (required), category (code or name), supplier, tax, notes. Invoices: client (required), description (required), unit price (required), number, quantity, issue date, due date, tax rate, status (draft/sent/paid/overdue/void), category (code or name).

1 Prepare your spreadsheet One row per record and a clear header row (e.g. name, email, phone). Save or export as CSV (comma, semicolon or tab separated). Keep dates in a clear format like 2026-07-15 or 15/07/2026 14:30.
2 Import in dependency order If you are importing several types, do Clients first, then Pets (so owners exist), then Services, then Bookings (so pets and services exist to link to).
3 Open the Wizard ModuleFest Pet Services → Import Wizard. Choose the data type, tick “the first row is a header”, and upload your file.
4 Check the auto-mapping Each field shows the column it will read, with a live sample. Fix any that are wrong using the dropdowns; required fields are marked with a red asterisk. Set anything you don’t want to import to “— ignore —”.
5 Set the options Choose duplicate handling — Create new, Update existing, or Skip (matched by email for clients, name for pets/services, or pet + start time for bookings). For pets/bookings you can also let it create a missing owner as a client.
6 Run the test (dry run) Press “Test import”. Nothing is saved. You get a summary — Ready / Warnings / Errors — and a per-row table with exact messages.
7 Read the results Green “Ready” rows import cleanly. Amber “Warning” rows import but note something (e.g. an optional owner not found). Red “Error” rows will be skipped.
8 Fix any errors Common ones: an unrecognised date, an unknown service or owner, an invalid email, or a missing required field. Edit those rows in your spreadsheet and re-upload, or adjust the mapping and test again.
9 Import When you are happy, press “Import”. Ready and warning rows are written; error rows are skipped.
10 Download the error report If any rows were skipped, download the CSV error report — it lists each row number and exactly what was wrong, so you can correct and re-import just those.
11 Verify Open the calendar or the Clients/Pets lists to confirm everything landed and links look right.

Was this helpful?

Still need help? Sign in to your account and raise a support ticket. The people who wrote the code will help, and most tickets are answered the same working day.

Sign in to raise a ticket