1. Open your Google Sheet → Extensions → Apps Script
2. Paste the Code.gs content → Save
3. Run "setupSheets" once
4. Deploy → New Deployment → Web App
5. Copy the URL and paste it above
Continue offline (no sync)
📲 Add to Home Screen
TRX
Fans+
Stock Manager
—
📅
Display ☀️ Morning
🎉Promotion — set image in Settings
📋 Display 模式 — 填剩餘陳列數量,Save 後記錄到 Activity Log。
📦 No delivery recorded for this date
Offline mode · built-in items
Loading items…
Items
0
Total Qty
0
Overview
—
Today's Stats
📦
0
Stock IN
🏪
0
Display
🚚
0
Transfer OUT
✅
0
Est. Sold
By Category
Sync & Export
☁️
Sync from Google Sheets
Pull latest entries from shared sheet
›
📊
Export CSV
For TRX_FANS_Generator.py
›
0 / 0
自動輪播中
‹
›
✕
數量欄是「修正成最終值」,不是再加一次 IN
←History
History
Recent entries
Past Entries
Settings
Configuration
Operator
👤
Current Operator
➕
Add Staff Name
›
Promotion Banner
📢
Show Promo Banner
🖼️
Upload Banner Image
800×110px
🗑️
Clear Banner Image
Display
↕️
Category Order
Drag to reorder
›
Google Sheets Connection
🔗
Apps Script URL
Not set
›
🧪
Test Connection
Tap to test
↻
Force sync items from Sheets
–
📄
Open Google Sheet
↗
Notifications
🔔
Daily reminder
⚠️
Negative stock alert
Data
📊
Export all entries as CSV
🗑️
Clear local item cache
About
📦
Items loaded
–
🕐
Last synced
–
ℹ️
Version
v5.33.1 · multi-IN fix
Category Order
Drag to reorder — changes apply to tabs and item list
📦 Stock IN
🔒 KC Only · Long-press to access
Date
Add SKU
0 items queued
Clear all
Search above and tap an item to add it here.
🕘 Recent IN entries (self-check)
📅 Expiry Dates · optional
Set a default date to fill all at once, then adjust if needed