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.