Consolidated from unfulfilled orders · Article → Color → Size
Articles Out of Stock
—
unique article numbers
Unfulfilled Orders Affected
—
orders contain no-stock articles
Total Undeliverable Units
—
units cannot be dispatched
Article #
Article Name
Color
Cannot Ship ↕
Orders ↕
Status ↕
No variants match your filters
Current Inventory
Total Articles
—
unique SKUs
Total On Hand
—
units across all variants
Total Available
—
units ready to ship
Oversold Units
—
variants with negative stock
Gender
Category
Article No
Article Name
MRP
Variants
Quantity (OH/Avail)
Status
Upcoming Articles
—
Total Units
—
Next Arrival
—
Article #
Article Name
Qty
Month
No upcoming inventory matches your filters
Discontinued Articles
—
On Hand
—
Available
—
Order VolumeTop & bottom articles by units ordered this season
🏆 Top 10 by Units Ordered
📉 Bottom 10 by Units Ordered
Article
Ordered In ▴▾
Ordered ▼
Dispatched
On Hand
Quadrant
Sales VelocityFulfillment Rate vs Inventory Velocity · medians at FR 87% · Vel 47%
⭐ Stars
—
articles
Scale up · Increase buy quantities next season
🔥 Demand > Supply
—
articles
Reorder urgently · Stock is limiting revenue
📦 Overstocked
—
articles
Reduce future buys · Push through offers
⚰️ Dead Weight
—
articles
Review range · Consider liquidation
Fulfillment Rate (X axis) — of everything ordered, how much actually shipped? Low = stock couldn't meet demand.
Inventory Velocity (Y axis) — of all stock that existed, how much has moved? Low = stock sitting idle despite orders.
Live examples from your catalog:
Bubble size = units ordered · Hover for details · Click to highlight in table · Dashed lines = median thresholds
SKU
Article
Ordered ↕
Dispatched ↕
On Hand ↕
Fulfil. Rate ↕
Inv. Velocity ↕
Quadrant
Dispatch TATTurn-around time from order creation to dispatch
Median TAT
—
days (fulfilled orders)
Same / Next Day
—
orders dispatched in 0–1 days
Flagged >30 Days
—
fulfilled + open orders
Median Days Open
—
days (partial orders)
TAT Distribution
Fulfilled
Partial / Open
Fulfilled >30 days
Partial >30 days
Order Detail
Order # ↕
Retailer
Created ↕
Fulfilled / Status
TAT / Days Open ↕
Fill Rate AnalysisAcross all 144 orders
Overall Fill Rate
—
Median Order Fill Rate
—
Fully Fulfilled
—
Below 75%
—
Click a bar to search that order
Fill Rate Distribution
Each bar = one order · sorted by fill rate · hover for details · click to filter table
Order #
Retailer
Date ↕
Status
Units ↕
Fill Rate ↕
Top Cannot-Ship SKUsPending variants with zero or insufficient inventory
Monthly Sales
Monthly invoiced sales (₹ gross, GST-inclusive) with cumulative running total · source: Tally Sales Register
Channel
Total Sales
—
Invoices
—
Avg Invoice
—
Sales Register
Date ▲
Retailer ▴▾
Channel ▴▾
Sales Value (₹) ▴▾
Monthly Order Activity
Units ordered per month — stacked by Dispatched · Pending · Cancelled (retailer)
Gender
Category
Total Ordered
—
Dispatched
—
Pending
—
Cancelled
—
Dispatched Orders History
📝 Register New Issue
➕ Add User
Adding a user is a two-step process: Step 1 (here): Add the email + role to the whitelist. Step 2: Create the auth user in Supabase Dashboard with a password.
Set a password (share it with the user via secure channel)
Check "Auto Confirm User"
Click Create user
Once created, the user's profile is auto-populated with role — via the database trigger. They can immediately log in.
📂 Upload Export Files
Upload fresh Shopify exports to update the dashboard
📋
Orders Export
orders_export.csv
🏭
Inventory Export
inventory_export.csv
⏱ Recent Uploads (Last 5)
Type
Filename
Uploaded At
Total Invoiced
—
Collected
—
Credit Notes
—
Outstanding
—
Where did the money go?
Monthly Invoicing & Collection Status
Amount invoiced each month, split by what’s been collected vs still outstanding as of today. Full bar = total invoiced that month.
0–30 days31–60 days61–90 days91–120 days120+ days
Retailer
City
Channel
Balance
0–30d
31–60d
61–90d
91–120d
120+d
Salesman
Invoice
Date
Due
Retailer
Channel
Invoiced
Balance
Status
Bucket
Top 10 retailers
Ranked by selected metric
Rank by
Retailer
Invoiced
Units
Orders
Channel
New
—
First order ≤60d ago
Active
—
Ordered ≤30d ago
Slipping
—
Last order 30–90d ago
Dormant
—
90+d no order
How retailers are scored
📊 Tier (volume)
Pareto-based by total invoiced amount. A = top 20% of retailers (driving most revenue), B = next 30%, C = bottom 50%. Retailers with no invoices yet are Unrated.
💚 Health (payment)
Healthy = balance fully cleared, nothing outstanding. Watch = has outstanding balance (current invoices, or small overdue without aged dues) but manageable. At-Risk = ≥30% of balance overdue OR has invoices in 91+ days bucket.
Volume × Payment health
x: total invoiced · y: collection rate · size: units ordered · colour: dominant channel · ring: multi-channel
SportsHosieryMulti-channel
Retailer ranking
#
Retailer
City
Channel
Orders
Units
Invoiced
Outstanding
Last order
Tier · Health
Issue Tickets
Raise issues and track resolution.
⚙ ADMIN MODE
Total
0
Open
0
In Progress
0
Resolved
0
Ticket ID
Status
Title
Type
Priority
Submitter
Created
Admin
Manage users, roles, and view system audit logs.
Total Users
0
Active
0
Inactive
0
Pending Sign-Up
0
Name
Email
Role
Status
Added
Ticket Deletion Audit Log
Record of tickets deleted by admin (with snapshot of ticket metadata).
