I want to list the details of all the customer which has made an order.
The customers who has created account , can easily be found out from the admin side.
But how can I find the list of all the guest customer who had made orders from the beginning of the store.
Please suggest me some query so that I can list all the customer from the order table.
Best Answer
Try this way:
Remember guest orders are not associated with any customer.
Hope this helps.
Update [1]
Even better way: