Skip to content

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.

Inventory workflow designGoogle SheetsGoogle Apps ScriptHTML interfacesOperational reporting
Inventory Management & POS System for Google Sheets — published product interface

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

  1. Create product records and minimum stock levels.
  2. Record a POS sale and produce a printable receipt.
  3. Create supplier purchase orders and mark received stock.
  4. 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.