00 Day

00 Hour

00 Min

00 Sec

Products
- ERP CoreCheck what you will get with WP ERP Free plan
- HR ManagementExplore all features inside our WordPress HRM module
- CRMPeek into our powerful CRM module
- AccountingFeature-rich Accounting module from WP ERP
- Product textWP ERP: Your all-in-one solution to streamline business operations
Extensions
- All ExtensionsFor enhanced functionalities
- HR ExtensionsAutomate HRM tasks
- CRM Extensions3rd party integrations
- Accounting ExtensionsSimplify your finances
- Extenstion textPick the modules you need, avoid paying for the ones you don’t
Pricing
Blog
Help
- DemoNo credit card required
- Contact24/7 support
- DocsStep-by-step guides
- Help textTry before you buy, with help anytime
Sign In

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, 1 month 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

The forum ‘CRM’ is closed to new topics and replies.

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-2024 WP ERP. Built by the folks at weDevs.

Contact Us

Reach out to us for any inquiry