How does the QuickBooks Enterprise and Connex Ecommerce Analytics integration work?

A step by step guide on what steps Connex takes to create reports.

How do I set up the integration?

Here are the steps:

  1. Log into QuickBooks Desktop as an admin and open the company file.
  2. Log into Connex.
  3. Click connections on the top right.
  4. Click QuickBooks Desktop.
  5. Enter QuickBooks Desktop in the text field.
  6. Click the green button:
  7. From the wizard, download the pairing file.
  8. Double click the file.
  9. A dialog will appear. Click OK.
  10. Another dialog may appear with radio buttons. Choose the last one, run even if the file is closed.
  11. To the left of Connex, check auto run and set an interval. We recommend 86400 to run it daily.
  12. Check the box to the left of Connex on the web connector.
  13. Click update selected:

What parts of QuickBooks do you integrate?

Our tool downloads the item list, sales by item detail and the inventory valuation. If you create or update an item in QuickBooks, then Connex will receive it. 

How does the data appear in Connex?

Our tool downloads data from QuickBooks to our database, using the QuickBooks Web Connector.

Connex will download your inventory and sales from QuickBooks using the inventory valuation report and sale by item report. Here are the steps:

  1. Connex downloads your inventory valuation report. The fields item, quantity on hand, average cost, and asset value are returned: 
  2. Connex saves the report to our database. Each time you run your web connector, Connex updates this report.
  3. Connex downloads your sales by item summary report. This report includes sales from selling channels, other QuickBooks syncing apps, and manual orders. Each time you run your web connector, Connex downloads the latest report into our database.

What do the reports look like?

Here is a screenshot of the inventory valuation report as a chart:

Here is a table:

The sales by item summary is located under inventory > turnover report: