Developer forum

Forum » CMS - Standard features » Duplication of users - how do we merge?

Duplication of users - how do we merge?

Jens Mouritzen
Jens Mouritzen
Reply

Hi guys.

We have an issue on a solution, where users are duplicated (maybe on user import). The issue is that when a user unsubscribes to the newsletters, it is only one of the users that unsibscribes newsletters. The users have the same email address but are in different groups. On of the groups (customers) is a group that we do not use, because of no ecommerce (there was on a earlier solution). So my question is:

How do we merge/delete and filter these users on email address and keep the email permissions on the users that has recieved and email from system lately?

customers.png newsletter.png

Replies

 
Nicolai Pedersen
Reply

You can execute a bit of SQL against the user database. Find all duplicate records and delete from accessusers: https://www.sqlshack.com/different-ways-to-sql-delete-duplicate-rows-from-a-sql-table/

BR Nicolai

 

You must be logged in to post in the forum