Plan Availability: ✓ Soho | ✓ Pro | ✓ Plus | ✓ Enterprise | ✓ Flex |
Locate: Reports > Booking Index > Import
- The Import Bookings feature is available to those using items (Inventory > Items), a feature of our classic version of Checkfront.
- Interested in using the Import Bookings feature with products (Inventory > Products)? Your account must be a member of our Early Access Program. Please reach out to Checkfront Technical Support to learn more.
Early Access Program
Find our complete set of help articles related to the Early Access Program here: Early Access Program.
Template DownloadBack to top
Once you arrive at the Booking Import page, you will see a button labelled Download Template. Clicking on this downloads a .csv file containing a sample booking which you can use as a template for your own external bookings.
Once you've downloaded the template, open it up and begin to add your own booking details. You can delete the sample row before saving the document, or simply override its contents with your own information.
Most of the fields are self-explanatory and correspond to the fields you have chosen to show on your booking form at Manage > Layout > Booking Form. There are a few things to note however and we will look at those below.
Item ID:Back to top
This field is critical and corresponds to the item(s) or product(s) included in the booking. The booking cannot be imported without a matching item or product ID. If you take a look at the inventory below, then you will see the IDs highlighted in yellow.
Returning to the .csv file we are editing, you will see the first column is labelled Item ID. This is where you input the ID we just looked at in the inventory.
When entering your information it is important to use the correct formatting on columns such as Date. Date formats can be in MM/DD/YYYY or YYYY/MM/DD. The Date column should also have a time associated with it. If you're not sure of what time the original booking was created, then don't worry just enter the approximate time.
In this case, the booking contains two items: Full Day Kayak and Horseback Adventure. Multiple items must be separated by a space in the ID field. A comma is not acceptable and will prevent the booking from importing correctly.
Checkbox FieldBack to top
In the screenshot above, the custom field labelled Stay up to date... is actually a checkbox field.
On the booking form, a customer must check the box to receive future newsletters from the company they are booking with. When adding bookings via the spreadsheet, this option should be input as either a '0' or a '1'. A '0' means that the option has been left unchecked, while 1 means that the option has been selected.