About the Product Database

This User Manual describes the main functions associated with the setup of products in the Tourplan Product database.

The Product database is where details of all types of products (accommodation, transportation, meals, attractions etc.) are stored. It is from this storehouse that users are able to retrieve products to enter into Bookings or Quotations, and the system uses the pricing and setup details that are stored within each product to calculate booking/quote costs, conditions and to produce documentation.

NOTE: In this document, Products, Services and Tariff Items have the same meaning. Similarly, Inventory, Allotments, and Allocations also have the same meaning.

Key Elements

A product is uniquely identified by its product code, which is generated from the four codes below.

NOTE: A Default Currency is also required, to create a supplier. The creation of a default currency is the first task described in this guide.

  1. Location Code: 3-character code indicating the city/town/locality where the product takes place, e.g. AKL - Auckland, SYD - Sydney.
  2. Service Code: 2-character code that categorises the product by type, e.g. AC - Accommodation, TR - Transportation, SS - Sightseeing.
  3. Supplier Code: 6-character Creditor/Supplier code indicating who will be paid for the product, e.g. HERA01 - Heritage Auckland Hotel
  4. Product Code: (up to) 6-character code that "ties" the Location, Service and Supplier codes together to create a Product code; e.g. AKL AC CLAA01 ROH - Run of House Rooms. The Product Code can be common to other products.

These are key elements and are used as key fields when creating a product. The description associated with each key code is displayed, so remembering codes is not essential. Extensive search facilities within the Product Database and Booking/Quoting Modules make locating products easy.

NOTE: The Product Code is not pre-defined, but is a code (which can be common to other products) that "ties" the Location, Service & Supplier together to create a product.

Example: Product AKL AC CLAA01 ROH

Location Code - AKL, Service Code - AC, Supplier Code - CLAA01, Product Code - ROH

Once a default currency and elements 1, 2 and 3 have been defined, a base product (element 4) can be created. After creation, additional detail such as seasonal pricing, conditions and booking parameters can be added and any existing information can be updated or deleted.

Creating Key Elements

How to create these key elements is covered in different places in this guide:

NOTE: Only codes that are essential to the creation of products in the database are discussed here. Features available in the Product Database that are not essential to their creation (such as Amenities, Localities and Destinations) are covered in the System Setup User Manual.