In QuickBooks Online, how should I enter an address to sync from QuickBooks?

What are some best practices to map addresses?

Open the customer record in QuickBooks. Ensure the billing, shipping, name, company, email, and phone fields are completed. Here is an example. QuickBooks will auto populate the address, when you create new orders. Make sure you hit the enter key on each line.

Does Connex use the address in the customer record or the order?

Our software uses the billing and shipping address from the order. To determine whether a line is a street, our tool looks at the address in the customer record.

How does Connex for QuickBooks Online know how to map company, first name, and last name?

Connex will enumerate through each address line. If the line matches the customer record's company, then our tool maps the line to company. If the customer first name and last name matches a line, then our tool maps the first and last name.

Here is an example:

You can preview how the order will map:

  1. Login to Connex.
  2. Click manage.
  3. On the left, click reports.
  4. Click order previewer.
  5. Change the drop down to sync orders from QuickBooks.
  6. Enter the order number.
  7. Click submit.

Here is an order in the previewer.

How do I map a U.S. address?

Here is the recommended format:

JMA Web Technologies
John Smith
123 Main St
Suite 100
Watertown, MA  02472

How do I map a foreign address?

The country should appear at the bottom with no text around it. Here are the recommended formats:

Jay Smith
20 Rue du Jeu des Enfants
67000 Strasbourg
France

Jay Smith
408 Main St.
Sintaluta, SK S0G 4N0
Canada

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

Comments

4 comments
  • It would be much more helpful to grab the ship-to address from the invoice instead of the customer record. The purpose of that box in the invoice is to be able to bill one and ship to the other. 

    0
  • Hi,

    Our software uses the billing and shipping address from the invoice. To determine whether a line is a street, our tool looks at the address in the customer record. I will update the documentation.

    0
  • I've been having issues with orders that sync to ShipStation from Quickbooks Online when the ship to on the invoice is manually changed and is different from the ship to in the customer record. In this case, the ship to in the customer record is the one sent over to ShipStation, not the one entered in the ship to box during invoice creation.

    0
  • Please open a new support case. Send a copy of the order from QuickBooks and your website. Point out what is wrong.

    0

Please sign in to leave a comment.