Amazon

Amazon

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?

By default Amazon sales sync when the order is shipped. With unshipped orders, you must specify the order status in Connex. Otherwise, they will not sync by date or by order number. To specify the order status:

  1. Login to Connex. Click manage.
  2. Expand Orders > Sync Orders to QuickBooks > Sync Manually to QuickBooks.
  3. Enter unshipped in the order status field.
    • To sync unshipped, unpaid Amazon sales, enter unshipped, invoiceconfirmed into order status field.

Sync Inventory from QuickBooks to Amazon

For more details, read these instructions.

How do the fields map with Amazon and QuickBooks?

Please read this guide.

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 (make sure you are signed in as primary user, all other users will be told they are not authorized).
  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 shipped sale.  To turn on this feature, follow these steps:

  1. Login to our software.
  2. Click manage.
  3. By default, Connex only syncs shipped orders. If you enabled unshipped orders, you must clear the filter under orders > sync orders to QuickBooks > sync manually to QuickBooks.
  4. Expand orders > sync orders to QuickBooks > merchant fees.
  5. Enter an item name:
  6. Click sync now.

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

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:

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.

    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.

    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.
    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?

    You must enable the next number from QuickBooks. Split shipments have the same order number, but the order date is different. 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.

    Two orders will sync:

    1. Order with memo 114-9737156-1563453 on 4/13:
    2. Order with memo Order 114-9737156-1563453 on 4/19:

    Troubleshooting

    Description

    I receive a 524 gateway timeout, when I sync sales from Amazon to QuickBooks. My QuickBooks Web Connector says authentication failed. My log might also say my request has been throttled.

    Here is the web connector error:

    Problem

    If you use QuickBooks Desktop, Amazon must respond with all sales in less than two minutes. Otherwise, the sync will fail. Our tool pulls the contact info on the order separately, which takes more time. We can sync about 250 - 300 sales at once.

    Solution

    Here are the solutions:

    1. Use a shorter sync range. Login to Connex. Click manage. Change the sync dates to a 24 hour range.
    2. Consider using our Amazon settlement report summary. You can sync a summary of your sales every two weeks. For historical syncs, we recommend the summary.
    3. Sync a daily summary of your sales. Our tool skips the contact info and it can sync about 450 - 500 sales at a given time.
    4. Our spreadsheet tool can import a large number of Amazon sales. Export a spreadsheet of sales from your Amazon seller central account. The spreadsheet should have the fields order-id, purchase-date, sku, and product-name.

    Description

    I am missing Amazon sales that have yet to ship, they are invoiced, or split shipments.

    Problem

    Our tool only syncs fully paid, shipped sales by default.

    Solution

    Here are the solutions:

    1. If you want to sync unshipped or invoiced orders by FBA, read this documentation.
    2. If you are running a manual sync, make sure you enter the date the orders shipped.
    3. If you are missing split shipments, ensure you selected use next QuickBooks number.