Sync Orders from Infusionsoft by Keap to QuickBooks

The integration installs no files on your website. It pulls data from a page on Infusionsoft by Keap's website, based on your user information.

Infusionsoft Set-Up

Here are the steps to integrate:

  1. Login to Connex.
  2. On the my connections page, choose Infusionsoft.
  3. Click submit.
  4. In the modal dialog, click continue.
  5. Login to Keap.
  6. Allow access to our app.

You will be redirected to our site to complete your settings.

I sync daily or I need to use the legacy API. How do I add my API key?

If you see 'please obtain an API key from Infusionsoft and replace the one we have on file', in your error log, here are the steps:

  1. Obtain an API key from Infusionsoft by Keap.
  2. On the Connex my connections page, click update login.
  3. In the company name field, enter the name of your Keap account. If your account was, then enter iq146: 
  4. Enter the key into the API key field.
  5. Clear the refresh token field.
  6. Click submit.

Invoices and Payments

Our system can pull Infusionsoft payments independent of invoices. An invoice can enter QuickBooks, followed by a payment a few days later. Infusionsoft by Keap adds manual payments with a time of 12:00 AM. Our system will add twenty hours to this time, so our system can retrieve it. If you create an order and a manual payment within a few minutes, the payment should sync with the order. Otherwise, please allow up to one day to receive payments in QuickBooks. 

To set-up invoices and payments, go to the settings page of Connex for QuickBooks Online or Connex for QuickBooks Desktop. Select invoices and payments if paid from the transaction drop down.

Why are failed payments syncing?

Connex for QuickBooks Online and Connex for QuickBooks Desktop will sync any Infusionsoft order to QuickBooks. Failed payments generate an Infusionsoft invoice, but no payment. There are two things you can do:

  1. Switch to invoices, payments if paid. It's the first drop down on the configure page.
  2. On the Connex for QuickBooks Online and Connex for QuickBooks Desktop All Settings Page, expand the Sync Manually to QuickBooks menu. In the order status field, enter paid. Only paid orders will enter QuickBooks. You can still sync sales receipts.

Matching Payments

The payment reference number uses the transaction ID, which is a unique ID assigned by your bank. By assigning a unique ID to QuickBooks payments, you can assign multiple payments to the same order:

  1. Invoice 123 in Infusionsoft for $100
  2. Payment 1 for $25
  3. Payment 2 for $75

Our software looks for duplicate payment by the reference number. If you assign the invoice id as the reference number, two things will happen:

  1. You cannot assign multiple payments for the same invoice.
  2. It's possible another payment uses that reference number.

If you pull a transaction detail summary from your merchant account, you can match the payment reference numbers.

Why do my QuickBooks item names say unknown_do_not_delete?

We match the Infusionsoft by Keap SKU and QuickBooks item name. If there is no SKU or the order item has no item name, you will get unknown do not delete.

There are two ways to resolve this issue:

  1. Open an order in Infusionsoft by Keap. Click the order item. Ensure that the item name has been completed. If not, Infusionsoft will match to no product and there will be no SKU. 
  2. In Infusionsoft, go to the products area. Edit a product. Ensure that the SKU field has been completed.

Matching Contacts

Connex for QuickBooks Online and Connex for QuickBooks Desktop primarily uses the QuickBooks email and the Infusionsoft by Keap email fields. In the event there is no match, the system will try a first name, last name match. If a company has been supplied and a city, the system will also use it to match.

How do I pull orders by invoice number?

You must find the Infusionsoft by Keap invoice number for each sale:

  1. In Infusionsoft by Keap, go to your all sales itemized report.
  2. Find the order that you are trying to sync.
  3. Note the invoice number field.
  4. Login to Connex.
  5. Expand manually sync.
  6. In the order number field, enter a comma separated list of invoice numbers.