For QuickBooks Desktop, how should I format an address?

Introduction

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.

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
Malaysia

Here is an example for Canada:

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

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

Samples

We recommend inserting the company on line 1. For company on the first line, here is a sample order from QuickBooks. If you want to enter the customer's name on the second line, prefix it with Attn:

line2.jpg

Here is a sample order from Infusionsoft.

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.

parker_customer.jpg

 

address.jpg

Here is the result in ShipStation:

ss_example.jpg

Troubleshooting

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.

 

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.