Connex can search for QuickBooks products by SKU or item name. If you choose SKU, ensure all of your SKUs in QuickBooks match your website SKUs. Your item name should match your product title.
How do I enable this setting?
Here are the steps:
- Login to Connex.
- Click manage.
- Expand products > product matching.
- Enable SKU to SKU:
If I enable SKU to SKU, how do fields map?
- The product title matches to the QuickBooks item name.
- Your website SKU maps to the QuickBooks product SKU field.
What if my QuickBooks item name matches my product title?
Connex will search all QuickBooks products by QuickBooks item name to website product title and QuickBooks SKU to website product SKU. In this example, the name of our product is SyncWithConnexItem2.
- There is no product in QuickBooks whose SKU is SyncWithConnexItem2.
- Connex creates a new item, but maps SyncWithConnexItem2 to the QuickBooks item name field.
- SyncWithConnexItem2 already exists (see image below this paragraph.)
- Creating the item fails and the order fails to sync.
How does it work?
- If you choose SKU to SKU, then all of your product SKUs in QuickBooks must match your website product SKUs.
- Your product SKU cannot match your QuickBooks item name and not your website SKU.
- Your shipping methods and discounts have no SKU. Therefore, we will match the QuickBooks item name to these items.
- Your products must have unique SKUs. QuickBooks allows you have two products with the same SKU: