Sync Orders from Connex Database

Introduction

Many e-commerce solutions fail to respond in two minutes when syncing several orders. The Web Connector, the application that runs the sync in QuickBooks, expects a response within two minutes from our database. Connex has a special setting to queue up orders, which responds within the two-minute timeframe, called "Insert Orders in Bulk."

Default Solutions

For these solutions, the setting is enabled by default:

  1. Amazon
  2. eBay
  3. Infusionsoft
  4. Magento

Download Historical Orders

If you are catching up on missing or historical orders, consider writing a journal entry. For more info on best practices, see this knowledge base article.

Web Connector Error

When you run the web connector, it will say "authentication failed" if the database tool has been disabled. When you click the blue link, it will say the operation has timed out. Enabling the Insert orders in Bulk feature will remedy this error.

Enable Sync Orders from Connex Database

Here are the steps:

  1. Login to your Connex.
  2. At the My Connections page, select your connection and click Configure.
  3. Scroll down and click on the Advanced Transaction drop-down menu. Click "Insert Orders in Bulk":
  4. Click "Sync Now" to save.

Download Orders

To download orders, simply run a manual sync. In 15-30 minutes, you will see some activity in your pending transactions report.

Pending Transactions

To see pending transactions, follow these steps:

  1. Login to Connex for QuickBooks.
  2. At the My Connections page, select a connection and click Configure.
  3. On the right-hand side of the screen, click Settings.
  4. Click Reports.
  5. Click Pending Transactions.

Here is an example report:

Delete Pending Transactions

On the Pending Transactions report page, click the link to delete the pending orders. It's located above the pending transactions grid.

Sync Time

The amount of time to sync transactions depends on several factors:

  1. If you chose invoices and payments, the software will check for duplicate invoices and payments one by one. The software goes from Connex to QuickBooks for each invoice and payment. The operation takes about a second per order and payment to complete.
  2. The system matches the customer on each order to an order in QuickBooks.

If you had two hundred orders matching by LNFN with payments, there are six hundred requests. It would take approximately ten minutes to sync the orders.

Have more questions? Submit a request
Powered by Zendesk