[Solved] Customer not in Default Group- How to embedding customers to Default Group?

[Kalastudio]

I migrated the tables in the database version 1.1 to version 1.2.5 embed various fields necessary for the new version on the old boards, everything seems to work well, but customers need to place them in the group "default" I have tried manually of embedding in the group ... but in reviewing the group and its members, is that members added manually, are not integrated.
Anyone have an idea of how to add these clients to the group "default"?

Thanks a lot.

[SeerKan]

I see it marked as "solved" but there are no replyes. Can you please tell us how did you fix this problem ?

Best regards.

[Kalastudio]

Hi SeerKan well I need ti make the change in the data base adding every customer to the default group.
I hope this can help you.

[ezakimak]

I faced the same problem some time ago, I solved this with plain SQL
issue this sql in your prefered program to manage your database

insert into ps_customer_group (id_customer, id_group )
select id_customer , 1
from ps_customer
where id_customer not in ( select id_customer from ps_customer_group where id_group = 1 )

hope this helps

hugh

[PrestaMagic]

Hugh,

 

That was very helpful. Thanks (over a year later!)

[Emmanuel Paris]

Thanks Ezakimak ! It works.