Sales Trend (Last 30 Days)
Stock Health
Top 10 Best Sellers
Top 10 Slow Movers
Daily Sales Trend
Sales by Store
Sales by Category
Top 10 Best Sellers / Slow Movers
Stock by Warehouse
Sell Through Rate
Stock Alerts
Shipment Submission
Submit a PO/DO and tracking number for an inbound restock shipment. The Super Admin is notified immediately.
Profile
Profile and logo changes are reviewed by the Super Admin. Your current details stay in place until the request is approved.
My Change Requests
Preferences
Brand Logo
Upload a square logo shown in the sidebar and login screen.
Dashboard
Company-wide performance and operational status
Inventory Health
company-wideRestock Summary
by priorityCritical Stock Summary
Sales by Brand
top 10 · unitsSales by Store
unitsTop 10 Best Sellers
Top 10 Slow Movers
stocked, lowest velocityRaw Data Sources
Google Sheets CSV · Super Admin onlyThe portal runs entirely on two RAW data feeds — no processed Master Data file is uploaded anywhere. Every KPI, chart, table and report on every dashboard (AUR, UPT, ASP, Sell Through, Days Cover, Growth %, Stock Health, Restock Recommendations, and more) is calculated automatically by the Data Processing Engine from these two sources. Publish each sheet to the web as CSV (File → Share → Publish to web → select the sheet → format: Comma-separated values (.csv) → Publish) and paste the links below. Only the Super Admin can add, edit, or replace a link, and every change requires the Admin PIN plus a confirmation step.
Transaction-level sales records — one row per line item sold (date, store, SKU, qty, price/value).
No RAW Sales Data connected yet
—
—
—
Current stock & movement records — one row per SKU per store (opening, received, sold, return, transfer, adjustment, ending stock).
No RAW Inventory Data connected yet
—
—
—
Each link is validated (fetched and checked) before anything is saved — an invalid or unreachable link stops right there and the current data stays untouched. Syncing is additive: refreshing Sales never touches Inventory, and vice versa, so both feeds can update on independent schedules. Every time a link is updated or removed, the data that was active immediately before is archived automatically to a Google Drive backup folder (Year → Month → Date) — nothing is ever deleted. Connect Google Drive under the Google Drive Backup tab to enable this archiving.
Product Master / Price List
optional · SKU → selling priceIf the RAW Sales Data doesn't carry a price column, upload a price list here so the engine can calculate value-based KPIs (AUR, ASP, Inventory Value, Sales Value).
File Archive
Year → Month → Daily Syncs · kept permanentlyBrands cannot change their own display name, brand name or logo directly — each change waits here for your decision.
Google Drive Backup
OAuth 2.0Connecting requires your own Google Cloud OAuth 2.0 Client ID (this static portal ships with none). Create one in Google Cloud Console with the Drive API enabled, paste it below, then connect. Real OAuth also requires this page be served over http/https with that origin authorized.
PIN Management
Brand Management
Upload Settings
Inventory Settings
Stock health bands (days cover):
Restock Settings
Recommended Restock Qty = (Average Daily Sales × Par Level) − Current Stock. Priority follows the stock health band: Critical or Low stock → Critical, Healthy under the cutoff → Medium, otherwise Low.