📋 Changelog
All updates and improvements to SimProSync
v1.9.9
26 Jun 2026
🧩 Pipeline Status Pagination + Projects Custom Object Create Fix
Latest- ✓ Pipeline Stage Mappings — the same pagination fix as v1.9.8, applied to the pipeline page. Its SimPro status fetch was also reading only the first 30 records (SimPro's default page size) before caching them, so on accounts with more than 30 status codes the later-sorting codes (typically the quote statuses) were missing from the status dropdown and could not be mapped. The fetch now requests the maximum page size and pages through the full list before caching. Note: this page reads from a cached status list, so after deploying, the status cache must be refreshed once for the complete list to appear.
- ✓ Projects custom object create failure (SimPro to GHL). The configurable project-type field that tags a synced record as lead/quote/job was being auto-populated with a capitalised value ("Job"/"Quote"/"Lead"). GHL single-option dropdown fields validate against their option keys, which are lowercase by convention, so GHL rejected the value with HTTP 400 ("couldn't validate the mapped field") and — critically — failed the entire Projects record create. The visible effect was that Projects custom object records silently stopped being created for affected accounts, while contacts, sites and opportunities continued to sync normally. The auto-populate now sends the lowercase entity type to match GHL's option keys. The project stage and status dropdown fields were never affected because they already pass through the status-mapping layer. Records that previously failed will be created the next time their entity fires a webhook.
- ✓ Both changes are multi-tenant safe with no per-customer hardcoding.
v1.9.8
26 Jun 2026
📊 Status Mappings — Full Status Retrieval (Pagination Fix)
- ✓ Fixes quote (and other) SimPro statuses being missing from the Stage & Status Mappings page on accounts with large status-code lists. SimPro list endpoints return only 30 records per page by default, and the page was reading just that first page. On builds with more than 30 status codes, the codes that sort later — frequently the quote statuses — fell onto subsequent pages that were never requested, so they never reached the mapping UI. Accounts with 30 or fewer codes were unaffected, which is why this only surfaced on larger configurations.
- ✓ The fix: the SimPro status fetch now requests the maximum page size and pages through until a short page is returned, retrieving the complete status list regardless of how many codes an account has. Results are de-duplicated by status ID.
- ✓ Supporting hardening made at the same time: the page now queries the SimPro status views resiliently (the base view plus the projects/quotes/jobs/leads filtered views), tolerating builds where some of those views return 404 by merging whatever is available. The built-in debug view now reports a per-view HTTP code, returned count, and pages fetched, making status-retrieval issues diagnosable at a glance. The earlier company_id = 0 handling for single-company SimPro accounts is retained.
- ✓ Multi-tenant safe with no per-customer hardcoding.
v1.9.7
8 Jun 2026
⏭️ GHL → SimPro Customer PATCH Echo-Break Gate
- ✓ Companion fix to v1.9.6. Together they make the GHL ↔ SimPro customer sync no-op-safe in both directions — every webhook is verified against the actual state of the target record before any update is sent, and the round-trip is skipped if nothing has really changed.
- ✓ The problem: every inbound GHL contact webhook was triggering a SimPro customer PATCH, even when no field had actually changed in GHL. SimPro then fired its own customer.updated webhook back, racking up wasted API calls and burning through GoHighLevel workflow executions. v1.9.6 caught the return leg, but the wasted PATCH had already happened, and any momentary timing or cache mismatch could still spawn a fresh cycle.
- ✓ Part 1 — Echo-loop skip gate in updateSimproCustomer(). Before firing the PATCH, the handler now fetches the current SimPro record and runs a diff against the outbound payload. If a reliable baseline was retrieved AND the diff shows no real changes, the PATCH is skipped entirely and the event is tagged unified.no_action_needed. If the baseline fetch failed, the PATCH still fires defensively so a genuine change is never missed. The skip is visible in the auto_actions log as "⏭️ SimPro customer PATCH SKIPPED - no real changes detected".
- ✓ Part 2 — Companion diff logger fix (diff_logger.php v1.0.2). Without this, v1.9.7 could never fire in production. SimPro accepts dropdown and lookup fields (Profile.CustomerGroup, Banking.PaymentMethod, Banking.PaymentTermID, Tags, etc.) as scalar IDs on PATCH but returns them as {ID, Name} objects on GET. The previous flat-path comparison saw these as phantom changes on every sync, permanently disabling the skip gate. A new normaliseShapesForDiff() pre-pass walks the payload and existing trees in lockstep before flattening, reduces {ID, Name} objects to their scalar IDs where the payload sends a scalar, and normalises tag-style arrays to sorted ID lists for order-independent comparison. Recursive — handles arbitrary nesting. Applied only in the ghl_to_simpro direction; simpro_to_ghl is untouched.
- ✓ Verified in production across multiple integrations and both customer types (individuals and companies), including configurations that use company_id = 0. Multi-tenant safe with no per-customer hardcoding.
v1.9.6
6 Jun 2026
🛡️ SimPro → GHL Contact Upsert Echo-Break Gate
- ✓ Fixes a severe production echo loop on the customer sync that was generating unnecessary API calls per cycle and racking up significant unexpected GoHighLevel workflow execution charges. v1.9.6 closes the SimPro → GHL leg of the loop; v1.9.7 (released the same day) closes the symmetric GHL → SimPro leg.
- ✓ The problem: every SimPro customer webhook was driving a GHL Contact upsert even when nothing had genuinely changed. Two phantom-diff drivers were responsible. (1) Tags came back from SimPro in Title Case but GHL stores tags lowercased, so a case-sensitive diff perpetually reported "Tags changed" on every sync. (2) Mappings sometimes targeted object-scope custom fields (business.*, opportunity.*, quote.*, job.*, site.*, lead.*, invoice.*, project.*) on the Contact. GHL silently drops these on Contact upsert because they belong on custom objects, not Contacts — but the diff would perpetually see them as "(empty) → value".
- ✓ The fix — payload-build scrub in webhook_processor.php. When building the GHL Contact upsert payload, object-scope custom fields are now stripped before sending. Tags are lowercased and deduplicated before they hit the diff comparison. The Contact upsert is skipped entirely when the cleaned diff is empty, completing the upstream cycle break.
- ✓ Defensive guards in the diff logger (v1.0.1) so that even if a malformed payload reaches the diff stage, object-scope fields and case-mismatched tags will not be reported as phantom changes.
- ✓ Impact: the runaway customer cascade stopped at deploy. Loop-prevented events (unified.loop_prevented) became visible across integrations, confirming the defensive layer is active. Note for integrations using business custom objects: business.simpro_customer_id is no longer written to the Contact object — it belongs on the Business custom object.
v1.9.5
28 May 2026
🔁 Duplicate Jobs Loop Fix (SimPro ↔ GHL Echo-Break)
- ✓ Fixes the duplicate SimPro jobs that were appearing roughly once per
- ✓ hour in production. This is a deeper fix than the v1.9.4
- ✓ duplicate-prevention work — it closes the actual echo LOOP, not just
- ✓ the symptoms.
- ✓
- ✓ THE BUG: SIMPRO → GHL → SIMPRO ECHO LOOP
- ✓ SimProSync creates a GHL opportunity FROM a SimPro job. That
- ✓ opportunity lands in a pipeline stage that is mapped (sync_direction
- ✓ = 'both') to CREATE a SimPro job. The GHL→SimPro side then creates a
- ✓ brand-new SimPro job, which fires job.created, which creates another
- ✓ opportunity... one new duplicate job per cycle (~1/hour).
- ✓ The v1.9.3 creation lock only stops SIMULTANEOUS webhooks — it never
- ✓ caught this slow echo, because each loop produces a genuinely new job
- ✓ with a new ID a few minutes apart.
- ✓
- ✓ PART 1: ECHO-BREAK TRACKER (the core fix)
- ✓ When the SimPro→GHL processor creates a GHL opportunity FROM a SimPro
- ✓ job/quote, it now records that opportunity in a short-lived tracker
- ✓ (new table ghl_opportunity_origin_tracker, 5-minute TTL, auto-created
- ✓ and auto-pruned). Before the GHL→SimPro side creates a SimPro job back,
- ✓ it checks this tracker: if SimProSync itself created the opportunity
- ✓ from a SimPro entity within the window, job creation is SKIPPED.
- ✓ Logs show "🔁 Loop prevented: opportunity originated from SimPro job #X
- ✓ — not creating a job back."
- ✓
- ✓ PART 2: DURABLE LINK ON EVERY JOB/QUOTE WEBHOOK
- ✓ Recent jobs were missing their opportunity_*_links rows, so dedup
- ✓ checks could not rely on them. When a job/quote webhook arrives and an
- ✓ opportunity already exists, the link row is now upserted (backfilled)
- ✓ so the system has a durable "we have seen this" record.
- ✓
- ✓ PART 3: BELT-AND-BRACES PRE-CREATE CHECK
- ✓ Immediately before creating a SimPro job, the GHL→SimPro handler now
- ✓ re-checks opportunity_job_links AND sync_links for an already-linked
- ✓ job. If one exists, creation is skipped (logs show "🛡️ PRE-CREATE
- ✓ GUARD"). Hardens the existing $isLinked check against rows written
- ✓ between detection and creation.
- ✓
- ✓ Multi-tenant safe: all logic is keyed by integration_id, with no
- ✓ per-customer hardcoding. The new tracker table is created
- ✓ automatically on first run — no manual SQL required.
v1.9.4
27 May 2026
🐛 Live Bug Fixes: Attachments, Duplicate Jobs, Quote Conversion & Log Cleanup
- ✓ Three bugs reported from 3+ months of live production use — all fixed.
- ✓
- ✓ FIX #1: JOB ATTACHMENTS NOT DOWNLOADING
- ✓ Attachment metadata was syncing but no files were ever downloaded
- ✓ Root cause: the attachment download cron crashed on every run with
- ✓ SQLSTATE[HY093] — MySQL does not allow a bound parameter inside an
- ✓ INTERVAL expression (INTERVAL ? DAY). The crash was triggered once a
- ✓ user set a local-file retention period.
- ✓ Fixed in auto_cleanup_attachments.php — the (int)-cast retention value
- ✓ is now inlined safely. The download cron runs cleanly again.
- ✓
- ✓ FIX #2: DUPLICATE JOBS CREATED IN SIMPRO (Dwell / Places)
- ✓ Old jobs were being re-created in SimPro and Prospect Pilot
- ✓ Root cause: the "is this opportunity already linked?" check trusted
- ✓ ONLY the opportunity_*_links tables. Those tables are empty for any
- ✓ job/quote created directly in SimPro (then synced up to GHL), or whose
- ✓ previous creation attempt failed — so the opportunity looked unlinked
- ✓ and a DUPLICATE entity was created on every subsequent webhook.
- ✓ Now also checks sync_links, and reads the simpro_job_id / simpro_quote_id
- ✓ custom field written onto the opportunity itself — the authoritative
- ✓ proof the entity exists. When found, the missing link row is BACKFILLED
- ✓ so the system self-heals (logs show "🛡️ DUPLICATE PREVENTED").
- ✓ simpro_customer_id is now also stored in the link tables (was always
- ✓ NULL) for a customer-scoped dedup safety net.
- ✓
- ✓ FIX #3: QUOTE→JOB CONVERSION NOT UPDATING PIPELINE
- ✓ Converting a quote to a job in SimPro left the quote opportunity
- ✓ stranded in its original pipeline stage, never marked won.
- ✓ Root cause: SimPro does not fire a quote webhook on conversion.
- ✓ Now, when a job webhook arrives for a job converted from a quote
- ✓ (ConvertedFromQuote / ConvertedFrom in the SimPro job payload), the
- ✓ originating quote's linked opportunity is moved to the mapped
- ✓ 'Converted' stage (falls back to the 'Complete' quote mapping).
- ✓ NOTE: requires a quote pipeline mapping for SimPro stage 'Converted'
- ✓ or 'Complete' to be configured in Pipeline Mappings.
- ✓
- ✓ ENHANCEMENT: STALE PIPELINE DETECTION
- ✓ When GHL rejects opportunity creation with "pipeline id is invalid"
- ✓ (caused by a pipeline being renamed/rebuilt in GHL), the failure is
- ✓ now recorded clearly in the event log with remediation instructions,
- ✓ instead of failing silently and being retried on every webhook.
- ✓
- ✓ FIX #4: EVENT_LOGS TABLE GROWING UNBOUNDED (reached 4.4GB)
- ✓ The daily log cleanup cron was launching but never deleting anything.
- ✓ Root cause: cleanup_logs.php used "INTERVAL ? DAY" with a bound
- ✓ parameter — the same MySQL limitation as FIX #1 — so it crashed with
- ✓ SQLSTATE[HY093] on every run for months. Plesk showed a green tick
- ✓ because the task LAUNCHED, not because it succeeded.
- ✓ cleanup_logs.php is now fixed: the (int)-cast retention value is
- ✓ inlined safely, deletion runs in batches of 2,000 rows to avoid
- ✓ locking the table, and the default retention is now 14 days.
- ✓
- ✓ ENHANCEMENT: NO-ACTION LOG PAYLOAD TRIMMING
- ✓ A single event type — unified.no_action_needed — accounted for
- ✓ ~1.8GB (40%) of the event_logs table: 20,000+ rows of full ~87KB
- ✓ forensic payloads logging webhooks where nothing happened.
- ✓ webhook_ghl_unified.php now stores a SLIM payload (under 1KB) for
- ✓ no-action events (no_action_needed, loop_prevented, throttled) —
- ✓ the heavy enrichment and API-call blobs are stripped, the summary
- ✓ fields are kept. Events that did real work keep their full payload.
- ✓ This cuts the largest source of log bloat at the source.
v1.9.3
11 Apr 2026
🛡️ Duplicate Creation Prevention & Multiple Webhook Fixes
- ✓ FIX #1: LOOP PREVENTION (v1.9.0 webhook)
- ✓ Job status was flip-flopping (Pending ↔ Progress) causing multiple notifications
- ✓ Root cause: GHL→SimPro→GHL echo loop when both sides fired webhooks
- ✓ Now fetches current job/quote state BEFORE updating
- ✓ Skips redundant updates if Stage/Status already match (logs show "🛑 LOOP PREVENTED")
- ✓ Also removed AutoAdjustStatus=false which was permanently disabling SimPro's Auto Adjust
- ✓
- ✓ FIX #2: ENTITY TYPE ROUTING (v1.9.1 webhook)
- ✓ Creating opportunity in "Ongoing Jobs Pipeline" was creating a Quote instead of Job
- ✓ Root cause: ACTION code always called createSimproQuote() regardless of entity_type
- ✓ Now checks entity_type from pipeline_stage_mappings and routes correctly
- ✓ Added new createSimproJob() function for direct job creation from opportunities
- ✓ Logs now show "⚡ ACTION: Creating Job for Opportunity..." when entity_type=job
- ✓
- ✓ FIX #3: ARCHIVING BUG (v1.9.2 webhook)
- ✓ Quotes/Jobs weren't archiving when moved to "Ghosted" or "Abandoned" stages
- ✓ Root cause: archive_reason_id was extracted from mapping but never added to API payload
- ✓ SimPro requires ArchiveReason array when Stage="Archived"
- ✓ Now includes ArchiveReason in update payload (logs show "📋 Adding ArchiveReason ID X")
- ✓
- ✓ FIX #4: DUPLICATE CREATION (v1.9.3 webhook)
- ✓ Multiple GHL workflows firing simultaneously could create duplicate jobs/quotes
- ✓ Root cause: No deduplication lock for job/quote creation (only sites had this)
- ✓ Added lock-based deduplication using acquireCreationLock() pattern
- ✓ First webhook creates entity; subsequent webhooks detect and skip
- ✓ Logs show "🛑 DEDUP: job #X already created for opportunity by another webhook"
- ✓
- ✓ ENHANCEMENT: GOOGLE DRIVE FILE NAMING
- ✓ Files uploaded to Google Drive now include customer name in filename
- ✓ Original: "photo.jpg" → New: "photo - John Smith.jpg"
- ✓ Makes it easier to identify files in Drive without opening folders
- ✓ Customer name is sanitized to remove invalid filename characters
v1.9.0
6 Apr 2026
🗑️ Deletion Manager
- ✓ NEW FEATURE: Admin-only Deletion Manager for safely removing entities from both SimPro and GHL
- ✓
- ✓ 🔍 SEARCH & PREVIEW:
- ✓ Search for Jobs, Quotes, or Sites by ID or name
- ✓ Preview shows EVERYTHING that will be deleted (cascade view)
- ✓ Shows linked GHL Opportunities, Custom Objects, and Associations
- ✓ Site deletion shows all child Jobs and Quotes that will also be removed
- ✓
- ✓ 🛡️ SAFETY FEATURES:
- ✓ Admin-only access - regular users cannot access deletion manager
- ✓ Soft-delete by default - items can be restored within configurable window (7-90 days)
- ✓ Must type "DELETE" to confirm soft-delete, "PERMANENT" for permanent delete
- ✓ Invoiced jobs are BLOCKED from deletion - must archive in SimPro instead
- ✓ Full audit trail of all deletion actions with user and timestamp
- ✓ Data snapshots stored for potential restore
- ✓
- ✓ ♻️ RESTORE & PERMANENT DELETE:
- ✓ Restore items from deletion queue within the expiry window
- ✓ Restored items get new IDs (SimPro limitation) with updated sync_links
- ✓ Permanent delete clears all snapshots - cannot be undone
- ✓ Auto-expiry cron job permanently deletes items past their restore window
- ✓
- ✓ 📋 NEW DATABASE TABLES:
- ✓ deletion_queue - tracks all deletion requests, status, and snapshots
- ✓ deletion_audit_log - full audit trail of all actions
- ✓ Tables auto-created on first access
v1.8.9
6 Apr 2026
🏷️ Fix Duplicate Tags, Zombie Records & Attachment Display
- ✓ FIX #1: Tags syncing from GHL to SimPro were creating massive duplicates
- ✓ Example: Dozens of identical "schools" tags with different IDs
- ✓ Root cause: findOrCreateSimproTagIds() was auto-creating tags when lookup failed
- ✓ Function now ONLY matches existing SimPro tags - never creates new ones
- ✓ Added whitespace trimming to tag name normalization for more robust matching
- ✓ To sync new tags, first create them manually in SimPro (Setup → Tags)
- ✓
- ✓ FIX #2: Zombie record prevention for deleted SimPro entities
- ✓ When updating a job/quote returns 404 (deleted in SimPro), the stale link is now cleared
- ✓ Removes orphaned references from opportunity_job_links and opportunity_quote_links
- ✓ Prevents the system from holding references to deleted SimPro entities
- ✓
- ✓ FIX #3: Gallery showing attachments that have been removed from server
- ✓ Files cleaned up after Drive sync were still appearing in the gallery
- ✓ Added WHERE clause filter: only show attachments where file_path is not empty
- ✓ Removed attachments no longer clutter the gallery view
v1.8.8
30 Mar 2026
🏢 Company Customer Contact Fallback
- ✓ FIX: Jobs/Quotes for company customers were not creating GHL contacts or opportunities
- ✓ Company customers in SimPro often have empty Email/Phone fields on the company record itself
- ✓ Contact details are stored on the company's Contacts (people like "Jackie" or "Joe")
- ✓ SimProSync was checking customer.Email which was empty, so no GHL contact could be upserted
- ✓ Without a GHL contact, no opportunity could be created or linked
- ✓ NEW: Fallback logic for company customer email/phone
- ✓ When customer.Email is empty, now checks customer.Contacts array
- ✓ Prioritises the Primary Invoice Contact (PrimaryInvoiceContact: true)
- ✓ Falls back to first contact with an email if no primary is set
- ✓ Also auto-populates firstName/lastName from the selected contact
- ✓ Example: "Company name Ltd" with empty Email now uses "contact@companyname.com" from contact
- ✓ Logging shows: "📧 Auto-populated email from company contact (contact): contact@companyname.com"
v1.8.7
30 Mar 2026
🧾 Invoice Status → Job Opportunity Sync
- ✓ FIX: When marking an invoice as paid, linked job opportunities were not updating in GHL
- ✓ SimPro automatically changes job status to "Job : Invoice Fully Paid" when invoice is paid
- ✓ But SimProSync was not syncing this status change to the GHL opportunity
- ✓ Root cause: invoice.status event type was not triggering opportunity stage sync
- ✓ NEW: invoice.status now triggers opportunity stage updates for associated jobs
- ✓ When invoice.status or invoice.updated fires, fetches all associated jobs from invoice.Jobs array
- ✓ For each job, fetches current job data to get latest status (e.g., "Job : Invoice Fully Paid")
- ✓ Looks up linked GHL opportunity for each job
- ✓ Updates opportunity stage based on job's current status using existing pipeline mappings
- ✓ Supports invoices linked to multiple jobs (processes each one)
- ✓ New logging section: invoice_job_sync shows each job processed and result
- ✓ Example: Invoice paid → Job #8221 status becomes "Job : Invoice Fully Paid" → GHL opportunity moves to mapped stage
v1.8.6
25 Mar 2026
🔧 company_id=0 Bug Fixes & Settings Test Buttons
- ✓ FIX: Multiple files failed for single-company SimPro accounts (company_id = 0)
- ✓ PHP treats 0 as "falsy", so checks like !$companyId or empty($companyId) incorrectly failed
- ✓ Fixed in: mappings_pipeline.php, fetch_simpro_attachments.php, force_sync.php, dropdown_resolver.php
- ✓ All single-company SimPro setups now work correctly
- ✓ NEW: Test API Connection buttons on Settings page
- ✓ Each integration now has "Test SimPro Connection" and "Test GHL Connection" buttons
- ✓ SimPro test calls /setup/statusCodes/projects/ to verify credentials
- ✓ GHL test calls /locations/{locationId} to verify API access
- ✓ Shows success (green) with status count or location name
- ✓ Shows failure (red) with specific error message and fix instructions
- ✓ Helps diagnose 401 (wrong API key) vs 404 (wrong company ID) errors
- ✓ IMPROVED: Snapshot system now captures source status cache
- ✓ create_snapshot.php now stores source_status_cache when snapshotting pipeline mappings
- ✓ Contains status_id → status_name mapping from source SimPro
- ✓ Enables future status ID remapping when applying to different SimPro instances
- ✓ Note: Status remapping only works when SimPro instances have matching status NAMES
- ✓ Different SimPro setups with custom statuses will need manual pipeline/status mapping
- ✓ Snapshot version bumped to 2.3
v1.8.4
25 Mar 2026
📸 Comprehensive Snapshots & Multiple Fixes
- ✓ FIX: apply_snapshot.php was using wrong column names for association labels
- ✓ Changed first_object_key/second_object_key → input_schema/output_schema to match actual DB schema
- ✓ FIX: Association mappings were looking for "is_enabled" but snapshot contains "enabled"
- ✓ FIX: Status mappings INSERT was completely wrong schema — fixed to match ghl_status_mappings table
- ✓ Correct columns: integration_id, custom_object_key, field_type, simpro_value, simpro_status_id, ghl_value, display_order
- ✓ FIX: Pipeline mappings now includes all columns from snapshot (simpro_status_id, simpro_status_ids, archive_reason_id, sync_direction, is_primary, is_default_for_new)
- ✓ Snapshots can now be successfully applied to new integrations
- ✓ NEW: Snapshots now include ALL mapping types for complete account cloning
- ✓ Added: Association Mappings (Contact↔Site, Site↔Project, etc.)
- ✓ Added: Association Labels (GHL custom object association definitions)
- ✓ Added: Pipeline Stage Mappings (GHL stages ↔ SimPro stages)
- ✓ Added: Status Mappings (SimPro status values ↔ GHL dropdown values)
- ✓ Snapshot version bumped to 2.2 to reflect new comprehensive structure
- ✓ NEW: Events are now ENABLED by default when applying snapshots
- ✓ Previously, if source account had disabled events, applied accounts inherited disabled state
- ✓ New accounts created from snapshots now start with all events active immediately
- ✓ FIX: Status Mappings page failed for single-company SimPro accounts
- ✓ company_id = 0 is valid for single-company setups, but PHP treated it as "falsy"
- ✓ Changed check from if($companyId) to if($companyId !== null && $companyId !== '')
- ✓ SimPro statuses now load correctly for ALL accounts regardless of company_id value
- ✓ FIX: Settings page now respects user permissions
- ✓ Cloud Storage section (Google Drive, Dropbox) hidden when user lacks permission
- ✓ Auto-Sync settings hidden when google_drive permission is disabled
- ✓ Permissions loaded from user_permissions table and checked before rendering sections
- ✓ NEW: Opportunity name automatically syncs to Quote/Job name in SimPro
- ✓ Name changes are detected independently — no stage change required
- ✓ When you rename an opportunity in GHL, the linked quote/job name updates in SimPro automatically
- ✓ New syncOpportunityNameToSimpro() function handles name-only updates
- ✓ Last known name stored in ghl_opportunity_name column for change detection
- ✓ Works for both quotes and jobs
- ✓ DB: Added ghl_opportunity_name column to opportunity_quote_links and opportunity_job_links tables
- ✓ UI: New "Additional Mappings" section in Create Snapshot modal
- ✓ UI: Info boxes explain snapshot behavior and event enabling
- ✓ UI: Association, Pipeline, and Status mappings checked by default when creating snapshots
v1.8.3
24 Mar 2026
⚡ SimPro Webhook Timeout Prevention
- ✓ FIX: SimPro webhooks failing with HTTP 408 (Request Timeout) during bulk operations
- ✓ SimPro was timing out waiting for SimProSync to respond while processing was still running
- ✓ NEW: Implemented fastcgi_finish_request() pattern in webhook_simpro.php
- ✓ Webhook endpoint now sends 200 OK immediately upon receiving valid JSON
- ✓ Processing continues in background after SimPro connection is closed
- ✓ Eliminates 408 errors even when enrichment requires 20-30 API calls
- ✓ Database logging still captures full processing results via shutdown function
- ✓ FIX: PHP warning "Undefined variable $ghlContactId" in webhook_processor.php
- ✓ Variable was referenced in diff logging section before being initialized
- ✓ Added proper initialization: $ghlContactId = null before the logging block
- ✓ Server timeout configuration also increased (max_execution_time: 300s, nginx proxy timeouts: 300s)
v1.8.2
24 Mar 2026
🔧 Server Timeout Configuration
- ✓ INFRASTRUCTURE: Increased PHP max_execution_time from 30s to 300s
- ✓ INFRASTRUCTURE: Added nginx proxy timeout directives (300s) for webhook endpoints
- ✓ Prevents 504 Gateway Timeout errors during bulk SimPro operations
- ✓ Each webhook with full enrichment can require 10-15 seconds of API calls
- ✓ Bulk updates (e.g., updating many jobs at once) previously caused server to become unresponsive
- ✓ Note: This changelog entry documents server-side Plesk configuration changes
v1.8.1
17 Mar 2026
🎯 Auto-Create Opportunity Fix
- ✓ FIX: Auto-create opportunity logic was incorrectly blocking opportunity creation
- ✓ The "auto_create_opportunity" setting was being checked for ALL jobs/quotes, not just new contacts
- ✓ This caused opportunities to NOT be created when jobs/quotes came in for existing GHL contacts
- ✓ REMOVED: The setting check wrapper that was blocking createGhlOpportunity() calls
- ✓ Now opportunities are created for ALL jobs/quotes that have a valid GHL contact linked
- ✓ The original intent was to control opportunity creation for brand new contacts only
- ✓ Existing contact workflows now work correctly: Job created in SimPro → Opportunity created in GHL
- ✓ No changes to association logic, custom object sync, or field mappings
v1.8.0
16 Mar 2026
📊 Opportunity Custom Fields & Company Customer Fixes
- ✓ FIX: Opportunity custom fields now sync from SimPro to GHL
- ✓ Previously, mappings for opportunity.* fields (SimPro Job ID, Opportunity Value, Site ID, etc.) were ignored
- ✓ Code was only handling contact.*, custom_objects.*, and contact.phone.* fields
- ✓ NEW: Mapping loop now collects opportunity.* fields into $opportunityFieldMappings array
- ✓ Opportunity fields are written when creating new opportunities (if auto-create enabled)
- ✓ Opportunity fields are written when updating existing linked opportunities
- ✓ Field ID lookup tries both "opportunity.fieldname" and "fieldname" formats (GHL API compatibility)
- ✓ FIX: Company customer sites URL now includes customer type (GHL → SimPro direction)
- ✓ Previously, creating quotes/jobs from GHL failed for Company customers with 404 errors
- ✓ Sites endpoint was using /customers/{id}/sites/ instead of /customers/companies/{id}/sites/
- ✓ Now correctly detects customer type and uses appropriate endpoint
- ✓ Applies to: createSimproQuote(), createSimproEntityFromProject(), and related functions
- ✓ NEW: "Opportunity Custom Fields" section in SimPro Logs page
- ✓ Shows which opportunity fields were collected and their values
- ✓ Helps debug opportunity field sync issues
- ✓ Processing Steps now show: "📋 Collected opportunity field: opportunity.simpro_job_id = 12345"
v1.7.9
5 Mar 2026
🏢 Company Contact Fallback & Mapping-Driven Opportunity Value
- ✓ NEW: Company customer contact fallback for SimPro→GHL direction
- ✓ Previously, jobs linked to Company customers with no direct email/phone failed with "No email or phone available"
- ✓ System now detects when customer is a Company with blank contact details
- ✓ Falls back to the job's CustomerContact (the specific person assigned to the job)
- ✓ Fetches full contact details from SimPro: /customers/{id}/contacts/{contactId}
- ✓ Extracts email, phone (CellPhone or WorkPhone), firstName, lastName from the contact record
- ✓ Enables contact upsert, opportunity sync, and project/site associations for Company customer jobs
- ✓ Fallback only activates when email AND phone are both empty — no impact on Individual customers
- ✓ Clear logging: "📧 Using CustomerContact email (company fallback): ..."
- ✓ NEW: Mapping-driven opportunity value sync
- ✓ Opportunity value (monetaryValue) is now read from ghl_field_mappings for the lead_value field
- ✓ Customers can map any SimPro value field to GHL opportunity value via the Mappings UI
- ✓ Falls back to Total.ExTax → Total.IncTax if no mapping configured
- ✓ New helper function: getOpportunityValueFromMappings() used in both createGhlOpportunity() and stage sync
- ✓ FIX: Dropdown resolver now removes unresolvable dropdown values from payload entirely
- ✓ Previously, invalid dropdown values were left in the payload causing SimPro API errors
- ✓ Acts as a safety net for customer misconfiguration of dropdown field mappings
v1.7.8
3 Mar 2026
🏢 Company Customer Support & Customer Type Storage
- ✓ FIX: Customer updates now work for BOTH Individual and Company customers
- ✓ Previously, all customers were assumed to be Individuals, causing 404 errors when updating Company customers
- ✓ NEW: simpro_customer_type column in sync_links table stores customer type (individuals/companies)
- ✓ Customer type is now stored when a customer is created via GHL→SimPro sync
- ✓ When updating, system checks sync_links first for stored type (avoids extra API call)
- ✓ If type not stored, detects from SimPro API and stores for future use
- ✓ NEW: Helper functions: getStoredCustomerType(), storeCustomerType(), detectSimproCustomerType()
- ✓ Detection logic improved: checks SimPro Type field AND CompanyName presence
- ✓ Company customers now correctly use /customers/companies/ endpoint
- ✓ Individual customers continue using /customers/individuals/ endpoint
- ✓ Backwards compatible: Existing sync_links records without type will auto-detect on next update
- ✓ FIX: PHP parse error in webhook_processor.php (duplicate empty function declaration)
- ✓ FIX: Undefined variable $ghlContactId warning in webhook_processor.php diff logging section
v1.7.7
3 Mar 2026
🔍 Site Deduplication - Prevent Duplicate GHL Sites
- ✓ FIX: Duplicate Sites created when manually adding Sites in GHL before SimPro sync
- ✓ NEW: Multi-level Site deduplication in SimPro→GHL direction
- ✓ Level 1: Check site_sync_links table for existing link by SimPro Site ID
- ✓ Level 2: Search GHL by site_id field (catches Sites created by SimProSync)
- ✓ Level 3: Search GHL by site_name field (catches manually created Sites)
- ✓ Level 4: Search GHL by site_address + site_postal_code (catches Sites with different names but same location)
- ✓ When match found: Updates existing Site and writes SimPro Site ID to link them
- ✓ Only creates new Site if ALL dedup checks fail
- ✓ NEW: getGhlObjectRecord() helper function for fetching GHL custom object records
- ✓ Logs clearly show which dedup method matched: "Found existing Site by name/address+postcode"
v1.7.6
3 Mar 2026
🏷️ Tags Sync Fix & Webhook 500 Error Resolution
- ✓ FIX: Tags now sync correctly to SimPro (was sending tag names, now sends tag IDs)
- ✓ SimPro API requires Tags as array of integer IDs, not string names
- ✓ NEW: findOrCreateSimproTagIds() function resolves tag names to SimPro Tag IDs
- ✓ Auto-creates tags in SimPro if they don't exist (via POST /setup/tags/)
- ✓ Tags from GHL (comma-separated string) are parsed, resolved to IDs, and sent correctly
- ✓ FIX: 500 error on SimPro → GHL webhooks caused by function redeclaration
- ✓ Wrapped duplicate functions with function_exists() checks to prevent conflicts
- ✓ Affects: webhook_processor.php and functions.php sharing common functions
- ✓ Loop prevention confirmed working: 60-second throttle prevents infinite sync loops
v1.7.5
2 Mar 2026
🎛️ Dynamic Custom Object Mapping & Flexible Entity Types
- ✓ NEW: Dynamic GHL Custom Object Mapping in Settings page
- ✓ Users can now map ANY GHL custom object to ANY SimPro entity type (Sites, Projects, Quotes, Jobs, Leads, Invoices)
- ✓ No longer limited to hardcoded "sites" and "projects" object names
- ✓ Settings UI shows a table of all discovered custom objects with dropdown to select SimPro entity type
- ✓ Auto-detection: Object names containing "site/location/property" default to Sites, "project/job/work" default to Projects, etc.
- ✓ Mappings stored in new ghl_custom_object_mappings database table
- ✓ NEW: SimPro entity type inference from GHL custom object key
- ✓ When custom object webhook arrives, system looks up configured entity type
- ✓ Falls back to smart detection based on object name if no mapping configured
- ✓ Unified webhook handler now routes to correct SimPro entity creation based on mapping
- ✓ FIX: Custom object field mappings now load correctly in GHL Mappings UI
- ✓ Field dropdowns now populate with custom object properties
v1.7.4
1 Mar 2026
🔗 Enhanced Association System & Object-to-Object Links
- ✓ NEW: Object-to-Object associations (Sites ↔ Projects) now fully supported
- ✓ Previously only Contact ↔ Custom Object associations were created
- ✓ System now creates associations between custom objects when both exist
- ✓ Example: When a Quote syncs with Site, the Quote's Project is linked to the Site
- ✓ NEW: Association processing split into two phases
- ✓ Phase 1: Contact ↔ Custom Object associations (immediate)
- ✓ Phase 2: Object ↔ Object associations (after all objects processed)
- ✓ Ensures both objects exist before attempting to link them
- ✓ FIX: Association errors no longer block the main sync process
- ✓ Errors are logged but processing continues
- ✓ Clear logging shows which associations succeeded, failed, or were skipped
v1.7.3
28 Feb 2026
📍 Site Sync Improvements & Address Handling
- ✓ FIX: Site address fields now sync correctly to GHL custom objects
- ✓ Site address, city, state, postal code, and country now map to corresponding GHL fields
- ✓ NEW: Automatic site sync when job/quote has associated site
- ✓ When a job or quote syncs, its linked Site is automatically synced to GHL
- ✓ Site ↔ Contact association created automatically
- ✓ Site ↔ Project association created if project exists
- ✓ FIX: Site sync no longer fails when Site has no address data
- ✓ Empty address fields are handled gracefully
- ✓ NEW: site_sync_links table tracks SimPro Site ID to GHL Site custom object ID
- ✓ Prevents duplicate Site creation on subsequent syncs
v1.7.2
25 Feb 2026
🔄 Loop Prevention Enhancements
- ✓ FIX: Loop prevention now correctly handles rapid sequential webhooks
- ✓ Previous 60-second throttle was too aggressive for legitimate batch updates
- ✓ NEW: Smart entity comparison - only blocks if Stage AND Status unchanged
- ✓ Allows legitimate updates while still preventing infinite loops
- ✓ NEW: GHL echo detection via sync_links table
- ✓ When GHL webhook arrives, checks if we just sent that update
- ✓ Prevents "we changed it → GHL echoed it → we changed it again" loops
- ✓ Improved logging shows exactly why a webhook was blocked or allowed
v1.7.1
20 Feb 2026
📊 Enrichment Optimization & Hash-Based Skip
- ✓ NEW: Hash-based enrichment optimization for SimPro→GHL direction
- ✓ Hashes webhook payload + enrichment data to detect duplicate content
- ✓ Skips processing if hash matches recent webhook (within 24 hours)
- ✓ Significantly reduces unnecessary GHL API calls
- ✓ NEW: webhook_data_hashes table stores recent hashes with auto-cleanup
- ✓ Hashes auto-expire after 24 hours to prevent table bloat
- ✓ Clear logging: "⏭️ Skipping - identical data recently processed (hash: abc123)"
- ✓ FIX: Enrichment no longer fetches data that won't be used
- ✓ Only fetches related entities that have active field mappings
v1.7.0
15 Feb 2026
🚀 Unified GHL Webhook Handler
- ✓ NEW: Single unified webhook endpoint for ALL GHL events
- ✓ Replaces multiple individual webhook handlers
- ✓ All GHL webhooks now route through actions/webhook_ghl_unified.php
- ✓ Simplified webhook configuration - one URL for all events
- ✓ NEW: Modular architecture with separate helper files
- ✓ core/ghl/discovery.php - GHL API discovery and custom fields
- ✓ core/ghl/simpro_api.php - SimPro API calls
- ✓ core/ghl/ghl_api.php - GHL API calls
- ✓ core/ghl/enrichment.php - Data enrichment logic
- ✓ core/ghl/pipeline.php - Pipeline stage handling
- ✓ core/ghl/payload_builder.php - SimPro payload construction
- ✓ core/ghl/helpers.php - Utility functions
- ✓ core/ghl/simpro_dedup.php - SimPro deduplication
- ✓ Improved error handling and logging throughout
v1.6.0
10 Jan 2026
SimPro → GHL Webhook Processor
- ✓ NEW: SimPro → GHL webhook processor with full enrichment
- ✓ Enriches SimPro webhooks with customer, site, job history, quotes, invoices, notes
- ✓ Smart field mapping from SimPro fields to GHL contact and custom fields
- ✓ Pipeline stage sync from SimPro job/quote stages to GHL opportunity stages
- ✓ Opportunity creation and linking with jobs/quotes
- ✓ Contact ↔ Site ↔ Project associations in GHL
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