A comprehensive Retail CRM and Analytics Dashboard built specifically for retail stores and Kiranas to track performance, manage inventory, and glean insights using AI.
- Dashboard & Analytics: Real-time KPI tracking for total revenue, gross margin, discount leakage, and shrinkage.
- Top Actions: Actionable alerts for stock-outs, slow-moving SKUs, and promotional leakage.
- Data Integration: Seamlessly sync data from Google Sheets or manual CSV uploads via background workers.
- AI Assistant: Powered by Google's Gemini, the AI assistant lets you ask natural language questions about your store's data and automatically renders tables, SQL, and markdown insights.
- Telegram Bot: Integrated Telegram bot for instant notifications on critical metrics and anomalies.
- Modern UI: Built on a sleek, organic design system for a premium user experience.
- Frontend: Next.js, React, Chart.js
- Backend: Python, FastAPI, SQLAlchemy, RQ (Redis Queue)
- Database: PostgreSQL, Redis
- AI Integration: Google Gemini
- Infrastructure: Docker & Docker Compose
- Clone the repository.
- Setup environment variables:
Copy
.env.exampleto.envand fill in your Gemini API key and Telegram Bot Token. - Start the application using Docker Compose:
docker compose up --build -d
- Seed the database with sample data:
docker exec -it retail-api-1 python seed_data.py - Access the application:
- Frontend:
http://localhost:3000 - API Docs:
http://localhost:8000/docs
- Frontend:
Important
Frontend Access Token
To log into the dashboard, use the following test token:
test-store-token-2026
You can upload historical sales and inventory data via the Data Sources tab on the dashboard, or link a public Google Sheet to automatically sync data every 5 minutes in the background.