How to filter sales to guest customers vs register

-- 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

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.

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.

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).

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 !