I would like to get customer details from all orders, specifically email address and company name if it exists. When I export customers via the Magento export menu, I only get a limited list of registered customers. We have many customers who don't register, and I want to have them in the list as well.

It's OK to do this via MySQL. Export to CSV is even better.

1 Answer 1


You can join the sales_flat_order_address table on parent_id with the sales_flat_order table, and filter out the desired address (billing or shipping) by filtering on address_type in the address table.

Or you can go search the web for a decent order export module, which has options to export addresses and the possibility to export to CSV.

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.