How do I map multiple Amazon listings to a single SKU?

Introduction

Connex can map multiple SKUs to a single item name in QuickBooks. In this guide, we have a QB item name called ABC. There are two additional listings for abc:

  • ABC-1
  • ABC-2

We will map ABC-1 and ABC-2 to ABC.

How do I replace part of a SKU?

In this example, we will replace -A in any SKU. Widgets-A will map to widgets. Here are the steps:

  1. In Connex for QuickBooks, login and hover over the gear.
  2. Click rules engine.
  3. Click add new rule.
  4. Using replace part of SKU, add this rule.

Instructions

We will use the rules engine to say if the SKU contains ABC, then map it to ABC. Here are the steps:

  1. Add a row to this sheet for each SKU to map. 
  2. In Connex for QuickBooks, login and hover over the gear.
  3. Click rules engine.
  4. Above the grid, select bulk upload rules.
  5. Upload the spreadsheet.
  6. When prompted, view your rules and verify that they were uploaded.

If I add more Amazon products, do I need to upload more rules?

If the Amazon products do not contain ABC, then you would need to upload new rules.

Have more questions? Submit a request
Powered by Zendesk