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:

http://devdocs.magento.com/guides/m1x/api/soap/sales/salesOrder/sales_order.list.html 


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.