Operations Dashboard

Overview of plumbers, scan rewards, and cloud sync

Total Plumbers

0

0 verified
👷

Pending KYC

0

Requires verification
🛡️

Points Issued

0

Scan points awarded
⭐

QR Codes

0

0 claimed
🏷️

Pending Plumber KYC Approvals

Plumbers waiting for document verification before points activation

Name Phone City & State Gov ID Type ID Number Action
Loading pending verifications...

Recent Point Transactions

Live ledger of plumber scan rewards and redemptions

Date Plumber Phone Type Details Points
No transactions yet

Supabase PostgreSQL Database Configuration

Direct REST integration credentials for Inavia Rewards cloud backend

Disconnected
Security Note: These database credentials are kept exclusively on this Web Operations Portal. They have been stripped from the mobile app to ensure end-users/plumbers cannot view or modify backend configs.
Found in Supabase Dashboard → Project Settings → API
Public Anon Key or Service Role Key with RLS bypass

Complete PostgreSQL Schema (DDL) Script

Run this script in Supabase SQL Editor to initialize all 7 tables with RLS policies and seed data

Loading SQL Schema...

Plumber Registration & KYC Queue

Verify applicant Aadhaar / PAN documents and activate plumber membership

Plumber Name Mobile Number Location Gov ID Type ID Number Status Actions
Loading KYC list...

Plumbers Directory & Points Ledger

Directory of registered plumbing contractors, current loyalty tiers, and balances

Name Mobile (+91) City, State Loyalty Tier Current Points Status Action
Loading plumbers...

Inavia Product Master Catalog

Configure bath fittings, sanitaryware, MRP, and scan reward points

SKU Code Product Name Category MRP (₹) Reward Points Warranty Actions
Loading products...

Generate Tamper-Evident QR Code Stickers

Produce unique serial QR codes to affix inside Inavia product packaging

Print-Ready Sticker Label Sheet

Showing 0 generated stickers

Click "Generate Batch" above to produce QR stickers for your packaging

Plumber Gift Redemptions & Dispatch Queue

Track reward requests, courier shipments, and tracking AWB numbers

Order # Plumber Gift Item Points Spent Delivery Address Status Action
Loading gift claims...

Loyalty Tier Configuration

Dynamic multiplier rates and milestone rules stored in Supabase

Tier Name Min Lifetime Points Scan Multiplier Badge Color Perks Description
Bronze
Silver
Gold
Platinum