How do I sync inventory from QuickBooks to Amazon?

Follow

Introduction

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

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.

What happens if I sell on FBA?

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

Parts

You must accomplish these tasks:

  1. Turn on the inventory sync from QuickBooks to Cloud Cart, so Cloud Cart can sync inventory to Amazon.
  2. Watch your pending inventory and transaction logs.
  3. Login to Amazon and confirm the updates.

Set Up Cloud Cart Connector

Here are the steps:

  1. On the my connections page, add your Amazon connection.
  2. On the configure page, scroll down to task settings.
  3. Select sync inventory and orders.
  4. Click save and sync.

SKU Mapping

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

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

Update Multiple Listings

Cloud Cart can update multiple listings from Amazon if the products are the same and the SKUs are different. Here is an example:

Cloud Cart Connector has multiple listings on 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 Cloud Cart Connector.
  3. Go to the bulk upload page.
  4. Upload the sheet.

Cloud Cart will update the SKUs with the same quantity as the parent SKU.

QuickBooks Updates

You must update items in QuickBooks, so they sync with Amazon. The Amazon product SKU must match the QuickBooks item name. For a future release, Cloud Cart will allow a single product in QuickBooks to update multiple listings. Right now, it's one product in QuickBooks updates one product in Amazon.

QuickBooks Item Name:

Amazon SKU:

Receive Items

You must receive the items in QuickBooks by performing an inventory adjustment or by creating a PO and a bill. Here are the steps:

Inventory Adjustment

You can easily adjust inventory in QuickBooks Online:

  1. Login to QuickBooks Online.
  2. Click the gear > products and services.
  3. Double click an item
  4. Click the inventory adjustment button
  5. Change the quantity
  6. Click save

This screenshot will show you how to make an inventory adjustment.

Purchase Order

To increment inventory with a PO, you must copy the PO to a bill. Here are the steps:

  1. Click suppliers on the left
  2. Choose the supplier
  3. Choose the PO
  4. On the right, click copy to bill.

If you do not copy the PO to a bill, then inventory is never received and the quantity on hand stays the same. Here is a screenshot of copying a PO to a bill.

To see the quantity on hand, view this screenshot. To see how to increment quantity on hand manually and make a product an inventory item, see this screenshot.

Confirm Updates

To confirm the inventory updates, follow these steps:

Cloud Cart Connector

Cloud Cart logs inventory updates. Login and hover over the gear. Click transaction log.

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: 

 

Have more questions? Submit a request
Powered by Zendesk