This guide is for course providers who want to bring bookings into Cademy from a spreadsheet, for example bookings taken in another system.
An order is Cademy’s record of a booking: who booked, which course and course date, how many spaces, the cost and whether it is paid. A registration is one person’s place on a course, and a contact is a person saved in your Cademy account. A course date is a date on which a course runs; an on-demand course has none.
If you only need to put learners on a course and do not need a cost or payment record, use the Registrations import instead: see Add Learners to Courses in Bulk (Import Registrations). If you are not sure which import you need, start with Import Your Data from a Spreadsheet (CSV or Excel).
Bring Existing Bookings from Another System (What the Orders Import Does)
Each new booking row creates one order for one course. The contact in the row is the person who booked and the person attending.
An on-demand course has no course dates, so its rows need none. Every other course needs a course date that already exists in Cademy.
The import creates new orders and leaves existing orders unchanged. It skips a row when a matching order is in the Pending or Active Status Group. A match uses the same existing contact, course and course date, or the same External Order Ref. On-demand courses have no course date. Draft, Cancelled and deleted orders do not count as matches.
Rows that match an existing order, and duplicate booking rows in the file, appear as Unchanged in the check; they are skipped rather than failed. A skipped row changes neither the existing order nor its contact. A registration on its own does not trigger this order-matching check. Rows without a usable matching identifier can still create another order, so review the check before retrying a file.
The check warns when the new orders would overbook a course date. That warning does not block the import. Review the remaining spaces before starting; the import can create orders beyond the date’s capacity.
It does not apply Registration Rules. Before importing, check that the people in the file meet the rules for the course or date they are booked onto, including any earlier training or organisation limit. See Control Who Can Book a Course With Registration Rules.
A row cannot hold guest names, more than one course, add-ons, discounts or vouchers.
Cademy records the amounts you import. It does not take a payment, and it does not work out tax or fees from the course price.
An import cannot be undone or cancelled once it has started. To remove a test or duplicate order afterwards, see Delete Test or Duplicate Orders and Registrations, which explains which orders can be deleted.
Can a Bookings Import Keep the Date the Booking Was Made?
No. Created date is listed on the mapping screen but is not used: every order gets the time of the import as its created date. For learner records without an order, the Registrations import has its own Created date field: see Add Learners to Courses in Bulk (Import Registrations).
What Each Imported Booking Row Creates (Paid, Unpaid or Awaiting Approval)
A paid row is saved with the whole cost as paid. The person has their place on the course straight away.
For a cost above 0, an awaiting_payment or overdue row is saved as an invoice order with nothing paid. The person’s place stays pending until the order is paid, unless Allow Course Access Before Invoice Is Paid is switched on in your invoice settings under Settings > Payments. A zero-cost row is recorded as paid, including when the row supplies awaiting_payment or overdue. Use costs of 0 or more in your file; correct negative amounts before importing.
If the course is set to require approval of its bookings, the order starts as awaiting approval, also when it is paid. The person’s place stays pending until the order is approved.
Does Importing Bookings Email Customers? (Send Confirmation)
Send Confirmation decides whether the person in a row is emailed about the order when the row is imported. For courses that do not require booking approval, with yes, true or 1:
A paid row sends the order confirmation. A zero-cost row is treated as paid and also gets a confirmation if Send Confirmation is on.
An awaiting_payment row with a cost above 0 sends an email that asks for payment. If course access before payment is switched on, the order confirmation is sent too.
An overdue row with a cost above 0 sends no email when it is imported.
With no, false, 0, a blank cell or the field on Do not import, none of these emails is sent.
Send Confirmation does not control emails that Cademy sends for other reasons, such as these:
If the course requires booking approval, Cademy sends the waiting-for-approval email instead, even when Send Confirmation is off.
Lesson notifications follow the course’s lesson schedule: see Release Lessons Over Time and Set Due Dates.
If the course has reminder emails set up, Cademy sends them before a course date to everyone who has a place on it, including people you imported. A pending place gets none. See Set Up Automatic Confirmation and Reminder Emails.
When an unpaid order’s invoice passes its due date, Cademy emails the person and your team if Overdue Payments Reminder Emails is on under Settings > Payments.
When a row is imported, Cademy does not email your team about the new order.
After you have imported an order or course place, customers and learners must log in with the email address linked to that imported record. Share Log In to See Your Courses and Bookings for the steps. An import of contacts alone does not give someone a course place.
Before You Import Bookings: Roles, Row Limits and Checks
The Orders import is available on every Cademy plan. You need the System Admin role to run it, whether from Settings > Imports or a course’s Orders tab, and to open imported orders afterwards.
Your plan limits the rows in one file: up to 1,000 on the Free, Starter and Pro plans, no limit on Teams, and a limit set for your account on Enterprise. A file with too many rows is refused at upload with a message that starts You cannot import more than. Split the rows over several files.
Check these points before you import:
Every course in the file must already exist in Cademy. For every course that is not on-demand, the course date must exist too. The import does not create courses or course dates. To add many at once, see Import a List of Courses from a CSV or Excel File and Import Course Dates (Classes and Sessions) from a Spreadsheet.
Import a file with one or two rows first and check those orders before you import the rest.
Prepare Your Bookings Spreadsheet (CSV or Excel)
Save the file as CSV or Excel. In an Excel file, Cademy reads the first sheet only. Put the column headings in the first row. Each row below it is one order.
The import window has a View example file link. It opens this example spreadsheet: orders import example file. Its column Total Paid is not chosen for you, because the Cademy field is named Total Paid / Cost: choose the column by hand, or rename the heading. To start from the example, copy it into a file of your own.
Contact Columns for the Booker in a Bookings Spreadsheet
Each row needs at least one detail of the person who booked. Include Email, First Name and Last Name. Cademy finds a contact you already have by email address, or by Cademy ID (the part of the contact page’s address after /contacts/) if you map it and leave Update existing Contact on. Otherwise it creates a new contact, so a row with no email address and no Cademy ID creates a new contact every time. A row with an email address that is not valid fails.
You can add columns for other contact fields, such as Phone, Tags or contact fields you have added yourself. Import Customers and Learners (Contacts) from a Spreadsheet lists the contact fields.
If you map Marketing Consent, supply each contact’s choice. Use Yes, true or 1 to record consent, and No, false or 0 to record no consent. In Excel, enter these values as text, for example Yes or No.
Columns for the Order: Course, Date, Cost and Payment Status
Only Course is marked as required on the mapping screen. Course Date is not marked, but every course that is not on-demand needs it.
Course - the course the order is for: its name, its Cademy course ID (the part of the course page’s address after /courses/ or /courses/edit/, up to the next /) or its course code. Use the same kind of value in every row, exactly as in Cademy, including capital letters and spaces. If two courses have the same name, Cademy picks one of them, so use the ID or the code for those. In an Excel file, a name or code made only of digits, such as 101, must be in a cell formatted as Text, or the course is not found.
Course Date - the day, or the day and time, the course date starts. Leave it blank for an on-demand course. “How the Bookings Import Matches Course Dates” below explains the formats.
Currency - one of these codes: GBP, USD, EUR, AUD, CAD, NZD, ZAR or MYR. If the cell is blank or holds anything else, Cademy uses the selected course date’s currency. If that date has no currency of its own, or the course is on-demand, it uses the course’s currency.
External Order Ref - a reference from another system. Cademy saves it on the order and uses it to skip a matching Pending or Active order. Use a unique reference for each order: a matching reference can skip the row even if its contact, course or date is different. It does not join rows into one order.
Payment Status - paid, awaiting_payment or overdue, spelled exactly like this. Capital letters do not matter. If the cell is blank, the order is saved as paid. A row with cancelled fails with Rows with payment_status = "cancelled" cannot be imported; create the booking and cancel it afterwards.
Secondary invoice ref - an invoice reference of your own. Cademy saves it as the order’s invoice reference.
Send Confirmation - yes, true or 1 to email the person. “Does Importing Bookings Email Customers?” above explains which email is sent.
Spaces - the number of places on the order, as a whole number. If the cell is blank, the order has 1 space. Only the contact in the row is registered. Extra spaces have no names.
Total Paid / Cost - the total for the whole order, not the price of one space, as a plain number such as 120 or 120.50. If the cell is blank, the cost is 0.
For example, if the course uses GBP and the selected date uses EUR, a blank Currency creates an EUR order, so enter the cost in euros: Cademy does not convert amounts. Entering GBP for that date fails the row. See Choose the Currency for Your Course Prices.
Why an Imported Order Shows a Cost of 0 or a Paid Status
Important: for file-column values in these fields, an unreadable value can use a default. A cost with a currency symbol or a comma, such as £120 or 1,200 in a CSV file, becomes 0 and paid. An unrecognised payment status such as unpaid becomes paid. Spaces that are not a number above 0 become 1. Sample Data shows the file’s values, not the final saved costs or payment states. Expand the order totals in the check and review them before importing, then check a few saved orders afterwards.
For Fixed value, enter a number of 0 or more for Total Paid / Cost or Spaces. The check refuses a negative fixed value. If that happens, select Back, correct the value and select Check Import again. A Spaces value of 0 is treated as 1.
The import cannot change an order afterwards. If orders were already saved with a wrong cost or payment status, contact Cademy Support with their IDs, which the Imported Orders (unified) list shows (see “Check Which Booking Rows Imported or Failed” below).
How the Bookings Import Matches Course Dates
Use the start of the course date in Course Date. Cademy uses the day and, where supplied, the time to find the course date.
With a format that has only a day, such as D/M/YYYY, Cademy looks for a course date that starts on that day. If the course has more than one course date starting that day, include the exact start time. A date without a time can match a different date on the same day.
With a format that has a day and a time, such as D/M/YYYY HH:mm, the time must be exactly the start time of the course date.
For a date written as text, choose a format that matches the day, month, year and any time in the cell.
Cademy reads the day and time in your account’s time zone.
Cademy suggests a format from the sample dates. Beside the date format under File Column, Reads as shows how Cademy reads the first filled sample. Check the day, month, year and time. If any filled sample can’t be read, a warning appears instead. Select the matching format or correct the dates in your file and upload it again. The preview checks only the sample. A row with a filled date cell that Cademy cannot read fails.
You can use Excel date cells in Course Date. Include the exact start time if you need to identify one of several dates on the same day.
If your file has letters with accents or symbols such as é or £, upload an Excel file. A CSV file can be read with these characters wrong, for example Zoë as Zoë, and a course name with one is then not found.
Run the Orders Import: Upload the File and Map Contacts
Open the Orders Import (Settings > Imports)
In the Cademy admin dashboard, select Settings in the main menu.
In the Settings menu, under Tools, select Imports.
Select the Orders card. The Import Orders window opens. The top of the window names its three steps: Select file, Map Contacts and Map Orders.
If you cannot see Imports or its Orders card, ask a System Admin on your account to run the import. Course Owners can open Imports but do not have the Orders import.
A System Admin can also start the import from a course’s Orders tab: select Import. Course is then already set on the Map Orders step, and Course Date too if you are viewing one course date.
Upload Your Bookings File
Drag your file onto the area marked Drop or Select a file, or select Select file and choose it. Upload one file at a time.
Wait while Cademy reads the file. The window then moves to the Map Contacts step by itself and shows the heading Configure your import.
If Cademy shows The uploaded file appears to be empty, check that the first sheet has a row of headings and at least one row below it, then upload the file again.
Map Contact Columns in the Bookings Import
The screen lists the contact fields in a table with the columns Cademy Field, Value Source, File Column and Sample Data.
Find Email. If Cademy has not matched it to a column, set Value Source to CSV column and choose the column that holds the email addresses under File Column. Sample Data shows values from the first five rows, so you can confirm the choice.
Set First Name, Last Name and every other contact field you want to import in the same way. Leave the rest on Do not import.
Select Continue.
Map at least one contact field. The window lets you continue with none, but then every row fails with Missing student data, as does any row with no value in the contact columns you mapped.
Leave Organisation on Do not import. The Orders import does not use it to set the organisation of the person or the order, and mapping it can create new organisations when Create organisations when auto-linking is on. Marketing Consent also needs care: the next section explains why.
Choose Whether the Bookings Import Updates Existing Contacts
The next screen starts with We will attempt to import and has one switch, Update existing Contact. The switch is on to begin with. It decides what happens when a row’s email address belongs to a contact you already have. It never changes orders.
On: for a row that creates a new order, Cademy writes the mapped values over the matching contact’s saved details. A row skipped because its order already matches leaves the contact unchanged.
Off: Cademy leaves the contact’s details as they are. Only tags from the file are added.
Either way, the new order belongs to that contact. A row whose email address no contact has creates a new contact. Import Customers and Learners (Contacts) from a Spreadsheet explains what an update changes, including addresses.
With Update existing Contact on, a supplied Marketing Consent value updates the matching contact’s choice. Use Yes, true or 1 to record consent, and No, false or 0 to record no consent. In Excel, enter these values as text, for example Yes or No. A blank cell or Do not import keeps an existing contact’s saved choice when you update their details.
Select Continue. The Map Orders step opens.
Map the Order Details and Start the Import
The Map Orders step has the same table, for the ten order fields described in “Columns for the Order: Course, Date, Cost and Payment Status” above. Course is marked REQUIRED. Until it is mapped, a box named Incomplete mappings is shown and Check Import cannot be selected.
The mapping picture below uses a separate two-row, on-demand booking file. The later check picture uses a five-row file for scheduled bookings.
Map Course. A second list appears in File Column: choose Course Name, Cademy Course ID or Course Code to say what your column holds. Check the second list after choosing or changing the column. If every row is for the same course, set Value Source to Fixed value and choose the course.
When you map Course Date from a CSV column, check Reads as beside the date format in File Column. If you see a warning, select the matching format or correct the spreadsheet and upload it again. If every row is for the same course date, use Fixed value. Once you choose a fixed course, you can pick one of its course dates.
Map Total Paid / Cost, Payment Status, Spaces, Currency and Send Confirmation if your file has them. For Send Confirmation, Fixed value shows a switch: turn it on to send the applicable email for each new order. Skipped rows send no new order email. Review the recipients in the check.
Check Sample Data for every field you mapped. Check each participant’s eligibility for their booked date or course before starting: the import does not validate Registration Rules.
Select Check Import. Review the expected counts and any row problems, order totals, confirmation emails and payment requests. Expand the recipient lists to check their addresses. Then select Import; Cademy shows Import started and the window changes to Processing Import.
The check shows how many orders it expects to mark New, Updated, Unchanged or Failed. Nothing has been imported yet. Read any row problems under Row, Column and Problem, and expand any duplicate or existing-record matches. The payment and email details help you check costs and recipients before starting. These are expected results for the file and your choices; check the actual results after importing.
Import is unavailable while the check runs or if the check could not finish, the file is over its import limit, or every row has a problem. For a failed check, read the message and select Try Again after resolving it. If you see Every row has a problem. Fix the file and try again., correct the file and upload it again. Some failed rows do not block the whole import, so review them before starting. Check a Spreadsheet Before Starting Its Import explains the shared check.
Select Back from the check to return to Map Orders; those mappings are kept. After changing them, select Check Import and review the result again. Going farther back through the contact steps can reset later choices, so check those screens again. To replace the spreadsheet, close the window and start a fresh import with the corrected file.
Check Which Booking Rows Imported or Failed
You can close the window: Cademy carries on. When it has finished, the window shows Import Complete with the number of orders imported and of failed rows.
To check an import afterwards, open Settings > Imports and find it in Your Imports. The newest import is the top row, and an Orders import has the type Orders (unified), which the TYPE column can cut short. Read IMPORTED, FAILED and STATUS in that row.
STATUS shows PROCESSING while Cademy works through the file and PROCESSED when it has finished. PROCESSED does not mean that every row succeeded, so always check FAILED.
Failed under Status means the whole run stopped. Read the saved reason beneath it when one is shown. Before uploading again, check on the Orders page whether any orders were created. If the run stays at Processing with no email, contact Cademy Support with the import’s type, date and time from Your Imports.
IMPORTED is the number of rows that created an order. Select it to open Imported Orders (unified), with each order’s course, the person’s name and email address, and the order’s ID.
FAILED is the number of rows that could not be imported because of a problem. Rows skipped because they match an existing order or duplicate another row are not failed rows.
A Processed Orders run with 0 imported and 0 failed can mean all its rows were skipped as matches or duplicates. Check the existing orders on Orders before retrying.
To see which rows failed and why, open the result email sent to the user who started the import when it finishes, if import-result emails are enabled for them and they still have account access. Its subject is “Cademy: 25 orders imported”, with your number. For failed rows it has a table with your file’s columns and an Error column.
Why a Booking Import Row Fails: Error Messages and Fixes
These are common messages in the Error column of the import email and what to check. Correct the failed rows and import only those rows again. Matching orders are skipped, but a row without a usable matching identifier can still create another order. Review the expected results before retrying.
If the reason says “Couldn’t read” followed by a value, field and format, correct the date in your file or select its matching format before re-importing.
Course with … not found. No course in your account has exactly that name, ID or code. Check the spelling, capital letters, spaces at the start or end of the cell, and your choice in the second list for Course.
The required field "Course" needs a value for this record. The Course cell is blank.
Could not find a matching course date for this row. Add a valid "Course Date" column and re-upload. Cademy found no course date at the day or time it read. Check the format you chose, the time, and that the course date exists.
Course date does not match the course. Cademy found a course date at that day or time, but it belongs to another course.
This row is in …, but the course date is priced in …. For example, the row is in GBP and the date in EUR. Check that you chose the intended date, then correct the row’s currency and cost. Do not change a booked date’s currency just to force an import through.
Error mapping contact data, Error mapping order data or Error importing unified order. Cademy could not read or save the row. Check that the email address is valid. If it is and the row fails again, contact Cademy Support with the row and the message.
Frequently Asked Questions
Can I import bookings for an on-demand course?
Yes. Map Course and leave Course Date on Do not import, or blank in those rows.
