I need to import opportunity data to NPSP cloud.
Contact lookup to Account. And Opportunities lookup to both Account and Contact.
I first imported Contact data using data loader. And then imported Account data via data loader. And then mapped their ID's in the Opportunity excel sheet using VLookup.
(This is how I imported data while working in other clouds)
What I didn't realize was that while importing Contact data, it would automatically create a household account.
I now have duplicate account records in NPSP - the household account related to contact, and the account records imported(related to opportunity). The names of both account records are different - ContactLastName Household and OpportunityOrganization Name.
How should I proceed?