I Built a Shopify HubSpot Integration for a Client With 200K Contacts

Description and use

Integrating Shopify with HubSpot for a client with 200 000 contacts required careful field mapping, source-of-truth definition, batch migration, and error handling to avoid duplicates and data loss.

Problem

Integrating Shopify with HubSpot for a client with 200 000 contacts risked duplicate contacts, data overwrites, and operational messes.

Outcome

The integration successfully synced 200 000 contacts, maintained data integrity, avoided duplicates, and provided clear logs and error handling.

Workflow

• Map Shopify fields to HubSpot destinations and actions
• Define field ownership and source of truth
• Design contact matching logic using email and normalization
• Implement batch migration with ETL pattern (Extract → Transform → Validate → Sync → Log → Verify)
• Set up error handling for rate limits, network failures, invalid data, duplicates, and authentication issues
• Separate migration from ongoing sync
• Test idempotency and realistic scenarios
• Deploy with observability and monitoring

Evidence

The real problem is rarely connecting the two platforms. The difficult part is making sure customer, order, marketing, and lifecycle data move between them without creating duplicate contacts, overwriting useful information, or turning your CRM into a mess.

Source

I created a field-by-field mapping before building any synchronization logic

Source

With 200,000 HubSpot contacts, even a small synchronization mistake can have a significant impact.

Source

The initial migration was only one part of the project, and a bulk migration of 200,000 contacts needs to be treated differently from everyday synchronization.

Source

Design error handling from the beginning. The failures we planned for included API rate limits, temporary network failures, invalid customer information, missing required fields, duplicate records, unexpected API responses, authentication problems, and partial synchronization.

Source