| No | Firm on record | Contact held | Products field | Gap |
|---|---|---|---|---|
| P 41 | Deepam Electricals | Ph 2745xxx | House Wiring Materials | Landline only |
| P 58 | Kadavil Traders | Ph 280xxx | Fans (brand name in field) | Product not tagged |
| L 617 | Sreelakam Agencies | Contact person only | Electrical Goods | No number |
| L 1104 | Vaishnav Switchgear | Ph 27127xxx | MCB RCCB DB etc. | Address outside Kerala |
| L 1892 | Anandhu Power Systems | Ph 2701xxx | Winding Wires | No GST on file |
| O 9 | Thejus Electricals | Mobile held offline | Light Fittings (Fancy) | Reachable |
| Role | Browse directory | See contacts | Post requirement | Send quote | List stock | Verify own unit | Manage all members | Publish price list | Reports |
|---|---|---|---|---|---|---|---|---|---|
| Public visitor | ✓ | — | — | — | — | — | — | — | — |
| Member firm | ✓ | ✓ | ✓ | ✓ | ✓ | — | — | — | Own only |
| Unit office-bearer | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | — | — | Own unit |
| KETA admin | ✓ | ✓ | ✓ | — | — | ✓ | ✓ | — | ✓ |
| Brand account | ✓ | Dealers only | — | — | — | — | — | ✓ | Own only |
| As recorded today | Category | Item | Also asked as |
|---|---|---|---|
| House Wiring Materials | Cables & Wires | House wiring cable | വയർ, ഹൗസ് വയറിംഗ് |
| Winding Wires | Cables & Wires | Winding wire | വൈൻഡിംഗ് വയർ, കോയിൽ വയർ |
| ANCHOR MCB RCCB DB etc. | Switchgear | MCB, RCCB, Distribution board | എംസിബി, ഡിബി, ബോർഡ് |
| Fans (Padmini) | Fans | Ceiling fan | ഫാൻ, സീലിംഗ് ഫാൻ |
| Light Fittings (Fancy) | Lighting | Decorative fitting | ഫാൻസി ലൈറ്റ് |
| Amplifiers, Sound Equipments | Audio & PA | Amplifier, PA speaker | ആംപ്ലിഫയർ, മൈക്ക് സെറ്റ് |
| Airconditioners, Aircoolers & Telephones | Split into 3 | AC · Air cooler · Telephony | എ.സി, കൂളർ |
| Electrical Goods | Too vague | Firm re-tags at re-registration | — |
| Firm | Unit | Type | Deals in | Member | Status |
|---|---|---|---|---|---|
| Deepam Electricals | Ernakulam | Retail, Distribution | MCB, RCCB, DB, Cables | Patron · 1985 | Verified |
| Anandhu Power Systems | Ernakulam | Distribution | Switchgear, Winding wire | Life · 1994 | Verified |
| Marikar Electric Co. | Ernakulam | Distribution | MCB, Changeover, Starters | Life · 2001 | Verified |
| Thejus Electricals | Ernakulam | Retail | DB, Modular switches | Ordinary · 2019 | Pending review |
| Kadavil Traders | Ernakulam | Agency | Switchgear, Fans | Patron · 1989 | Verified |
| Vaishnav Switchgear | Ernakulam | Manufacturer | Distribution boards | Life · 1997 | Pending review |
| How the member asked | Language | Understood as | Action |
|---|---|---|---|
| തൃശൂരിൽ വൈൻഡിംഗ് വയർ ഡീലർമാർ | Malayalam | Cables & Wires › Winding wire · Thrissur | Directory |
| palakkad il submersible cable und? | Transliterated | Cables & Wires › Submersible cable · Palakkad | Directory |
| who supplies LED panel lights in Kozhikode | English | Lighting › LED panel · Kozhikode | Directory |
| 1.5 വയർ റേറ്റ് എത്ര? | Malayalam | House wiring cable 1.5 sqmm · rate enquiry | Requirement |
| ബോർഡ് ഉണ്ടാക്കുന്ന ആളുകൾ | Malayalam | Switchgear › Distribution boards · Manufacturer | Directory |
| Surface | Malayalam | How it works |
|---|---|---|
| Interface labels, buttons, errors | Full | ~1,100 strings, both languages |
| Member data entry | Accepted | Firm name, address, remarks accepted in Malayalam script |
| Product tags | Both stored | English is the key, Malayalam is displayed |
| WhatsApp notifications | Full | ~30 templates, sent in the member's chosen language |
| Receipts and PDFs | Full | Needs a Malayalam font embedded in the PDF |
| Membership no, GSTIN, mobile | English | Identifiers stay as issued |
| Auditor and registrar reports | English | Statutory filings stay in English |
| Firm | Unit | Brand offered | Rate | Available | Delivery | Terms | |
|---|---|---|---|---|---|---|---|
| Marikar Electric Co. | Ernakulam | ISI marked | ₹ 412 / no | 240 nos | 2 days | 15 days | |
| Anandhu Power Systems | Ernakulam | ISI marked | ₹ 418 / no | 240 nos | Same day | Against delivery | |
| Deepam Electricals | Ernakulam | ISI marked | ₹ 405 / no | 140 nos | 2 days | 30 days | |
| Kadavil Traders | Ernakulam | ISI marked | ₹ 424 / no | 240 nos | 3 days | 15 days | |
| Neelima Agencies | Thrissur | ISI marked | ₹ 399 / no | 240 nos | 4 days | Advance | |
| Vaishnav Switchgear | Ernakulam | Own make | ₹ 388 / no | 90 nos | 5 days | Against delivery |
| Type | Item | Brand | Qty | Firm | District | Posted |
|---|---|---|---|---|---|---|
| Surplus | LED panel 18W round | House brand | 1,100 nos | Thejus Electricals | Ernakulam | Today |
| Need urgent | Submersible cable 3 core 4 sqmm | Any ISI | 800 m | Nirmal Pumps & Cables | Palakkad | Today |
| Surplus | Ceiling fan 1200mm | Discontinued model | 62 nos | Kadavil Traders | Ernakulam | 1 day ago |
| Need urgent | RCCB 63A 100mA | Any | 45 nos | Marikar Electric Co. | Ernakulam | 1 day ago |
| Surplus | Modular switch 6A one way | Overstock | 3,400 nos | Neelima Agencies | Thrissur | 2 days ago |
| Surplus | Starter DOL 3 HP | House brand | 28 nos | Anandhu Power Systems | Ernakulam | 3 days ago |
| Expiring | PVC conduit 25mm | Any | 900 lengths | Deepam Electricals | Ernakulam | 6 days ago |
| Switchgear range · v9 | Live |
| Wires & cables · v6 | Live |
| Lighting · v4 | Superseded |
| Monsoon dealer scheme | till 30 Sep |
| MCB slab offer | till 15 Sep |
| New dealer onboarding | open |
| Unit | Fee head | Firms billed | Collected | Pending | Status |
|---|---|---|---|---|---|
| Ernakulam | Annual subscription | 96 | ₹78,400 | ₹9,600 | On track |
| Thrissur | Annual subscription | 71 | ₹54,200 | ₹11,300 | On track |
| Kozhikode | Annual subscription | 64 | ₹31,900 | ₹24,700 | Behind |
| All units | Annual conference fee | 212 | ₹96,300 | ₹15,900 | Closing 05 Sep |
| All units | Brand listing invoice | 3 | ₹24,000 | ₹0 | Settled |
| Unit | On register | Verified | Signed in 30d | Requirements | Status |
|---|---|---|---|---|---|
| Ernakulam | 388 | 241 | 102 | 24 | Leading |
| Thrissur | 261 | 147 | 61 | 15 | On track |
| Kozhikode | 247 | 88 | 34 | 9 | Needs a push |
| Kollam | 184 | 52 | 18 | 4 | Behind |
| Kannur | 171 | 96 | 41 | 11 | On track |
| Time | User | Action | Reference |
|---|---|---|---|
| 09:14 | Ernakulam Unit Secretary | Verified member details after OTP confirmation | L 1104 |
| 09:31 | Deepam Electricals | Updated product tags, 1 added, 2 removed | P 41 |
| 10:02 | KETA Admin | Approved brand account and rate card | BRD-07 |
| 10:47 | Marikar Electric Co. | Sent quote against requirement | REQ-2026-0841 |
| 11:20 | Ernakulam Unit Secretary | Marked inactive — firm closed, reason recorded | L 617 |
| 12:05 | KETA Admin | Exported verification status report, all units | RPT-0219 |
| 13:38 | Thejus Electricals | Posted surplus stock listing, expires 27 Aug | STK-1188 |
| 14:52 | Anandhu Power Systems | Released contact to buyer on requirement match | REQ-2026-0841 |
| 15:26 | KETA Admin | Changed role — unit office-bearer added, Kollam | USR-0341 |
By signing below, the undersigned confirm that the workflow described in this walkthrough is a true representation of the process to be supported, and that the proposed roles, permissions, dashboards and reports are acceptable. Signing commits the workflow and the scope of Phases 1 and 2. Phases 3 and 4 remain subject to a separate approval. Dates will be added once the open items on slide 22 are settled.