By default, Connex maps the Amazon purchase date to QB. You can tell Connex to use the order ship date, which you will see on many Amazon reports. If the order was created on June 20th and you look for it on June 21st, then the order is missing from your report.
On the advanced tab of Connex, scroll down to timezone. Enter your timezone. Amazon sends orders in UTC, so it's possible the order appears tomorrow in your report instead of the day it shipped. The timezone setting will adjust the date to local time.
To prove this theory, you can search for the order manually. Connex places the full Amazon order number in the QB memo field. To search for orders in the memo field, follow these steps:
- In QB, press ctrl + F.
- Click advanced.
- Select memo.
- Enter the full Amazon order number.
- See if the order exists.
Here is a screenshot of the order in QB.