StockTrack: Complete Setup & Usage Guide

Stop wrestling with spreadsheets, label-makers, and clunky inventory software. StockTrack turns a single Google Sheet into a full-featured inventory and delivery manager — products, stock movements, delivery slips, low-stock alerts, and interactive dashboards — all living in a clean dark-themed web app you open from any browser.

It runs 100% inside Google Apps Script. No Twilio, no OpenAI, no external services, no monthly SaaS fees, no data leaving your Google account. You install it once, and it is yours forever.

What You Get

• Product catalog with categories, units, min-stock thresholds, locations, and unit prices
• Stock movements — record stock in, stock out, and manual adjustments with notes
• Delivery management — create delivery slips, track status (Pending → Preparing → In Transit → Completed), auto-deduct stock on completion, print customer-ready slips
• Interactive dashboard — total products, stock value, low-stock alerts, 7-day stock flow chart, top movers
• CSV import and export for products, movements, and deliveries
• Multi-currency display — choose from 10 world currencies (USD, EUR, TRY, GBP, JPY, CAD, AUD, INR, BRL, MXN)
• Dark / light theme, keyboard shortcuts, smart filtering, sortable columns
• Sample data loader — explore every feature before entering your real products
• Full data ownership — every product, movement, and delivery lives in your own Google Sheet

Before You Start

StockTrack is self-contained. Everything it needs comes from Google — you will never be asked to sign up for a third-party service.

Step 1: Create a New Google Sheet

Open Google Sheets and create a blank spreadsheet. Name it "StockTrack" (or anything you prefer — the name is only for you).

This spreadsheet will become your inventory database. StockTrack will automatically create five sheets inside it: Products, Movements, Deliveries, Categories, and Settings. You do not need to set up any columns yourself.

Step 2: Open Apps Script

In your new spreadsheet, click Extensions → Apps Script from the top menu. This opens the built-in script editor in a new tab.

You will see a default file called Code.gs with empty content — keep it open, we will replace its content in the next step.

Step 3: Paste the Files

StockTrack is delivered as four code files plus a manifest. In the Apps Script editor, create and fill them as follows:

That is everything — four content files plus one manifest. No command-line tools, no package installs.

Step 4: Deploy as a Web App

1. Click Deploy → New Deployment (top right of the Apps Script editor)
2. Click the gear icon and select Web app
3. Set these options:
   • Description: StockTrack
   • Execute as: Me
   • Who has access: Anyone
4. Click Deploy
5. Google will ask you to authorize the app. Click Review Permissions, pick your Google account, and click Allow
6. Copy the Web App URL — this is how you and your team will open StockTrack

Bookmark this URL. You will open it every time you use StockTrack. You can also pin it as a Chrome shortcut so it feels like a native app.

First Launch

Open your Web App URL. StockTrack automatically creates the five sheets on first load, then shows the empty dashboard.

Before adding your real products, we recommend you click Settings → Load Sample Data to see how every feature works with 10 demo products already filled in. Once you understand the flow, use Settings → Re-initialize Sheets (or simply clear the Products sheet manually) and start fresh.

Try it right here — this is the actual app UI. Click any tab, try filters, open a delivery card:

Using StockTrack

Dashboard

See the health of your inventory at a glance:

• Total Products, Total Stock, Low Stock count, Inventory Value — live stats, updated as you move stock
• Products by Category donut chart
• Stock Flow (last 7 days) — green bars for stock in, red bars for stock out, grouped by day
• Recent Movements — last 10 stock changes from the last 30 days
• Low Stock Alerts — every item below its minimum threshold, with a progress bar that turns red under 50%
• Top Movers — the 5 most active products over the past month

Products

Add, edit, delete, filter, sort, import, and export products. Every product has:

• Name, category, unit (piece, box, kg, etc.), current stock, minimum stock, unit price, storage location, description

Handy touches:

• Search by name, category, or location (Ctrl+K focuses the search box instantly)
• Filter by category and Low Stock only toggle
• Sortable columns — click any header to sort ascending/descending
• Record stock movement from a product row without leaving the page
• Automatic initial stock entry — if you add a product with a starting stock greater than zero, the system records a “stock in” movement so your history is complete from day one

Movements

Every change to stock is logged — forever. You can never lose track of why a product count changed.

• Stock In — receiving goods, manufacturing output, returns
• Stock Out — sales, internal use, damages
• Adjustment — correcting count after a physical recount (sets stock to an exact value)

You see the previous stock, the change, and the resulting stock on every row, plus a free-text note. Stock-out is blocked if the quantity would take you below zero — no accidental negative stock. Movements are append-only; they cannot be edited or deleted, which protects your audit trail.

Deliveries

Create delivery slips for customer orders, supplier shipments, or internal transfers:

1. Click New Delivery and add the recipient, address, and line items (product + quantity + price per unit)
2. The delivery starts as Pending. Move it through Preparing and In Transit as you prepare and ship it
3. When you mark a delivery Completed, StockTrack automatically deducts all line items from your product stock — no separate stock-out entry needed

You can Print a clean delivery slip with your company name, line items, totals, and addresses — ready to hand to a customer.

Pending and Preparing deliveries can be edited. Once Completed or Cancelled, a delivery is locked to preserve its record.

Categories

Six default categories come pre-loaded: Electronics, Food & Beverage, Textiles, Furniture, Office Supplies, Other. Add your own, edit the defaults, or delete ones you do not use.

Settings

• Company Name — shown at the top of every printed delivery slip
• Currency — pick from 10 currencies; all prices and totals re-format instantly in your sheet view
• Theme — switch between dark and light at any time
• Re-initialize Sheets — recreates any missing sheets and restores default categories (useful if you accidentally delete a sheet)
• Load Sample Data — adds 10 example products, only works if your product list is empty

CSV Import Format

The Products tab has an Import button that accepts CSV files. You can drag-and-drop or pick a file.

Your CSV should have a header row. StockTrack automatically recognizes common header names — you do not need to match them exactly:

Only the Name column is required. If a column is missing, StockTrack fills in a sensible default (0 for stock, empty for description, etc.).

You will see a preview of the first 5 rows before the import commits. Maximum 500 rows per import.

Who Can Access Your App

StockTrack is deployed as a public web app — anyone with your Web App URL can open it and has full read/write access. This is the standard Google Apps Script configuration and keeps setup fast.

For most small businesses this is fine — you only share the URL with your team, and Google does not index it. Treat the URL like a password.

If you need stricter access:

• Change Who has access to Anyone with a Google account during deployment — then users must be logged into Google (but still no team-specific access control)
• For team-only access, use Google Workspace: change Who has access to Anyone within [your workspace]

You can change the access level anytime: Deploy → Manage Deployments → Edit the existing deployment.

Frequently Asked Questions

Do I need any paid services? No. StockTrack runs entirely inside Google Sheets and Apps Script. Both are free for personal Google accounts. There is nothing to subscribe to and no usage fees.

Does it work offline? No — Google Sheets requires an internet connection. Everything syncs automatically when you are online.

Can I use multiple currencies at once? Not currently. StockTrack displays all prices in a single configured currency. If you need per-product currency, upgrade to the Custom Build plan.

Is there barcode scanning? Not in the current version. This is a common custom feature we build under the Custom Build plan.

Can I back up my data? Yes — it is a normal Google Sheet. Use File → Make a copy in Google Sheets to create a backup snapshot anytime, or set up Google Takeout for scheduled exports.

What if I accidentally delete a sheet? Go to Settings → Re-initialize Sheets. StockTrack will recreate the missing sheet with its headers intact. Data in deleted sheets cannot be recovered beyond Google's standard version history — so we recommend not deleting sheets manually.

Can multiple people use it at the same time? Yes. Since the backend is Google Sheets, Google handles concurrent reads and writes. Click Refresh in the top bar to pull the latest data anytime.

Can I add custom fields to products? You can add extra columns to the Products sheet directly in Google Sheets, but the web app will not surface them in its forms. Full custom-field support is available under the Managed and Custom Build plans.

Is my data private? Yes. Everything lives in your own Google Sheet, inside your own Google account. We never see or touch your inventory data. The app has no external API calls and no analytics — we could not see your data even if we tried.