I have a contact in CiviCRM that is of contact-type Individual in CiviCRM. In real life, this is an organization.

I want to convert this contact from an Individual to an Organization. How do I do that?

(I could just delete the contact, and create a new contact, but I really want to keep the contribution history. So then I would need to move that from one contact to another. Using merge contacts only works within same contact-type. So this solution doesn’t seem to work either)


2 Answers 2


Run below query in mysql

UPDATE civicrm_contact
SET contact_type = 'Organization',
organization_name = sort_name
WHERE id = 123;

123 is a contact id

  • Isn’t there a non-code way of doing this?
    – Flying
    Sep 2, 2020 at 14:05
  • As Jon said contact editor extension is another option to do so, if its a matter of updating more than one contact. Sep 3, 2020 at 0:01

Alternatively - you can try install/use:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.