Orders can be missing from QuickBooks for many reasons. These include number overlaps, the sync date range, QuickBooks errors, and data errors.
You could have old orders in QuickBooks that match new orders from your online store. Go to your Connex transaction log. In this example, Connex has found a duplicate transaction:
Transaction 106-2935127 already exists in QuickBooks under New Amazon Store placed on 12/18/2015 8:52:20 PM.
There are a few ways around this problem.
You can add an order prefix to incoming orders:
- On the Connex All Settings page, expand the Sync Manually to QuickBooks menu.
- In the order prefix box, enter a prefix.
- Click save settings.
Connex will add a prefix to all orders before they reach QuickBooks.
Use QuickBooks Numbering
Connex will use the next number from QuickBooks. Connex will place the original order in the memo field. For more details, see these instructions.
Shorter Date Range
When you run a manual sync, do two to three days at a time. Run the web connector.
It is possible certain errors will prevent orders from syncing. They include the company file being closed, the computer being turned off, or modal dialogs open in QuickBooks. These steps should prevent these errors:
- Open QuickBooks and log in as Admin.
- Ensure no dialog boxes asking you to click OK are open.
- Run your web connector.
Connex has a transaction log that will describe errors. For more info, read these instructions.