I want to export all the orders till date (without using extension) with Following Details - Name - E-mail - Phone

Can someone guide me on DB query to export the same? Default export in panel only allows name and email, no phone numbers.

  • which Magento version you are using? Name of the customer?, Phone of what (billing/shipping address) ? May 11, 2018 at 1:39
  • 2.0.19. Billing Details.
    – A.Agg
    May 12, 2018 at 3:31

1 Answer 1


You can use this query to have what you need

SELECT T0.entity_id As OrderId,CONCAT_WS(' ',T0.customer_firstname ,T0.customer_lastname) AS Name,T0.customer_email As Email, T1.telephone As Telephone from sales_order T0 inner join sales_order_address T1 on T1.parent_id = T0.entity_id where T1.address_type ="billing"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.