Add all customers who have already bought a specific product to a user group

  • Posts: 44
  • Thank you received: 0
  • Hikamarket Multivendor Hikashop Business
3 years 7 months ago #323601

-- HikaShop version -- : 4.3.0
-- Joomla version -- : 3.9.21
-- PHP version -- : 7.3
-- Browser(s) name and version -- : Chrome

Hi,

Is it possible to add all users who have already bought a specific product to a new user group without doing it manually?

I have a list of 700 customer that now need adding to a new Joomla user group.

Thanks

KH

Please Log in or Create an account to join the conversation.

  • Posts: 81481
  • Thank you received: 13062
  • MODERATOR
3 years 7 months ago #323610

Hi,

Yes.
First, for future customers, you can use the "user group after purchase" setting of the product to set that up.
For existing customers, you want to create a mass action via the menu System>Mass actions, and select the type "order". There, you'll need one filter on the order_product column "order_product_code" being equal to the product_code of the product. And you'll want an action "change the user group" and configure the action to target the user group you want.
Once you click on the "process" button of the mass action, it will do it all at once.
Note that if you mess it up, it can have dire consequences. So I would recommend to make backups, and to use an action "display the results" first to check what "elements" are found when running the filter(s) of a mass action, before using an action which change things.
www.hikashop.com/support/documentation/167-massaction-form.html

The following user(s) said Thank You: vividfish

Please Log in or Create an account to join the conversation.

  • Posts: 44
  • Thank you received: 0
  • Hikamarket Multivendor Hikashop Business
3 years 7 months ago #323626

Thanks, Nicolas,

That worked jsut as required.

Best

KH

Please Log in or Create an account to join the conversation.

Time to create page: 0.063 seconds
Powered by Kunena Forum