📋 Changelog
All updates and improvements to SimProSync
v1.7.3
25 Feb 2026
📦 Auto-Create Quote/Job from GHL Project Custom Objects
Latest- ✓ NEW: Auto-create quote or job in SimPro when a Project custom object is created in GHL
- ✓ Reads the Lead/Quote/Job dropdown field on the GHL Project to determine entity type
- ✓ Configurable via new "⚙️ Project Type Field" setting in GHL → SimPro field mappings
- ✓ NEW: Per-integration toggle: "Auto-create quote/job from GHL Project" in Settings
- ✓ NEW: Type change detection — changing Lead/Quote/Job dropdown from Quote to Job (or vice versa) creates the new entity in SimPro
- ✓ Type change detection uses project_sync_links table to compare previous vs current entity type
- ✓ Each type change creates a separate SimPro entity (mirrors SimPro behaviour where quotes and jobs are distinct records)
- ✓ NEW: Dedup protection via project_sync_links lookup — prevents duplicate creation when GHL workflow fires multiple times
- ✓ NEW: Creation lock (same pattern as site dedup) prevents race conditions from near-simultaneous webhooks
- ✓ Stores GHL↔SimPro links in new project_sync_links table for bidirectional tracking
- ✓ Writes project_id, quote_id or job_id back to GHL Project custom object after creation
- ✓ Loop prevention via ghl_custom_object_tracker table (5-minute TTL)
- ✓ NEW: "⚙️ SimProSync Settings" group added to SimPro fields dropdown for special configuration fields
- ✓ GHL workflow setup: "SimPROsync Projects Webhook" with Project Created/Changed triggers
v1.7.2
24 Feb 2026
🏗️ Auto-Create Site, Quote-to-Job Conversion & Loop Prevention Fix
- ✓ NEW: Auto-create Site in SimPro when a GHL contact has no existing site
- ✓ Per-integration toggle: "Auto-create site for new customers" in Settings
- ✓ Site creation uses customer name and address with dedup lock protection
- ✓ FIX: Loop prevention for site.created webhooks — site creation from unified webhook no longer triggers echo loop
- ✓ Added simpro_entity_loop_tracker table to track entities created by SimProSync
- ✓ NEW: Quote-to-Job conversion when opportunity moves to a job pipeline stage
- ✓ Pipeline stage mappings with entity_type = "job" now trigger automatic quote→job conversion in SimPro
- ✓ Conversion uses SimPro ConvertToJob endpoint with proper error handling
v1.8.1
23 Feb 2026
🛡️ Race Condition Fixes, Duplicate Prevention & Context Detection Fix
- ✓ FIX: GHL unified webhook was logging duplicate entries for single events
- ✓ Root cause: PHP script took too long processing (enrichment API calls) causing server-side request retries
- ✓ Added early 200 response — GHL now gets instant acknowledgement BEFORE heavy processing begins
- ✓ Added ignore_user_abort(true) and fastcgi_finish_request() for clean async processing
- ✓ NEW: Request ID debounce system — each webhook generates a unique 32-char ID
- ✓ Atomic INSERT...ON DUPLICATE KEY UPDATE claims the slot, then SELECT verifies ownership
- ✓ Even if two requests hit at the exact same millisecond, only one wins — the other blocks itself
- ✓ Replaces unreliable rowCount() approach which gave inconsistent results with conditional IF() updates
- ✓ unified_webhook_tracker table now has request_id column (auto-migrated)
- ✓ FIX: SimPro individual customer events were bypassing the throttle entirely
- ✓ individual.customer.updated and individual.customer.created now included alongside company variants
- ✓ FIX: SimPro webhook_processor.php had same SELECT-then-INSERT race condition
- ✓ Replaced with atomic upsert using process_count tracking for bulletproof deduplication
- ✓ FIX: Three-layer customer ID resolution in context_detection.php
- ✓ Layer 1: Raw webhook payload field display names (e.g. "Simpro Customer ID")
- ✓ Layer 2: ghl_discovered_fields table lookup (resolves GHL internal field IDs to display names)
- ✓ Layer 3: sync_links table fallback
- ✓ Previously only checked GHL internal field IDs which never matched — causing duplicate customer creation loops
- ✓ Increased GHL unified webhook debounce window from 15s to 30s
- ✓ SQL cleanup script provided to remove 107 duplicate entries from event_logs table
v1.8.0-beta
22 Feb 2026
⚡ Unified Webhook & Full Job Support (v1.8.0-beta)
- ✓ NEW: Unified Webhook Architecture — one webhook URL handles everything!
- ✓ No more separate workflows for customer.upsert, job.create, quote.create etc.
- ✓ Single GHL workflow with 4 triggers (Contact Created/Changed, Opportunity Created/Changed) replaces all individual action webhooks
- ✓ NEW: Pipeline Stage Mappings are now the Decision Engine
- ✓ entity_type column in pipeline_stage_mappings drives whether to create a Quote or Job
- ✓ Webhook automatically detects: create quote, create job, convert quote→job, or sync stage — all from pipeline stage context
- ✓ NEW: Full Job Creation support in unified webhook
- ✓ Jobs created directly when pipeline stage entity_type = "job" and no existing links found
- ✓ Applies SimPro stage/status from pipeline mapping automatically
- ✓ NEW: Customer Update support — existing SimPro customers now PATCHED when GHL contact fields change
- ✓ Previously only created new customers — now does full upsert (create if new, update if existing)
- ✓ Includes fallback: tries individuals endpoint first, then companies if that fails (or vice versa)
- ✓ NEW: Quote-to-Job Conversion
- ✓ When opportunity moves to a "job" stage but has an existing quote link, automatically converts: marks quote as Approved → creates new job from quote details
- ✓ Preserves quote site, name, and type during conversion
- ✓ NEW: Dual Entity Stage Sync
- ✓ Stage changes now sync for both quotes AND jobs based on linked_entity_type
- ✓ Updates correct link table (opportunity_quote_links or opportunity_job_links) with new stage
- ✓ NEW: Loop Prevention for unified webhook
- ✓ Sync source check: blocks echo-back if SimPro synced same contact within 15 seconds
- ✓ Rapid-fire debounce: blocks duplicate webhooks for same contact within 3 seconds via unified_webhook_tracker table
- ✓ Race condition protection via ON DUPLICATE KEY on all link table INSERTs
- ✓ NEW: Simplified GHL Mappings Page (replaces old per-action page)
- ✓ Single page with unified webhook URL, setup status sidebar, and customer field mappings
- ✓ Live status showing customer mappings, pipeline stages (quote/job breakdown), associations, and linked entity counts
- ✓ Server-side customer mapping count with AJAX fallback for reliable status display
- ✓ Links to Pipeline Stage Mappings, Association Mappings, and Status Value Mappings pages
- ✓ All existing customer field mappings carry over automatically — no remapping needed
- ✓ Keeps all features: drag-and-drop groups, searchable dropdowns, discovered fields, clone, manual entry
- ✓ Page split into modular includes (ghl_mapping_fields.php, ghl_mapping_js.php) — 1,168 lines vs 2,166 old monolith
- ✓ IMPROVED: GHL Webhook Logs page now fully supports unified events
- ✓ Unified events show proper badges: Success (green), Loop Blocked (blue), Duplicate Blocked (blue), Error (red)
- ✓ Friendly event labels: "unified.customer_update+job_create" → "Unified Customer Update+Job Create"
- ✓ New expandable "Unified Decision Context" section showing the decision engine results
- ✓ Fixed false "Ignored" badge caused by "Loop prevention checks passed" text matching legacy loop detection
- ✓ IMPROVED: Full event_logs logging on success AND error — unified webhook events now always appear in SimProSync logs
- ✓ IMPROVED: opportunity_quote_links table now stores ghl_pipeline_id, ghl_pipeline_stage_id, simpro_quote_stage columns
- ✓ IMPROVED: Reverse sync (SimPro→GHL) now reads real pipeline columns from quote links instead of NULL aliases
- ✓ IMPROVED: Production webhook INSERT statements updated to populate new quote link columns
- ✓ Fully backwards compatible — old per-action workflows still work alongside unified webhook
- ✓ Modular codebase: unified webhook split into context_detection.php, action_executor.php, entity_actions.php
- ✓ TESTED: Live production test with Definitive Electrical — customer update + job creation + loop prevention all confirmed working
v1.6.3
10 Feb 2026
🔄 SimPro → GHL Opportunity Reverse Sync (The Final Piece!)
- ✓ CRITICAL FIX: SimPro Quote updates now sync back to GHL Opportunities!
- ✓ getLinkedOpportunity() was only checking opportunity_job_links table - never checked opportunity_quote_links for quotes
- ✓ Function now checks the correct table based on entity type (quotes vs jobs)
- ✓ Added fallback to sync_links table for quotes created before this fix
- ✓ FIX: Quote creation from GHL Opportunities now saves link to opportunity_quote_links table
- ✓ Previously only saved to sync_links - reverse sync couldn't find the link
- ✓ Now saves to BOTH tables for complete coverage
- ✓ THE CIRCLE IS NOW COMPLETE: GHL Opportunity ↔ SimPro Quote ↔ GHL Project (Custom Object)
- ✓ Pipeline stage changes in SimPro now update the linked GHL Opportunity stage
v1.6.2
4 Feb 2026
🔄 Bidirectional Pipeline Stage Sync Fix & Integration ID Stability
- ✓ CRITICAL FIX: Integration IDs no longer regenerate when saving settings!
- ✓ save_settings.php was using DELETE+INSERT pattern which created new auto-increment IDs
- ✓ This broke webhook URLs, field mappings, and pipeline mappings after every settings save
- ✓ Now uses UPDATE for existing records, INSERT only for new ones
- ✓ FIX: GHL → SimPro pipeline stage sync now working for Jobs
- ✓ job_create.php now looks up pipeline_stage_mappings table to set Stage/Status
- ✓ When opportunity moves to "Job Scheduled 📆", job is created with correct SimPro status
- ✓ FIX: GHL → SimPro pipeline stage sync now working for Quotes
- ✓ quote_create.php now includes pipeline_stage_mappings lookup (was missing entirely)
- ✓ FIX: GHL → SimPro pipeline stage sync now working for Leads
- ✓ lead_create.php now includes pipeline_stage_mappings lookup (was missing entirely)
- ✓ Pipeline stage mapping applied to both CREATE and UPDATE operations
- ✓ Respects sync_direction setting (both, ghl_to_simpro, simpro_to_ghl)
- ✓ Confirmed: Bidirectional sync working - SimPro ↔ GHL pipeline stages stay in sync
v1.6.1
3 Feb 2026
🏗️ Major Code Refactoring, SimPro API Fixes & Google Drive Disconnect Fix
- ✓ REFACTOR: Modularised webhook_ghl.php from 9,712 lines to 3,826 lines!
- ✓ Split 36 helper functions into 7 dedicated modules in core/ghl/
- ✓ Split 11 action handlers into individual files in core/ghl/actions/
- ✓ Main webhook file now acts as a slim router - much easier to maintain
- ✓ Helper modules: discovery.php, simpro_api.php, ghl_api.php, enrichment.php, pipeline.php, payload_builder.php, helpers.php
- ✓ Action modules: customer_upsert.php, site_create.php, job_create.php, quote_create.php, lead_create.php, notes.php, job_create_object.php, quote_create_object.php, lead_create_object.php, site_create_object.php, opportunity_stage_changed.php
- ✓ FIX: Status field in pipeline sync now sends plain integer instead of ['ID' => x] object
- ✓ FIX: Customer field in lead.create now sends plain integer instead of ['ID' => x] object
- ✓ FIX: Type field in orphan lead creation now sends string 'Project' instead of ['ID' => 1] object
- ✓ These fixes resolve silent failures when updating SimPro job statuses and creating leads
- ✓ FIX: Google Drive disconnect now works when admin is managing another user's settings
- ✓ Disconnect link now passes target_user_id parameter
- ✓ google_disconnect.php now respects admin context and disconnects correct user
- ✓ Redirect after disconnect preserves manage_user_id for admins
v1.6.0
2 Feb 2026
🔄 Generic Dropdown Resolver, API Optimisation & Project Type Routing
- ✓ NEW: Generic Dropdown Field Resolver - converts text values to SimPro IDs (and vice versa) for ANY dropdown field
- ✓ Dropdown resolution is configuration-driven via simpro_dropdown_config table - no hardcoding needed!
- ✓ Supports: PaymentTerms, TaxStatus, JobType, CostCentre, PaymentMethods, and any future dropdown field
- ✓ Works bi-directionally: GHL→SimPro (text→ID) and SimPro→GHL (ID→text)
- ✓ In-memory caching prevents duplicate API calls when resolving multiple records in same request
- ✓ NEW: API Call Optimisation via change detection hashing
- ✓ SimPro webhooks now skip full enrichment (20-30 API calls) when entity data hasn't changed
- ✓ Uses MD5 hash of key fields (Stage, Status, DateModified, names, etc.) to detect changes
- ✓ Most repeat webhooks now complete in under 1 second instead of 5-6 seconds
- ✓ Hash cache auto-cleans entries older than 24 hours
- ✓ FIX: Enhanced project_type_field detection for Quote/Job/Lead routing
- ✓ Now checks payload, customData block, AND enriched custom object data (was only checking payload)
- ✓ Better debug logging when project_type_field value can't be found - shows available payload keys
- ✓ Clearer setup instructions in logs when __setting_project_type_field is not configured
v1.5.62
19 Jan 2026
🔧 Customer Profile & Group Sync Fix (GHL → SimPro)
- ✓ FIX: GHL custom field unique keys now correctly map to webhook payload display names
- ✓ GHL sends "Customer Type" in payload but mappings use "contact.customer_type" unique key
- ✓ Added automatic conversion: contact.customer_type → "Customer Type" for payload lookup
- ✓ Also handles "OR" fields: contact.domestic_or_commercial → "Domestic OR Commercial"
- ✓ Customer Profile and Customer Group now sync correctly from GHL to SimPro
v1.5.61
19 Jan 2026
📱 Phone Label Capitalisation Fix (SimPro → GHL)
- ✓ FIX: Additional phone labels now capitalised correctly for GHL API
- ✓ GHL requires "Mobile", "Home", "Work", "Landline" - was sending lowercase "mobile", "home"
- ✓ This was causing HTTP 422 errors and blocking ALL customer updates from SimPro to GHL
- ✓ Customer Profile and Customer Group syncs were also failing due to this error
- ✓ Added ucfirst(strtolower()) to ensure correct capitalisation
v1.5.60
19 Jan 2026
📱 Mobile Phone Mapping Fix (GHL → SimPro)
- ✓ FIX: Mobile Phone field now syncs correctly for Individual customers
- ✓ Root cause: contact.CellPhone was being used instead of customer.CellPhone
- ✓ contact.CellPhone is for Company customer Contacts only - Individual customers need customer.CellPhone
- ✓ Updated simpro_fields.php to clarify field labels and prevent future confusion
- ✓ Contact/Employee fields now show "(Company Contacts Only)" suffix in dropdown
- ✓ Customer Phone field now shows "(Primary)" suffix for clarity
- ✓ DATA FIX: Corrected existing bad mappings in ghl_field_mappings table for affected integrations
v1.5.59
19 Jan 2026
👤 Customer Profile Sync (GHL → SimPro)
- ✓ NEW: Customer Profile names are now automatically converted to SimPro IDs
- ✓ When GHL sends "Gold", system looks up the ID (e.g., 11) and sends that to SimPro
- ✓ Added findSimproCustomerProfileId() function - fetches and caches all profiles from SimPro
- ✓ Profiles are fetched from /setup/customerProfiles/ endpoint and cached per request
- ✓ Handles both customer.Profile.CustomerProfile.Name and entity.Profile.CustomerProfile.Name
- ✓ Logs show which profiles are available if a match is not found
v1.5.58
19 Jan 2026
📱 Phone Sync Fix (SimPro → GHL)
- ✓ FIX: additionalPhones now uses "phoneLabel" instead of "label" (was causing 422 errors)
- ✓ GHL API requires "phoneLabel" for additional phone numbers - our code was using wrong key
- ✓ FIX: formatUkPhoneNumber now properly preserves + prefix on international numbers
- ✓ Numbers like +441773775411 were being sent as 441773775411 (missing +)
- ✓ Improved UK phone formatting: handles 07, 0, and 44 prefixes correctly
v1.5.57
13 Jan 2026
🔒 Quote & Lead Duplicate Prevention
- ✓ CRITICAL: Added METHOD 0 duplicate check for quote.create (matches job.create logic)
- ✓ CRITICAL: Added METHOD 0 duplicate check for lead.create (was completely missing!)
- ✓ Quotes/Leads now check enriched Contact Projects for existing quote_id/lead_id before creating
- ✓ Added opportunity_quote_links table for tracking Opportunity↔Quote associations
- ✓ Added opportunity_lead_links table for tracking Opportunity↔Lead associations
- ✓ Prevents duplicate quotes/leads when webhooks fire multiple times
v1.5.9
26 Dec 2025
Read-Only Fields & Site Lookup Fix
- ✓ Fixed HTTP 422 "Total.ExTax - This API Column does not allow POST requests" error
- ✓ Now removes read-only Total field from all Job, Quote, and Lead payloads
- ✓ Fixed Status field validation - must be integer ID, not object with Name
- ✓ Improved Site ID lookup for job.create_object - now searches contact custom fields properly
- ✓ Added fallback to fetch customer's primary site from SimPro when Site ID not found
- ✓ Applied fixes to: job.create, job.create_object, quote.create, quote.create_object, lead.create_object
- ✓ Fixed Retry button - was missing action parameter in URL, now properly reports success/failure
v1.5.8
26 Dec 2025
Company vs Individual Customer Payload Fix
- ✓ Fixed HTTP 422 errors when creating Company customers
- ✓ Company customers no longer send GivenName/FamilyName at top level
- ✓ Individual customers no longer send nested "contact" object
- ✓ Fixed cascade customer creation in site.create and job.create
- ✓ Fixed fallback CREATE scenario payload cleanup
v1.5.7
25 Dec 2025
GHL → SimPro Custom Object Create Fix
- ✓ Fixed site.create_object was not looking up Customer ID from associated contact
- ✓ Fixed job.create_object was not looking up Customer ID from associated contact
- ✓ Fixed quote.create_object was not looking up Customer ID from associated contact
- ✓ Fixed lead.create_object was not looking up Customer ID from associated contact
- ✓ All *.create_object handlers now properly call getSimproCustomerIdFromAssociatedContact()
- ✓ Sites, Jobs, Quotes, and Leads can now be created from GHL custom objects when linked to a contact
v1.5.6
25 Dec 2025
Object-to-Object Associations Fix
- ✓ Fixed Sites ↔ Projects associations not being called
- ✓ Association functions are now properly invoked after successful API calls
- ✓ Improved logging for association creation
v1.5.0
20 Dec 2025
Enrichment Engine & Smart Mapping Analysis
- ✓ Added GHL Enrichment Engine - fetches full contact, business, opportunities, and custom objects
- ✓ Smart Mapping Analysis now shows all available fields from enriched data
- ✓ Improved field lookup with unified GHL data
- ✓ Added support for custom object properties in mappings
v1.4.0
13 Dec 2025
Quote Creation, ID Writebacks & Safety Checks
- ✓ Fixed quote creation - Customer now sent as integer, auto-fetches Site/Type/Name
- ✓ Fixed enrichment to use correct contact_id instead of opportunity ID
- ✓ Added Company vs Individual customer auto-detection
- ✓ Improved Contact events handling (separate from Customer events)
- ✓ Added safety check to prevent accidental mapping deletion
- ✓ Fixed Site ID writeback API URL bug
- ✓ Added Job ID writeback for custom objects
- ✓ Added Quote ID writeback for custom objects
- ✓ Added smart fallbacks for site_id, job_id, quote_id field names
- ✓ Removed debug logging code
v1.3.0
10 Dec 2025
Site Update Fixes & Log Improvements
- ✓ Fixed site update failures - removed trailing slashes from PATCH URLs
- ✓ Fixed site.create_object payload structure
- ✓ Improved log display with loop prevention detection
- ✓ Added "No Action" status display
- ✓ Added detailed SimPro API Calls section in logs
v1.2.0
8 Dec 2025
Site ID Writeback & Dynamic Field Mapping
- ✓ Made Site ID writeback fully dynamic using ghl_field_mappings table
- ✓ Supports any custom object name and field name
- ✓ Improved association handling between custom objects and contacts
v1.1.0
1 Dec 2025
Pipeline Stage Mapping
- ✓ Added bi-directional pipeline stage sync
- ✓ SimPro job stages now sync to GHL opportunity stages
- ✓ GHL opportunity stage changes sync back to SimPro
- ✓ Added pipeline stage mapping configuration page
v1.0.0
15 Nov 2025
Initial Release
- ✓ Bi-directional sync between SimPro and GoHighLevel
- ✓ Customer, Site, Job, Quote, Lead, Invoice sync
- ✓ Custom object support
- ✓ Field mapping configuration
- ✓ Event toggle controls
SimProSync by My Local Trades