Bi-Directional CRM to ERP Data Synchronization & Conflict Resolution
Synchronize customer records, deals, invoices, and inventories between CRM and ERP systems with bi-directional conflict resolution.
System Directive • Copy and Paste Below
Act as a Principal Enterprise Systems Integration Architect specializing in CRM and ERP synchronization. Design a bi-directional, real-time data sync pipeline between a modern CRM and an enterprise ERP system with strict conflict resolution. ### INTEGRATION SPECIFICATIONS: - CRM Platform: [CRM_PLATFORM_E_G_HUBSPOT_SALESFORCE_ZOHO] - ERP Platform: [ERP_PLATFORM_E_G_NETSUITE_SAP_QUICKBOOKS_ODDOO] - Objects to Synchronize: [OBJECTS_E_G_CUSTOMERS_ACCOUNTS_INVOICES_PRODUCTS] - Sync Direction: Bi-directional (Two-way) - Master System of Record for Each Object: [MASTER_RECORD_RULES] ### TECHNICAL SPECIFICATIONS: 1. **Data Mapping & Transformation Matrix**: - Field-by-field mapping table between CRM fields and ERP fields (handling type differences, foreign keys, tax codes, and currency). 2. **Infinite Sync Loop Prevention Mechanism**: - Architecture preventing ping-pong sync loops (e.g., using specialized 'Sync User' service accounts, metadata flags like `last_synced_by`, or deterministic payload hashing). 3. **Conflict Resolution Strategy**: - Timestamp-based Last-Write-Wins vs Field-Level Master of Record rules (e.g., CRM owns contact email; ERP owns credit limit and billing address). 4. **Bi-Directional Webhook & Polling Flow**: - Inbound webhook listeners for real-time updates. - Nightly reconciliation batch job detecting orphaned or out-of-sync records. 5. **Audit Logging & Transaction Isolation**: - Immutable log table tracking every sync event, change delta, and error state.
Customization & Placeholders
Define which system is master for each field (e.g. CRM for contact details, ERP for tax IDs). The prompt handles loop prevention.
Example Input Values
CRM: HubSpot, ERP: NetSuite, Objects: Companies/Customers & Closed Deals/Invoices, Master rules: HubSpot owns sales stages; NetSuite owns invoice numbers.
Expected Output Structure
Detailed field mapping matrix, loop prevention code using header flags, and timestamp reconciliation algorithm.
Enterprise CRM & ERP System Integration
Qubenix unifies fragmented sales, billing, and accounting systems into a single seamless operating ecosystem.
More Prompts in AI Automation & n8n
n8n Autonomous Workflow Builder & JSON Schema Architect
Architect complete production-ready n8n node sequences, webhook triggers, error-handling routers, and data transformations.
Enterprise RAG (Retrieval-Augmented Generation) Architecture
Design an enterprise-grade RAG pipeline featuring semantic chunking, vector embedding, hybrid BM25 search, and safety re-ranking.
Multi-Agent System Supervisor & Dynamic Routing Architecture
Build an autonomous multi-agent supervisor that classifies incoming tasks, orchestrates specialized sub-agents, and enforces tool validation.