Share your end-to-end ops playbook for guided tours and packaged trips

For operators running guided tours, packaged trips or destination services: what processes, tools and templates keep your daily operations reliable as you scale? Looking for first‑hand playbooks — not vendor marketing — that cover the full lifecycle: reservations → availability/calendar sync → supplier coordination & confirmations → last‑minute itinerary changes → pricing updates & margin tracking → customer communications & claims → reporting and KPIs.

Please include concrete examples you actually use: workflows or step‑by‑step checklists, automation recipes or custom scripts, exact integrations (API/webhook pairs), SaaS or vendor names (e.g., booking engines, channel managers, CRMs, accounting integrations), dashboards/KPIs you watch, and the recurring bottlenecks you still face. Helpful details:
- Company size, product mix (day tours vs multi‑day), and regions served
- Reservation flow (online / phone / OTA mix) and how availability is maintained
- Supplier confirmation cadence and how vouchers/tickets are delivered
- How you handle last‑minute changes/cancellations operationally and financially
- Pricing change propagation and margin reconciliation process
- What you automate vs what stays manual, and any scripts/IFTTT/Zapier/Make recipes
- Concrete KPIs (e.g., OTIF, pick‑up wait time, booking lead time, margin per pax)

If you can, paste short examples: a 6‑step supplier confirmation checklist, the SQL behind a margin report, a Zap/Make recipe, or a snippet of a booking availability sync logic. Mention the single biggest recurring pain point that still trips you up.

This thread is for operator-to-operator sharing: please label any templates or code as ‘example’ and note where it was used (scale & region).