If the following error is returned during order sync for Magento: 

"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 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 

In order to resolve this issue, the module needs to be removed from Magento.