0

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) ? – WISAM HAKIM May 11 '18 at 1:39
  • 2.0.19. Billing Details. – A.Agg May 12 '18 at 3:31
0

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, privacy policy and cookie policy

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