If the following error is returned during order sync for Magento 2:
"Server returned a fault exception: [1] SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous."
Then this means that a 3rd party module installed on Magento 2 has changed one of the tables in the Magento database and interferes with a standard API call:
One of the modules we have found to cause it is called: Amasty_Orderarchive. To resolve this issue, the module needs to be removed from Magento 2.