NorthStarStateCruiser Posted May 9, 2023 #1 Share Posted May 9, 2023 Hi everyone, I've made reference to this trick before on other topics, but I figured I'd put this in it's own topic post so people can identify it easier. Basically, you are able to view any upcoming cruise planner page without actually being booked on that cruise. Accessing the cruise planner before booking the cruise is especially helpful in identifying available excursions or the current prices for dining or beverage packages. This is more helpful for Royal Caribbean cruises because the pricing is more dynamic and can vary widely from sailing to sailing. All that needs to be done is some modification to parameters in the URL. Here's the base URL for the beverage package page (you can navigate to any other cruise planner page from there as you normally would): https://www.celebritycruises.com/account/cruise-planner/category/beverage?bookingId=0000000&shipCode={ShipCode}&sailDate={YYYYMMDD} 1. Simply replace the {ShipCode} portion of the URL with the ship code you're looking for. You can find the ship code by doing a search with on the main "Find A Cruise" page and filter down to the ship you're looking for. The 2 letter ship code will then be shown within the URL for that filtered page. 2. Also replace the {YYYYMMDD} with the sail date of the cruise you want to look at. 4 digit year, 2 digit month and day. 3. Sign out from the celebrity website before navigating to the url. It blocks you from viewing if you're logged in. To make this process easier, I made a tool on a Google Sheet where you can select cruise line, ship, and sail date and the URL is generated for you. Here's the link to the Google Sheet tool: https://docs.google.com/spreadsheets/d/1ukT6gOPcu7coL92LuDcyDaWXQfO88u5kN9FEdHRj5bM/edit?usp=sharing Note that this is a shared sheet, so there may be more than 1 person in it at the same time. You can use any of the rows 9 thru 13 if someone is currently editing one of the rows. Hope this is helpful for some of you! 8 13 Link to comment Share on other sites More sharing options...
mnocket Posted May 9, 2023 #2 Share Posted May 9, 2023 Thanks. This could prove helpful. 1 Link to comment Share on other sites More sharing options...
Rare Georgia_Peaches Posted May 9, 2023 #3 Share Posted May 9, 2023 Wow! Great information...thank you so much! 1 Link to comment Share on other sites More sharing options...
Rare mahdnc Posted May 9, 2023 #4 Share Posted May 9, 2023 1 hour ago, NorthStarStateCruiser said: Hi everyone, I've made reference to this trick before on other topics, but I figured I'd put this in it's own topic post so people can identify it easier. Basically, you are able to view any upcoming cruise planner page without actually being booked on that cruise. Accessing the cruise planner before booking the cruise is especially helpful in identifying available excursions or the current prices for dining or beverage packages. This is more helpful for Royal Caribbean cruises because the pricing is more dynamic and can vary widely from sailing to sailing. All that needs to be done is some modification to parameters in the URL. Here's the base URL for the beverage package page (you can navigate to any other cruise planner page from there as you normally would): https://www.celebritycruises.com/account/cruise-planner/category/beverage?bookingId=0000000&shipCode={ShipCode}&sailDate={YYYYMMDD} 1. Simply replace the {ShipCode} portion of the URL with the ship code you're looking for. You can find the ship code by doing a search with on the main "Find A Cruise" page and filter down to the ship you're looking for. The 2 letter ship code will then be shown within the URL for that filtered page. 2. Also replace the {YYYYMMDD} with the sail date of the cruise you want to look at. 4 digit year, 2 digit month and day. 3. Sign out from the celebrity website before navigating to the url. It blocks you from viewing if you're logged in. To make this process easier, I made a tool on a Google Sheet where you can select cruise line, ship, and sail date and the URL is generated for you. Here's the link to the Google Sheet tool: https://docs.google.com/spreadsheets/d/1ukT6gOPcu7coL92LuDcyDaWXQfO88u5kN9FEdHRj5bM/edit?usp=sharing Note that this is a shared sheet, so there may be more than 1 person in it at the same time. You can use any of the rows 9 thru 13 if someone is currently editing one of the rows. Hope this is helpful for some of you! I have 3 cruises booked that I still do not allow you to make specialty dining reservations. This includes one coming up this Dec. I used a modified form of your shorex hack to determine that specialty dining reservations could be made on the sailings before and after my Dec cruise. It doesn't solve the problem, but at least I know that it is just something with my particular sailing. Your little spreadsheet tool now makes that simpler. Nice. 1 Link to comment Share on other sites More sharing options...
crewsgirl Posted May 9, 2023 #5 Share Posted May 9, 2023 This is awesome! Thanks for all your work. Is there a way to see what cabins might still be available in case I am considering a move up option, specifically for Celebrity? Link to comment Share on other sites More sharing options...
NorthStarStateCruiser Posted May 10, 2023 Author #6 Share Posted May 10, 2023 3 hours ago, crewsgirl said: This is awesome! Thanks for all your work. Is there a way to see what cabins might still be available in case I am considering a move up option, specifically for Celebrity? Unfortunately, I have not found any better method to identifying number of cabins available besides doing a mock booking on the Celebrity website or a TA website and then counting. Some sites give you counts by deck number to make it a little easier. 1 Link to comment Share on other sites More sharing options...
NorthStarStateCruiser Posted May 12, 2023 Author #7 Share Posted May 12, 2023 (edited) Update: I added some backend stuff so that a dropdown list of sailing dates is now available in the Sail Date column after selecting the cruise line and ship. This makes it easier to identify dates without having to reference a list on another website. I thought it would be super helpful for myself, so I went ahead and built it in. Enjoy! edit: I should mention that the sailing date list is referenced from a cruise related website that gets updated regularly, so there's nothing to maintain there. Edited May 12, 2023 by NorthStarStateCruiser 2 1 Link to comment Share on other sites More sharing options...
Swordfish1949 Posted May 21, 2023 #8 Share Posted May 21, 2023 Very helpful...many thanks Link to comment Share on other sites More sharing options...
beachluver9 Posted May 21, 2023 #9 Share Posted May 21, 2023 Thanks! Link to comment Share on other sites More sharing options...
Rare bjahil47 Posted June 29, 2023 #10 Share Posted June 29, 2023 @HRH SR Here is cruise planner… Link to comment Share on other sites More sharing options...
Rare bjahil47 Posted June 29, 2023 #11 Share Posted June 29, 2023 @Alakegirl Link to comment Share on other sites More sharing options...
NorthStarStateCruiser Posted September 12, 2023 Author #12 Share Posted September 12, 2023 FYI, Royal Caribbean Group updated the cruise planner page authorizations and by doing so, each cruise planner page accessed outside of a reservation needs to be accessed independently. On the spreadsheet tool, there are now links to the highest used pages instead of only one link. Here's the link to the spreadsheet tool (same link as previous). https://docs.google.com/spreadsheets/d/1ukT6gOPcu7coL92LuDcyDaWXQfO88u5kN9FEdHRj5bM/edit?usp=sharing For those of you utilizing the URL trick manually, Royal Caribbean modified the page authorizations and the workaround I found now disallows the navigation from page-to-page within the cruise planner. Therefore, you need to manually enter the page category in the url. Here's the updated schema. Note: There's no longer "000000" for the bookingId parameter. https://www.celebritycruises.com/account/cruise-planner/category/{PageCategory}?bookingId=&shipCode={ShipCode}&sailDate={YYYYMMDD} 1. Replace the {PageCategory} portion of the URL with your desired cruise planner page (referenced below). Shore Excursions = shorex Beverage Packages = beverage Dining = dining Spa = spa Packages = packages Internet = internet Onboard Activities = onboardactivities Casino = casino Photo = photoPackage Gifts and Gear = gifts 2. Simply replace the {ShipCode} portion of the URL with the ship code you're looking for. You can find the ship code by doing a search with on the main "Find A Cruise" page and filter down to the ship you're looking for. The 2 letter ship code will then be shown within the URL for that filtered page. 3. Also replace the {YYYYMMDD} with the sail date of the cruise you want to look at. 4 digit year, 2 digit month and day. 4. Sign out from the Celebrity website before navigating to the url. It blocks you from viewing if you're logged in. Link to comment Share on other sites More sharing options...
ecslady Posted September 12, 2023 #13 Share Posted September 12, 2023 Thanks so much. Link to comment Share on other sites More sharing options...
iujen94 Posted December 30, 2023 #14 Share Posted December 30, 2023 This is amazing. Thank you!! 1 Link to comment Share on other sites More sharing options...
Rare Jim_Iain Posted December 31, 2023 #15 Share Posted December 31, 2023 On 5/9/2023 at 6:05 PM, NorthStarStateCruiser said: Unfortunately, I have not found any better method to identifying number of cabins available besides doing a mock booking on the Celebrity website or a TA website and then counting. Some sites give you counts by deck number to make it a little easier. I do something similar to you except - I do a mock booking up to the Category Selection and then book mark that page like below. It then allow me to quick check room prices and can check to see how many cabins if I want to check by category. https://www.celebritycruises.com/booking-cruise/selectRoom/stateroomCategory?pID=SL11H036&sDT=2024-04-25&sCD=SL&sCT=CO&roomQuantity=1 For checking room availability I find the best for me is to us AA.Com site and do a mock booking. They have maps of open rooms by category with green squares on available rooms. 1 Link to comment Share on other sites More sharing options...
Rare Kmkub Posted January 10 #16 Share Posted January 10 Wow is that helpful! Thank you for creating that! Link to comment Share on other sites More sharing options...
ewo1992 Posted January 12 #17 Share Posted January 12 On 9/12/2023 at 7:58 AM, NorthStarStateCruiser said: FYI, Royal Caribbean Group updated the cruise planner page authorizations and by doing so, each cruise planner page accessed outside of a reservation needs to be accessed independently. On the spreadsheet tool, there are now links to the highest used pages instead of only one link. Here's the link to the spreadsheet tool (same link as previous). https://docs.google.com/spreadsheets/d/1ukT6gOPcu7coL92LuDcyDaWXQfO88u5kN9FEdHRj5bM/edit?usp=sharing For those of you utilizing the URL trick manually, Royal Caribbean modified the page authorizations and the workaround I found now disallows the navigation from page-to-page within the cruise planner. Therefore, you need to manually enter the page category in the url. Here's the updated schema. Note: There's no longer "000000" for the bookingId parameter. https://www.celebritycruises.com/account/cruise-planner/category/{PageCategory}?bookingId=&shipCode={ShipCode}&sailDate={YYYYMMDD} 1. Replace the {PageCategory} portion of the URL with your desired cruise planner page (referenced below). Shore Excursions = shorex Beverage Packages = beverage Dining = dining Spa = spa Packages = packages Internet = internet Onboard Activities = onboardactivities Casino = casino Photo = photoPackage Gifts and Gear = gifts 2. Simply replace the {ShipCode} portion of the URL with the ship code you're looking for. You can find the ship code by doing a search with on the main "Find A Cruise" page and filter down to the ship you're looking for. The 2 letter ship code will then be shown within the URL for that filtered page. 3. Also replace the {YYYYMMDD} with the sail date of the cruise you want to look at. 4 digit year, 2 digit month and day. 4. Sign out from the Celebrity website before navigating to the url. It blocks you from viewing if you're logged in. Is this still working, it won’t load for me? Link to comment Share on other sites More sharing options...
NorthStarStateCruiser Posted January 12 Author #18 Share Posted January 12 2 hours ago, ewo1992 said: Is this still working, it won’t load for me? What exactly is not loading? The sheet, links, the cruise planner? You may have popped into the sheet when all 5 of the available data rows were occupied with data previously entered by another person. I have a trigger set up to clear out that data every 24 hours around midnight but I may want to add some code to clear out that data periodically throughout the day. I could also add some more rows to be available for selection. Link to comment Share on other sites More sharing options...
Rare mahdnc Posted January 12 #19 Share Posted January 12 11 minutes ago, NorthStarStateCruiser said: What exactly is not loading? The sheet, links, the cruise planner? You may have popped into the sheet when all 5 of the available data rows were occupied with data previously entered by another person. I have a trigger set up to clear out that data every 24 hours around midnight but I may want to add some code to clear out that data periodically throughout the day. I could also add some more rows to be available for selection. A few months ago, the sailing dates were not loading properly after specifying cruise line and ship. It seems to be ok now. Link to comment Share on other sites More sharing options...
NorthStarStateCruiser Posted January 12 Author #20 Share Posted January 12 3 minutes ago, mahdnc said: A few months ago, the sailing dates were not loading properly after specifying cruise line and ship. It seems to be ok now. That also can happen. The reason for this is because I'm automatically pulling a list of available itineraries from a cruising website which may not be 100% up-to-date for new ships, redeployments, etc. If you know a sailing exists for a specific date and ship, you can manually type in that sail date in column C rather than using the dropdown list. An error message will be shown in column D, but the links to the cruise planner pages will still work properly. 1 Link to comment Share on other sites More sharing options...
truckswain Posted January 14 #21 Share Posted January 14 This is great, especially for RC cruises that don't offer All Included. I take it there is not a way to have the cruise planner results in Canadian Dollars. Link to comment Share on other sites More sharing options...
Ex-Airbalancer Posted January 14 #22 Share Posted January 14 7 minutes ago, truckswain said: This is great, especially for RC cruises that don't offer All Included. I take it there is not a way to have the cruise planner results in Canadian Dollars. Just use a multiplier of 1.3839 to the USD price , as my $100 SHC OBC IS $138.39 CAD 😭 1 Link to comment Share on other sites More sharing options...
HondaGirl05 Posted January 31 #23 Share Posted January 31 (edited) I am getting a #REF! after selecting the line - any way to fix this? BTW this tool is amazing, so thank you!! UPDATE: Must have been user error - someone else got it to work 🙂 Thanks again!! Edited January 31 by HondaGirl05 Link to comment Share on other sites More sharing options...
2Long2NxtCrz Posted January 31 #24 Share Posted January 31 I somehow missed this when you originally posted, so I'm very glad it got another reply. This is an amazing tool and had to take a lot of hard work. I really appreciate it! Thank you! Link to comment Share on other sites More sharing options...
gatorima Posted February 1 #25 Share Posted February 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now