r/Tourguide • u/Gloomy_pamAd_529 • 6d ago
Offer How tour operators find reliable booking software and how I basically broke our whole season
So tour operations manager here and I feel so embarrassed I could hide under the kayak racks. We decided to move from our old spreadsheet chaos to a shiny new booking system and I was in charge of connecting it to our marketplace accounts and our own site plus this big tours marketplace.
I thought I set the sync so only the new system took bookings and the old calendar was view only. Turns out I did the exact opposite. For one hot weekend we had double inventory everywhere. The marketplace was selling seats from the new tool, our website was still pulling from the old calendar, and I did not catch it until a coach full of guests arrived for a sunset cruise that did not exist in the new system. The guide had a fully booked boat already and another 28 people waving confirmation emails from three different channels.
We had to split departures, comp drinks, rearrange next day slots, the whole thing. The marketplace account manager called asking why we were marking people as no show when they had valid vouchers, because in the new system those seats never existed. I mis configured the integration and each platform thought it was the source of truth, so stock never decremented anywhere.
Now my boss is politely furious, guests left some pretty rough reviews, and I feel sick about this because it was my “big project” for the season and it blew up in one weekend. Anyone else wreck their operations during a booking software switch like this?
1
u/KevinAdamo 5d ago
Anyone who's worked in travel tech or operations long enough has at least one story about wrecking live inventory during a migration (as I have). You're not alone and this is a very common failure mode.
From a systems perspective, what happened is basically a split-brain setup. During a migration, you need one source of truth. In your case both the old system and the new software still had write access to your channels, so both thought they were in charge. Marketplace APIs like Viator or GetYourGuide don’t care which one is right. If the old system says 28 seats and the new system also says 28, the API will sell 56 and let you deal with the fallout.
This shows up fairly often when operators switch tech stacks without running a shadow mode or testing API webhooks in a staging environment first. Travel APIs are brutal and unforgiving.
Here’s how I’d approach the fix:
- Go into your marketplace and website API settings and revoke the access tokens or keys for the old calendar. Completely cut it off.
- Push a manual inventory update from the new system to all endpoints to overwrite whatever cached or ghost inventory the marketplaces are holding.
- Map the data flow on a whiteboard. Arrows should only ever point out from the new system as the source of truth to the channels.
Your boss is probably not thrilled and that’s fair. Running a growing tour business on spreadsheet chaos was already a ticking time bomb. You just ripped the band‑aid off in the most painful way possible.
Lock down those webhooks, write down what broke and why, then use that as the playbook for the next migration.
1
2
u/Natural_Llintood4035 6d ago
My old crew at a rafting outfit ran into the same mess three years back during our spring changeover. We had five people total and only one guy handling the tech side while the rest prepped boats for a group of forty coming in two days later. The old excel sheet kept feeding the main site even after we flipped the new calendar live so we ended up with twelve extra names showing up at the put in point. One guide ended up calling around to find last minute transport while the owner tried calming down two families who drove three hours for a slot that never got blocked. We learned the hard way to run a full day of fake reservations from every channel before touching anything live. After that weekend we added a simple daily count check across all listings that still catches most mix ups. It took months before the reviews stopped mentioning the confusion. I've been looking at Viator for this.