How does Connex match products?

Introduction

Connex will match the product SKU from your online store to the QuickBooks Item Name field. Although QuickBooks Desktop has a field called SKU, it is not used in any matching at this time.

How do you recommend matching products?

We highly recommend entering SKUs to all of your products n your store, regardless of them being inventory items. SKUs almost never change and they usually contain numbers or letters, which QuickBooks accepts as the name field. In the event that a product has no SKU in your online store, Connex will insert a SKU called unknown_do_not_delete into QuickBooks. If your product SKUs and QuickBooks item name field matches, then there is no manual matching you must perform. If you need to match SKUs and QB names manually, see this article.

Here is a product SKU from an online store:

 

Here is a matching item in QuickBooks:

What if I use parent child items? 

QuickBooks has two fields: name and full name. If your product SKU is hammer, Connex will locate the product if it's under a parent, like Tools:Hammer.

If hammer exists under two different parent items, then your SKU must be the parent:child.

Tools:Hammer

Hammers:Hammer

Your SKU must be Tools:Hammer to match correctly.

Can Connex log errors and stop creating products, if orders are missing?

Yes, Connex can log errors and tell you to map products. For more details, read this guide.

Can Connex match the product title to the QB item name?

Product titles can change and many contain special characters, like trademark and copyright signs. These can cause sync errors because QB cannot accept them in the name field. Connex will strip many of these characters. Although we recommend against matching a product title to a QuickBooks name, it can be accomplished. Here are the steps:

  1. Login to Connex.
  2. Hover over the gear box and click rules engine.
  3. Click add new rule.
  4. Enter these values:

 

Can Connex Match Manufacturer Part Numbers?

Connex can match the manufacturer part number to your online store SKU. Go to the Connex configure page and click the advanced tab. From the advanced item settings, choose manufacturer part number. 

How does Connex map SKUs that contain a colon?

If the SKU contains a colon, then the product must exist as a parent child relationship in QuickBooks. Here is an example:

Here is how the full name appears in QB:

If QB had no Tools:Hammer, you would receive this error:

Error 3140 : While trying to Add a(n) Invoice with name or order number of SW105275, QB responded There is an invalid reference to QuickBooks Item "Tools:Hammer" in the Invoice line.

You can either create the items or replace the colons with a dash:

Tools-Hammer

Connex can find names under multiple parent items, even if the SKU contains no colon. If your SKU was hammer, QB would find it under Tools:Hammer.

Have more questions? Submit a request
Powered by Zendesk