Mass update Clients default Group

[cogeanumarius]

salve to you all,

I have just realized that our website (PS1751) has a problem, the old clients (2016+2017) have no default Group and none of the access Groups are selected (Visitor,Guest or Client)

I would love to update my database and select for all our 1300 clients Default Group: Client and Access Group: Client, is there a way I could achieve this desired outcome?

Huge thanks in advance,

yours,

Marius

Edited November 9, 2020 by cogeanumarius (see edit history)

[Knowband Plugins]

Through admin, Its not possible.

If you want to update the group id to all the customers in the DB, then simply run the following query in the DB.

UPDATE `ps_customer` SET id_default_group  = 3;

OR RUN the below query to update the group of the those customers which is not having the default group

UPDATE `ps_customer` SET id_default_group  = 3 WHERE id_default_group  IS NULL OR id_default_group  = 0 ;

[cogeanumarius]

44 minutes ago, Knowband Plugins said:

Through admin, Its not possible.

If you want to update the group id to all the customers in the DB, then simply run the following query in the DB.

UPDATE `ps_customer` SET id_default_group  = 3;

OR RUN the below query to update the group of the those customers which is not having the default group

UPDATE `ps_customer` SET id_default_group  = 3 WHERE id_default_group  IS NULL OR id_default_group  = 0 ;

first query worked like a charm, and I have verified a couple of the clients, it really worked, the second query may need some adjustments, I simulated the query and found no records

[Knowband Plugins]

Running any of one query will resolve the issue. 

If first query is executed that means default group for all the customers has been updated then 2nd query will not have the matching results (Means there no use of running the 2nd query after running the first one)

 

[cogeanumarius]

On 11/9/2020 at 11:36 AM, Knowband Plugins said:

Running any of one query will resolve the issue. 

If first query is executed that means default group for all the customers has been updated then 2nd query will not have the matching results (Means there no use of running the 2nd query after running the first one)

 

I clearly understand, Thank you for the explanation, but I would still feel more comfortable to see a tick in the third box, even if the default is now set to Client. Huge thanks in advance, yours, Marius

Edited November 16, 2020 by cogeanumarius (see edit history)

[cogeanumarius]

Thank you for all your help, but looks like out of 1233 clients only 518 are in the default Access Group Clients as can be seen in the attached images

is there a way to fix this situation and to have all 1233 in the group Client.

yours,

Marius

Edited November 16, 2020 by cogeanumarius (see edit history)