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, there are a few things to check.
If after running a Product Import to update a Product already existing in Acctivate, you may get the message below due to a couple possible reasons.
More than one record returned and recordset was not opened in batch mode.
- The Product ID and Alt Product ID are the same in Acctivate.
- 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.
- The import file contains an update for a vendor product ID, but multiple instances of the vendor exist for the product.
- Acctivate allows a product to have the same vendor listed multiple times as long a each instance has a different Vendor ID.
For example, the product "Widget" may have "Acme" inc. listed twice; one with a blank Vendor Product ID and the other with Vendor Product ID "ABC-123". If performing a product import with the import option "One vendor prod id per vendor" set to "Yes" (recommended), the Acctivate import will not create multiple instances of the same vendor for a single product. If the vendor/product combination already exists, it will be updated; if it doesn't exist then it will be created
When set to "No", an Acctivate product can have multiple instances of the vendor as long as each instance has a unique Vendor Product ID.
If the option is set to Yes, and the Vendor and Vendor Product ID combination in the spreadsheet do not match the Vendor and Vendor Product ID in Acctivate, the error will be returned. Either change the option to No (which would create a second vendor record) or manually update the vendor info in Acctivate.
- Acctivate allows a product to have the same vendor listed multiple times as long a each instance has a different Vendor ID.