How do I perform an initial sync of inventory and products to QuickBooks?



Cloud Cart Connector will sync inventory modified from the date of install moving forwards. You can adjust the dates it uses to sync inventory updates.

What are the benefits of using a spreadsheet?

There are many benefits:

  1. If you have several hundred products, you can import them faster. Our tool inserts products one by one.
  2. Using spreadsheet is the easiest way to perform an initial sync of inventory because you can insert items in bulk.
  3. You can specify different accounts for each product.

I have several thousand products. How do I sync the items to my site?

We recommend exporting your item list as a spreadsheet from QuickBooks. Here are the steps:

  1. In QuickBooks, go to the gear box > products and services.
  2. On the right, click the export to excel icon.

Almost all e-commerce solutions offer a product spreadsheet import. If the tool finds a match, you will be asked to update it. The most important mapping is the QuickBooks item name to the product SKU. Here are some other suggested mappings:

QuickBooks Field E-Commerce Field Notes
Name Product SKU The QuickBooks item name should be the unique identifier. 
Sales Description  Product Description or Title This field is arbitrary to us. The sales description is usually the product title.
UnitPrice  Price   
Quantity on Hand  Quantity on Hand    

If I have a small number of products, like a few hundred, can I just sync them automatically?

Cloud Cart can sync inventory updates up to ninety days ago from QuickBooks to your site. Cloud Cart can perform an initial sync if you have a few hundred products. To change the timers, follow these steps:

  1. Login to
  2. Select the connection where you want to sync inventory. If you have one site only, click submit.
  3. Go to the advanced tab.
  4. Under inventory settings, adjust the timer: 
  5. Click save and sync.
Have more questions? Submit a request
Powered by Zendesk