Sync Orders from QuickBooks Desktop

For QuickBooks Desktop, how should I format an address?

Instructions for formatting an address


To sync orders from QuickBooks, you must have a valid billing and shipping address. If the order is outside of the United States, add the country to the last line of the address. The city, state (if supplied) and postal code should exist on the same line. This guide is compatible with QuickBooks Online and QuickBooks Desktop, though screenshots of desktop are supplied.

Can I enter an order without a billing or a shipping address?

No, the orders will fail to sync. Ensure you enter a name and street address.

Orders Outside of the U.S.

Orders shipping to Canada should have the full country name on the last line. Orders outside of Canada and the U.S. must have the postal code and city on the line before the full country name. Orders shipping to Europe must have this format.

Here is an example order for Asia:

Eric Yan
Biomedic Technology
36 jalan desa 4/5 - Bandar Country Homes
48000 Selangor Darul Ehsan

Here is an example for Canada:

Maher Nuwwareh
Nebo Medical Ltd
55 Town Center Crt., Suite 700
Toronto, Ontario M1P 4X4

If you have a specific order traveling to a foreign country and it fails to sync, please contact us. 


We recommend inserting the company on line 1. If you want to enter the customer's name on the second line, prefix it with Attn:

Company and Name Mapping

Connex will compare lines one and two to the customer's name and company on file. In this example, Peter Taub is listed on line two. Connex determined that Peter Taub was the name because it was on file. If line 2 said Dr. Peter Taub, then the system would fail to match it correctly. You can prefix a line with Attn: and Connex will replace that part.


Here is the result in ShipStation:


A quick internet search of the valid address format for the country will fix most issues. The most common problem is an address is incomplete, or a phone number is included in the address.