Step 1 — Export the rate template

1. Go to the supplier's Rates tab.
2. Select the rate lines you want to use as a template.
3. Click Export and save the CSV file.

This gives you a correctly formatted file with the right column headers and existing ProductIDs and OptionIDs already populated.

Step 2 — Prepare the file

Open the CSV in Excel or a spreadsheet application and add or update your rate rows. Before saving, check the following:

Required fields — every row must include a rate period name, start date, end date, net price, and markup. Gross price and commission are calculated automatically and do not need to be entered.
Date format — all dates must be in YYYY-MM-DD format. Any other format will cause an import error.
Days field — leave this blank to apply the rate to the entire period, or enter "Weekend," "Weekday," or a specific day abbreviation (Mon, Tue, Wed, Thu, Fri, Sat, or Sun) to restrict it.
ProductIDs and OptionIDs — these must match records that already exist in Tourwriter. Rates cannot be imported for products or options that do not exist.

Delete any rows with incorrect or incomplete data before importing.

Step 3 — Import the file

1. Go to the supplier's Rates tab.
2. Click Import rates.
3. Select your prepared CSV file.

Tourwriter will validate the file before importing. If any errors are found, the import will not proceed. Review the error dialog, correct the issues in your CSV, and resubmit.

Common import errors

Invalid date format — dates must be YYYY-MM-DD. Formats such as DD/MM/YYYY or MM-DD-YYYY will fail.
Overlapping rate periods — you cannot import rates for a date range that already has rates in Tourwriter.
Missing required fields — every row must have a rate period name, start date, end date, net price, and markup. Rows with any of these missing will cause the import to fail.