B Bookare Helpbookare.app →

Using Bookare · Gyms and studios

Moving from another system

Bring your members, their packs, bookings, class history and check-ins over from your old system or spreadsheet, without emailing anyone.

If you already run your studio with another booking system, or with a spreadsheet, you do not have to start from zero. You can bring over your members, the packs they hold (with classes left and expiry dates), their bookings and class history, and past check-ins. Members keep their history and their remaining classes, and you start the next day as if nothing changed.

Nothing is emailed to anyone while you do this, and you can safely run the same file again: nothing is written twice.

You find it under Settings → Data import. Only admins can see it, and only for venues with classes.

Before you start

Set up your venue first, so the imported data has somewhere to go:

  1. Your class types and instructors. Use the same class names as in your old system, so bookings can find them.
  2. Your packs on sale.
  3. Your weekly timetable. Upcoming bookings can only be brought over to classes that are already on the calendar.

What you need: files from your old system

Each step takes one file, in the CSV format that every spreadsheet can save. In Excel: Save as → CSV. Google Sheets and other spreadsheets can download a sheet as CSV too.

Each step has a Download the template link: a ready file with the right column names and one example row. The easiest way is to download the template, paste your data under the right columns, and save.

  • The first row must hold the column names, as in the template. Columns Bookare does not use are listed and skipped.
  • Dates can be written as 2025-03-18 or 18/03/2025.
  • Yes/no columns accept yes or no.
  • Leave out what you do not have.
  • Fill in the external_id columns with the codes from your old system. This is what lets you run a file again safely.

The four steps, in order

Go from top to bottom. Each step can find what the previous one brought over.

1. Members

All members, including former ones, with the date they joined.

Column What to put
external_id The member’s code in the old system. Strongly recommended: packs and bookings use it to find the member.
name Full name (required).
email · phone One of the two, or the external_id.
street · city · postal_code Address, optional.
joined The date they joined.
status active (the default), disabled for former members, or pending.
wants_news yes only if they had agreed to receive offers and news.
groups Group names, separated by a vertical bar, e.g. Morning group|Students. Missing groups are created.

A member whose email already exists in Bookare is left as it is and counted as “already there”.

Members who joined in the last 90 days count towards your plan’s member limit. Former members and long-time members do not. See Plans and billing.

2. Members’ packs

The packs that are running now, with their end date and the classes already used. Old ones too, if you want them in the history.

Column What to put
member_external_id · member_email Which member (one of the two).
name The pack’s name.
classes · unlimited How many classes it had in total, or unlimited = yes.
classes_used How many were used, including those already booked for the coming days.
starts · expires Start date and last valid day.
price_eur · paid · paid_on · method The price, whether it was paid, when, and how (cash, card or iris).
off_peak_only yes if it is for off-peak hours only.

Give each pack an external_id too, so bookings can point to it.

3. Bookings and history

Upcoming bookings, and past ones with attendance.

Column What to put
member_external_id · member_email · guest_name Which member, or a guest’s name.
date · time · class_type The day, the time and the class name, written exactly as on your Classes page.
status attended (the default for past classes), no_show, booked (the default for upcoming), cancelled or late_cancel.
pack_external_id Which pack it was booked with. If missing, the pack that covered that day is used.
free · trial yes for a free or a trial class.

Past classes that are not on your calendar are created for you, so the history is complete. Upcoming classes must already be on the timetable.

Bringing over bookings never takes classes from packs again. The classes_used number from step 2 already counts them. The booking is still linked to the pack, so if a member cancels an upcoming one in time, the class goes back to their pack as usual.

4. Check-ins

This step appears only if you have a drop-in class type (no fixed times, check-in only, such as the gym floor). It brings over past visits, one per member and day, with the member, class, date and time. No pack is charged again.

Running a step

  1. Press Choose file and pick your CSV file. Bookare shows how many rows it found.
  2. Press Import.
  3. Wait while it works through the file. A large file takes a little while; keep the page open.
  4. Read the result, e.g. “Done. 212 new · 3 already there · 2 with errors”.

Rows with an error are listed with their line number in the file and the reason, for example a member who could not be found. Fix those lines and run the same file again: rows that were already brought over are skipped, so nothing is written twice.

A Pilates studio in Chalandri moves over on a Sunday. The owner exports her members, active packs and the next two weeks of bookings from her old system into three files, and adds the old member codes in the external_id columns. She imports members (184 new), then packs (97 new), then bookings (305 new, 4 errors: a class name was spelled differently). She renames the class in the file, imports the bookings file again (301 already there, 4 new), and opens on Monday. Nobody got an email.

After the move

  • Tell your members about the new booking page. They sign in with the same email they had in your old system and find their pack, classes left and bookings waiting for them.
  • Check a few members’ pages to see that packs and classes left look right.
  • Members did not get any email during the move, so a short message (News) to everyone is a good way to announce it.

If your old data is messy, your AI assistant can do the move for you. Give it your old export, even an untidy one, and say:

“Bring over the members, their packs and the bookings from this file. Don’t email anyone.”

“How much have we brought over so far?”

It follows the same order and rules as this page, a hundred rows at a time, and tells you what it created and what it skipped.

Ideas

  • Do a test with ten members first. Look at their pages, then run the full files.
  • Move on a quiet day, after the last class, so no new bookings are made in the old system while you work.
  • Use the groups column to bring over your existing teams, such as “Morning group” or “Students”.