Dashboard
Recent Transactions
| Date | Product | Type | Qty | Value (RM) | Supplier / Destination | Taken By | Recorded By |
|---|
Products
| Product Name | Category | Active Ingredient | Unit | Stock | Value (RM) | Status |
|---|
Back to Products
Analytics
Monthly Usage — All Products (2026)
Suppliers
| Company Name | Contact Person | Products Supplied |
|---|
Workers
| Name | Role | Status |
|---|
Reports
Generate and export inventory reports
Settings
Connected — Last synced just now
Currently set to every 5 minutes. The app fetches data from Google Sheets and checks for discrepancies at this interval.
Setup Instructions:
- Create a new Google Sheet with 3 tabs: "Products", "Transactions", "Summary"
- Go to Extensions → Apps Script
- Paste the Apps Script code (provided separately)
- Deploy as Web App → Execute as "Me" → Access "Anyone"
- Copy the deployment URL and paste it above