How does Connex match products without a SKU or unique ID?

How to fix products without a SKU


For many selling channels, the field SKU can be blank. We use SKU as a unique ID to match QuickBooks and your selling channel products. 

My products have no SKU or unique ID. How will Connex match them?

Connex will log errors under sync activity's errors tab. Connex will map the value unknown_do_not_delete as your product SKU. Here is an example from QuickBooks:

You should fix these mappings because your inventory in QuickBooks will be incorrect.

Can I fix a SKU retroactively?

Once the order is placed, there is no way to change the SKU in your selling channel for past sales. You must open the sale in QuickBooks and fix the issue manually. You can only fix this issue going forwards. 

How do I fix blank SKUs in the future?

Using Shopify as an example, here are the steps:

  1. In Shopify, open the product whose SKU field is empty.
  2. In QuickBooks, locate the field that should match. The field is usually QuickBooks item name.
  3. Copy the value from QuickBooks into Shopify:
  4. In QuickBooks, open the sale and correct the mapping.
  5. Future orders should map correctly.

Can I use the rules engine to fix these mappings?

It is not recommended, unless you have a large number of sales. Here are the steps:

  1. Go the rule engine.
  2. Click add new rule.
  3. Under rule templates, choose map SKU.
  4. Enter the product title as the rule name.
  5. In the comparisons, enter these values
    1. Field to compare is name
    2. Field value is product title
    3. Comparison is equals
  6. In the end result, enter the QuickBooks item name.

Here is the end result: