How do I sync historical orders?

Follow

Introduction

Cloud Cart Connector can import historical orders or change existing orders, based on a settings change. 

Can I preview a list of orders?

On Cloud Cart, hover over the gear icon and click reports. Click order previewer. You can view orders by a date or by a list of order numbers.

Can I sync all of last year's orders?

On a trial, you may sync up to 500 orders. Paid subscribers are limited by their yearly order limit, so you need to purchase to sync a year's worth of orders. Cloud Cart allows you to sync up to thirty days at a time, but you might have to sync one to two weeks at a time for Amazon orders. How far back in time you can sync is unlimited.  If you have several thousand orders, contact your CPA about creating journal entries. You may export a spreadsheet of orders from your store and use Transaction Importer Pro, a third party app, to import a spreadsheet to QuickBooks. For more info on the disadvantages of syncing last year's orders, read these instructions.

Historical Orders

Cloud Cart Connector uses a scheduled task system to pull orders. By default, the system pulls orders from current install date into the future. If you want to import orders from the past, login to cloudcartconnector.com with your Intuit account and follow these steps:

To run a manual sync to QuickBooks:

  1. On the my connections page, click Manually sync an existing connection, and choose your solution if you have more than one. 
  2. Adjust the date range. Click Sync Now.
  3. Wait about 15 minutes.
  4. Check the log by clicking on Settings > Transaction Log on the top right. 

To update existing orders in Quickbooks:

  1. On the my connections page, click Manually sync an existing connection, and choose your solution if you have more than one. 
  2. Check Update existing transactions in QuickBooks.
  3. Adjust the date range. Click Sync Now.
  4. Wait about 15 minutes.
  5. Check the log by hovering over the gear box > transaction log.

To run a manual sync from QuickBooks:

  1. On the my connections page, choose your solution if you have more than one. 
  2. Click Configure.
  3. Go to the Sync from QuickBooks Manually tab.
  4. Adjust the date range. Click Sync Now.
  5. Wait about 15 minutes.
  6. Check the log by hovering over the gear box > transaction log. 


Here is an image of the order export settings area:

Screen_Shot_2017-06-02_at_11.32.37_AM_copy.png

To sync by order number, enter a comma separated list of order numbers or IDs:
 

Screen_Shot_2017-06-02_at_11.32.59_AM_copy.png

Have more questions? Submit a request
Powered by Zendesk