How do I sync from multiple Amazon marketplaces?

Change marketplaces by currency

Introduction

In this example, the user is syncing from Amazon USA, Amazon Canada, and Amazon United Kingdom. The user must set-up mappings for A/R accounts and customers in QuickBooks.

How do I map customers?

Amazon orders have different currencies. You must change the customer name, based on the currency. You may place no USD sale into a QuickBooks customer that accepts CAD payments only.

Amazon combines the USA and Canada sales into one connection. All of the European marketplaces are combined under Amazon Europe.

In this example, we will separate Amazon sales by marketplace:

Here are the steps:

Change customer match

You must change the mode to selling channel.

1. Login to Connex.
2. Click manage.
3. Click customers.
4. Change the drop down to store name.
5. Click save.

Add customer rule

Next, we will add a rule to change the customer based on the currency code field:

1. Click rules > my rules on the left.
2. Click add new rule.
3. Select map field, based on a condition.
4. As the action, enter map selling channel.
5. Under what conditions, enter these values: order currency code, equals, CAD.
6. Under what should the value be, enter Web Store CAD.
7. Report steps 2 - 6 for each rule.

Add A/R account rule

If you sync sales receipts, this rule is unnecessary. Next, we will add a rule to change the A/R based on the currency code field:

1. Click rules > my rules on the left.
2. Click add new rule.
3. Select map field, based on a condition.
4. As the action, enter map order A/R account.
5. Under what conditions, enter these values: order currency code, equals, CAD.
6. Under what should the value be, enter Accounts Receivable (A/R) - CAD.
7. Report steps 2 - 6 for each rule.