Products Matching

Can I sync products from QuickBooks Online to Shopify?

We recommend adding new products to QuickBooks, then adding stock levels. This workflow ensures you can properly track inventory and COGS. Connex can map products from QuickBooks to Shopify, if the product is missing during the inventory sync. 

How do I enable this feature?

Here are the steps:

  1. Login to Connex.
  2. Click manage.
  3. Expand sync direction.
  4. Choose inventory and orders.
  5. Expand sync inventory from QuickBooks.
  6. On the bottom, select create products if missing.
  7. Click save and sync now. 

Can you sync pictures?

Not at this time. Please contact us and if there is enough demand, then we will consider for a future release. Shopify requires that the picture exists on the internet as a file, which makes syncing pictures more difficult for us.

Can Connex map parent products?

If the parent product already exists with the item title and if two items have the same name, then Connex will map both items as child products.

The problem with QuickBooks is item name is a unique field. The solution is to use QuickBooks product category feature:

  1. In QuickBooks, open a product.
  2. In the product category field, enter the Shopify product name. In this case, enter Boston Red Sox Ball:
  3. In Connex, click rules on the top right.
  4. Add a rule that maps the QuickBooks product category to the Shopify product title.

Here is a parent product in Shopify:

Here are two child items in QuickBooks:

How do the fields map between QuickBooks and Shopify?

Here is a list:

Can I preview the fields, prior to syncing?

Connex has a product previewer, which can show the field mappings:

  1. Login to Connex.
  2. Click manage.
  3. On the left, click product previewer.
  4. If you want to query items by SKU, check the SKU checkbox. Otherwise, our tool will query items by QuickBooks item name.
  5. Enter a comma separated list of QuickBooks item names or SKUs to query.
  6. Here is the end result: 
Can't find what you're looking for? Let us help you right now!