I have a CRM database connected to my education-based, non-profit company. The product is CiviCRM. My problem is that data on each person/contact does not get merged properly and so there are often many duplicates of the same contact. Currently my data on the contacts is getting outdated and I want to have contacts enter in updated contact information, but I can't do it as long as this duplicate issue exists (their original contacts won't get updated on the database; instead, new contacts will be created and clog up the database even more). There are currently a few thousand contacts in the database.
I need a 100% dependable solution to be written for my CiviCRM so that all matching contacts will be properly merged and new information can be smoothly updated to existing contacts without any parallels being created.