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
  • You must be logged in to reply to this topic.