Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

(warning)This functionality is currently available via administration panel.

If it needed to apply difficult and more flexible conditions of markups and commissions for different hotels and flights it is possible to use module Markups and commissions settings (switch on in ASP options)

...

To accomplish this you need to upload the following data into the system:

  1. Fill all the necessary data info at Excel file (the file template is provided by the support team at the stage of system implementation) by setting up following categories:

    1. Supplier code;

    2. Hotel code;

    3. Hotel name;

    4. Starting date of the rule;

    5. Rule expiration date;

    6. Hotel location;

    7. Date of stay;

    8. Supplier commission;

    9. Direct sales mark-up;

    10. Agency commission;

    11. Currencies;

    12. and other categories that you can find in the Excel file template.

...

  1. On Clients tab click Sales settings and find Markups and commission settings.

...

2. Click Upload.

...

3. Click Add in the dialog box.

...

Instructions how to fill in the markups and commissions file for flights:

  1. This file contains different rules for markup and commission calculation. Only if all conditions match to the current offer, the corresponding rule will apply.

  2. Empty or "-" cell value means that this condition is not checked. In this case this condition has lower weight as compared with the cell with concrete value.

  3. Commission is always calculated from basic fare (without taxes).

  4. Its possible to use slash (/) for OR logic and expression NOT () to exclude some values (for example, "Everything except LON" can be written as NOT (LON)"

  5. In order to apply several conditions at once, use "&" (for example, "all CIS countires except Russia can be written as "CIS & NOT (Russia)")

  6. It's also possible to specify ranges, like "4001:4999"

  7. For correct calculation it's important to keep current structure of file and order of columns. The lines can be added.

...

The sample you can find in the Excel file template.

View file
nameFlights Setup Sample.xlsx
pageMarkups and commissions settings

Apply commision on cancelled services

There can be different scenarios on applying Agent commission on cancelled services:

  • current logic - when a service is cancelled, the Agent commission is totally removed;

  • new logic - when a service is cancelled, the commission is recalculated from cancellation fees.

With a new version the configuration on this functionality has been added to the settings of groups of contracts and individual contracts with Agencies / Distributors.

...