Import Suppliers

Import Suppliers

InfoThe Supplier import feature lets you create a new Supplier by importing the basic supplier information, using a CSV file template. You can then manually create a Product for the newly imported Supplier.

Suppliers for each supplier type are imported through separate import methods, as the included fields vary slightly between the types.. This means there are separate import templates for Accommodation, activity, transport and Fees & Insurance. More information on Supplier Types can be found in the Supplier loading guidelines help file.

To import suppliers follow these steps:

  1. Access the supplier library by selecting Suppliers in the navigation bar.
  2. From the Import dropdown menu, select one of four supplier types to import:
    • Accommodation
    • Activity
    • Transportation
    • Fees and Insurance
  3. Selecting the supplier type to import opens a window with a download link to the template.
  4. Download the template if you haven’t already done so.
  5. When you click on “Import suppliers” and select any supplier type from the drop-down, clicking on the “Select file” button allows you to attach a CSV file that includes all fields of the supplier.
  6. Imported suppliers will show in the supplier library.

Notes
Note: No suppliers will be added to the supplier library if you attach a file that does not match the format or if the data in that file does not match the format. You can import up to 100 suppliers at once. The Supplier import will duplicate supplier records if the Supplier is already in the your Tourwriter database.

Description of templates

To import Suppliers, you need to populate data in the Import Supplier CSV (Comma Separated Value) file template. The templates can be downloaded from here.

Fields that can be imported include:

  • Supplier Name 
  • Price range (whole number between 0 and 4)
  • Industry rating (number between 0 and 5, with .5 increments)
  • Booking email (email format)
  • Phone
  • Mobile
  • Freephone
  • Other
  • Website (website format)
  • Notes
  • Description
  • Margin type ('net', 'gross', or ;net gross')
  • Default markup/commission (format number)
  • Currency (currency code example USD)
  • Payment Terms (generate due date from) ('days before service date','days after service date','day of month','day of next month' or 'on confirmation')
  • Payment Terms (days) (format number)
  • Payment details (free text)

Importing new season rates to existing suppliers

Once you have imported a supplier and added Products, Options and some rate periods you can create a CSV template and import future rates. For more detail on this review to this help file.

--
If you need help, please contact our Support team via email (support@tourwriter.com) or live chat.

    • Related Articles

    • Can Tourwriter help with uploading Supplier data?

      You can create supplier records and add supplier-level details on mass using the supplier import templates (Suppliers > Import). You can download the appropriate template, input the supplier details and upload the file in a CSV format. Once uploaded ...

    • Creating and managing Suppliers

      Suppliers are the foundation of your account. Tourwriter makes it straightforward to add supplier details, products, rates, and media — so everything you need is ready when you start building a trip. Suppliers Finding and filtering suppliers Go to ...

    • Supplier Import via CSV – Field Requirements & Validation Guide

      This guide explains how to correctly complete the Supplier Import CSV file to ensure successful validation and import into the system. The CSV template includes: Supplier-level fields Product-level fields Option-level fields Some fields are mandatory ...

    • Making Bookings and Emailing Suppliers

      Manage all your supplier communication without leaving Tourwriter. Send booking requests, track confirmations, and update statuses across every service on an itinerary, all from one place. The Bookings tab Go to the Bookings tab on any itinerary to ...

    • How do bulk-update supplier rates?

      Use the Rate Import CSV to add new rate periods for products that are already set up in Tourwriter. For a video and step-by-step guide, please see how to import supplier rates using the CSV export template