Pipemonk continuously matches existing Products & Customers from Shopify to QuickBooks Online.


We match Customers if the display name is same in both Shopify and QuickBooks Online. For instance, if there is a Customer 'John Mayer' on both sides then we do not create another customer 'John Mayer' in QuickBooks Online.


We offer two options to configure while creating Products

  1. Name 
  2. SKU


If SKU is chosen then if it is same of both Shopify and QuickBooks Online then matching happens automatically. And if name is chosen then for matching to happen with existing products thereby avoiding duplicates we expect the product in QuickBooks follows our naming convention. 


For instance, Say there is a product named 'Puma T-Shirt', whose variants are classified on attributes: size (Small/Medium/Large) and color (Black/White). Then we create products with names in the following style:


1. Puma T-Shirt -- Small / Black

2. Puma T-Shirt -- Medium / Black

3. Puma T-Shirt -- Large / Black

4. Puma T-Shirt -- Small / White

5. Puma T-Shirt -- Medium / White

6. Puma T-Shirt -- Large / White 


Format followed: <Product Title>[1-Character White Space]--[1-Character White Space]<Attribute1>[1-Character White Space]/[1-Character White Space]<Attribute2>


So if this style is followed for your product names on QuickBooks Online then we will match with the product else a new product will be created.