save result as
upload a list
match my list
save result as
A: Select mapping matching options, above.
click on above tabs and build your criterias list to be maped in your result.
B: select files
Follow the CSV fields instruction below and have the appropriate fields set before uploading your listing.
C: choose output
Click on your result file format (CSV, JSON evo or full).
E: launch mapper
Launch the mapping. wait for the download link to be returned or check your email.
The mapper statut (above central panel) will keep you informed about what is going on.
Time vary according to the number of asynchronous threads selected in the "power user"=> "endpoint"=> "this web page" tab. default is 6.
if you have room descriptions with policies and offer specifications already inside the description, they will be parsed as well, No need for suppliers API data, or availabilty request API data.
using supplier s data:
you can overimpose data from suppliers inside the mapping process.
In your xls (csv) file, The first table line is used for the fields names (in lowercase).
Your csv file must be saved comma separated
column A: hid the hotel id: can be empty, it can be any, yours or suppliersoptional
column B: supplier supplier s code: can be empty, it can be anyoptional
column C: rcode1 room code 1: can be empty, it can be anyoptional
column D: rcode2 room code 2: can be empty, it can be anyoptional
column E: amount room amount can be empty, number or decimaloptional
column F: name room name: must be with a description as text, any kindmandatory
column G: cancel cancel policy: can be empty, true or falseoptionalnew
column H: refund refund policy: can be empty, true or falseoptionalnew
column I: fees fees policy: can be empty, true or falseoptionalnew
column J: board board meal: can be empty or a stringoptionalnew
An easy mapping using supplier API policies
surimpose policies like "supportcancelation" boleans from suppliers API.
By setting the last 4 fields, you can surimpose API data over what s in the description. This is especialy handy for policies.
you have a complete indexed list to use.
column G: cancel cancel policy, set it to true or false to overwrite what s in the description (false = cannot be canceled) (true = cancelable) (null or emty: from description)
column H: refund refund policy, set it to true or false to overwrite what s in the description (false = none refundable) (true = refundable) (null or emty: from description)
column I: fees fees policy, set it to true or false to overwrite what s in the description (false = fees excluded) (true = fees included) (null or emty: from description)
column J: board board meal, add any description.
use the demofile csv as a model.
only one is required (name) with the room name.
the mapper will take into account any others from the list if they are set. all columns can be mixed as far as they retain the proper column name
examples of csv columns:
hid - name
hid - supplier - price - name
hid - rcode1 - price - name - cancel - fees
hid - supplier - rcode1 - rcode2 - amount - name - cancel - refund - fees - board
If multiple elements are found, each element inside each field are slash separated.
List of mapped criterias columns and descriptions for CSV results:
send download link to
3 - result as
4 - launch mapping
drag and drop elements below
Navigate the JSON
inspect and check corresponding terms table below before saving
|number of room mapping
|flat fee||cost of usage
per 1M rooms
|number of hotel search
|flat fee||online cost of usage
|number of rows