How to reassing contacts to anonther user using a command in DB?

Home Forums CRM How to reassing contacts to anonther user using a command in DB?

Viewing 1 reply thread
  • Author
    Posts
    • #9812
      gobejhu
      Participant

      Hi, we have more than 2000 contacts in DB, and the user that was associated with the contacts is deleted. Currently we see NULL value. Is there any way to work on DB to reassign all these contacts to another user, or delete them all, and we will run the import again?

    • #9822
      Shawon Chowdhury
      Moderator

      @gobejhu,

      You can run an update query to assign one contact owner to all these contacts.

      Here is the query snipset:
      update wp_erp_peoplemeta set meta_value = 1 where meta_key = ‘contact_owner’
      Note: meta_value=1 (user id of whom you want to make a contact owner).

      Thanks 🙂

Viewing 1 reply thread
  • The forum ‘CRM’ is closed to new topics and replies.

Contact Us

Reach out to us for any inquiry

You must enter full name
You must enter email
You must enter message

We received your query

We will reply to you very soon :)