Skip to content
Trio Travel guide

Importing hotel prices from Excel

On this page
  1. The template and import route
  2. The six reference columns
  3. Prices validity and offers
  4. Weekdays and gala dinners
  5. Uploading the training example
  6. The result and rejection report
  7. Uploading the corrected row
  8. Checking the saved prices
  9. Matching the amounts and dates

The template and import route

This guide explains how to import hotel prices from Excel, fill all eighteen columns, review the result and correct rejected rows.

Open Hotels in Settings and use Import Hotel Price. Use its adjacent arrow to download Example and Catalogue. This import is for prices; Import Hotels is a separate action for hotel definitions.

1 The template starts with reference columns from hotel_name to currency. Keep the headings unchanged and enter data from row 2.
The template starts with reference columns from hotel_name to currency. Keep the headings unchanged and enter data from row 2.
2 The second group contains cost, selling price, validity dates, offer, promotion and market group.
The second group contains cost, selling price, validity dates, offer, promotion and market group.
3 The final group contains applicable weekdays and New Year and Christmas gala dinner settings.
The final group contains applicable weekdays and New Year and Christmas gala dinner settings.

Save your working copy as xlsx. The catalogue explains the fields and lists reference values; upload the data template rather than the catalogue.

The six reference columns

4 Extract from the corrected example: hotel, room type and room view. These are training values.
Extract from the corrected example: hotel, room type and room view. These are training values.

hotel_name is the existing hotel name from Hotels; room_type is the name from Room Types; room_view is the name from Room Views. All are required. Copy names as listed, rather than their ID or Serial numbers.

5 The nationality, meal and currency values are all, Bed and Breakfast (BB) and EGP.
The nationality, meal and currency values are all, Bed and Breakfast (BB) and EGP.

nationality accepts all for every nationality or an existing nationality name from Nationalities. meal uses the meal plan name from Meal Plans. currency uses the currency short code from Currencies, such as EGP.

Check the Hotels, Room types, Room views, Nationalities, Meal plans and Currencies catalogue sheets. Add any missing reference in its own setting first, then download a refreshed catalogue.

This example uses the full name Bed and Breakfast (BB), rather than BB alone. Catalogue examples are illustrative; use values actually defined for your company.

Prices validity and offers

6 The example uses cost 1800 and selling price 2200, valid from 2026-12-01 to 2026-12-31.
The example uses cost 1800 and selling price 2200, valid from 2026-12-01 to 2026-12-31.

cost is the base cost and price is the base selling price. Both are required. Enter numeric cells without a currency symbol or extra text. Both amounts use the currency specified in currency.

date_from is the start of price validity and date_to is its end. Both are required. Use Excel dates or unambiguous YYYY-MM-DD text, and check that the end is on or after the start.

7 The example has offer turned off, a promotion label identifying example B and an empty market group.
The example has offer turned off, a promotion label identifying example B and an empty market group.

offer specifies whether the price is an offer. Keep its column heading. Use true or 1 to enable it, or false, 0 or blank to disable it. yes/no and on/off are also accepted.

promotion is an optional promotion label. market_group is an existing market group name; check the Market groups sheet. Leave it blank if no group is needed.

Weekdays and gala dinners

8 The example covers all weekdays. New Year gala dinner is disabled and its price is zero.
The example covers all weekdays. New Year gala dinner is disabled and its price is zero.

days specifies English weekday names separated by commas or semicolons. Accepted names are saturday, sunday, monday, tuesday, wednesday, thursday and friday. Blank means every day.

new_year_gala_dinner_is_required specifies whether New Year gala dinner is mandatory. new_year_gala_dinner_price is its price. Both fields are optional; defaults are false and 0.

9 Christmas gala dinner is disabled and its price is zero in the example.
Christmas gala dinner is disabled and its price is zero in the example.

christmas_gala_dinner_is_required specifies whether Christmas gala dinner is mandatory; christmas_gala_dinner_price is its price. Use true/false or 1/0 for the option and a number for the price. yes/no and on/off are also accepted; blanks default to false and 0.

Each row represents a price rule for one hotel and room type, with one meal plan and room view. Use this template for the base price; review child pricing or additional supplements in the prices screen when needed.

Uploading the training example

The file hotel-prices-demo-mixed.xlsx contains two rows. The first uses view A, while the second intentionally names a nonexistent view to demonstrate correction. Cost is 1800 and selling price 2200 EGP, valid from 1 to 31 December 2026.

10 Click Import Hotel Price, select the prepared file and check its filename in the Import window. Choose Yes to start, or No to return.
Click Import Hotel Price, select the prepared file and check its filename in the Import window. Choose Yes to start, or No to return.

Confirm once, then open Background tasks to follow the operation. Wait for its result before uploading again.

The result and rejection report

11 Hotel prices shows one successful row and one rejected row. Click Download details. Completed here does not mean every row was accepted.
Hotel prices shows one successful row and one rejected row. Click Download details. Completed here does not mean every row was accepted.

In the error report, room_view contains DEMO-MISSING-VIEW-20261115 and error shows room view not found.

Correct only the rejected row in a copy of the original eighteen-column template. Replace the view with DEMO-XLS-VIEW-20261115-B and leave the error column out of the upload file.

Check dates and optional values against the original file when preparing the correction. Retain false and 0 as in the example, and keep only one data row in the corrected file.

Uploading the corrected row

12 The corrected file uses the existing view B with the same hotel and room type.
The corrected file uses the existing view B with the same hotel and room type.

Save as hotel-prices-demo-corrected.xlsx. Upload through Import Hotel Price, check the filename and confirm Yes once.

13 The new operation shows 1 succeeded and Completed. The original operation and its partial result remain separately listed.
The new operation shows 1 succeeded and Completed. The original operation and its partial result remain separately listed.

Exclude the previously successful row from the retry. Review the price list once the operation has finished.

Checking the saved prices

Return to Hotels, open the training hotel’s row menu and select Hotels Prices.

14 The hotel price list contains two Accessible Room rows: view B and view A, with all nationalities, the selected meal plan and local currency...
The hotel price list contains two Accessible Room rows: view B and view A, with all nationalities, the selected meal plan and local currency.

Both rows were checked in the screen: cost 1800, selling price 2200, valid from 2026-12-01 to 2026-12-31. Scroll the table horizontally to check the remaining columns.

The first row and the corrected second row are now saved. Check the hotel, room type, view, currency, dates, cost and selling price before using these prices in a booking.

Matching the amounts and dates

15 After scrolling horizontally, both rows show cost 1800, price 2200 and dates 2026-12-01 and 2026-12-31.
After scrolling horizontally, both rows show cost 1800, price 2200 and dates 2026-12-01 and 2026-12-31.

Match these values to the prepared file, then keep the operation result and corrected file for reference.

Sign in to record the lessons you have read. Sign in