Order Customer Sync

Overview

While Shopify and HubSpot's standard integration app handles basic customer sync, this custom implementation enables fine-grained control not possible with the standard connector:

• Sync only under specific conditions (order amount, product category, etc.)
• Integrate custom fields not covered by standard sync
• Custom business logic like cumulative purchase calculations

By connecting HubSpot Contacts API with Shopify Webhooks, sales reps can check the latest customer info and purchase history in HubSpot without manual entry.

Why Custom Integration

The standard integration app covers basic needs, but real-world operations often require:

Solution

Trigger on Shopify Webhook (orders/paid), received by Next.js API Route. HMAC signature verification blocks unauthorized requests. Search/create/update customers via HubSpot Contacts API. Define custom Contact Properties (Shopify Customer ID, total purchases, last purchase date, etc.) to accumulate purchase data.

Benefits

• Auto-create/update HubSpot Contact on Shopify order completion
• Accumulate Shopify purchase data in HubSpot custom properties
• Automate MA with HubSpot Workflows (post-purchase follow-up emails, etc.)
• Sales reps can instantly check purchase history in HubSpot Sales Hub

Architecture

1. Customer completes Shopify order
      ▼
2. Shopify sends Webhook (orders/paid)
      ▼
3. Next.js API Route receives and processes
 a. HMAC signature verification (confirm legitimate Shopify request)
 b. Extract customer info from order data
 c. Search existing customer via HubSpot Contacts API (match by email)
 d. New → Create Contact / Existing → Update properties
 e. Update custom properties (total purchases, last purchase date, etc.)
      ▼
4. Register/update as Contact in HubSpot CRM
      ▼
5. HubSpot Workflow triggers (post-purchase follow-up emails, etc.)