Shopify Two-way Data Integration
The challenge they faced
As a custom graphics manufacturer, the team needed to integrate their operations with HubSpot and connect critical systems like Notion to manage proposals, quotes, and project documentation. They had explored a basic integration approach through a third-party connector, but testing revealed it would not support their core workflows–specifically, it could not pull in live documents, quotes, or proposal ideas as required. The team also needed to resolve email functionality within their CRM to streamline communication and document handling.
The challenge was compounded by the need to ensure the right integration approach before implementation. The team wanted to avoid deploying a solution that would create problems down the line, particularly around syncing proposal and quote data. They also needed to coordinate with multiple stakeholders across their organization to align on the solution and move forward with confidence.
The strategy we mapped
We designed the integration strategy to establish two-way data flow as the foundation, treating HubSpot as the single source of truth from the start. The project revealed that a third-party connector the team had explored would not support their core workflows–specifically pulling live documents, quotes, and proposals from Shopify–so we pivoted to native HubSpot integrations and custom API work. The sequencing prioritized email connectivity and Shopify order sync first, since these fed the sales and design workflows, before tackling quote and proposal automation.
Early testing of the HubSpot-Shopify two-way sync exposed a critical blocker: the native integration could not handle product variants or dynamic shipping costs, forcing salespeople back into Shopify despite the goal of keeping them in HubSpot. We investigated supplemental tools and workarounds–including file aggregation, email permission fixes, and a custom Shopify metafield for payment links–to bridge the gap while the team assessed longer-term solutions. Gmail history backfill and QuickBooks bi-directional sync were enabled in parallel to complete the data foundation.
The solutions we executed
We integrated Shopify with HubSpot using both native and custom approaches. The native Shopify app syncs contacts, companies, and cart abandonment data, and we set up two-way order sync to feed Shopify order data back into HubSpot deals. A custom Shopify metafield stores payment links from draft orders so they can be pulled into deal properties and included in email templates–allowing salespeople to send a Shopify invoice and HubSpot proof in a single email thread. Due to limitations in the native integration's handling of product variants and shipping calculations, the team is evaluating a supplemental tool to fully support the workflow.
Gmail migration brought in historical email and attachments–roughly 600GB across 14 email accounts over the past ten years–into HubSpot contact records. We set up attachment filters to exclude small files and sender exclusion rules to keep internal noise and junk mail out of the CRM. We also backfilled a gap in the email record (Feb 8–17) before native mailboxes were connected, with the team accepting minor duplicates in exchange for complete archive. This created a continuous email thread view for every customer relationship.
QuickBooks Online synced bi-directionally with HubSpot, keeping contacts, invoices, and products in sync across both systems. We also implemented a workflow to automatically manage file accessibility for customer uploads, changing files from private to public (no-index) so they can be shared externally without requiring recipients to request access.
ZoomPhone integration connected calls and SMS to contacts and companies in HubSpot, routing all customer phone activity into the CRM for unified communication tracking.
What changed after the engagement.
The client now has native integrations between HubSpot, Shopify, QuickBooks Online, Gmail, and ZoomPhone, establishing HubSpot as the single source of truth for customer data, orders, and communication. Shopify order and contact data sync bidirectionally; Gmail brought ten years of email history and attachments into contact records; QuickBooks invoices and products stay synchronized across both systems; and phone calls and SMS route through the CRM. Custom workflows extract Shopify metafields like PO numbers and payment links into deal properties, and file accessibility automation allows the team to share customer uploads externally without requiring recipients to request access. While the native Shopify integration lacks support for product variants and dynamic shipping, workarounds using custom metafields and supplemental tools bridge the gap so salespeople can operate primarily in HubSpot instead of toggling between systems.
Want results like these?
Tell us where your revenue engine is stuck — we'll map the fix in one call.