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



Cloud Cart can map multiple SKUs to a single item name in QuickBooks. In this guide, we have a QuickBooks 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 Cloud Cart Connector, login and hover over the gear.
  2. Click rules engine.
  3. Click add new rule.
  4. Using replace part of SKU, add this rule.


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 Cloud Cart 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