how to get list of customers with no order

  • Posts: 98
  • Thank you received: 3
10 years 9 months ago #144665

Hi,

I get a fair number of 'tyre kickers' who create an order and then do nothing. I would like to get a list of these so I can communicate with them and if they don't respond disable their accounts. Can't see any UI in HikaShop to do this. Is there an SQL query that I run?

Conrad

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

  • Posts: 12953
  • Thank you received: 1778
10 years 9 months ago #144743

Hi Conrad,
The solution will be to do it by using an SQL query through your phpmyadmin :).

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 9 months ago #144750

why not instead create a mass action (menu System>Mass actions) on the data "order" with a filter on the order status and an action to either export a CSV of the results or a table display ?

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

Time to create page: 0.061 seconds
Powered by Kunena Forum