StockTrack: Inventory Tracking System
Stop tracking inventory in messy spreadsheets. Run a real warehouse from Google Sheets — for the price of a lunch.
A complete inventory management app for small businesses that lives right inside your Google Drive. Track stock in real time, get emailed when products run low, manage deliveries with printable slips, and handle 10+ currencies — without a single monthly SaaS fee.
The Problem
Why this matters
Inventory SaaS tools cost $30–$200 every month and force your data onto someone else's servers. Plain Google Sheets are free, but you end up with broken formulas, no dashboard, no audit trail of who moved what, and 'surprise' stockouts every other week. Your team ends up doing inventory math on sticky notes.
The Solution
How we solve it
StockTrack turns a normal Google Sheet into a polished inventory web app — same spreadsheet, but now with a dashboard, charts, a full movement ledger, delivery status workflow with auto stock deduction, multi-currency pricing, CSV import/export, and automatic low-stock emails. Your data never leaves your own Google Drive.
The Results
What you get
- Stop paying $30–$200/month to inventory SaaS — pay once, use forever
- Catch low stock before it becomes a stockout — automatic daily or weekly email alerts
- See total inventory value, low-stock items, and top movers the moment you open the dashboard
- Every stock change is logged with who/when/before/after — no more 'who took the last one?' arguments
- Create deliveries, print slips, track status — stock auto-decrements when a delivery is marked Completed
- Import your existing Excel/CSV inventory in seconds; export any table the same way
Interactive Product Tour
A click-through demo with realistic sample data. Browse tabs, filter tables, explore the UI. Save, import, and other write actions happen for real in the live app — one click away.
Key Features
Dashboard That Actually Tells You Something
Open the app and in 5 seconds see: total products, total stock, low-stock count, inventory value, products-by-category donut, 7-day stock flow, top movers of the last 30 days, and recent activity.
Automatic Low-Stock Email Alerts
Get a clean, formatted email every morning (or every Monday) listing exactly which products need restocking. Never lose a sale to a stockout again. Send a test email anytime to verify delivery.
Full Movement Ledger
Every stock change — Stock In, Stock Out, Adjustment — is logged with the product, quantity, previous stock, new stock, note, and date. No argument about who moved what can survive this.
Delivery Workflow With Auto Stock Deduction
Create deliveries with multi-line items, track status (Pending → Preparing → In Transit → Completed), and the moment you mark a delivery Completed, the stock deducts itself for every item. Print professional delivery slips straight from the browser.
10+ Currencies — Switch Instantly
USD, EUR, GBP, TRY, JPY, CAD, AUD, INR, BRL, MXN. Change the currency in Settings and every price on every page updates immediately.
CSV Import & Export
Already have your inventory in Excel? Import it in one click with a drag-and-drop CSV (up to 500 products per file). Export products, movements, or deliveries anytime for accounting, backups, or reports.
Printable Delivery Slips
Every delivery generates a professional print-ready slip with your company name, line items, totals, recipient, and address. Hand it to the driver, file a copy — done.
Light & Dark Mode
A modern interface that works however you like to work. Toggle between light and dark; your preference is remembered per user.
Google Workspace Integration
Works seamlessly with your favorite Google apps
What Does It Bring to Your Business?
Real business value, not just cool tech
Pay Once, Keep Forever
One-time payment. No monthly bills, no per-user fees, no 'we're raising prices' emails. Compare: most inventory SaaS costs $500–$2,400/year.
Your Data Stays Yours
Everything lives in your Google Drive. We can't see it, sell it, or lose it in a breach. Google's own version history is your backup.
Running in 5 Minutes
No servers to provision, no database to configure. Copy four files into Apps Script, deploy as a web app, done.
Works Anywhere
Open the web app URL on any device — desktop, tablet, warehouse phone. One link, fully responsive interface, same data everywhere.
Simple Pricing
Choose the plan that fits your needs
Standard
Script only — install it yourself, no support
- Full inventory dashboard with charts
- Automatic low-stock email alerts (daily or weekly)
- Complete movement ledger + audit trail
- Delivery workflow with auto stock deduction
- Printable delivery slips
- 10+ currency support (USD, EUR, GBP, TRY, JPY, CAD, AUD, INR, BRL, MXN)
- CSV import & export
- Light & dark theme
- Keyboard shortcuts (Ctrl+N, Ctrl+K, Esc)
- Mobile & tablet responsive
- 100% unobfuscated source code — you own it
- 1 year of free updates (renewal at 50% after)
Managed
Script + professional installation + 2 weeks free support
- Everything in Standard
- We install the script in your Google Workspace
- We configure the system & up to 5 initial product categories
- 2 weeks of priority support
Custom+
Everything in Managed + custom features built on top
- Everything in Managed
- Custom feature development on top of the script
- Tailored to your specific workflow
- Delivered via Upwork (escrow protection)
- Full source code ownership
Frequently Asked Questions
Everything you need to know
No recurring fees at all. You pay once and own the system forever. It runs entirely on a standard (free) Google account — Apps Script has a generous free daily quota that normal inventory use never comes close to hitting.
Everything lives in your own Google Drive — the spreadsheet, the Apps Script code, the deployed web app URL. MageSheet has zero access to any of it. You can open the script at any time and read or modify every line yourself.
Typically 5–15 minutes following our step-by-step guide (with screenshots) at magesheet.com/docs/stock-inventory-tracking. If you get stuck, email info@magesheet.com and we'll help you through it. Prefer to skip setup entirely? Our Managed plan includes professional installation in your workspace.
Yes. The Products page has a drag-and-drop CSV import — just map your columns and you're in. Up to 500 products per file; run the import multiple times for larger catalogs.
Yes. The interface is fully responsive — phones, tablets, desktops all work. Staff can record stock movements and check low-stock alerts from the warehouse floor.
Practically speaking, 50,000–100,000 products run smoothly. The hard ceiling (Google Sheets' 10 million cells) is around 900,000 products.
Yes — concurrent use is supported. Best for teams of 1–10 active users. Heavy simultaneous edits to the same product can conflict (same as any Google Sheet).
USD, EUR, GBP, TRY, JPY, CAD, AUD, INR, BRL, and MXN are built in. Switch anytime in Settings; every price on every page updates instantly.
Absolutely. Since you get 100% unobfuscated source code, you can modify anything yourself. Or contact us for a Custom+ engagement — we build extensions for multi-warehouse, API integrations (Zapier/Make), and mass historical data migrations. (Note: Managed tier covers system installation; bulk data entry or external API setups are scoped separately).
1 year of free updates included. When a new version ships, you get the updated files and a guide to apply them. After year 1, you keep your version forever; renewal is available at 50% of the then-current price.
Ready to get StockTrack: Inventory Tracking System?
Starting from $89