If the following error is returned during order sync for Magento:
"Server returned a fault exception:  SQLSTATE: 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.