AI-Powered Inventory & Sales Tracking Web App

Overview

Managing inventory and recording sales across bloated enterprise software (NetSuite, SAP, Odoo) drains $100–$500+ every single month. On the flip side, manual spreadsheets lack real-time stock deduction, have no point-of-sale checkout screen, and are vulnerable to broken formulas and human errors.

The AI-Powered Inventory & Sales Tracking Web App is a full-stack, serverless business operating system hosted 100% inside your Google Workspace. Powered by Google Sheets, Google Apps Script, React 19, and Google Gemini AI, it delivers lightning-fast POS checkout, atomic inventory deduction, automated PDF invoice archiving in Google Drive, and an autonomous AI Copilot that forecasts stockouts and drafts restock orders conversationally.

Key Features

✨ CORE CAPABILITIES & ARCHITECTURE:

⚡ High-Speed Point-of-Sale (POS) Checkout: Select customers, add SKUs to the cart, apply discounts and taxes, and confirm orders with instant atomic stock deduction to eliminate overselling.
📦 Real-Time SKU Master Catalog: Live search, category filters, cost vs. retail price margins, dynamic stock badges (In Stock, Low Stock, Out of Stock), and product image previews stored in Google Drive.
📄 Automated Google Drive PDF Invoicing: Clean, professional invoices generated instantaneously and organized neatly into App Data - Files / Invoices [YYYY-MM] / INV-<OrderNo>.pdf in Google Drive.
🤖 Google Gemini 2.5 Flash AI Copilot: Slide-out assistant drawer with 5 native function-calling tools:
- queryInventory: Instant natural language stock queries.
- adjustStock: Rapid stock corrections and delivery logging.
- createSalesOrder: Conversational sales order entry.
- generateRestockRecommendation: Proactive velocity-based restock recommendations.
- scheduleSupplierFollowUp: Google Calendar sync for supplier deliveries.
👥 Customer CRM & Supplier Directory: Track customer lifetime spend, order history, outstanding balances, and vendor lead times with payment terms.
🛡️ Immutable Stock Audit Ledger: Every single adjustment, receipt, or sale logs a permanent audit record with before/after quantities, timestamp, and user reason.
🌐 100% Serverless & Zero Subscriptions: Single-file React 19 SPA running on Google Apps Script with zero recurring cloud hosting fees.

What Happens After Purchase?

Once your payment is successfully processed, digital delivery is fully automated:

Instant Access & Copy Screen: You will immediately see a success confirmation containing the direct link to copy the master Google Spreadsheet template into your Google Drive.
Email Receipt & Access Link: An automated email confirmation will also be sent to your inbox containing your order details and lifetime access link to the template.

How to Use

🛠️ FIRST-TIME SETUP & DEPLOYMENT GUIDE:

Copy the Database: Open the Spreadsheet template copy link provided in your receipt and click Make a copy to save it to your Google Drive.
Open Apps Script Editor: In your copied spreadsheet, navigate to Extensions → Apps Script.
Deploy Web Application:
- Click the blue Deploy → New deployment button.
- Select type Web app.
- Set Execute as: Me (your Google account).
- Set Who has access: Anyone.
- Click Deploy.
Authorize Permissions: Click Authorize access, choose your Google account, click Advanced → Go to Web App (unsafe), and click Allow for Sheets, Drive, and Calendar permissions.
Run Onboarding Wizard: Open the generated Web App URL in your browser, enter your business name, currency symbol, tax rate, and optional Gemini API key. You are ready to manage inventory and sales!