Zipchat: RAG and search for a Shopify AI chatbot
Zipchat is an AI sales chatbot for Shopify stores. I worked on it as a full-stack engineer, finishing in November 2023.

The problem
A live chatbot whose answers depended on retrieval quality, and whose admin dashboard and request path needed to get faster.
What I did
- Improved retrieval (RAG) over store data using a vector database.
- Integrated search tools into the chatbot's function-calling flow.
- Improved response performance.
- Optimised the admin dashboard.
Result
Faster answers and better retrieval.
Stack
Ruby on Rails
PostgreSQL
Shopify
ChatGPT API with function calling
Pinecone
Tailwind
Konstantin is extremely knowledgable about ruby on rails and back-end optimization. I recommend him 100%
Related: AI and LLM integration
Add a production AI feature, retrieval over your data, or model routing to a Rails app that already works. How it works →
Full overlap with European business hours, and 9am–6pm US Eastern.
43 clients, 21,500+ hours, 100% Job Success — the reviews are on Upwork.