How do I sync a summary of orders from Amazon?

Introduction

Connex can pull the Amazon settlement report and sync a single order. The transaction will add the products as line items with the quantity, SKU, unit price, and tax. Optionally, Connex will add the Amazon fees.

What are the advantages and disadvantages?

There are many advantages:

  1. You sync one order per settlement report, instead of several hundred.
  2. Connex adds the Amazon fees.
  3. It's easier to reconcile and it makes QuickBooks cleaner.

Here are the disadvantages:

  1. You cannot track sales by customer, since you only have a single order.
  2. You can only sync ninety days back.
  3. The sync runs bi-monthly, so you can't see your sales reporting until the next settlement report.

How far back can you sync?

The Amazon settlement report can only go ninety days back. If you need older orders, you can sync individual orders with Amazon directly. Choose Amazon at the my connections page. As a workaround, you could select summary order in the configure page and choose a one to two week date range. Cloud Cart would summarize them into a single order.

How do I add Amazon Fees?

At the configure page, Expand the Merchant Fees Tab, enter Amazon Fees:

How are shipping and gift wrap fees calculated?

Connex will add line items for shipping and gift wrap, as if you collected sales. If you add Amazon fees, Connex will add the shipping and gift wrap as an expense to cancel it.

What does a sample order look like?

Here is a sample summary sales receipt and a summary refund receipt.

Do I need to run this every two weeks?

Yes, you must log in every two weeks and run the sync.

How do I pair Amazon?

Even if you already have a seller ID and marketplace ID, you must add JMA as a licensed developer. Otherwise, your login will fail. You must obtain a seller ID and marketplace ID to integrate with your store. Do not enter your store login and password because it will fail. To obtain these identifiers, follow these steps:

  1. Go to this site: developer.amazonservices.com
  2. Click sign up for MWS.
  3. Login to your account.
  4. Click I want to give developer access.
  5. Enter developer's name as JMA Web Technologies
  6. Enter the developer Id as 5761-8358-4110
  7. Click next
  8. Agree to Amazon's terms and click next
  9. Make note of the Seller ID, Marketplace ID, and the MWS Auth Token: 

Once those steps are complete, go to back to Connex and enter your information:

  1. On the my connections page, select Amazon.
  2. 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 fourth box alone.
  3. Click the submit button.

How do I sync my first summary sales receipt?

Here are the steps:

  1. Login to Connex.
  2. Expand the "Sync Manually to QuickBooks" Tab
  3. Select configure.
  4. Change the export dates to the two week period of your settlement summary: Connex_Amazon_Sync_Manually.png
  5. Click Sync Now.
  6. In QuickBooks, click file and select update web services.
  7. In the web connector, check the box to the left of Connex.
  8. Click update selected.
  9. When the web connector reaches 100%, search for the Amazon Summary customer.
  10. You will see your summary sales receipt. You will see a credit memo, if there were refunds.

How do I check what report Connex will use?

Settlement Reports are distributed after the seller's settlement period, which is typically bi-weekly. If you had a sales period of February 23rd to March 9th, the report might be a day later. Try February 24th to March 10th in our system. You can use the order previewer:

  1. Login to Connex.
  2. Click configure at my connections.
  3. Hover over the gear and click reports.
  4. Click order previewer.
  5. Enter the date range.

In this example, we entered 1/13 - 1/27 to get the 1/13 to 1/27 settlement report. Connex pulls the settlement report where the export before date is greater than the report end date. If we entered 1/13 to 1/26, the report would not show. 1/26 is less than 1/27. Instead, the report before it of 12/30 to 1/13 would appear.

What if my settlement reports are not two weeks ranges?

Please read how do I check what report Connex will use above. Change the date ranges in the previewer, until you get the desired result.

 

Have more questions? Submit a request
Powered by Zendesk