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

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

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

Technical solution

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.

04

Architecture

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

05

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.