Sync orders from QuickBooks to Shopify

Introduction

This article gives you step by step instructions for creating orders in QuickBooks and having them appear in Shopify.

Delay

There is up to a fifteen minute delay in syncing orders from QB to your ordering solution. Connex downloads the orders from company file, stores them, and processes them in a batch. To process them ASAP, go back to the Connex configure page. Click save and sync. Hover over the gear and click transaction log to see activity.

Product Matching

Connex matches the QB item name to the Shopify product SKU. If there is no match, Connex will log that syncing the order failed. Connex does not create products in Shopify from QB at this time.

Connex for QuickBooks

You must set-up your Shopify connection on the my connections page. On the configure page, follow these steps:

  1. On the QB export tab, check the box for sync orders from QuickBooks.
  2. If you want update orders in QB and update the order in Shopify, click update orders. If you want to update orders, go to the transaction tab of Connex. If you want to update invoices in QB, select invoices as the transaction mode. Otherwise, select sales orders.
  3. Click save and sync.

QuickBooks

You must create an invoice or sales order in QB. It must have a class called Shopify. Here are the steps:

Class Tracking

Each order must have a class called Shopify. To enable class tracking in QuickBooks, follow these steps:

  1. In QuickBooks, go to edit > preferences > accounting > use class tracking for transactions.
  2. Create a new invoice in QuickBooks and mark the class as Shopify.

Creating Orders

In QuickBooks, create a new invoice or sales order. Here is an example order.

Web Connector

You must run the web connector to send orders to Connex:

  1. In QB, go to File > Update Web Services.
  2. Next to Connex, check the box on the left.
  3. Click update selected.

If you have auto run enabled on the web connector, you could wait for it to run. Updating or creating an order in QuickBooks will cause the web connector to send the order to us for processing.

Next Steps

In Connex, click submit at my connections. Click save and sync at the configure page. In a few minutes, hover over the gear and click transaction log. You will see the order enter Shopify.

Examples

Here is an example from Shopify and the order from QB.

 

Have more questions? Submit a request
Powered by Zendesk