tomlyon Posted September 28, 2023 Share Posted September 28, 2023 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, Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted September 28, 2023 Share Posted September 28, 2023 When you mention /add/ you refer to importing customers? Link to comment Share on other sites More sharing options...
tomlyon Posted September 29, 2023 Author Share Posted September 29, 2023 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. Link to comment Share on other sites More sharing options...
ps8modules.com Posted September 30, 2023 Share Posted September 30, 2023 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. Link to comment Share on other sites More sharing options...
tomlyon Posted September 30, 2023 Author Share Posted September 30, 2023 Can you explain how to do this? Thanks Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted September 30, 2023 Share Posted September 30, 2023 (edited) 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) Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 1, 2023 Share Posted October 1, 2023 (edited) 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) Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 1, 2023 Share Posted October 1, 2023 (edited) 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) 1 Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted October 1, 2023 Share Posted October 1, 2023 @ps8moduly.cz thanks for your solution - what is the reason for creating the "old_group" column? Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 1, 2023 Share Posted October 1, 2023 To restore Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted October 1, 2023 Share Posted October 1, 2023 (edited) 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) Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 1, 2023 Share Posted October 1, 2023 (edited) 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) Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted October 1, 2023 Share Posted October 1, 2023 (edited) Of course not - will copy your solution why bother 😆 Edited October 1, 2023 by QuickUpdate.net (see edit history) Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 1, 2023 Share Posted October 1, 2023 (edited) 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) Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted October 1, 2023 Share Posted October 1, 2023 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. Link to comment Share on other sites More sharing options...
tomlyon Posted October 2, 2023 Author Share Posted October 2, 2023 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 Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted October 2, 2023 Share Posted October 2, 2023 (edited) @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) Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 2, 2023 Share Posted October 2, 2023 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. Link to comment Share on other sites More sharing options...
tomlyon Posted October 5, 2023 Author Share Posted October 5, 2023 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 Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted October 5, 2023 Share Posted October 5, 2023 @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?" Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 5, 2023 Share Posted October 5, 2023 (edited) 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) Link to comment Share on other sites More sharing options...
tomlyon Posted October 6, 2023 Author Share Posted October 6, 2023 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. Link to comment Share on other sites More sharing options...
tomlyon Posted October 10, 2023 Author Share Posted October 10, 2023 Is this possible? Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 10, 2023 Share Posted October 10, 2023 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. Link to comment Share on other sites More sharing options...
Olivier33000 Posted October 21, 2023 Share Posted October 21, 2023 (edited) 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) Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 21, 2023 Share Posted October 21, 2023 (edited) 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) Link to comment Share on other sites More sharing options...
Olivier33000 Posted October 21, 2023 Share Posted October 21, 2023 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. Link to comment Share on other sites More sharing options...
Olivier33000 Posted October 21, 2023 Share Posted October 21, 2023 And I've only 35 (+1 with this one) posts, you could easily see how "humiliating and inappropriately expressing forum participant" I am. Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 21, 2023 Share Posted October 21, 2023 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. Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 21, 2023 Share Posted October 21, 2023 Please read the whole thread. Free module for .... Link to comment Share on other sites More sharing options...
Olivier33000 Posted October 21, 2023 Share Posted October 21, 2023 (edited) 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) Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 21, 2023 Share Posted October 21, 2023 (edited) 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) Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 21, 2023 Share Posted October 21, 2023 (edited) 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) Link to comment Share on other sites More sharing options...
Olivier33000 Posted October 21, 2023 Share Posted October 21, 2023 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. Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 21, 2023 Share Posted October 21, 2023 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. Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted October 23, 2023 Share Posted October 23, 2023 @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. Link to comment Share on other sites More sharing options...
Olivier33000 Posted October 23, 2023 Share Posted October 23, 2023 @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 Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted October 23, 2023 Share Posted October 23, 2023 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. Link to comment Share on other sites More sharing options...
Olivier33000 Posted October 23, 2023 Share Posted October 23, 2023 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;). Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted October 23, 2023 Share Posted October 23, 2023 (edited) 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) Link to comment Share on other sites More sharing options...
Olivier33000 Posted October 23, 2023 Share Posted October 23, 2023 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. Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted October 23, 2023 Share Posted October 23, 2023 (edited) 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) Link to comment Share on other sites More sharing options...
ZHSoft Posted October 27, 2023 Share Posted October 27, 2023 The safest way is to go to the background and edit them one by one. Link to comment Share on other sites More sharing options...
tomlyon Posted October 27, 2023 Author Share Posted October 27, 2023 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... 1 Link to comment Share on other sites More sharing options...
wonderstore Posted August 2 Share Posted August 2 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! Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted August 2 Share Posted August 2 @wonderstore https://addons.prestashop.com/en/fast-mass-updates/45498-quickupdate-pro-the-expert-multitool-for-prestashop.html Link to comment Share on other sites More sharing options...
wonderstore Posted August 2 Share Posted August 2 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 Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted August 2 Share Posted August 2 (edited) @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) Link to comment Share on other sites More sharing options...
wonderstore Posted August 2 Share Posted August 2 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 Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted August 2 Share Posted August 2 You need to enter username / password as they are mentioned on the demo site Link to comment Share on other sites More sharing options...
wonderstore Posted August 2 Share Posted August 2 @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 Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted August 2 Share Posted August 2 (edited) 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) Link to comment Share on other sites More sharing options...
wonderstore Posted August 2 Share Posted August 2 Ok thanks for the info, I'll decide soon if I want to buy it. Is it compatible with PS 8.1? Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted August 2 Share Posted August 2 (edited) 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) Link to comment Share on other sites More sharing options...
ZHSoft Posted August 7 Share Posted August 7 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) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now