$ cd ~/repos/gestao-comercial
GestaoComercial
Desktop system for stores that sell products and also service their customers' equipment. First deployed at a toner, printer and stationery store.
Private repository: code available on request.
## Presentation
## Screen tour
The customer brings in a printer, a quote goes out, they approve it on WhatsApp, the store does the job, closes it and the inventory updates itself. Let's take a tour of the screens:
The screen that stays open all day. Red is a quote awaiting an answer, green is approved, blue is closed.
## About the project
GestaoComercial is a Windows Forms desktop system (.NET Framework 4.8) for stores that sell products and also service their customers' equipment. It grew out of the auto repair shop system, with generic names so it fits other businesses, and its first user is a toner and printer store with a stationery section.
The workflow follows the shop counter day to day: the customer brings in a printer, a quote goes out, the customer approves it on WhatsApp, the store does the job, closes the order and the inventory updates itself. Quick counter sales are created already closed.
Its strong point is the link between equipment and supplies. Each product stores the models it fits (for example "HP P1102; HP M1132"), and the match ignores case, spaces and dashes and accepts the model with or without the brand. So when an order is for a printer, the product list opens already filtered to the compatible toners, and each customer's equipment shows which supplies fit it and how many are in stock.
Products belong to departments (printing and stationery), which drive the catalog filters and the sales-by-department report. The system runs on SQLite with no server, or on PostgreSQL for several computers, with versioned migration scripts and an .msi installer built by CriadorInstalador.
## Highlights
- Order workflow quote → approved → closed, plus quick counter sales
- Products with compatible models: a printer order already filters the toners that fit it
- PDF quotes with the store's details, sent on WhatsApp with a ready-made message
- Reports: stalled quotes, sales by department, what to restock, top services and returning customers, with Excel export
- Users with per-area permissions (sell, quote, approve, close, view reports)
- Runs on SQLite (no server) or PostgreSQL, with versioned migration scripts
## Stack and languages
## Other projects
- GestaoModaSales and inventory for clothing stores: keyboard-driven POS, size and color grid, store credit, exchanges, cash register and 22 reports. Rebuilt in .NET 8 on top of GestaoComercial.
- pdf-para-epubOnline PDF to EPUB converter for reading on Kindle, Kobo and reading apps. Static front end on GitHub Pages and a Python API running Calibre in a Docker container.
- ProjetoOficinaThe system that started the family: work orders, customers and vehicles for auto repair shops.
- CriadorInstaladorA desktop tool that builds the .msi installer for a Windows Forms system, with Portuguese setup screens and a shared data folder.
- LionFinancePersonal finance API in ASP.NET Core organized in layers: Domain, Application, Infrastructure and API. Work in progress.