VAMBRACE AI

Week 3 Review

Green Horizons Digital Modernization

October 15–22, 2025

Status: Comprehensive Customer Portal Specification completed. Full technical architecture, feature roadmap, and implementation plan delivered.

Week 3 At a Glance

Customer Portal Overview

Self-service capabilities • Account management • Service history • Quote requests • Stripe payment processing

Technical Architecture

Next.js 14 + Stripe integration • MySQL 8.0 compatibility • ColdFusion-compatible data format • NextAuth.js authentication

Database Schema & Service Catalog

1.4M historical services • 229+ service offerings • New portal tables • Stripe product mapping • Transaction safety

Interactive Quote Calculator

Deep Lawn AI-powered pricing • Real-time calculations • Property size input • Service selection interface

Week 3 delivered a comprehensive Customer Portal Specification with complete technical architecture, database integration strategy, and implementation roadmap for January 1, 2026 launch.

Customer Portal Overview

A modern, self-service portal that empowers customers and reduces operational overhead

Core Capabilities

Account management and profile updates
Service history and upcoming appointments
Request quotes and schedule services
Invoice viewing and payment processing
Direct messaging with Green Horizons team

Business Impact

Reduces phone calls and admin workload
24/7 customer self-service availability
Faster payment collection cycles
Improved customer satisfaction scores
Data-driven insights on customer behavior

Technical Architecture

Modern Next.js portal integrating Stripe payments with legacy ColdFusion/MySQL backend

Frontend Stack

Next.js 14 with App Router
React Server Components
Stripe Elements for payments
shadcn/ui component library

Backend Integration

MySQL 8.0 (existing database)
ColdFusion-compatible data format
Stripe webhooks for order processing
NextAuth.js authentication

Critical Constraint: Cannot modify existing ColdFusion application — portal must write orders in legacy-compatible format

Database Schema & Integration

Existing database reality: 1.4M services since 2001 across 35K+ locations

Existing Tables (Read-Only)

tblcustomerlocations (35,324 rows)
tblcompletedservices (1.4M rows)
tblcustomerlogin (19,137 users)
tblorderedservices (127,880 orders)

New Tables (Portal-Specific)

tblstripe_customers (Stripe mapping)
tblservice_catalog (229+ services)
tblportal_orders (order processing)
tblportal_audit_log (audit trail)

Data Safety: All writes wrapped in MySQL transactions with idempotency keys to prevent duplicate orders

Service Catalog & Stripe Integration

229+ service offerings mapped to Stripe products for seamless payment processing

Service Categories

Type 1: Fertilization/Treatment (seasonal)
Type 2: Mowing/Maintenance (weekly)
Type 3: Premium Landscaping (one-time)
Type 4: Standard Landscaping (seasonal)

Stripe Product Mapping

Each service → Stripe Product + Price
Support for one-time and recurring
Metadata links to ServiceID/Type
Stripe Customer Portal for management

MVP Scope: Single-service orders only (95% of historical orders) — multi-service cart deferred to Phase 2

Interactive Quote Calculator with Deep Lawn

Instant pricing estimates — customers select services and see real-time price calculations

Features

Service selection with descriptions
Property size input for accuracy
Real-time price calculation
Line-item breakdown by service

Business Proposition

Sets expectations before contact
Pre-qualifies leads by budget
Reduces unqualified inquiries
Demonstrates price transparency

Technology: Deep Lawn AI-powered pricing engine • Interactive tool allows customers to explore different service combinations and see how pricing changes based on their selections

Implementation Roadmap

Target Launch: January 1, 2026 — Phased rollout to ensure quality and minimize risk

Phase 1: Core Portal (Nov-Dec 2025)

Authentication & account management
Service catalog with top 20 services
Stripe checkout integration
Service history viewing

Phase 2: Enhancements (Q1 2026)

Multi-service cart functionality
Subscription management UI
Invoice download (PDF)
Property management features

Critical Success Factor: Zero data corruption in existing tables — comprehensive testing with staging database required

Week 3 Complete

Week 3 delivered a comprehensive Customer Portal Specification that provides a complete blueprint for transforming customer engagement through modern self-service technology.

What Was Delivered

Complete technical specification • Architecture design • Implementation roadmap • ROI analysis • Risk assessment

Ready For

Development kickoff • Vendor evaluation • Budget approval • Phased implementation • Stakeholder review

Status: On Track • All Week 3 deliverables completed • Portal specification ready for implementation planning