Orders can be missing from QB for many reasons. These include numver overlaps, the sync date range, QB errors, and data errors.
You could have old orders in QB 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 configure page, click the order export tab.
- In the order prefix field, enter a prefix.
- Click save and sync.
Connex will add a prefix to all orders before they reach QB.
Use QB Numbering
Connex will use the next number from QB. 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 QB. These steps should prevent these errors:
- Open QB and login 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.