Legacy Database Modernisation & GoHighLevel CRM for Coolkit

The Challenge

Coolkit, a manufacturer of refrigerated van conversion kits, had accumulated years of operational data across a legacy database with a 779-column schema — a sprawling, undocumented structure that made reporting near-impossible and integration with modern tools prohibitive. Their sales and customer follow-up processes were entirely manual, with no CRM to track leads, automate follow-ups, or provide visibility across the pipeline.

The Solution

We tackled the problem in two phases. First, we performed a full audit and modernisation of the legacy database — decomposing the monolithic schema into a clean, relational structure that could be queried efficiently and integrated with third-party systems. Second, we implemented GoHighLevel as the central CRM, connecting it to the new database and configuring automated lead routing, follow-up sequences, and pipeline reporting. Sales and operations teams gained real-time visibility for the first time.

The Challenge: A System That Had Grown Beyond Control

Coolkit had been operating for years with the same core system — a database that had grown organically over time into a sprawling 779-column schema. No documentation. No clear ownership. Just a structure that held the business together through inertia.

The consequences were predictable:

Reporting was painful: Extracting meaningful data required specialist knowledge of the schema and hours of manual work
Integrations were impossible: Modern tools couldn’t connect to the legacy structure without significant middleware complexity
No CRM in place: Leads were tracked in spreadsheets. Follow-ups happened when someone remembered to do them. Opportunities slipped through the cracks

The Solution: Two-Phase Modernisation

Phase 1: Database Restructuring

We began with a complete audit of the legacy database — mapping every column, understanding the relationships, and identifying what was actively used versus legacy cruft from systems long since retired.

The audit informed a ground-up redesign: decomposing the 779-column monolith into a clean, normalised relational schema. Data was migrated, validated, and verified against the source system before the legacy structure was retired.

The result: a database that could be queried by any developer, integrated with modern tools without specialist knowledge, and maintained without fear of cascading failures.

Phase 2: GoHighLevel CRM Implementation

With a solid data foundation in place, we implemented GoHighLevel as the central CRM platform. Key deliverables included:

Lead capture integration: Website and inbound enquiry forms feeding directly into GHL pipelines
Automated routing: Leads assigned to the right team member based on product interest and geography
Follow-up sequences: Automated email and SMS sequences triggered by lead status, ensuring no enquiry goes cold
Pipeline visibility: Management dashboards showing real-time pipeline status, conversion rates, and team performance

The Result

Coolkit went from a business running on institutional knowledge and spreadsheets to one with a clean data infrastructure and an automated CRM — all without disrupting day-to-day operations during the transition.

If your business is still running on legacy systems that have become a liability, let’s talk.