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.
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.
- Location Code: 3-character code indicating the city/town/locality where the product takes place, e.g. AKL - Auckland, SYD - Sydney.
- Service Code: 2-character code that categorises the product by type, e.g. AC - Accommodation, TR - Transportation, SS - Sightseeing.
- Supplier Code: 6-character Creditor/Supplier code indicating who will be paid for the product, e.g. HERA01 - Heritage Auckland Hotel
- 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:
- Default Currencies are required to set up suppliers and are created in the Code Setup module (see Create a Default Currency).
- Suppliers are created in the Creditors module and are described in this document under Create a Supplier.
- Locations and Service Types are created in the Product module and are described in this document under Create a Product Location and Create a Product Service Type.
- Product Codes are created in the Product Setup module, which is also where product services are set up and assigned to products (see Add Product Detail).
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.
