How Data is Matched Between Systems

Contacts
We use a variety of ways to match customers between Shopify and your accounting system. Contact matching is determined by the setting "Assign Sales to be:". There are three options:
Customers are Companies
If the option for assigning sales to Customer's Organization is selected, then we will take the "Company" field in the customer's Default Address, and try to match it with the "Company Name" field in your accounting system.
Example: the default address shown of a customer in Shopify 
Customers are Individuals
If using Original Customer, we will first check the customer's first name and last name, then check if their email and phone number match between the store and the accounting system. If neither email nor phone number is found, then we will also try matching for customers in your accounting system with the exact same first name, last name and address (same street, city, country and Postal code)
Changing the customer on an invoice in MYOB
Unfortunately, you can't directly change the customer on an already closed invoice. The easiest way would be to follow the steps outlined here: https://help.myob.com/wiki/display/ar/Changing+the+customer+on+a+recorded+invoice​
Products
Products are matched using the product SKU from your store with the item code in your accounting system.
Invoices
Invoices in your accounting system are matched with Shopify order number and the optional setting for order number prefix.
​

Workflow setups - Previous

Sync Stock Levels from Xero to Shopify Stock Levels

Next - How do I...?

How do I sync a single Shopify order manually?

Last modified 1yr ago

Copy link

On this page

Contacts

Customers are Companies

Customers are Individuals

Changing the customer on an invoice in MYOB

Products

Invoices