Weekly Collection (pichle 7 din)
Renewal (pichle 5 din)
Expiring (agle 5 din)
Expired (pichle 5 din)
Monthly Collection (12 mahine)
Area-wise Summary
👥 Customers
💰 Collection (Payments)
⏰ Renewal / Expiry
📕 Due Report (Area-wise)
🎫 Complaints (Tickets)
📦 STB / ONU / Router (Serial-wise)
🧰 Material Stock (Cable, Connector...)
Stock Summary
Aane-Jaane ka Record
📈 Reports
Din-war Collection
Agent-wise Collection
Payment Mode
Company-wise Collection
🧾 GST Invoices
🗂️ Plans / Packages
🏢 Companies
Cable TV aur Broadband — dono type ki companies bana sakte hain. Har customer kisi ek company mein hota hai.
👤 Users / Staff Login
Admin = sab kuch. Staff = customers, collection, complaints (settings/companies nahi).
🔔 Notifications
💬 WhatsApp Inbox 9356249677
📣 Offer bhejo (WhatsApp)
1) Pehle apne number par test 2) Customers ko bhejo
Ek customer ko ye offer sirf ek baar jayega (dobara dabane par bache hue ko hi jayega). Kharcha ~₹0.86 + GST har deliver message. Reply WhatsApp Inbox me aayenge.
⚙️ Settings
Business Ki Jaankari
WhatsApp Message Templates
Use kar sakte hain: {name} {plan} {expiry} {due} {business}
WhatsApp Auto-Receipt (Cloud API)
Payment save hote hi customer ko WhatsApp par receipt apne aap jayegi (Shiv WiFi Broadband ke number se, approved template (neeche chuna hua)).
Webhook URL (Meta App → WhatsApp → Configuration): https://srv1962738.hstgr.cloud/webhook/whatsapp — Verify token: shivwifi-webhook-2026 — Fields: messages
Agents / Collection Staff
Har line par ek naam
Masters (Providers / Reasons)
📥 Bulk Import (Excel/CSV se customers)
1. Template download karein → 2. Excel mein bharein → 3. CSV format mein save karke yahan upload karein
⬇️ Template Download💰 Payments Import (SPECTRUM se)
spectrum_ALL_payments.csv yahan upload karein — har customer ki payment history agent ke naam ke saath judegi
📦 STB / VC / MSO Import
spectrum_STB_*.csv files yahan upload karein — har customer ka STB, VC, MSO number update hoga
📅 Activation Date Update
activation_dates.csv upload karein (company, membership, username, phone, activation) — sirf har customer ki Activation Date badlegi, baaki kuch nahi. Pehle "Check" se dekhein kitne match hue.
🔁 iCREM Sync (Activation + Expiry + Plan)
icrem_sync.csv upload karein (company, username, phone, activation, expiry, plan, validity_days, customer_price). Username se match — Activation Date, Expiry aur Plan update honge. Plan ka naam+validity iCREM jaisa hoga, price customer ki abhi wali hi rahegi (jaise "UL_150Mbps_Y ₹3690"). Pehle "Check".
🧹 Duplicate Customers
Ek hi company me same code / same phone / same username wale customers. Delete sirf us copy ka hoga jis par koi payment nahi hai.
⬇️ Excel (CSV)