Complete and develop a web CRM for an electronics store (Flask, Python, already deployed)
Project description
There is a ready working prototype of the CRM system for the electronics store — Electronics CRM.
This is my diploma project + a real project that I want to bring to the level of a full-fledged working product.
✅ The project is already deployed and running on hosting (test/production version available online, link will be provided in private messages).
I need a developer (or a small team) who can carefully complete the existing code, expand functionality, and clean up the design/structure without rewriting from scratch.
Current stack
- Backend: Python, Flask
- Database: SQLite
- Frontend: HTML, CSS, Bootstrap 5, Jinja2
- Reports: Excel (openpyxl)
- AI assistant: integration with Groq (Llama 3.x) for answering user questions in CRM
- Deployment: already configured (details will be provided during collaboration)
What has already been implemented
- User registration / authorization
- Product accounting (categories, prices, stock)
- Client accounting
- Order creation, order list
- Excel report generation
- Basic AI assistant in CRM (via Groq API)
- Basic admin panel + templates on Bootstrap
- The project runs locally and is already online
Main tasks for completion
Work can be done in stages, in blocks.
1. Refactoring and code structure
- Split the large app.py into modules / blueprints (auth, products, clients, orders, reports, ai_helper).
- Move config, DB, working services into separate files (config, models, services, utils).
- Make the code more readable and maintainable.
2. Database and performance
- Prepare the DB structure for 10,000+ products (indexes, optimization).
- Implement pagination, filters, search for products/clients/orders.
- Optionally: consider transitioning to PostgreSQL in the future.
3. Expanding CRM functionality
- Product card: photo, description, brand, serial number, warranty, etc.
- Client card: client type, discounts, purchase history.
- Dashboard: turnover, number of orders, top products, top clients.
- More flexible reports (periods, filters, different export formats).
- User roles: admin / manager / viewer.
4. Development of AI assistant
- Establish stable integration with Groq API (error handling, timeouts).
- Configure the prompt so that AI:
- can answer questions based on the database (products, clients, orders),
- helps search for products / create orders.
- Organize a separate chat page with dialogue history.
5. UI/UX and responsiveness
- Clean up responsiveness (currently looks awkward on mobile).
- Unify the style of all pages.
- Proper tables, buttons, modal windows, system messages.
6. Documentation
- Describe how to deploy locally, how to update, where everything is located in the project.
- Brief overview of modules/structure for future developers.
Important: the deployment is already working, the task is not to build everything from scratch, but to improve, optimize, and expand.
Who I am looking for
- Experience with Python + Flask.
- Understanding of web project structuring.
- Experience with SQL (SQLite / PostgreSQL).
- Basic frontend: HTML, CSS, Bootstrap, responsive layout.
- Plus will be:
- experience with LLM / AI API (OpenAI, Groq, others),
- experience in developing CRM/ERP/admin panels.
What I ask to specify in the response
- Your experience with Flask / similar projects (1–3 sentences).
- Link to GitHub or completed projects.
- Estimated:
- price for the first stage (refactoring + basic UI fix),
- hourly rate.
- Are you interested in long-term cooperation (further development and support of CRM).
