Why am I Getting "More than One Record Returns and Recordset was Not Opened in Batch Mode" on the Product Import?

If you run the Product Import, and get the exception "More than one record returned and recordset was not opened in batch mode" after a failed import, check the Alt Product ID for duplicate IDs to the Product ID.

If after running a Product Import to update a Product already existing in Acctivate, you may get the message below if the Product ID and Alt Product ID match. If you get this message, remove or change the Alt Product ID to be different from the Product ID, save the Product, and run the import again. Be sure to not have the Excel file open when importing the Excel sheet into Acctivate. 

More than one record returned and recordset was not opened in batch mode.