How your Shopify customers appear in QuickBooks Online isn’t a one-size-fits-all decision. Some merchants want every customer as their own QuickBooks Online (QBO) record. Others want a clean, consolidated view by sales channel. Some need both, depending on order type. WeIntegrate supports all of it — and lets you configure exactly how it works without compromising your books.
That flexibility starts with a single, powerful choice: bulk or unique customer matching.
Bulk Customer Matching: All Orders Into a Single QBO Customer
With bulk customer matching, every Shopify order flows into a single designated customer in QuickBooks Online — one record per store connection. Your Shopify channel appears as one customer in QBO, giving you total revenue by channel without individual customer records in your books.
Some Shopify stores operate entirely at the channel level — wholesale accounts, high-volume direct-to-consumer (DTC) stores, or merchants whose accounting structure simply doesn’t require per-customer detail in QBO. Others prefer consolidated records regardless of volume. Whatever the reason, WeIntegrate supports it: you pick the default customer from your existing QBO records, and WeIntegrate routes everything to it automatically.
Unique Customer Matching: Full Customer Intelligence
Unique customer matching maps each Shopify customer to their own QuickBooks Online record. For merchants who want to see customer-level detail in QBO — repeat buyers, individual transaction history, customer-specific reporting — this is the mode that makes it possible.
The matching engine gives you two layers of control:
Primary matching lets you define which Shopify field maps to which QBO field. WeIntegrate uses that mapping to find the right QBO customer for each incoming order. The available fields are:
- Shopify (Sales Channel): Email, Company Name, FirstName LastName, LastName First Name, FirstName LastName + Company Name, FirstName LastName + Zip Code, LastName First Name + Zip Code, Phone
- QuickBooks Online (Accounting): Email, Customer Name, Phone
The breadth of Shopify-side options means WeIntegrate can match on whatever combination best represents how your customers exist in QBO — whether that’s by email, by name in various formats, by company, by a name-plus-zip combination for disambiguation, or by phone. A common setup is Shopify Email matched to QBO Customer Name — WeIntegrate compares the customer’s email from the Shopify order against customer names in QBO to find the right record.
Secondary matching adds a fallback within unique mode. If the primary match fails to find a result, WeIntegrate attempts a second match using a different field combination before moving to the next step. It’s a safety net that catches customers who might not match on the first criteria but do on the second — for example, falling back to Phone matched against Customer Name when an Email match comes up empty.
The full configuration walkthrough — including how to set up primary and secondary matching — is in the WeIntegrate customer matching setup guide.
When No Match Is Found: Two Powerful Options
What happens when a Shopify customer genuinely doesn’t exist in QBO yet? WeIntegrate gives you two choices, and this is where the system gets especially powerful:
Auto-create a new customer in QBO. When no match is found, WeIntegrate automatically creates a new customer record in QuickBooks Online using the Shopify customer’s details. Your QBO customer list stays current with your actual Shopify customers — no manual entry, no gaps. Every new customer who places an order through Shopify gets their own QBO record without anyone lifting a finger.
Fall back to the bulk customer default. If you’d rather keep unmatched orders consolidated, WeIntegrate can route any order where no customer match is found into your designated default bulk customer. This keeps individual customer records in QBO clean — only customers you’ve intentionally matched get their own record.
Additional Controls That Round Out the System
Unique customer matching also includes two practical options that handle real-world data quality:
- Convert inactive customers to active — if a returning Shopify customer exists in QBO but was marked inactive, WeIntegrate can automatically reactivate them rather than creating a duplicate or failing the match
- Update customer address — WeIntegrate can keep the shipping address on the QBO customer record current based on what Shopify provides on each order
The details for configuring bulk or unique customer matching and setting up primary matching are in the WeIntegrate community documentation.
The Right Customer in the Right Place, Every Time
Whether you want a single consolidated customer for channel-level accounting or a full per-customer breakdown with automatic new-customer creation, WeIntegrate handles it — and the flexibility to choose means your QBO structure reflects your actual business, not a compromise forced by your integration tool.
Start your free 15-day trial and configure your customer matching as part of your 10-minute setup. No credit card required.
Look out for our upcoming post on item matching — the same flexibility and power, applied to how your Shopify products map to QuickBooks Online items.