How to export NOT LOGGED IN customers' list

[simone_romeo]

Hi everybody.

I'm exporting the list of all my customers and I have set different custom groups for them. One in particular, "NOT LOGGED IN", is not featured among the ones I can export. How do I get a list of these customers?

I'm using Magento 1.9.2.2

Thanks!

Edit: this group is not one of the custom I made.

[gelanivishal]

Hello @simone_romeo ,

You can import export customer by customer group with the help below extension, Please check it 

https://marketplace.magento.com/commerceextensions-ext21359.html

--
If my answer is useful, please Accept as Solution & give Kudos

[simone_romeo]

Hello @gelanivishal and thank you for your answer!

I can alredy export customer by customer groups. All the groups I have in Magento are exportable with no issues with an exception for the "NOT LOGGED IN" group.

[gelanivishal]

Hello @simone_romeo ,

How do you export CSV by Magento way? and do you want to exclude "NOT LOGGED IN" group customers in exported list?

--
If my answer is useful, please Accept as Solution & give Kudos

[simone_romeo]

Hello @gelanivishal 

I go to Customers > Manage Customers, I select the group and export in CSV. I can find all the groups I have except for "NOT LOGGED IN".

What I want to do is to export "NOT LOGGED IN" customers, but I can't manage to do is since this group does not appear.

These are my customer groups:

And these are the customer groups I can export:

As you can see, the group "NOT LOGGED IN" does not appear.

[gelanivishal]

Hello @simone_romeo 

Let me clear with you "Not logged in" it is just group. There is not any customer assigned on it. If any customer has placed an order with as guest then Magento assign "Not logged in" as customer group. If you want to export all customer of "not logged in", You will get in sales_flat_order table. I hope that you understand it. Let me know if you have any issue. I can't see your attachment. 

--
If my answer is useful, please Accept as Solution & give Kudos

[simone_romeo]

Hello @gelanivishal 

Yes, I do understand and thank you very much! Do you know the location of this file you're talking about?

[gelanivishal · Accepted solution]

Hello @simone_romeo ,

I'm taking abouot sales_flat_order table. Please go to phpmyadmin and run below query

SELECT `customer_firstname`, `customer_lastname`, `customer_email`
FROM `sales_flat_order`
WHERE `customer_id` IS NULL

--
If my answer is useful, please Accept as Solution & give Kudos

[simone_romeo]

Thank you @gelanivishal

You have been very helpful!