How do I sync inventory from QuickBooks to Amazon?

Introduction

Connex allows you to use QB as a product catalog. You can make pricing and inventory updates in Amazon from your QB item list. You must set up Connex, map the ASIN, update items in QB, and verify that the updates were successful.

What happens if I sell on FBA?

Connex will log that the item is FBA and skip changing stock.

How do you map handling time from QuickBooks to Amazon?

There is no report to pull the handling time from QuickBooks. As a workaround, you can hard code a default handling time for all products. If our tool sends no handling time, then our system will remove the handling time from all products. Here are the steps to add the handling:

  1. Go to the Connex rules engine.
  2. Add this rule. You may replace five with any period.

Parts

You must accomplish these tasks:

  1. Turn on the inventory sync from QB to Connex, so Connex can sync inventory to Amazon.
  2. If you want to update multiple listings from one QB item, map the SKUs.
  3. Watch your pending inventory and transaction logs.
  4. Login to Amazon and confirm the updates.

SKU Mapping

If your Amazon SKU and QB item name match, skip to the next section. Otherwise, follow these steps:

  1. Complete this spreadsheet.
  2. Login to Connex.
  3. Go to the bulk upload page.
  4. Upload the sheet.

Update Multiple Listings

Connex can update multiple listings from Amazon, if the products are the same and the SKUs are different. Cloud Cart Connector, another product our company created, has multiple listings in the Intuit App Center:

If you want to update multiple listings, follow these steps:

  1. Complete this spreadsheet. Add a row for each listing.
  2. Login to Connex.
  3. Go to the bulk upload page.
  4. Upload the sheet.

Connex will update the SKUs with the same quantity as the parent SKU.

QuickBooks

If you have a single warehouse in QuickBooks, you must update some items. Here are the steps:

  1. In QuickBooks, go to list > item list.
  2. Update the quantity on hand for some items.
  3. Go to File > Update Web Services.
  4. Check the box next to Connex and run the web connector. This action will send a text file of the inventory updates to us. Our system will process these updates in a batch every fifteen minutes. It can take up to twenty minutes for Connex to sync with Amazon.

If you have multiple warehouses, just run your web connector.

Confirm Updates

To confirm the inventory updates, follow these steps:

Connex

Connex logs inventory updates:

  1. On the Connex my connections page, select your connection.
  2. On the configure page, click account in the top menu.
  3. Click pending inventory. Here is the grid: 
  4. Hover over the gear and click transaction log to see what has synced.

Amazon

Amazon produces a report of the sync. To read it, follow these steps:

  1. Login to Amazon Seller Central.
  2. On the top menu, go to inventory > add products via upload.
  3. Verify that none of the updates show errors:  

Troubleshooting

Here are some common issues:

The product-id that you provided does not match

Your product SKU in Amazon and the ASIN that you send us must match. In this example, we send the SKU as BD3664, instead of BD3664c.

  1. FBA products will not update stock. 
  2. A product can only have a single ASIN. If you add multiple rules, the last rule to execute will run.
Have more questions? Submit a request
Powered by Zendesk