Plugin / Import hotels from CSV for affiliates



You must have a Affiliate account in order to import the hotels using this plugin.

This plugin allows you to import easyly hotels from TSV files. Before of that you should have downloaded these hotels datasets from Affiliate area (Downloads > Hotel datasets).

Before use this plugin you have to do:

  • Download hotels TSV files of the cities that you want import hotels from Affiliate Partner Centre > Downloads,
  • Place these tsv files in tsv-import folder located in the plugin folder.
  • Create a draft post or custom type template. (It will be used to create the hotel posts)

This plugin will create posts (of the same type of the post template). The numbers of post will be created may vary depending the hotels to import and languages (if you have WPML installed ).

It is strongly recommended to:

  • edit the TSV files and keep only the cities and hotels you want to import to your wordpress site.
  • create a database backup of your wordpress site.


  • Compatible with wordpress post types (posts/pages) and custom post types.
  • Easy template creation.
  • TSV/CSV cache and hotel indexing for performance
  • Easy to use. Insert Destination city ID, post ID and click validate/import
  • Replacements fields compatible with Visual Composer
  • Import system compatible with WPML
  • Remote Hotel Image URL inside posts or as featured image (Do not need to download hotel images)

Possible customisation

Use these fields inside your post template.

  • {{hotel_id}} => Hotel ID
  • {{hotel_name}} => Property name
  • {{hotel_address}} => Property address
  • {{hotel_zip}} => Post code
  • {{hotel_city_hotel}} => Property city
  • {{hotel_cc1}} => Property country code
  • {{hotel_ufi}} => Unique city identifier (destination id), also known as city_id or dest_id
  • {{hotel_class}} => Star rating of property
  • {{hotel_currencycode}} => The currency in which prices are given for this property (three characters, uppercase – e.g – EUR)
  • {{hotel_minrate}} => The lowest rate charged by the property, calculated on average
  • {{hotel_maxrate}} => The highest rate charged by the property, calculated on average
  • {{hotel_preferred}} => If value is 1, this property is a preferred property
  • {{hotel_public_ranking}} => The rank of the property (higher is better)
  • {{hotel_nr_rooms}} => The total number of rooms at the property
  • {{hotel_longitude}} => Decimal longitude
  • {{hotel_latitude}} => Decimal latitude
  • {{hotel_hotel_url}} => The property URL on
  • {{hotel_photo_url}} => URL for main property photo
  • {{hotel_desc_(language)}} => Short description of property change (language) => en, es, fr … {{hotel_desc_en}}
  • {{hotel_city_unique}} => Unique city name for use in URL
  • {{hotel_city_preferred}} => Preferred name of city for use
  • {{hotel_continent_id}} => sThe unique ID for the continent on which the property is located

The plugin will replace the fields above with the hotel information. For example:

{{hotel_name}} will be replaced with the name of the hotel

{{hotel_hotel_url}} will be replaced with hotel url


The information provided in this THEME/PLUGIN DIRECTORY is made available for information purposes only, and intended to serve as a resource to enable visitors to select a relevant theme or plugin. wpSocket gives no warranty of any kind, express or implied with regard to the information, including without limitation any warranty that the particular theme or plugin that you select is qualified on your situation.

The information in the individual theme or plugin displayed in the Directory is provided by the owners and contributors themselves. wpSocket gives no warranty as to the accuracy of the information and will not be liable to you for any loss or damage suffered by you as a consequence of your reliance on the information.

Links to respective sites are offered to assist in accessing additional information. The links may be outdated or broken. Connect to outside sites at your own risk. The Theme/Plugin Directory does not endorse the content or accuracy of any listing or external website.

While information is made available, no guarantee is given that the details provided are correct, complete or up-to-date.

wpSocket is not related to the theme or plugin, and also not responsible and expressly disclaims all liability for, damages of any kind, arising out of the use, reference to, or reliance on, any information or business listed throughout our site.

Keep Leading Your Followers!
Share it for them.