Answers.Body: <p>You need to set as Organisation name instead sort name.</p>
  <p><a href="https://i.sstatic.net/XKjUJ.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/XKjUJ.png" alt="enter image description here" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-12-14T21:40:58.680Z
Answers.Text: Hi,, that's how we started out (we changed it to Sort Name after installing The The) but I'll give it another go and report back :)
Answers.UserDisplayName: Robin Fenwick
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-12-11T00:52:24.220Z
Answers.LastActivityDate: 2021-12-11T00:52:24.220Z
Answers.UserDisplayName: Pradeep Nayak
Answers.Body: <p>You may want to check out <a href="https://civicrm.org/extensions/public-autocomplete-of-organisation-names" rel="nofollow noreferrer">https://civicrm.org/extensions/public-autocomplete-of-organisation-names</a> but of course this means the list of Orgs that you allow to show become 'public' in a sense, and hence may have security concerns</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-12-04T21:45:45.713Z
Answers.Text: Thanks Pete - I should've said we also already have that extension installed. It's great, but there are still some duplicates slipping through
Answers.UserDisplayName: Robin Fenwick
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-12-04T21:09:47.013Z
Answers.LastActivityDate: 2021-12-04T21:09:47.013Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>I wonder if anyone can help me with what I'm missing re duplicate contacts.</p>
  <p>We have a profile form which also creates a wordpress account - it asks only for first &amp; last name, email, username and password.</p>
  <p>Once registered and logged in, we have a separate profile form that asks users for more information, including their current employer. We ask only the employer name, and for no other information about that organisation.</p>
  <p>If two separate users enter exactly the same current employer name, two organisation records are created.</p>
  <p>Looking at the profile settings I'm actually surprised this is happening, because the de-dupe option that we have set is:</p>
  <p><a href="https://i.sstatic.net/7Dp3X.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/7Dp3X.png" alt="Profile Settings" /></a></p>
  <p>The unsupervised dedupe rule for organisations is:</p>
  <p><a href="https://i.sstatic.net/yCBL3.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/yCBL3.png" alt="Unsupervised de-dupe rule" /></a></p>
  <p>We also have the extension 'The the' installed as it's common in our sector for people to register their company with and without a 'the' at the start.</p>
  <p>I'm guessing the profile settings don't influence any <em>related</em> contacts that may be created, which is why people are being able to create duplicate employer/organisation records... But any thoughts on why the unsupervised de-dupe rule is not working in the way I would expect?</p>
  <p>Especially when, if we run the de-dupe manually, the unsupervised rule DOES spot the duplicates!</p>
  <p><a href="https://i.sstatic.net/lAB2i.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/lAB2i.png" alt="Manual run" /></a></p>
  <p>I'm sure this is something basic that I'm getting wrong, but I just can't fathom it. Thanks!</p>
  
Tags: <duplicate-contacts>
Title: Preventing duplicate organisations being created
ThreadText: # Preventing duplicate organisations being created
  
  (Asked by: username_0 on 2021-12-04)
  
  I wonder if anyone can help me with what I'm missing re duplicate contacts.
  
  We have a profile form which also creates a wordpress account - it asks only for first & last name, email, username and password.
  
  Once registered and logged in, we have a separate profile form that asks users for more information, including their current employer. We ask only the employer name, and for no other information about that organisation.
  
  If two separate users enter exactly the same current employer name, two organisation records are created.
  
  Looking at the profile settings I'm actually surprised this is happening, because the de-dupe option that we have set is:
  
  [![Profile Settings](https://i.sstatic.net/7Dp3X.png)](https://i.sstatic.net/7Dp3X.png)
  
  The unsupervised dedupe rule for organisations is:
  
  [![Unsupervised de-dupe rule](https://i.sstatic.net/yCBL3.png)](https://i.sstatic.net/yCBL3.png)
  
  We also have the extension 'The the' installed as it's common in our sector for people to register their company with and without a 'the' at the start.
  
  I'm guessing the profile settings don't influence any *related* contacts that may be created, which is why people are being able to create duplicate employer/organisation records... But any thoughts on why the unsupervised de-dupe rule is not working in the way I would expect?
  
  Especially when, if we run the de-dupe manually, the unsupervised rule DOES spot the duplicates!
  
  [![Manual run](https://i.sstatic.net/lAB2i.png)](https://i.sstatic.net/lAB2i.png)
  
  I'm sure this is something basic that I'm getting wrong, but I just can't fathom it. Thanks!
  
  **Tags:** duplicate-contacts
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2021-12-11. Score: 1
  
  You need to set as Organisation name instead sort name.
  
  [![enter image description here](https://i.sstatic.net/XKjUJ.png)](https://i.sstatic.net/XKjUJ.png)
  
  > **Comments:**
  > **username_0**: Hi,, that's how we started out (we changed it to Sort Name after installing The The) but I'll give it another go and report back :)  
  
  ---
  
  ### Answer by username_2 on 2021-12-04. Score: 0
  
  You may want to check out <https://civicrm.org/extensions/public-autocomplete-of-organisation-names> but of course this means the list of Orgs that you allow to show become 'public' in a sense, and hence may have security concerns
  
  > **Comments:**
  > **username_0**: Thanks Pete - I should've said we also already have that extension installed. It's great, but there are still some duplicates slipping through  
  
  ---
  
  