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.
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.Sign up to join this community
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"