Dashboard Overview
Real-time interactive metrics & live MySQL database analytics.
Active Category A List (15038)
Full registered field users, loyalty point balances, and pan verifications from splicelam_db.
| Details | Name | User Type | Category | Mobile No | City | State | District | Pincode | Total Points | Total Redeem | Bonus | Points | Action | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading users from MySQL database... | ||||||||||||||||||
QR Code List (3531320)
| Details | Company | Product Category | User Category | Product Name | Product Code | Points | Group ID | Qrcode Number | Valid To | Valid From | Dealer | Action | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading QR inventory from MySQL database... | |||||||||||||
Generate QR Code
QR Code Information Form
Qrcode
Qrcode Details
Edit QR Code
QR Code Information
All Dealer Points (337)
View, filter, manage status, and export B-Client dealer point allocations from splicelam_db.
| ID | Dealer | Points | Total Points | Status | Invoice | Invoice Date | Created At | Admin Comment | Action |
|---|---|---|---|---|---|---|---|---|---|
| Loading dealer points... | |||||||||
Pending Lead Data List (0)
View, search, export, and manage field leads fetched from splicelam_db.
| Sr. No. | Client Name | Client Phone | Product Names | Address | Comment | Sales Person | Sales Person Mobile | User Name | User Phone | User Type | App | Created | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading lead data from MySQL database... | |||||||||||||
Sales Executive List (0)
Sales executive directories, team hierarchies, and monthly sales target achievements.
| ID | Name | Mobile | Job Role | City / State | Team Members | Status | |
|---|---|---|---|---|---|---|---|
| Loading sales executives... | |||||||
Manage Business Client (0)
Authorized plywood & laminate business clients, point allocations, and transfer approvals.
| ID | Client Name | Mobile No | GST / Business | City / State | Sales Executive | Status | |
|---|---|---|---|---|---|---|---|
| Loading business clients... | |||||||
Business Client Assigned Points (207)
Dealer distribution, distributor point transfers & account manager sales point allocations.
| Business Client Name | Mobile | Business Name | Invoice Number | Invoice Qty | Product Name | Invoice Date | Total Assigned Points | |
|---|---|---|---|---|---|---|---|---|
| Loading B Client Sales Points... | ||||||||
Pending Enquiries List (0)
View, filter, manage and export user support enquiries from splicelam_db.
| Details | Name | User Type | Mobile | State | City | District | Action | ||
|---|---|---|---|---|---|---|---|---|---|
| Loading enquiries... | |||||||||
Category A Reward Points List (0)
View, filter, manage, and export loyalty reward point allocations from splicelam_db.
| Details | First Name | Dealer Name | Sales Executive Name | User Type | Member Id | Category | Product Name | Qrcode Number | Reward Point | Created |
|---|---|---|---|---|---|---|---|---|---|---|
| Loading rewards from MySQL database... | ||||||||||
Bank Redeem Status List (0)
View, filter, manage status, and export field user reward redemptions & TDS payouts.
| Sr. No. | User Name | Member Id | Total Points | Redeem Points | Balance Points | Next Redemption Date | Ratio | Total Amount | Redeem Amount | Balance Amount | Bank Name | Branch Name | A/C Number | IFSC Code | Sales Executive | Transaction Date | Created |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading redeems from MySQL database... | |||||||||||||||||
Executive Analytics Report
System analytical reports for sales representatives, manufactured QR codes, users, and business clients.
| Details | ID | Name | Mobile | City / State | Total Registered Users | Total Leads Given | |
|---|---|---|---|---|---|---|---|
| Loading report metrics... | |||||||
Manage Product Category
Manage laminate sheet categories, product codes, points allocation, and status.
| Sr. No. | Category Title | Company Name | Created | Action | |
|---|---|---|---|---|---|
| Loading product inventory... | |||||
Pending Claimed Offer List (0)
View, filter, export, and manage B Client claimed offer requests from splicelam_db.
| Sr. No. | Offer Title | Offer Point | Business Client Name | Mobile | City | State | Pending At | Status | Remarks | Claimed At | Action |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading claimed offers from MySQL database... | |||||||||||
Category A Bank Setting (0)
Manage carpenter & contractor point-to-cashback conversion values.
Search Filters
| Sr. No. | Title | Redeem Value | Cashback Value | Created | Actions |
|---|---|---|---|---|---|
| Loading Bank Settings... | |||||
Category A Gift Setting (0)
Manage reward point threshold settings for claiming physical gifts & trips.
Search Filters
| Sr. No. | Category | Point | Gift Value | Gift Image | Created | Action |
|---|---|---|---|---|---|---|
| Loading Gift Settings... | ||||||
Referral setting List (0)
Configure bonus points awarded when users invite new carpenters or contractors.
Search Filters
| Sr. No. | Referrer Role | Referred Role | Point | Created | Action |
|---|---|---|---|---|---|
| Loading Referral Settings... | |||||
Lead Point Setting List (0)
Set reward point tiers based on sales lead amount ranges.
| Sr. No. | Min Amount | Max Amount | Point | Action |
|---|---|---|---|---|
| Loading Lead Point Tiers... | ||||
Sales Executive (0)
Manage monthly target values and status for sales representatives.
Search & Filter
| ID | Name | Mobile | Monthly Target | Status | Actions | |
|---|---|---|---|---|---|---|
| Loading Sales Executives... | ||||||
Star Master Configurations
System parameters, permissions, categories, and tier setups.
| ID | Title / Name | Code / Category | Status / Details |
|---|---|---|---|
| Loading master configuration... | |||
Promise Dashboard Overview
Splice Promise Warranty, User & Enquiry real-time analytics.
Total Promise Users
Live DB--
-- Active • -- Inactive
Pending Warranty
Action Required--
Warranty card requests awaiting approval
Approved Warranty
Active Cards--
-- total warranty cards logged
Support Enquiries
CRM--
-- Done • -- Total
Promise Users Distribution
Click slice to filterWarranty Card Requests Status
Click slice to filterPromise Warranty Card Requests
Digital warranty request management, customer verification, and approval workflow.
| Request ID | Customer Name | User Type | Mobile No | Email ID | Total QRs | Requested On | Status | Action |
|---|---|---|---|---|---|---|---|---|
| Loading warranty cards from splicelam_db... | ||||||||
Promise Users
Registered Promise application consumers, fabricators, and architects.
| #ID | Full Name | User Type | Mobile No | Email ID | City / State | District / Pin | Created At | Status | Action |
|---|---|---|---|---|---|---|---|---|---|
| Loading Promise users from splicelam_db... | |||||||||
Promise Enquiries
Customer feedback, warranty inquiries, and support tickets from Splice Promise.
| #ID | Customer Name | Mobile No | Email ID | Location | Enquiry Message | Created At | Status | Action |
|---|---|---|---|---|---|---|---|---|
| Loading Promise enquiries from splicelam_db... | ||||||||
User Details
Comprehensive user account information, activity logs, and redemption summary.
| Sr. No. | First Name | Member Id | Category | Dealer | Invoice | Product Name | Qrcode Number | Reward Point | Created |
|---|---|---|---|---|---|---|---|---|---|
| No record found. | |||||||||
Virtual Dealer Details
Comprehensive dealer account information, document checklist, lead performance, and margin earnings.
| # | Customer Name | Customer Mobile | City / State | Assigned Sales Exec | Deal Amount | Margin % | Pending Points | Matured Points | Status | Created |
|---|---|---|---|---|---|---|---|---|---|---|
| No leads recorded. | ||||||||||
Virtual Dealer (VD) Registrations
Manage VD onboardings, verify payments, approve KYC documents, and track kit delivery.
| # | VD Certificate ID | Name / Business | Contact Info | Location | Payment Status | Registration Status | Kit Delivery | Created Date | Actions |
|---|---|---|---|---|---|---|---|---|---|
| Loading Virtual Dealers... | |||||||||
VD Area & Regional Configuration
Allow or disallow multiple states/cities for Virtual Dealer operations, and review VD service area applications.
Global VD Availability Master Switch
When enabled globally, all users across India can register and browse VD services unless a specific state or city is explicitly disallowed below.
| # | Configuration Scope | State | City / Cities | Service Status (Allowed / Blocked) | Last Updated | Action |
|---|---|---|---|---|---|---|
| Loading area configurations... | ||||||
Products & VD Pricing Management
Maintain tiered product pricing (MRP, Distributor, Dealer, VD Price) and configured margin % limits.
| # | Product Code | Product Name | Category | MRP (₹) | VD Price (₹) | Margin Limits (Min - Max %) | Status | Action |
|---|---|---|---|---|---|---|---|---|
| Loading products & pricing... | ||||||||
VD Customer Lead Management
Centrally review leads, inspect quotation files, assign sales persons, negotiate margins, and complete deals.
| # | Customer Name & Contact | Virtual Dealer & Tier | Location | Quotation | Assigned Sales Exec | SLA & Follow-up | VD Margin & Handshake | Deal & Payment Collection | Points Maturity | Action |
|---|---|---|---|---|---|---|---|---|---|---|
| Loading leads... | ||||||||||
Sales Person Assigned Leads
Track assigned sales team performance, follow-up timelines, remarks, and deal conversions.
| # | Customer Info | Virtual Dealer | Deal Amount (₹) | Proposed Margin % | Status | Date Assigned | Actions |
|---|---|---|---|---|---|---|---|
| Select a Sales Executive to view assigned leads. | |||||||
VD Points & Redemption Requests
Manage Deal Bonus point payouts, verify bank / UPI details, process approvals, and record transaction references.
| # | Redeem ID | Virtual Dealer | Points | Amount (₹) | Payment Mode | Bank / UPI Details | Status | Transaction Ref / UTR | Requested Date | Actions |
|---|---|---|---|---|---|---|---|---|---|---|
| Loading redemptions... | ||||||||||
Festive & Seasonal Offers (Splice VD)
Create and manage limited-time festive bonanzas (Diwali, Navratri, New Year), seasonal sprints, and partner reward campaigns.
| # | Offer / Campaign Name | Type & Badge | Validity Window | Target Qualification | Reward / Gift Item | Claims (Appr / Total) | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| Loading Festive & Seasonal Offers... | ||||||||