Bulk upload ARI

Follow these steps to import Availability, Rates, and Inventory (ARI) data into the Hotel Trader ecosystem. This guide is for:

1. First-time users importing ARI to Hotel Trader
2. Existing users adding ARI for future dates
3. Existing users updating previously loaded ARI through bulk Excel uploads

Step 1: Download the Template

1. Click the Availability, Rates & Inventory icon on the left navigation panel.

   

2. Click on the Manage ARI tab.

   

3. Click Download Template to get the preformatted ARI upload template.

   

Step 2: Fill up the Template

1. Open the downloaded file in Microsoft Excel.
2. Read through the Instructions tab that provides important information on how to fill out the file.
3. This needs to be filled out for each rateplan present on individual tabs in the Excel template as shown below.
   
4. If you choose not to provide ARI for some dates, those rows must be deleted from the file.
5. Save the file as .xls or .xlsx or .csv format.

Step 3: Upload the file

1. Return to the Manage ARI tab on the Availability, Rates & Inventory screen.
2. Drop your file or click on the link to open the file browser and upload your file

   

3. Click the Upload file button and provide your confirmation on the pop-up you are done!

Common causes for upload failure:

1. No data is filled in for a date.
2. Daily Rate and/or Allotment are blanks or 0.
3. Modifications are made to the file structure, like renaming a column or making any edits to the first 6 rows on each tab.

Verify your upload

1. The upload status is updated on the page once the upload is completed.
2. After a successful upload, you can view and manage your ARI from the Manage ARI Tabular View or the Quick view calendar.