At some point you may have a need to download information on all your Magento orders that were ever placed in your Magento store. There are some build in Magento tools as well as extensions to address the task on hand. The problem with extensions is that either cost money and/or often times just clutter your code with unknown/untested additions. The problem with Magento is it by default it only allows you to export customer information. Which means you only get the information on the customers that registered themselves. But what about those customers who did not register with your Magento store and preferred to checkout without registering? How to we get those email addresses?
PhpMyAdmin to the rescue! Here is a step by step procedure to export the email addresses. A word of caution, if you have thousands of orders, it may take a while to display the table. So filter your database queries! Here are the step-by-step instructions:
- Open http://www.yoursite.com/phpmyadmin If you do not have it you can install and download it form here. Note this is not a Magento applicatoin or extension. It just allows you to view and download your MySQL database tables.
- In the table Search field, type sales_flat_order_address for the table name.
- Click Search and watch the first 30 orders display
- You can change the amount of orders displayed and export all information right from that screen. (Check All > Export).
That is it you are done! To summarize, use sales_flat_order_address table in your Magento MySql Database to export all email addresses associated with all your Magento store orders.