Can I stop syncing orders if products are missing from QuickBooks?


Connex is programmed to create a new inventory item in QuickBooks if the product does not exist or there is a mismatch between the product SKU in your shopping cart/shipping platform when an order syncs to QuickBooks.

You can instruct Connex to NOT create new items in QuickBooks, if there is no matching product.

Is there a video I can watch?

Yes, watch this demo. Skip to Part 4 on the Table of Contents. 

How do I set up this feature?

Here are the steps:

  1. Login to Connex.
  2. Click the 'manage' button next to the Selling Channel you wish to configure settings.
  3. Expand the Products Menu -> Missing Products
  4. Choose 'Flag order as error and map':



The product mapping tool is a short hand way to use our rules engine

How do I use this tool?

You can access the Product Mapping Tool from the Connex Dashboard in the Map Product Window or from the Left Navigation Area:


  1. Login to Connex.
  2. Select the Products Menu in the left nav area.
  3. Select Missing Product Mapping.
  4. Click the edit button next to the product you wish to map.
  5. If you use QuickBooks Online, use the auto-complete tool and start to type the product name to match. If you use QuickBooks Desktop, you can upload a list of QuickBooks products using the link on the left. This step is optional and many users just enter the item into the field.
  6. Enter the QuickBooks item.
  7. When finished, click Resync orders.
  8. If you use QuickBooks Desktop, run the web connector.

Steps to upload your QuickBooks item list (For Desktop users only):

Export QuickBooks Item List

Connex has an autocomplete box that will find the item in QuickBooks, when you type part of it's name. Although using this feature is optional, it is recommended.

To set it up the auto-complete feature, here are the steps:

  1. Select the Product Link in the Left Nav of Connex.
  2. Select the link to Upload QuickBooks Products.
  3. In QuickBooks, go to lists and click item list.
  4. Click excel on the bottom.
  5. Export all of the items.
  6. Open the spreadsheet.
  7. Go to file and click save as.
  8. Select CSV.
  9. Upload the sheet to Connex on the Upload QuickBooks Item List page by clicking the 'select files' button
  10. Go back to the Product Mapping Tool page or tab and select the 'edit button'.
  11. Enter a QuickBooks item to map and the type of item to match. If you are mapping shipping methods, choose shipping method from the item type drop down. If you are mapping SKUs, choose product


If my products have no SKUs, can I map by title?

If your product SKU field is blank in your web store,  then our tool will add the product title as the field to map.

Was this article helpful?
0 out of 0 found this helpful



Article is closed for comments.