Fullstack E-Commerce with AI Assistant & Internal Logistics

A full-stack Indonesian e-commerce platform built on SvelteKit and Supabase, spanning three audiences at once — customers, store admins, and delivery staff — with an AI shopping assistant, Midtrans payments, Biteship shipping, a PWA, and a native Android app.

📱 Android Application Available

The latest Android build is installable directly through Expo:

👉 Install Tree Coffee Android App on Expo

Highlights

• Hybrid product search, not just LIKE — full-text BM25 combined with vector embeddings, HyDE query expansion, and an optional reranking pass (Voyage AI or Cohere). Relevance is composed from several signals rather than one, which is what makes a two-word Indonesian query return the right SKU.
• A dedicated Go search microservice — search was moved out of the app into GO-toko-online, a Fiber service that keeps a read-only snapshot of active products in RAM behind an atomic.Pointer, answering queries with zero database hits.
• An AI assistant with tool-use, not a canned FAQ — fast and expert modes over the OpenAI SDK, able to call tools, search the web, cite sources, and recommend products from live catalogue state.
• COD gated by a real verification step — cash-on-delivery eligibility is decided per area and confirmed by a WhatsApp OTP through Fonnte, so the riskiest payment method is the one with the strongest identity check.
• Three separate portals against one database — customers, admins, and logistics staff each get their own surface, with role-based auth and real-time deactivation: banning an account takes effect while the session is open, not at next login.
• Shipping that reflects reality — Biteship integration covering JNE, J&T, SiCepat and Anteraja with live tracking, alongside an internal courier zone for areas the aggregators price badly.

Key Features

1. Catalogue and checkout — category browsing, product detail with reviews, a cart persisted to localStorage, and a protected checkout flow through Midtrans Snap covering cards, bank VA, e-wallets, QRIS, and COD.
2. Reviews, reactions and flash sales — ratings with replies and likes, plus scheduled flash-sale campaigns with smooth horizontal scrolling on mobile.
3. Live chat — customer-to-admin messaging over Supabase Realtime, with an admin inbox, quick replies, and staff assignment.
4. Admin CMS — dashboard metrics, product CRUD with variants, stock and Tiptap rich text, category and banner management, content pages, theme customisation, complaints tracking, and revenue analytics.
5. Logistics portal — a separate login at /auth/logistics-login where delivery staff see orders ready to ship, update delivery status, and sync tracking through Biteship.
6. PWA plus native Android — add-to-home-screen on iOS and an installable APK on Android, with the app detecting when it is running inside the native shell.

Tech Stack

• SvelteKit 2.50 + Svelte 5 (runes), TypeScript 5.9
• Tailwind CSS 4.1 + Skeleton UI 4.12
• Supabase — Postgres, Auth (email + OTP, role-based), Realtime, Storage
• Midtrans Snap (payments) + Biteship (shipping)
• OpenAI SDK 6.22 — gpt-4o, gpt-4o-mini, text-embedding-3-*
• Voyage AI / Cohere (optional reranker)
• Fonnte (WhatsApp OTP)
• Tiptap 3.23 + sanitize-html 2.17
• React Native + Expo (native Android client)
• Vercel (primary target), with Docker / Node adapters kept working

Status & Maturity

Active, and the largest project in this catalogue by both commits and lines of code. The web repository and the Android client are versioned separately, which is why the metrics below are reported in two columns rather than summed. There is no automated test suite on either side — verification is manual against a live Supabase project, and that is the clearest gap in the project rather than an oversight to gloss over.

Measured Metrics