🏠 Overview › 👥 User Roles ›📖 Review and Resolve Member Data Sync Conflicts

Review and Resolve Member Data Sync Conflicts

When the sync service detects a conflict between the external system and the app (e.g., a member's role was changed in the app after the last sync but also changed in Cornerstone/Consio), the conflict is logged and surfaced for review. The default rule applies the external system as source of truth for membership status while keeping the app as source of truth for activity data. Administrators can review each conflict, see both versions, and either accept the default resolution or manually override. Resolved conflicts are logged in the sync repository for audit purposes.

HIGH story-member-system-integration-global-admin-005 3 pts
3
Story Points
High
Priority
Member System Integration
Feature

User Story

As a administrator
I want to review records where the external member system and the app hold conflicting data, and confirm or override the conflict resolution outcome
So that So that membership status and role assignments are always based on the authoritative source, and edge cases where the automatic conflict rule is inappropriate can be corrected manually

Acceptance Criteria

  • Given a sync identifies a conflicting record, when the sync completes, then the conflict is added to the pending conflicts queue visible in the admin UI
  • Given I open a conflict record, when I review it, then I see the current app value, the external system value, the timestamp of each change, and the proposed automatic resolution
  • Given I accept the default resolution, when I click 'Apply', then the app record is updated to match the external system value and the conflict is marked as resolved
  • Given I want to keep the app value, when I select 'Override' and confirm, then the app value is preserved, the external system update is rejected for this record, and the override is logged with my user ID and timestamp
  • Given conflicts are resolved, when I view the sync audit log, then all resolutions (automatic and manual) are recorded with timestamps, actor, and before/after values

Business Value

Automatic conflict resolution handles the vast majority of sync divergences correctly, but edge cases require human judgment. Without a conflict resolution UI, administrators either blindly trust the automatic rule in cases where it is wrong, or lose visibility into data quality issues entirely. A transparent conflict queue with clear override capability maintains both data integrity and administrator confidence in the system.

Components

Member System Integration
Related Feature
Global Administrator
User Role