Software EngineeringArtificial Intelligence (AI)Verified engineering case
Stockly — Gestion de stock et commerce de proximité
A centralized web platform to manage inventory, sales, and supplies.
Stockly digitizes the operations of a local business: catalog, inventory, suppliers, orders, customers, and sales. Its dashboard brings together business indicators, low-stock alerts, and marketing advice generated from available data.
01. Context & Challenge
Problem addressed
Small shops need to centralize the tracking of goods and business operations in order to limit manual errors, track stockouts and consult their activity indicators.
02. Engineering Goals
Objectives
Centralize the management of products, categories, suppliers, customers, orders, and sales.
Ensure the traceability of stock movements and prevent exits exceeding available stock.
Secure user access and administer accounts according to their roles.
Provide performance indicators, low stock alerts, and Excel exports.
Offer marketing assistance generated from trade statistics.
03. Architecture & System
Architecture
Stockly associates an Angular interface with a secured Spring Boot API. Sales, delivered order, and stock movement operations update the stock in MySQL; the dashboard consolidates data, displays charts, and queries an AI service to generate marketing advice or product descriptions.
Architectural components & pipeline
›User
›Angular web application
›JWT interceptor and route guard
›Spring Boot REST API
›Spring Security filter and JWT authentication
›Business controllers
›Product, stock, sales, order, user, export, and dashboard services
›JPA / Hibernate layer
›MySQL database
›Groq AI service for descriptions and marketing advice
›SMTP service for email address verification
›Nginx for serving containerized frontend
04. Metrics & Outcomes
Documented results
The Angular production build completes successfully.
The JPA model defines 13 persisted entities, including users, products, movements, sales, orders, lines, customers and suppliers.
The application implements management of sales, orders, inventory, users, Excel exports, charts and low stock alerts.
Sales that are under-stocked are rejected by the business logic before stock deduction.