PharaohSMS

SMS booking bot that captures guest reservations via text during Cairo internet outages

Score: 8.0/10EgyptMedium BuildReady to Spawn
Brand Colors

The Opportunity

Problem

Hotel operators in Cairo and tourist areas suffer lost bookings from frequent internet blackouts that cause downtime in online reservation platforms.

Solution

Guests text a shortcode to book rooms directly with hotel staff confirming via SMS, bypassing website downtime entirely. Integrates with your PMS for inventory sync over mobile data. Perfect for tourist walk-ins without reliable WiFi.

Target Audience

Hotel operators in Cairo and Egypt's tourist areas relying on online reservation platforms

Differentiator

Mobile-first SMS gateway leveraging Egypt's 99% SMS penetration during blackouts

Brand Voice

friendly

Features

SMS Booking Intake

must-have15h

Guests text keywords like BOOK ROOM to shortcode, bot parses details

Staff Confirmation Flow

must-have12h

Hotel receives SMS alerts, replies YES/NO to confirm

Inventory Sync

must-have10h

Updates room availability via API post-confirmation

Analytics Dashboard

must-have8h

Track SMS bookings, conversion rates

Custom Shortcode Setup

must-have6h

Assign hotel-specific SMS number

WhatsApp Integration

nice-to-have10h

Fallback to WhatsApp API

Automated Receipts

nice-to-have7h

Send confirmation SMS with QR code

Bulk Guest Reminders

nice-to-have5h

Schedule check-in reminders

Total Build Time: 73 hours

Database Schema

users

ColumnTypeNullable
iduuidNo
phonetextNo
hotel_iduuidNo
created_attimestampNo

Relationships:

  • hotel_id references hotels(id)

hotels

ColumnTypeNullable
iduuidNo
nametextNo
sms_shortcodetextNo
room_typestextNo

sms_bookings

ColumnTypeNullable
iduuidNo
hotel_iduuidNo
guest_phonetextNo
room_typetextNo
statustextNo
timestamptimestampNo

Relationships:

  • hotel_id references hotels(id)

API Endpoints

POST
/api/sms/inbound

Twilio webhook for incoming texts

GET
/api/bookings

List pending SMS bookings

🔒 Auth Required
POST
/api/confirm/:bookingId

Staff confirms booking

🔒 Auth Required
GET
/api/analytics

Fetch booking stats

🔒 Auth Required

Tech Stack

Frontend
Next.js 14 + Tailwind + shadcn/ui
Backend
Next.js API + Supabase Functions
Database
Supabase Postgres
Auth
Supabase Auth
Payments
Stripe
Hosting
Vercel
Additional Tools
Twilio for SMS

Build Timeline

Week 1: SMS core

25h
  • Twilio webhook
  • Basic parsing
  • DB setup

Week 2: Dashboard and auth

20h
  • Staff UI
  • Analytics
  • Auth

Week 3: Confirmation flow

20h
  • Reply handling
  • Sync logic
  • Testing

Week 4: Payments and polish

15h
  • Stripe
  • Landing
  • Shortcode setup

Week 5: Nice-to-haves

10h
  • WhatsApp
  • Reminders

Week 6: QA and deploy

8h
  • Full tests
  • Launch prep
Total Timeline: 6 weeks • 98 hours

Pricing Tiers

Free

$0/mo

Basic rooms only

  • 50 SMS/month

Pro

$20/mo

None

  • 500 SMS/month
  • Custom pricing
  • Analytics

Enterprise

$60/mo

None

  • Unlimited SMS
  • WhatsApp
  • API access

Revenue Projections

MonthUsersConversionMRRARR
Month 1258%$40$480
Month 612020%$480$5,760

Unit Economics

$12
CAC
$350
LTV
6%
Churn
88%
Margin
LTV:CAC Ratio: 29.2xExcellent!

Landing Page Copy

Book Rooms via SMS – Blackout-Proof for Cairo Hotels

Guests text to reserve, you confirm instantly. No internet needed.

Feature Highlights

Parse guest texts auto
Staff reply confirm
Inventory sync
Usage dashboard
99% delivery

Social Proof (Placeholders)

"'Text bookings saved our peak season!' - Pyramids Inn"
"'Simple and reliable.' - Aswan Resort"

First Three Customers

Contact 50 Cairo hotels via WhatsApp business directories, demo SMS flow live call. Offer month 1 free Pro with custom shortcode setup. Leverage tourist association lists for Luxor/Hurghada intros.

Launch Channels

Product Huntr/EntrepreneurTwilio CommunityEgypt Tourism TwitterHotel WhatsApp Groups

SEO Keywords

sms hotel booking egyptcairo outage reservation smstext to book hotelblackout sms bookingsegypt hotel sms system

Competitive Analysis

Twilio Studio

twilio.com
Per-message
Strength

Reliable SMS

Weakness

No hotel-specific booking logic

Our Advantage

Turnkey booking parser + dashboard

🏰 Moat Strategy

Network effects from shared shortcodes in tourist clusters

⏰ Why Now?

Rising mobile data use in Egypt amid blackouts makes SMS dominant

Risks & Mitigation

technicalmedium severity

SMS parsing errors from dialects

Mitigation

AI-powered parsing with fallback manual

financiallow severity

Twilio costs spike

Mitigation

Tiered SMS limits

Validation Roadmap

pre-build5 days

Run SMS prototype with 10 hotels

Success: 70% bookings via text

launch30 days

Track first 100 SMS conversions

Success: 20% repeat use

Pivot Options

  • SMS for restaurants
  • General customer service bot
  • WhatsApp-only version

Quick Stats

Build Time
98h
Target MRR (6 mo)
$800
Market Size
$1.5M
Features
8
Database Tables
3
API Endpoints
4