Skip to main content
All CollectionsBookings
Import Bookings from Files
Import Bookings from Files
Kate G avatar
Written by Kate G
Updated over 5 months ago

You can batch add bookings from a file into Sion in a three step process:

Note: If Sion is integrated with your GDS, you may not need to upload bookings. More information about how to set up your GDS can be found here.


Upload a File

When you first log into Sion, you’re on the Bookings page. In the top right, click the arrow on the Add Booking button.

Select Import from File in the dropdown.

The Import Data window will open. You can either drag and drop a file into the window or click in the window to upload a file from your device. You can use a TXT, CSV, or TSV file.

Once you’ve selected your file, you’ll be prompted to select the Import Type and enter a File Name for your records of the upload. When you’re done, click Import.

The Apply Mapping page will open.


Map Columns

On the Apply Mappings page, the first section shows you an overview of what columns from your file have been mapped to Sion categories. This data will update as you map columns in the bottom section.

There is also a Reset Mappings button that will remove any Sion categories you have mapped to the file columns.

If you frequently upload bookings from the same source, you can use a Preset to automatically map certain columns to categories. Simply click Select Preset and use an existing template.

Note: You can create new presets at the end of an upload process. Jump to the Review and Confirm section for more information on saving a mapping as a preset.

The second section, Import Settings and Defaults lets you enter basic information for all of the uploaded bookings. The IATA, Agency, and Agent fields provide the default values for imported bookings if a column isn’t mapped for the data. Hover over the question mark (?) icon in order to see more information about any of the fields.

The Column Mappings section is the last one on the page. To the right you can toggle the switch to avoid importing a row of file headers.

For each of the columns you can either select:

  • Don’t Import - This means that none of the information in the column will be imported with the booking.

  • Select a Field- Use the dropdown to find a Sion field that matches the column values. You can scroll to find the field or use the search at the top of the dropdown to find things quicker.

Some columns might be automatically mapped. You should double check to make sure the columns are correct.

In order to move forward with the import, you must at least map the following values:

  • Client Name (First and Last)

  • Supplier

  • Check-In and Check-Out Dates

Once you’ve mapped the required values, you’ll see that the first section has all the requirements check marked.

Click Map Columns in the top right when you’re done.

The Review and Confirm page will open.


Review and Confirm

The Review and Confirm page gives you a change to look over the columns you’ve mapped to Sion categories. To the right you can preview what the new bookings will look like in Sion.

If you’ve made a mistake in your mapping, click Back to Mapping in the top left to make your changes.

If you intend to upload files from the same source often, you may want to create a Preset for the column mappings. This means that the selected columns will automatically map to the indicated Sion categories. Click Yes in the Mapping section to create a Preset for future use.

Enter a name for your preset in the Preset Name field. Your preset is only saved when you complete the booking upload.

Click Create Bookings in the top right to import the bookings into Sion.

Did this answer your question?