When importing membership data into ACME from your CRM, certain memberships may trigger the error message: "This membership number already exists in ACME with a different Import ID so the membership number update was blocked." This indicates that the import was unsuccessful due to IDs in the import file not aligning with the IDs currently associated to the membership in ACME. In particular, ACME is validating the following IDs:
- Membership ID
- Membership Import ID
- Customer ID
- Customer Import ID
Most commonly, this issue occurs when a membership has been merged in your CRM and has adopted new import IDs, causing ACME and the CRM's data to be misaligned.
When this occurs, there are two approaches to resolving this issue. One is a temporary workaround involving a manual edit to get the data in, whereas the second is a more holistic fix that will prevent the need for any manual adjustments moving forward. Depending on the timeline to implement a mapping update, you may choose to employ the temporary method on a short-term basis until the new updates can be completed.
Temporary Workaround: Manually update the IDs in your import files
Manually replacing the IDs pulled from your CRM with the values ACME is expecting will allow you to successfully import the membership into ACME. That said, any subsequent imports from your CRM would also then require this manual process to successfully make it into ACME.
Long-term Solution: Adding Alias and Attribute fields to your Import Mapping
Adding Alias and Attribute fields to your Import Mapping will allow ACME to accept the provided IDs from your CRM, even if they differ from what is currently in ACME. To do so, follow the steps outlined in our Adding Attribute and Alias Fields to Raiser's Edge for ACME Data Imports guide.
More details about our recommended and required fields can be found in our Raiser's Edge Export Guide.