eSIM advisor

What it does

Country-by-country connectivity guide with hero photo, intro, pro tips, local resource links, and multiple recommended providers (logos, plans, prices, purchase URL, activation steps).

Where to find it

Users: /connectivity index, /connectivity/$country detail.
Admin: /admin/esim full CMS.

How to use it (admin)

/admin/esim -> "New guide" -> enter country code (e.g. IT) and name.
Expand the row, upload hero photo, fill intro / pro tips (markdown).
Add local resource links (label + URL).
"Add provider" -> name, price from, currency, logo, plans (label/data/days/price), purchase URL, activation steps.
Toggle Published when ready.

Admin controls

Full CRUD on guides & providers, image upload to private esim-photos bucket (signed URLs on read), draft/published flag per guide and per provider, sort order.

Edge cases

Drafts hidden from users via RLS.
Missing hero/logo handled gracefully.
Markdown renderer supports paragraphs, bold, links, bullets.

Related files

DB: esim_guides, esim_providers, storage bucket esim-photos
src/routes/admin.esim.tsx
src/routes/connectivity.tsx, src/routes/connectivity.$country.tsx