How to filter sales to guest customers vs register

  • Posts: 67
  • Thank you received: 3
5 years 4 months ago #210117

-- HikaShop version -- : 2.5.0

Hi,

My e-shop allows guest customers to buy.
is it possible to get a report with sales to guest customer ?

Many Thanks

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

  • Posts: 13201
  • Thank you received: 2319
  • MODERATOR
5 years 4 months ago #210132

Hi,

Yes that can be done through the mass actions, you have to select the "order" data and in the filter part set the filter on "User columns", then "id" "IS NULL", let the input field empty.

And for the action you can export a csv file.

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

  • Posts: 67
  • Thank you received: 3
6 months 3 days ago #320002

Xavier wrote: Hi,

Yes that can be done through the mass actions, you have to select the "order" data and in the filter part set the filter on "User columns", then "id" "IS NULL", let the input field empty.

Hi HikaShop team !
is this mass action still ok ?
I get an error when I try it ( 1054 Unknown column 'joomla_user.id' in 'where clause')
Thanks for your help.

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

  • Posts: 71219
  • Thank you received: 10726
  • MODERATOR
6 months 2 days ago #320041

Hi,

It works fine on my end.
Try again after activating the "debug mode" and "error reporting" settings of the Joomla configuration.
Also, please provide the exact version number you see in the Hikashop configuration (along with the build number).

The following user(s) said Thank You: Thierry H.

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

  • Posts: 67
  • Thank you received: 3
5 months 4 weeks ago #320212

Hi Nicolas !

I updated Joomla from 3.9.18 to 3.9.19 and Hikashop from 4.3.0 [2005091545] to [2006031845] and now it's OK.
It works.

Thank you !

The following user(s) said Thank You: Philip

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

Time to create page: 0.057 seconds
Powered by Kunena Forum