Can I sync products from QuickBooks Online to Shopify?

Introduction

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:
    category.png
  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:

red_sox.png

Here are two child items in QuickBooks:

boston_red.png

How do the fields map between QuickBooks and Shopify?

Here is a list:

Connex Shopify Rule Notes
Title Title Map Product Name  
SKU SKU N/A If you select SKU to SKU on the Connex product matching tab, our tool maps the QuickBooks SKU. Otherwise, Connex maps the QuickBooks item name.
Description Long Description N/A Connex will map the QuickBooks sales description to the Shopify long description.
Collection Collection Map Product Collection  
Stock Quantity Stock Level N/A  
Amount Price N/A  
Active Active Map Product Visibility There is no way to add a product to a selling channel in Shopify. If you mark the product as inactive, then Shopify will list the product on no channel.
Vendor Vendor N/A  
Purchase Cost Purchase Cost    

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: product_previewer.png
Was this article helpful?
0 out of 0 found this helpful

Comments

1 comment
  • <a href="https://quickbooksfiledoctor.co/">Quickbooks File Doctor</a> is a widely used online tool for accounting and now it is in the market with the File Doctor that offers you to check your files with the free tool provided by Quickbooks.
    Quickbooks is the key to manage your personal finance by your own without any interference of anyone in your income. From the house of that great software company-<a href="https://quickbooksdiagnostic.tools/"> "Quickbooks Diagnostics tool" </a>is here now to secure your files over your system and prevent from any kind of unauthorize access.

    0

Please sign in to leave a comment.