Sql Request for change groupe customer by Mail.

[Blawdi]

Hello,

I need to change group for all customer with mail exemple : @prestashop.com  

Could you enlighten me on the request?  Thx

[MigrationPro]

Hello Blawdi,

 

Using this query you can change the group of all customers with ending: @prestashop.com  

UPDATE ps_customer_group as cg INNER JOIN ps_customer as c ON cg.id_customer = c.id_customer  SET  cg.id_group = 1 where c.email  LIKE  "%@prestashop.com"

change the "ps_" with your table prefix and  cg.id_group = 1 also can add your group ID which you want to assign to the customer.

[Blawdi]

Hello, Thanks u! I try it tonight

[MigrationPro]

You are most welcome!

[Blawdi]

It is possible to use this command only for Group 3 emails (client) so that emails @ prestashop.com in the other groups are not changed.

thanks a lot for your help

[MigrationPro]

Hello,

Use this query: UPDATE ps_customer_group as cg INNER JOIN ps_customer as c ON cg.id_customer = c.id_customer  SET  cg.id_group = 1 where c.email  LIKE  "%@prestashop.com" AND c.id_default_group = 3

in this time will updated ID group 3 and "prestashop.com"

[Blawdi]

Heyy !! Thanks you!!!

 

The host does not accept Phpmyadmin events. Could you tell me how to create a php file to execute this command? I hope not to overuse your kindness.