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.

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.

Last updated