How to bulk update customers groups?

[tomlyon]

Hi there,

Is there a way to bulk update customers groups. For example i want to add 100 customers as 'guest' but I don't want to manually go in to each customer and tick guest one by one.

Is this possible? or is there a module for it?

Thanks,

[QuickUpdate.net]

When you mention /add/ you refer to importing customers?

[tomlyon]

I mean for example. Say I have 100 customers and I add a customer group called 'Customer Group 1'. I now want 50 of these customers to have Customer Group 1 ticked but i'd have to go in to each customer and tick the group access. I'd like to be able to bulk update the group access.

 

 

[ps8modules]

Hi.

In this way, all you need to do is simply run an SQL query in the database.

I don't know of any ready-made modules.

It's nothing complicated.

[tomlyon]

Can you explain how to do this?

Thanks

 

[QuickUpdate.net]

We will be adding this feature in our QuickUpdate Bulk Commander module, but it is not ready yet.

Updating this directly with SQL would not be advisable unless you (or someone who posts the code) know for sure all the tables that need to be updated for this action, otherwise it might damage you store setup.

 

Later edit: This functionality has been implemented in QuickUpdate, details in last post.

Edited October 23, 2023 by QuickUpdate.net (see edit history)

[ps8modules]

9 hours ago, tomlyon said:

Can you explain how to do this?

Thanks

 

In your module:

OLD ID group = 3

NEW ID GROUP = 4

TOP 50 CUSTOMERS

$db = Db::getInstance();
$getTopCustomers = $db->executeS('SELECT id_customer FROM '._DB_PREFIX_.'customer WHERE id_default_group = 3 ORDER BY id_customer ASC LIMIT 50');

foreach ($getTopCustomers as $c) {
    $customer = new Customer((int) $c['id_customer']);
    $customer->id_default_group = 4;
    $customer->addGroups(array(4));
    $customer->update();
}

Maybe today I'll find a moment and make a free module and put here.

It is a job for a maximum of 30 minutes 🙂

Edited October 1, 2023 by ps8moduly.cz (see edit history)

[ps8modules]

Editing and moving customer groups FREE module for @tomlyon

Supported PS 1.6.1.14 > 8.x

 

The module settings are clear, there is no need to explain anything 😉

Module deleted !!

Because he didn't help the interviewer.

Please read carefully the readme.txt located in the module folder.

Edited October 21, 2023 by ps8moduly.cz (see edit history)

[QuickUpdate.net]

@ps8moduly.cz thanks for your solution - what is the reason for creating the "old_group" column?

[ps8modules]

To restore

[QuickUpdate.net]

to restore the previous group  - is that a bonus feature? why you could not set a new group to the previous one?

Edited October 1, 2023 by QuickUpdate.net (see edit history)

[ps8modules]

If someone makes a mistake, they reset everything to the previous records.

He will not have old and new.

Logically, the module does what the requester requested. For others, it's a demonstration of how to do it.

I assume that you will make your own solution in your module 😉

 

Edited October 1, 2023 by ps8moduly.cz (see edit history)

[QuickUpdate.net]

Of course not - will copy your solution why bother 😆

Edited October 1, 2023 by QuickUpdate.net (see edit history)

[ps8modules]

34 minutes ago, QuickUpdate.net said:

Of course not - will copy your solution why bother 😆

It is polite to appreciate the effort and say thank you.

Well, you see, somehow I miss your like 🙂

 

Edited October 1, 2023 by ps8moduly.cz (see edit history)

[QuickUpdate.net]

Your solution fits the bill for the op (maybe should confirm themselves) so i think the purpose of this thread was well served - the rest seems kind of a misunderstanding.

[tomlyon]

Thanks for making the module but this isn't actually what I was after.

I'd like to be able to add a customer to multiple access groups at once whilst still leaving the original access group (not changing from an old to new one).

For example if I create a new customer access group, i'd like to be able to add that group to selected customers on top of what they already have access to.

Does this make sense?

Thanks

[QuickUpdate.net]

@tomlyon The best way is to provide a concrete example, eg:

Customers 1,2,3 already have access in Group 1 and Group 2. You want to create Group 3 and give Customers 1,2,3 access also to Group 3, correct?

Edited October 2, 2023 by QuickUpdate.net (see edit history)

[ps8modules]

6 hours ago, tomlyon said:

Thanks for making the module but this isn't actually what I was after.

I'd like to be able to add a customer to multiple access groups at once whilst still leaving the original access group (not changing from an old to new one).

For example if I create a new customer access group, i'd like to be able to add that group to selected customers on top of what they already have access to.

Does this make sense?

Thanks

Hi.

I modified the module for your needs as you wrote.
The previous version of the module needs to be uninstalled and removed.
You have the modified version in the message.

[tomlyon]

Hi there, thanks a lot for creating the module, however it doesn't serve the purpose required unfortunately.

I'd like to be able to select the customers and then add group access to the selected customers without removing any customer access groups. I'd like to select the customers in a list like the screenshot below. I'd then like to tick the customer access group to add to them. Does this make sense?

The module currently only allows me to select an old customer group and a new customer group.

Thanks

Tom

[QuickUpdate.net]

@tomlyon Doesn't this example fit the use case you are looking for?

"Customers 1,2,3 already have access in Group 1 and Group 2. You want to create Group 3 and give Customers 1,2,3 access also to Group 3, correct?"

[ps8modules]

3 hours ago, tomlyon said:

Hi there, thanks a lot for creating the module, however it doesn't serve the purpose required unfortunately.

I'd like to be able to select the customers and then add group access to the selected customers without removing any customer access groups. I'd like to select the customers in a list like the screenshot below. I'd then like to tick the customer access group to add to them. Does this make sense?

The module currently only allows me to select an old customer group and a new customer group.

Thanks

Tom

Hi.

The module filters the first 50 customers who are registered, active and in the old group.

It will add a new group to these selected customers.

The module does exactly what you wanted in the first post.

If you need something special, there is a Job forum.

https://www.prestashop.com/forums/forum/235-job-offers/

Edited October 5, 2023 by ps8moduly.cz (see edit history)

[tomlyon]

18 hours ago, QuickUpdate.net said:

@tomlyon Doesn't this example fit the use case you are looking for?

"Customers 1,2,3 already have access in Group 1 and Group 2. You want to create Group 3 and give Customers 1,2,3 access also to Group 3, correct?"

Exactly yes, but I'd like to be able to select each customer i want to add this group to.

[tomlyon]

Is this possible?

[ps8modules]

Of course it is possible.
Only no one will program it for you for free.
Since then, here is the Job section!
There is no such module and it must be programmed according to your needs.
Work max. two hours, for a good programmer.

[Olivier33000]

Hi all

@ps8moduly.cz

I tryed to install your module (PS 1.6.1.24, php7.4.33) and I received this error :

Uncaught Error: Call to undefined method Ps8mod_groupsmove::fetch() in /var/www/clients/client1/web4/web/modules/ps8mod_groupsmove/ps8mod_groupsmove.php:90

Edited October 21, 2023 by Olivier33000
error copying (see edit history)

[ps8modules]

Hi.

For humiliating and inappropriately expressing forum participants, I will not provide solutions to individuals or adapt the SAMPLE module in any way. As originally written, the module is a demo.

Edited October 21, 2023 by ps8moduly.cz (see edit history)

[Olivier33000]

Wow, "humilating", a bit excessive isn't it ? I just asked for any tip you could provide if ever you already encountered that case. It seems quite strange it felt from $this->fetch() that you probably tried with positive results.

[Olivier33000]

And I've only 35 (+1 with this one) posts, you could easily see how "humiliating and inappropriately expressing forum participant" I am.

[ps8modules]

You weren't meant to be. The module was modified and intended directly by the founders of the topic and for others as a guide.

[ps8modules]

Please read the whole thread.

Free module for  ....

 

[Olivier33000]

And I do deserve being humiliating and inappropriately expressing participant 'cause I wasn't meant to be. I'm speechless.

Edited October 21, 2023 by Olivier33000 (see edit history)

[ps8modules]

Again you didn't read the whole thread. Unfortunately, it is not in my power to help you.

QuickUpdate.net and tomlyon will definitely help.

I have absolutely no idea where the problem could be with a module that was intended for someone else.

Edited October 21, 2023 by ps8moduly.cz (see edit history)

[ps8modules]

I apologize for my pride and not sharing all the possibilities. You need to follow the Prestashop documentation. Although documentation is available for developers, it is insufficient. What I have learned for more than 10 years needs to be put to good use. I am not an employee of Prestashop and I am happy to help out of good will and without coercion, without claiming any creation of my own, if it is not related to the topic. I don't work for anyone for free.

I understand that you would need a functional solution, but as I wrote, I don't know how to solve your problem.

I'm not writing anything bad to your address, I'm just pointing out that it was only targeted p9moc for a specific user.

Edited October 21, 2023 by ps8moduly.cz (see edit history)

[Olivier33000]

It's quite fair to apologize for the roughness towards me, and understand you can't help me about that case, but it could have been encountered by others as well and as a forum it means sharing and discussing first of all. If anyone is in that case, I could have some answers anyway.

[ps8modules]

And that's why I removed the module from the forum to avoid misunderstandings. I believe that someone will help and give you a working code or module.

[QuickUpdate.net]

@Olivier33000 & @tomlyon

Hi - as mentioned previously on this thread we have integrated bulk updating of "Customer Groups" into our QuickUpdate suite (named QuickUpdate eCommerce Manager)

You can use this functionality (and many more) free for a limited amount of operations  - available at www.quickupdate.net, you need to download the connector module and set the api key and you are good to go and update your customer groups for free.

If you have questions let us know.

[Olivier33000]

@QuickUpdate.net

Thank you. I did a sql request to modify over 10 thousands of customers to change their default group (ps_customer), but I can't change the ID of group in ps_customer_group as it contains primary keys (receive a sql error). I think it could be feasible with a foreach loop instead. Does your module is able to make any change in ps_customer_group (not only changing default_group ID), and not duplicating customers as that module done (new customer) ? Also does it save and restore the old group, smart functionality by the way ?

Appreciate any help,

Thanks again

[QuickUpdate.net]

QuickUpdate allows you to add customers to one or multiple groups as you need, you can change them whenever you want, the same with the default group.

Essentially you select the customers you want to modify and then select the groups you want to "add" to those customers, then you can modify the default group to any of the groups for those customers.

Attached is how the interface looks:

The first screenshot, selected customers on  the left and their groups on the right; select the group to add and click "+"  (Add) and the group in the dropdown is added to the selected customers - you can filter the customers by any field like: name, email, default group etc.

The second screen shows bulk updating of the default group for the selected customers.

[Olivier33000]

Thanks again, but I wanted to know if it was also possible to remove customers from an assigned group. As it is pretty simple (as I wrote) to mass change customers from default_group, but not mass change their group from ps_customer_group (UPDATE `ps_customer_group` SET `id_group`=X WHERE `id_group`=Y;).

[QuickUpdate.net]

Yes - in QuickUpdate you can do all the operations eg. add/remove customers in groups  - in the first screenshot, instead of adding groups by clicking "+", you can select groups from the right side and click delete ("trash" icon) and those groups will be removed from the respective customers (or vice-versa depending how you see it).

Btw you are struggling to solve your issue with queries because of the falsely promoted idea that "you can solve it with a query" - the whole point of having modules is to facilitate a specific functionality that can be performed repeatedly.

Edited October 23, 2023 by QuickUpdate.net (see edit history)

[Olivier33000]

I know I also could make my own module or buy one to do this job, but it's a one shot operation I won't redo then. That's why I did sql request first. And also for the number of customers to treat. Thank you anyway for having provided your help.

[QuickUpdate.net]

As you can see, it is one of the multiple features that are available in QuickUpdate besides customers - bulk update of products / images / features / seo / tags / attributes etc., so glad you found a solution then.

Edited October 23, 2023 by QuickUpdate.net (see edit history)

[ZHSoft]

The safest way is to go to the background and edit them one by one.

[tomlyon]

the point of this thread was to find a way to not do it one by one as I have thousands of accounts to edit...

[wonderstore]

Hello everyone,

I need exactly this module that allows me to massively modify/update the group to which several customer accounts belong. Can you kindly give me the link of the module so I can download/buy it?

Thank you!

[QuickUpdate.net]

@wonderstore https://addons.prestashop.com/en/fast-mass-updates/45498-quickupdate-pro-the-expert-multitool-for-prestashop.html

[wonderstore]

Thanks for the quick reply, but I don't need a mass modifier of products (I already use a performing one), but a module that only deals with modifying the group of belonging of customers massively. I hope it is available, otherwise amen

[QuickUpdate.net]

@wonderstore The module link i sent to you is both for products and customers mass updating, including mass updating the customer groups as you need 😉

Edited August 2 by QuickUpdate.net (see edit history)

[wonderstore]

Ok, I'm trying to access the demo, but unfortunately it doesn't allow access: https://addons.prestashop.com/en/demo/BO35484.html

Could you please provide me with a working demo link? So I can test the module in action. Thanks

[QuickUpdate.net]

You need to enter username / password as they are mentioned on the demo site

[wonderstore]

@QuickUpdate.net I logged in, but it is only possible to access the module configuration settings. It does not allow managing the product and customer sections to see it in action. I kindly ask you to fix it, thanks

[QuickUpdate.net]

The customer mass updating is not available on the demo site currently, see the animation below to get an idea about how it works if you purchase the module.

Update Customer Groups for multiple Customers at once

 

Edited August 2 by QuickUpdate.net (see edit history)

[wonderstore]

Ok thanks for the info, I'll decide soon if I want to buy it. Is it compatible with PS 8.1?

[QuickUpdate.net]

No worries, we have a huge number of very satisfied customers using our extremely performant module who achieved enormous time and cost savings with their stores - they are constantly increasing and you may also become one of them.

The QuickUpdate module is compatible with PS > v1.6x and if you have issues we offer support for fixing incompatibilities with your setup in case they are "caused" by the module.

Edited August 2 by QuickUpdate.net (see edit history)

[ZHSoft]

https://docs.prestashop-project.org/v.8-documentation/user-guide/configuring-shop/advanced-parameters/import

customers_import.csv

The built-in CSV import of customer information in the PrestaShop backend can support your needs. You only need to edit the CSV table according to the requirements of PrestaShop.
If you think editing the CSV table is a waste of time, you can also choose the module to export customer information, and then use the built-in CSV import of customer information in the PrestaShop backend to perfectly meet your needs.

 

https://addons.prestashop.com/en/data-import-export/49857-product-catalog-combination-customer-address-csv-export.html

[PrestaShop Modules] - Advanced CSV Export For 9-in-1(Product-Catalog-Combination-Customer-Address-Brand-Supplier-Aliases-Contact)