Amazon

Introduction

Our software can pull Amazon Prime, FBA and Amazon MFN. Our software works with Amazon Canada, Europe, and the U.S.

When do Amazon sales sync?

They sync, when the order shipped. With unshipped orders, you must specify the status in Connex. Otherwise, they will not sync by date or by order number. To specify the order status, login to Connex. Click manage. Expand orders > sync orders to QuickBooks > sync manually to QuickBooks. Enter unshipped in the order status field.

Sync Inventory from QuickBooks to Amazon

For more details, read these instructions.

Can I sync a summary of orders?

Yes, you can sync a single summary sales receipt from the Amazon settlement report and you can include fees. For more details, read this article. If you require a daily summary of shipped sales, login to our software. Click manage. Expand the first area. Choose summary sales receipt. Please contact us, so we can make an adjustment on your account for the daily summary.

Set-Up - Amazon US

Pairing for QuickBooks Online users:

  1. Sign in to the Amazon Seller Central admin account - https://sellercentral.amazon.com 
  2. On the top menu, click apps and services.
  3. Click manage my apps.
  4. Click authorize a developer.
  5. Enter developer's name as: JMA Web Technologies
  6. Enter the developer Id as: 5761-8358-4110
  7. Go through the install wizard. You will obtain a seller ID, marketplace ID, and a AWS auth token.
  8. Login to Connex.
  9. Click add a new connection.
  10. Choose Amazon.
  11. Enter your seller ID, marketplace ID, and AWS auth token.

Pairing for QuickBooks Desktop users:

  1. Sign in to the Amazon Seller Central admin account - https://sellercentral.amazon.com 
  2. Visit the Connex app by clicking this link. Our software works with QuickBooks Online and QuickBooks Desktop.
  3. On the right, click authorize now.
  4. Go through the install wizard. You will obtain a seller ID, marketplace ID, and a AWS auth token.
  5. Login to Connex.
  6. Click add a new connection.
  7. Choose Amazon.
  8. Enter your seller ID, marketplace ID, and AWS auth token.

Please note, the developer credentials should auto-populate. If this fails, enter the following details into the appropriate fields:

  • Enter developer's name as: JMA Web Technologies
  • Enter the developer Id as: 5761-8358-4110
  1. Agree to Amazon's terms and click next.
  2. Make note of the Seller ID, Marketplace ID, and the MWS Auth Token. 
  3. Return to our software and enter your information:
  4. Enter your marketplace ID in the first box, the seller ID in the second box and the AWS token in the third box. The AWS Auth Token begins with amzn. Leave the URL alone.
  5. Click the Configure button.

Do you have a demonstration video?

Can I sync Amazon fees to my orders?

Our software can sync Amazon fees on each sale. To turn on this feature, follow these steps:

  1. Login to our software.
  2. Click manage.
  3. Expand the first area.
  4. Enter shipped as the order status. Only shipped orders have fees.
  5. Expand merchant fees.
  6. Enter an item name, like Amazon fees.
  7. Click sync now.

Our software will add a negative line item beneath each sale. Here is an example with Amazon fees.

FBA

By default, Connex pulls Amazon orders regardless of fulfillment channel. To pull FBA orders only, follow these steps:

  1. Login to Connex.
  2. Click manage.
  3. Expand orders.
  4. Expand sync orders to QuickBooks.
  5. In the last drop down, choose FBA:
    mceclip0.png

Can I sync unshipped sales?

Connex will sync shipped orders, by default. To pull in orders before they ship, follow these steps:

  1. Login to Connex.
  2. Click manage.
  3. Expand orders.
  4. Expand sync orders to QuickBooks.
  5. In the order status field, enter unshipped.

Why is the product name missing?

Our new Amazon integration sends no product name. As a workaround, you can map the sales description from QuickBooks:

  1. In QuickBooks, go to lists and click item list.
  2. Double click the item.
  3. In the sales description, enter the product title.
  4. In Connex, click manage.
  5. Expand orders.
  6. Expand advanced transaction.
  7. Check use QuickBooks item description.

If you can sync sales before they ship, please review the unshipped order instructions above this paragraph. Unshipped orders use our older logic.

Why do I receive throttling errors?

Amazon has a speed limit and you may pull a certain number of sales in a time frame. We estimate our software can pull about two hundred fifty shipped orders in one sync. If unshipped, our tool can pull about fifty sales. Here are our suggestions to stay under the limit:

  1. For Connex for QuickBooks users, set your auto sync interval to thirty minutes. 
  2. If you perform a manual sync, wait fifteen minutes before running another one.
  3. Set the sync dates to one to two days apart.
  4. If you use Connex for QuickBooks, try this method. Turn if off, when you are done. 

How do I map the Amazon ship date as the order date?

Out of box, our tool maps the purchase date as the QuickBooks order date:

  1. Login to our software.
  2. Click rules engine on the left.
  3. Click action and add new rule.
  4. Add this rule.

Can I sync shipped Amazon sales that are paid by invoice?

Amazon allows qualified businesses to pay on NET 30 terms. By default, these orders are skipped by our sync. Once the customer pays, the order will appear in QuickBooks. We recommend waiting for these orders to receive payment, before they sync, since the orders will fail to show on your settlement report. The order date will equal the purchase date. To sync these orders, follow these steps:

  1. Login to our software.
  2. Click manage.
  3. Expand the first area.
  4. Enter InvoicedUnconfirmed in the order status field.

To sync these orders with Amazon fees, expand advanced transaction. Check update QuickBooks transactions. Once the order is paid, our tool will locate the QuickBooks sale and add the fees.

To see if you have invoiced orders, follow these steps:

  1. Login to our software.
  2. Click manage.
  3. Click reports and order previewer on the left.
  4. Enter the order number.
  5. Check the payment method field. If it says invoice, then you need to add InvoicedUnconfirmed as the status.

How do I sync stock levels from QuickBooks?

You can instruct Connex to add existing Amazon items to your account, if they are missing. Connex can update the prices, stock levels, and handling time. For more details, read this guide. To test syncing stock updates, read this guide.

Can I sync a daily summary of sales from Amazon to QuickBooks?

Yes, you can sync a daily summary of shipped orders from Amazon to QuickBooks. This is advantageous, if you no desire to match individual sales to Amazon settlement reports.

Here are the steps:

  1. After pairing Amazon, choose summary transaction on the first step of the wizard.
  2. On the customer matching step, choose single name. This will place all sales under a single customer.
  3. In the merchant fees area, enter an item to hold merchant fees. Connex will summarize all fees per day.
  4. In the account matching area, we recommend choosing an asset account as the deposit account. You should use this method to match the deposits. For more info, read this guide.
  5. Finish the install wizard.
  6. To edit the single name customer, manage your connection. On the next page, expand advanced customer and enter Amazon summary.

Do you support split shipments?

Here is a use scenario:

  1. Order 114-9737156-1563453 has two split shipments.
  2. The first is on 4/13 and the second is on 4/19.

When our tool receives a split shipment, our tool will sync the other parts of the split. Order 114-9737156-1563453 tried to reexport on 4/19, even though it exported on 4/13. Your Connex log will say that order 114-9737156-1563453 already exists.

The other half of the split shipment should sync with a date of 4/19 and its order number is 114-9737156-1563453-1. If you had three split shipments, the orders would be 114-9737156-1563453, 114-9737156-1563453-1, and 114-9737156-1563453-2. Our software has to sync split shipments as separate orders.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.