Sales Trend (Last 30 Days)
Sales value by day
Stock Health
Counted per SKU per store — the same article at two stores counts as two records.
Top 10 Best Sellers
Top 10 Slow Movers
Daily Sales Trend
Sales value by day
Sales by Store
Sales by Category
Top 10 Best Sellers / Slow Movers
Stock by Warehouse
Sell Through Rate
Stock Alerts
Click a card to filter the table below — click it again to clear the filter.
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.
Performance Matrix
Momentum (recent vs earlier months) against share of sales. Bubble size = sales; colour = category. Top 40 brands.
Brand League Table
Click a row to open the brand's detail.
Sales Trend
Monthly sales
Sales by Store
Where the brand sells
Top Products
Best sellers by value
Benchmark
vs category
Talking points
Auto-generated from the data — starting points for the review
Commercial · internal only
Take rate & margin — hidden from the brand-facing lens
⏳ Awaiting data — space & placement
The most important merchandising lenses need data not yet in the monthly export.