← All work
Internal Project Live

SimplySmartChat

AI-powered WooCommerce sales assistant. RAG pipeline meets real product knowledge.

An AI chatbot that actually knows the product catalog. Built for a WooCommerce store — the bot ingests product descriptions, pricing, specs, and FAQs via a RAG pipeline, then answers customer questions with real product knowledge. Not a generic ChatGPT wrapper — it quotes prices, compares products, and links directly to purchase pages.

Key decisions

  • RAG pipeline with pgvector: WooCommerce product data ingested into Supabase pgvector. Semantic search retrieves relevant products before the LLM generates responses.
  • OpenRouter for model flexibility: Route between Claude, GPT-4o, and Groq depending on query complexity. Fast models for simple questions, reasoning models for comparisons.
  • Cloudflare Workers for edge processing: Query preprocessing and caching at the edge. Sub-200ms response times for cached product lookups.

Stack

Next.js · TypeScript · OpenRouter · Claude API · Supabase pgvector · Cloudflare Workers · WooCommerce REST API