This topic describes uploading hotel private rate sets on the Hotel Private Rate Sets page.
| Table of Contents |
|---|
Overview
You can upload up to 5,000 hotel private rates to a hotel private rate set using a comma-separated values (CSV) file that you can create in Microsoft Excel. If hotel search results are set to appear in tabs (as described in Hotel Shopping Display Configuration), the uploaded hotels appear under the Corporate Preferred Hotels tab.
You can define multiple hotel private rate sets. Each set is an uploaded CSV list of hotels with their private rates, codes, restrictions, descriptions, and amenities. A CSV file with actual hotel information, opened in Excel as a worksheet, looks like the following figure (you would scroll the worksheet horizontally to see all columns):
When “-1” is entered into the PREFERENCE_RANKING column, the system will hide the associated property from the hotel search results.
In order to have different hotels and rates for different groups of users, you upload the hotel list, as a CSV file, into a set that can be assigned to one or more groups.
Warning: The uploaded file replaces the existing file — it does not append to it. Therefore, all hotels must be loaded each time you need to change the set. We recommend that you keep historical versions of the file, so that you can restore a previous version if the new version causes errors or fails. If you are adding new hotels, you must add them to the existing list of hotels to upload them.
Tip: For a description of groups, see Groups Tab for Managing Groups.
Navigating to the Hotel Private Rate Sets Page
To view and change a hotel set, or upload a file to use for a set, follow these steps:
- Click the Services tab..
- Click Private Rates. The Private Rates page appears.
- Click the Hotel Private Rate Sets link. The Hotel Private Rate Sets page appears with a list of sets.
Tip: You can also add or change hotel private rate sets after choosing a specific group's set first. Click the Add/Edit Hotel Private Rate Sets link on the Rules page for the group (as described in Enabling Travel Rules). The Hotel Private Rate Sets page appears.
Creating a Set for the First Time
Follow these steps the first time you create a hotel private rate set. If your site is based on a template with an existing hotel private rate set, see "Changing an Existing Set" in this topic.
...
- Column headings highlighted in yellow are required for global distribution system (GDS) properties.
- Column headings highlighted in orange are required for non-GDS properties.
- Column headings highlighted in blue are optional for GDS properties and recommended for non-GDS properties. If you are loading any non-GDS properties, you should always populate all of these fields. You may also populate these fields for GDS properties. This information will appear to the user when booking hotels. For GDS properties, information included in any of these fields will overwrite the Northstar database information.
- Column headings highlighted in gray are for Deem use only.
- The remaining column headings are optional. If you populate data in those fields, they will appear to the user on the Hotel Description Details page.
When “-1” is entered into the PREFERENCE_RANKING column, the system will hide the associated property from the hotel search results.
Several hotel rows are included as examples. You can overwrite the information in these rows to specify different hotels, and add new hotel rows as needed after the existing rows. You can include up to 5,000 hotels.
To see a full description of each field (a.k.a. column heading), Click the Data Field Description tab of the spreadsheet:
| Anchor | ||||
|---|---|---|---|---|
|
...