Travel Partner User Guide
Contents
1. RoyalCaribbean Celebrity Cruises Like no vacation on earth Partner Pricing Feed Travel Partner User Guide Version 1 06 Confidential Royal Caribbean Cruises Ltd 2007 Travel Partner User Guide Table of Contents 1 INTRODUCTION OVERVIEW OF THE PRICING FEED sccccccsssssseccceccssssscccccescessscscccsescesececcesceesssecccesecees 2 PARTNER FULFILLMENT PROCESS eoeoeetre noto tees ases st scavssccecsecaganteaceesssoasscesesseseoussceesecesentusesesssenoonencstsceoesene 2 1 REQUEST ENROLEMENT 4 ten itieenee tea meme dimito em eere tero 2 2 CHANGES TO ENROLLMENT eene teet usse ie ee nore en e eiat 2 3 SORTING ACCESSING OF EILES trt oerte en stes o Eee E ates thv sth NI EILES WITHIN THE DELOLOL DP 3 1 FILE NAMING CONVENTIONS NE ertet 3 2 ITINERARY FILE SR Rete EIN Nea EEUU P RETE FEE 3 3 NO AIR PRICING FILE AND INTERLINE PRICING FILE eee eee nennen ener einen n nnne einn eterne 3 4 SCHEDULE FOR BACK END PROCESS cccccssessessssseeceesenseececeecessuaeeeceeecenseaeeeseceenseaeeeeccesenseecseeecenseaeaeeeseseeetaesesens 3 5 UNSUPPORTED ITEMS WHICH WILL NOT BE DISPLAYED IN THE PRICING FEED eee RUE e Confidential Royal Caribbean Cruises Ltd 2007 Page 2 of 11 Travel Partner User Guide 1 Introduction2. Overview of the Pricing Feed The Partner Pricing Feed will provide our travel partners with an enhanced version of the Daily Pricing Feed to retrieve pricing itinerary and cruise tour information through an FTP transfer process This data will be primarily used for caching purposes supporting the initial shopping browsing needs The pricing data will be updated at least three 3 times a day starting at 2 A M EST and the last pricing update will begin at 10 P M EST 7 days a week The cruise and cruise tour itineraries will be refreshed once a day 2 Partner Fulfillment Process Once access is granted the agency will be provided with a user ID and password that will allow access to the files by visiting the following URL FTP PricingFeed rccl com The process to download the files is not automated and will require the agency to pick up or upload the files 2 4 How to Request Enrollment 2 2 Changes to Enrollment 2 3 Sorting Accessing of Files The itinerary file is public and available to all travel partners participating in the program All other files are secured based on agency permissions An agency will only be able to view files based on the permission level granted 3 Files within the Feed The feed will be made up of the three 3 files listed below File 1 Itinerary inclusive of cruise and cruise tour File 2 No Air Pricing including pricing for cruises and cruise tours File 3 No Air Interline
3. 8 BRKUOSI WIT2008 12 51 2008 Beeskthrs CAS CARIB ADISCSJ3 4 20 2006 2 6 2006 12 31 2008 JU ARCODEI CAS CARIB ADTSCSJ3 4 20 2008 SRSA 2082008 12 21 2008 CARIB ADTSCSJ3 4 20 2008 SRSB16 342006 12 31 2006 su CAS CARIB ADISCSJS 4 20 2008 ARSIE 2122008 12 31 2008 JU CAS CARIB _ADTSCSJ3 4 20 2008 BRKLOSh 5182001 12 31 2006 CAS CARIB ADTSCSJS 4 20 2008 SRSA 21072006 12 31 2008 ssy CAS CARIB ADTSCSJS 4 20 2008 SRSBT 304 2008 1273112008 su CAS ADISCSJ3 4 20 2008 RESCAN W32008 12 31 2008 JU AB BC MB CAS ADTSCSJ3 4 20 2008 206 2008 12032008 su AR DE IA ADTSCSJS 4 20 2008 2812008 12 31 2008 JU ADTSCSJS 4 20 2008 ERKINOSI 811522007 12 31 2008 Ju Breskthrs CAS ADTSCSJS 4 20 2006 MILAH 2812008 12 31 2008 ADTSCSJO 4 20 2008 516 20 12 31 2008 lt lt lt lt lt lt MM N Guest Guest Singh Non Sailing Conrertibl Quert 1 Guest Le Guest 5 4 Child Traveer Comm bCategory Only ePrice Package Price 2Price Gratuity 3 4 Gratuity Price Gratuit Price Cruise Tames Flag Desc Amt Amt Amt Amt Amt y Amt Amt Fore Amt Pees Ant Y Y ADSOUTF 1990 1230 6825 340 65 25 0 0 2780 159 32 37 Y Y ADSOUTF 1840 1840 6825 340 68 25 0 0 3680 13 32 31 N Y ADSOUTr 1240 1240 625 340 65 25 0 o 2450 153 32 31 ARM Y Y ADS
4. OUTr 1190 130 6825 340 65 25 0 o 2280 153 32 37 aS Y Y ADSOUTE 1240 1240 5625 340 63 25 9 0 2430 153 32 37 x Y ADSOUTr 1370 1970 6625 340 5 25 0 0 2740 159 32 31 N Y Y AD SOUTH 1250 1350 66 25 340 65 25 o 0 2700 159 32 31 4 Y Y j ADSQUTR mo 6825 340 6825 0 90 940 53 23297 lt Y Y ADSOUTt 1220 1220 5825 349 68 25 0 0 2440 59 32 31 JN Y Y 007 150 150 6825 340 63 25 o 2300 159 32 31 EE d Y Y 1220 1220 6825 340 68 25 0 0 2440 159 32 37 N Y Y ADSOUTE 1260 1260 5625 540 65 25 0 0 2520 53 32 31 S en Y Y AD SOUTE 1430 1450 58 25 340 63 25 0 0 2650 159 32 31 M Y Y Y ADSOUTr 1250 1250 6825 340 68 25 o 2500 15 32 3T NAM Y Y ADSOUTK 1360 1260 6825 340 63 25 9 0 2720 153 32 31 3 4 Schedule for Back End Process The process that creates the itinerary file will run once a day seven 7 days a week The process that creates the pricing file will run at least three 3 times a day 7 days a week A scheduled reboot will occur every Sunday at 7pm bringing the server down for 10minutes The only other down time will be when the core reservations system is unavailable for system maintenance 3 5 Unsupported Items Which Will Not Be Displayed in the Pricing Feed The Partner Pricing Feed does not support the pricing types listed below Any pricing that meets these criteria will not be supported and not included in the feed Pricing that Displays as FIT e Air add ons Appendix A The following a
5. ation Location Location Arrival Departure Package ID Sail Date Date Code Code OnlyFlag Portion Code Name Activity Time Time AD7SCSJ3 4 20 2008 4 25 2008 AD 7SCSJ3 CRUISE SXM PHILIPSBURG DOCKED 80000 173000 AD7SCSJ3 4 20 2008 4 26 2008 AD 7SCSJ3 CRUISE STT CHARLOTTE ANDOCKED 80000 173000 AESOP ARIRE 4 27 2008 AD SEL cnn n AGRIS PUDEBARK 70000 gannan a AD7SCSJ3 4 13 2008 4 13 2008 AD 7SCSJ3 Y CRUISE SJU JUAN PU EMBARK 0 203000 AD SCSJ3 4 13 2008 4 14 2008 AD 7SCSJ3 Y CRUISE CRU CRUISING CRUISING 0 0 AD 7SCSJ3 4 13 2008 4 15 2008 AD 7SCSJ3 Y CRUISE ORANJESTAD DOCKED 80000 203000 AD7SCSJ3 4 13 2008 4 16 2008 AD 7SCSJ3 Y CRUISE CUR WILLEMSTAD DOCKED 80000 170000 AD7SCSJ3 4 13 2008 4 17 2008 AD 7SCSJ3 Y CRUISE CRU CRUISING CRUISING 0 0 AD7SCSJ3 4 13 2008 4 18 2008 AD 7SCSJ3 Y CRUISE SXM PHILIPSBURG DOCKED 80000 173000 AD7SCSJ3 4 13 2008 4 19 2008 AD 7SCSJ3 Y CRUISE STT CHARLOTTE ANDOCKED 80000 173000 AD7SCSJ3 4 13 2008 4 20 2008 AD 7SCSJ3 Y CRUISE SJU SANJUAN PUDEBARK 70000 0 AD7SCS 4 20 2008 4 20 2008 AD 7SCSJ3 Y CRUISE SJU JUAN PU EMBARK 0 203000 AD7SCSJ3 4 20 2008 4 21 2008 AD 7SCSJ3 Y CRUISE gt CRUISING CRUISING 0 0 AD7SCSJ3 4 20 2008 4 22 2008 AD 7SCSJ3 Y CRUISE AUA ORANJESTAD DOCKED 80000 203000 AD7SCSJ3 4 20 2008 4 23 2008 AD 7SCSJ3 Y CRUISE CUR WILLEMSTAD DOCKED 80000 170000 AD7SCSJ3 4 20 2008 4 24 2008 AD 7SCSJ3 Y CRUISE CRUISING CRUISING 0 0 Y Y 3 3 No Ai
6. iline pricing for cruises and cruise tours 31 File Naming Conventions For the itinerary file the file name is standard across all markets use the following convention Itinerary Pricing files will be created with the naming conventions described below and examples are also included Confidential Royal Caribbean Cruises Ltd 2007 Page 3 of 11 Travel Partner User Guide For no air pricing use the following convention Office Currency cruise no air price The following are examples for no air pricing MIA USD cruise no air price LON EUR cruise no air price For interline no air pricing use the following convention Iline Office Currency cruise no air price The following are examples for interline MIA USD cruise no air price LON EUR cruise no air price 3 2 Itinerary File The following table identifies the data for the fields within the itinerary file To obtain the pricing the travel partner would join Package ID and Sail Date Note that the combination of the field in green will allow for a unique ship sail date combination A Ipha or Max field Field Name N umeric length Field Description The first two characters are the ship code followed by the itinerary code Eg MR15H011 MR Mercury 15H011 ITINERARY CODE Package ID E Sail date and not the package start date in case of an inclusive pre tour in the package in format MM DD YYYY Sail Date Start date for the package Same as
7. ng T Verification Desc Sub Region Region Code Super Stateroom Type Stateroom Type Confidential Royal Caribbean Cruises Ltd 2007 One to two character code representing categories Date on which the prices reflected become applicable MM DD YYYY Date on which the price program is becomes unavailable MM DD YYYY Code used to represent the brand of the ship R Royal C Celebrity Two character code used to represent the ship Unique for each ship Code representing the port from which the ship departs Code representing the type of price program Eg ITL Interline RES Residential Special SRC Senior Special AIR Air Promo Text describing the eligibility of the price program Code representing the sub region for the sailing Eg CAW for Caribbean west Code representing the region for the sailing Eg CARIB for Caribbean Code representing the super type of the stateroom Eg I Inside O Outside B Balcony D Deluxe Code representing the type of stateroom Eg SI Standard Inside LO Large Outside DO Deluxe outside etc Page 7 of 11 Travel Partner User Guide Y Triple and Quad cabins are available N Triple and Quad cabins are not Triple Quad Required available Occupancy Flag A 1 Y Guarantee cabins available N Guarantee cabins not available Guarantee Category Flag NW Convertible Price Flag Y package has just a cruise N package has an inclusive pre pos
8. r Pricing File and Interline Pricing File The following table identifies the data for the fields within the No Air Pricing File The fields in green are also the unique keys Note that the same fields are used in the interline pricing It is the price program ID which identifies which price programs are Interline Only Interline agencies will have access to interline pricing files which are identified by adding to the file name To obtain the itinerary the travel partner would find the records with a matching package ID and sailing date in the Itinerary File See section 2 2 for the Itinerary File Format definition A Ipha or Max field Field Name N umeric length Field Description The first two characters are the ship code followed by the itinerary Package ID Sail Date code Eg MR15H011 MR Mercury 15H011 Itinerary code Sail date and not the package start date in case of an inclusive pre tour in the package in the format MM DD YYYY No set nomenclature for price program New price program names are added often Price program name starting with the following letters have the corresponding meaning RES Residential special SRS Senior Special HR Happy Hour A ARS Air Special Confidential Royal Caribbean Cruises Ltd 2007 Page 6 of 11 Stateroom Category Code Price Effective Date Travel Partner User Guide Price End Date Brand Code Ship Code Departure Port Code Prici
9. re step by step instructions with Screenshots to assist you with logging into the FTP site Confidential Royal Caribbean Cruises Ltd 2007 Page 9 of 11 Travel Partner User Guide INSTRUCTIONS Type ftp pricingfeed rccl com 36360 in either the Run box as below or on a browser Note that the port number must be specified or you will not be able to access our FTP site Enter your user ID and password when prompted Page 10 of 11 Confidential Royal Caribbean Cruises Ltd 2007 Travel Partner User Guide After successfully login in you will be presented with the files and folder s that you have access to ftp pricingfeed rccl com 36360 Microsoft Internet Explorer File Edit View Favorites Tools Help Qe 9 E gt Folders Address i Ftp Jpricingfeed rccl com 36360 2 Der pieces Itinerary Miami Llsd Internet Explorer My Documents My Network Places Confidential Royal Caribbean Cruises Ltd 2007 Page 11 of 11
10. sail date in case the package has a post tour In case of a pre tour it s the date calculated by subtracting the pre tour nights from the Sail Date It is the same as the Sail Date In case Sailing Only Flag has a value of Y Activity Date Two character code used to represent the ship Unique for each ship Ship Code The itinerary code does not have a set nomenclature and each new itinerary that RCCL comes up with would have a new itinerary code Itinerary Code Page 4 of 11 Confidential Royal Caribbean Cruises Ltd 2007 Travel Partner User Guide 6 Vacation Portion EN Location Code Arrival Time Departure Time Sample Itinerary File Confidential Royal Caribbean Cruises Ltd 2007 Y package has just a cruise N package has an inclusive pre post tour along with a cruise One of the following PRE CRUISE TOUR In case of pre cruise tour nd a cruise in the package POST CRUISE TOUR In case of Post cruise tour and a cruise in the package CRUISE In case of just a cruise in the package Code representing one of the following Port code AT SEA Tour location code Text describing the pre tour itinerary and or post tour which ever is part of the package Will be one of the following DEBARK EMBARK CRUISING or the Time of departure from the Location Code in local time in HH MM SS format Page 5 of 11 Travel Partner User Guide Activity Ship Itinerary Sailing Vac
11. t tour along with a cruise Y Existing bookings are allowed to switch to the price program Text describing the package Package Amount applicable to 1st Guest on the booking Package Amount applicable to 2nd Guest on the booking Guest 1 Price Amt Guest 2 Price Amt 13 13 Gratuity Amount applicable to 1 and 2 Guest the booking Package Amount applicable to 3 and 4 Guest on the booking Gratuity Amount applicable to 3 and 4 Guest on the booking Package Amount applicable to a child guest Gratuity Amount applicable to a child guest Package Amount applicable to an only guest on the booking Non Commissionable Cruise Fare Amount Er aen ern m Single Traveler Price Amt i 6 7 8 9 0 1 2 3 6 7 8 1 1 1 1 2 2 2 2 2 2 2 N N N N N N N N 13 7 13 13 Non Comm Cruise Fare 29 Amt Taxes Fees Amt Notes 311 For guest pricing n is variant as the field is selected based on the cabin category price code and currency combination Taxes and Fees Amount oo NI a Sample Pricing File Confidential Royal Caribbean Cruises Ltd 2007 Page 8 of 11 Travel Partner User Guide Price Program Stateroom Price Bran Dopartur Super Effective Price Ead Pricing Yerification Seb Region Stateroom Stateroom Occupa Sail Date Date Date Code Type Dese Regios Code Type 1477 ADTSCSJ3 4 20 2008 2122008 12 21 2008 CAS Y ADTSCSJS 4 20 200
Download Pdf Manuals
Related Search