Case study / Published Completo product
One view of stock, sales and purchasing.
An inventory and point of sale app built on Google Sheets and Apps Script.
The business problem
Product records, sales and supplier purchases held in separate sheets can obscure what is in stock and what needs replenishing.
Intended users
Small retailers, independent sellers and businesses managing physical products.
Requirements & constraints
- Maintain products, SKUs, prices and minimum stock thresholds.
- Update stock when a sale is recorded or a purchase order is received.
- Provide a useful daily operations dashboard.
My contribution
Created and published the Google Sheets inventory and POS system, including backend and HTML source files and sample product data.
How the workflow functions
- Create product records and minimum stock levels.
- Record a POS sale and produce a printable receipt.
- Create supplier purchase orders and mark received stock.
- Review revenue, stock value and low-stock alerts on the dashboard.
Design choices
- Keep an editable Google Sheet behind the interface so records remain inspectable.
- Connect sales and purchase receiving to stock updates to reduce repeated entry.
- Make low-stock thresholds configurable for different products.
Demonstrated functionality
The published application demonstrates connected product, sales and purchasing workflows. No verified customer adoption or stock-accuracy measurements are available.
Limitations & possible improvements
- Initial Apps Script deployment and Google authorization are required.
- Marketplace channels are recorded manually and do not automatically synchronize.
- Payment gateway processing is outside this tool.
A custom implementation could add import validation and reconciliation appropriate to the user’s sales channels and stock process.