[Skip to main content](#vessel-content) # How to filter sales to guest customers vs register ## - **[Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile")** - [![Thierry H.'s Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33573-thierry-h "View Thierry H.'s Profile") Topic Author - [ Offline](/forum/user/33573-thierry-h) Less More - Posts: 70 - Thank you received: 3 - - 11 years 3 months ago [\#210117](#210117) by [Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile") *[How to filter sales to guest customers vs register](/forum/36-reports-statistics/878482-how-to-filter-sales-to-guest-customers-vs-register#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")* was created by *[Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile")* -- 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84Nzg0ODItaG93LXRvLWZpbHRlci1zYWxlcy10by1ndWVzdC1jdXN0b21lcnMtdnMtcmVnaXN0ZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 11 years 3 months ago [\#210132](#210132) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[How to filter sales to guest customers vs register](/forum/36-reports-statistics/878482-how-to-filter-sales-to-guest-customers-vs-register#210132 "-- 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84Nzg0ODItaG93LXRvLWZpbHRlci1zYWxlcy10by1ndWVzdC1jdXN0b21lcnMtdnMtcmVnaXN0ZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile")** - [![Thierry H.'s Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33573-thierry-h "View Thierry H.'s Profile") Topic Author - [ Offline](/forum/user/33573-thierry-h) Less More - Posts: 70 - Thank you received: 3 - - 6 years 5 months ago [\#320002](#320002) by [Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile") Replied by *[Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile")* on topic *[How to filter sales to guest customers vs register](/forum/36-reports-statistics/878482-how-to-filter-sales-to-guest-customers-vs-register#320002 "-- 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")* > 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84Nzg0ODItaG93LXRvLWZpbHRlci1zYWxlcy10by1ndWVzdC1jdXN0b21lcnMtdnMtcmVnaXN0ZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 6 years 5 months ago [\#320041](#320041) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to filter sales to guest customers vs register](/forum/36-reports-statistics/878482-how-to-filter-sales-to-guest-customers-vs-register#320041 "-- 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, 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.](/forum/user/33573-thierry-h "View Thierry H.'s Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84Nzg0ODItaG93LXRvLWZpbHRlci1zYWxlcy10by1ndWVzdC1jdXN0b21lcnMtdnMtcmVnaXN0ZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile")** - [![Thierry H.'s Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33573-thierry-h "View Thierry H.'s Profile") Topic Author - [ Offline](/forum/user/33573-thierry-h) Less More - Posts: 70 - Thank you received: 3 - - 6 years 5 months ago [\#320212](#320212) by [Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile") Replied by *[Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile")* on topic *[How to filter sales to guest customers vs register](/forum/36-reports-statistics/878482-how-to-filter-sales-to-guest-customers-vs-register#320212 "-- 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 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](/forum/user/34318-philip "View Philip's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84Nzg0ODItaG93LXRvLWZpbHRlci1zYWxlcy10by1ndWVzdC1jdXN0b21lcnMtdnMtcmVnaXN0ZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.058 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)