Skip to main content

Temporary Pricing Rules

Distribution Rules files offer the ability to create a range of rules. In particular, through temporary pricing rules, you will be able to apply commissions or markups for different market conditions.

Create and Upload your Temporary Pricing Rules File​

To get started, create your temporary pricing rules file in the correct format and then upload it to your FTP account. We've provided a template file below ⬇️ to help you with this process. Just click on the file name, add your rules, save it in CSV format, and then upload it to the corresponding folder in your FTP.

sftp.xmltravelgate.com

📁Distribution
     📄Rules_TempPricingRules.csv

File Format Specification​

  • File Name: Rules_TempPricingRules.csv
  • Directory: Distribution
  • Delimiter: Hashtag (#)
  • Data:
    • For All or Specific Agencies (mandatory): Defines if the rule is specific for a list of concret agencies or if it applies to all agencies.
      • 0: All agencies.
      • 1: List of specific agencies, in this case it is mandatory to receive a list of items, a list of agency codes separated with ;(e.g. 1|Agency1;Agency2#).
    • Type of Cancellation Policies (mandatory):
      • 0: All (NRF + RF).
      • 1: Only No refundable (NRF).
      • 2: Only Refundable (RF).
    • Rate Type (mandatory):
      • 0: All (B2C + B2B).
      • 1: Only B2C.
      • 2: Only B2B.
    • For All, Direct, Third Party or Concrete providers (mandatory): Defines if the rule is specific for a list of concrete providers or if it applies to all providers or only to direct or third party providers.
      • 0: All providers.
      • 1: List of concrete providers. In this case it is mandatory to receive a list of items, a list of provider codes separated with ;(e.g. #1|Provider1;Provider2#).
      • 2: Only all Third Party providers.
      • 3: Only all Direct providers.
    • For All or a List of Concrete Hotels (and from countries, cities, chains or destinations) (mandatory): Defines if the rule is specific for a list of concrete hotels (and from countries, cities, chains or destinations) or if it applies to all hotels.
      • 0: All hotels.
      • 1: List of hotels. In this case it is mandatory to receive a list of items, a list of hotel codes separated with ; (e.g. #1|Hotel1;Hotel2#).
      • 2: Hotels from a list of countries. In this case it is mandatory to receive a list of items, a list of country codes separated with ;. In ISO 3166-1 alpha-2 code format (e.g. #2|FR;PT#).
      • 3: Hotels from a list of cities. In this case it is mandatory to receive a list of items, a list of city codes separated with ; (e.g. #3|City1;City2#).
      • 4: Hotels from a list of chains. In this case it is mandatory to receive a list of items, a list of chain codes separated with ; (e.g. #4|Chain1;Chain2#).
      • 5: Hotels from a list of destinations. In this case it is mandatory to receive a list of items, a list of destination codes separated with ;. In ISO 3166-1 alpha-2 code format (e.g. #5|SP;PT#).
      • 6: Hotels from a list of groups of destinations. In this case it is mandatory to receive a list of items, a list of group of destination codes separated with ; (e.g. #6|Group1;Group2#).
    • For All or a List of Concrete Markets (mandatory): Defines if the rule is specific for a list of concrete markets or if it applies to all markets.
      • 0: All markets.
      • 1: List of markets. In this case it is mandatory to receive a list of items, a list of market codes separated with ;(e.g. #1|ES;FR#).
    • For All or Concrete Meal Plans (mandatory): Defines if the rule is specific for a list of concrete meal plans or if it applies to all meal plans.
      • 0: All meal plans.
      • 1: List of meal plans. In this case it is mandatory to receive a list of items, a list of meal plan codes separated with ;(e.g. #1|MealPlan1;MealPlan2#).
    • For Any or Concrete Check-in Dates (mandatory): Defines if the rule is specific for a concrete range of check-in dates or if it applies to any date.
      • 0: All check-in dates.
      • 1: Range of check-in dates. In this case it is mandatory to receive a list of items, a range of check-in dates, from - to, separated with ;(e.g. #1|yyyy-mm-dd;yyyy-mm-dd#).
    • For Any or Concrete Booking Dates (mandatory): Defines if the rule is specific for a concret range of booking dates or if it applies to any date.
      • 0: All booking dates.
      • 1: Range of booking dates. In this case it is mandatory to receive a list of items, a range of booking dates, from - to, separated with ;(e.g. #1|yyyy-mm-dd;yyyy-mm-dd#).
    • For Any or Concrete Range of Prices (mandatory): Defines if the rule is specific for a concret range of prices or if it applies to any price.
      • 0: All prices.
      • 1: Range of prices. In this case it is mandatory to receive a list of items, a range of prices, from - to, separated with ;(e.g. #1|50.5;95.85#).
    • Overriding Rule or Not (mandatory): Defines if the rule is an overriding rule or not.
      • false or 0: It is not an overriding rule.
      • true or 1: It is an overriding rule.
    • Commission/Markup of the Rule (mandatory): Decimal (e.g. 0.5).
    • Description of the Rule (mandatory)
    • Release: Defines the release. A zero value indicates that there is no release applied. By default it is considered 0 if this field does not exist or it is not defined.
    • For Any or Concrete Range of Release from check-in: Defines if the rule is specific for a concret range of days of release from check-in or if it applies to any release.
      • 0: No release. By default if this field does not exist or it is not defined.
      • 1: Range of days of release from check-in. In this case it is mandatory to receive a list of items, a range of dates, from - to, separated with ;(e.g. #1|yyyy-mm-dd;yyyy-mm-dd#).
    • For Any or Concrete Range of Hours: Defines if the rule is specific for a concret range of hours or if it applies to any hour.
      • 0: All hours. By default if this field does not exist or it is not defined.
      • 1: Range of hours. In this case it is mandatory to receive a list of items, a range of hours, from - to, separated with ;. Value has to be set with an integer between 0 and 23 (e.g. #1|15;20# = for three pm to eight pm).
    • For Any or Concrete Days of the Week: Defines if the rule is specific for some day of the week or if it applies to any day.
      • 0: All days. By default if this field does not exist or it is not defined.
      • 1: List of days. In this case it is mandatory to receive a list of items, a list of days. Days from 1 (Monday) to 7 (Sunday)(e.g. #1|1;6;7# = Monday, Saturday and Sunday).
  • Note:
    • The first line is not a header line: it contains data directly.
    • The data of the fields is not encapsulated by " or any other character.
    • Each line represents a room.
    • Any blank line will be skipped.
    • If a field’s data is not mandatory and we don’t want to set it then we just keep it empty: e.g. …##…
    • The file and its data have to be encoded using UTF-8. Otherwise there can be stored strange characters.
📹 Learn how to change the format of the csv file in order to edit and save it
TAKE INTO CONSIDERATION
  • If all the data on the file is correct then the existing definition of Temporary Pricing Rules is removed and file’s data is inserted into the system to define the new Temporary Pricing Rules.
  • If there is any problem with the file or its data then the load is cancelled and the existing definition of Specific Stop Sales is not removed.