Grocery Manager

· 1 min read

Grocery store price management web app on Google Apps Script + Sheets

github

tags: webapp, google-apps-script, spa, inventory

stack: google-apps-script, google-sheets, materialize-css, clasp

What

Single-page web app for small grocery stores to manage 500-2000 SKUs — products, prices, inventory, categories, and reports.

Built entirely on Google Apps Script with Google Sheets as the database and Google Drive for image storage. No build step, no external server.

Why

Small grocery stores in Vietnam need a simple, free price/inventory management tool.

Google Sheets provides a zero-cost database that store owners already understand, and GAS eliminates hosting costs entirely.

Notes

  • 6 Sheets as DB tables (Products, Prices, Inventory, PriceHistory, Users, Categories)
  • Barcode scanner via device camera, Google price search integration
  • Role-based access (admin/viewer) using Google account emails
  • IIFE module pattern to avoid GAS global scope pollution
  • Vietnamese UI. ~11 backend .gs files + 8 frontend .html files