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

This topic has 1 reply, 2 voices, and was last updated 7 years, 2 months ago by Shawon Chowdhury.

Viewing 1 reply thread

Author

Posts
- September 24, 2017 at 2:55 pm #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?
- September 25, 2017 at 10:04 am #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 🙂
Author

Posts

Viewing 1 reply thread

You must be logged in to reply to this topic.

Supercharge Your Growing Business with
All-in-one Business Manager

Upgrade WP ERP Pro

10,000+ successful businesses

14 days no questions asked refund policy

Industry leading 24x7 support

Supercharge
your growing business from your
WordPress dashboard

Products

Company

Resources

© 2015-2021 WP ERP. Built by the folks at weDevs.

Contact Us

Reach out to us for any inquiry