How to get a list of customers in specific country

  • Posts: 98
  • Thank you received: 3
9 years 6 months ago #200843

-- HikaShop version -- : 2.4.0

I have a product sold only in the United States and I'd like to get a list of the existing customers in the States to send them an email. Ideally this would be an AcyMailing integration, but I can't see a way to do it.

At the very least to be able to export a list of US customers from Hikashop would go a long way to helping.

Any ideas?

Conrad

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 6 months ago #200847

AcyMailing has the universal filter plugin for that:
www.acyba.com/acymailing/309-acymailing-...universalfilter.html
With the advanced query mode, you can write such query:

SELECT u.user_email FROM #__hikashop_user AS u JOIN #__hikashop_address AS a ON u.user_id=a.address_user_id WHERE a.address_country='country_United_States_of_America_223';
and that should allow you to get all the US users with such filter and you can combine it with an action to send an email to them or add them to a specific list for later.

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

Time to create page: 0.053 seconds
Powered by Kunena Forum