← All work
Case StudyTier AProduction2022 — 2023
Travel Tour Reservation & Capacity Approval Bot
Telegram reservation product for a travel agency with stateful booking, admin-controlled capacity approval, targeted messaging, and manual payment verification.
ProductAutomationTechnical
Evidence
~10 months real use
Context
2022 — 2023 · Production · historical · Maturity: Production.
Problem
Tour reservations needed a lightweight digital workflow without building a full web booking platform.
Users
Travel-agency customers and administrators.
My Role
Custom product design and implementation.
Product Decisions & Responsibilities
- Mapped reservation states and admin approval steps.
- Designed targeted messaging and operational controls.
Technical Approach
- Built PHP/MySQL state workflows and Telegram Bot API integration.
PHPMySQLTelegram Bot APIState workflows
Constraints
- Capacity required admin approval.
- Payment remained card-to-card with manual verification.
Product Flow
- Browse/select tour
- Submit reservation
- Admin capacity approval
- Payment evidence
- Manual verification
- Confirmation
Outcome
- Used for ~10 months.
- Approximately 3 tours/week; estimated 120+ tours only when labeled approximate.
What I Learned
- A simple operations-aware product can outperform unnecessary platform complexity.
Evidence Boundary
What this does — and does not — prove
Capacity was not automatic inventory and payment was not an online gateway.
Next Iteration
Extend the product only after the next decision can be tied to stronger user, operational, or business evidence rather than adding features for their own sake.