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


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.


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 transaction log.
  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