Product Mapping FAQ

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

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

Introduction

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.

Is there a video I can watch?

Here is a demo:

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':

Overview: 

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.

How do I edit product mappings?

The product mapping tool is shorthand for our rules engine, which maps fields. Once you resync the sales, the mappings are export to rules and cleared from the product mapping area. Our mapping tool creates rules called map SKU. To edit a mapping, follow these steps:

  1. Login to Connex.
  2. Click rules on the left.
  3. Click my rules.
  4. In the name column, filter by the SKU:
  5. Click edit.
  6. Click the comparisons button.
  7. Edit your mapping: