Techology, Politics, Life

Export Shipping Emails from all Magento orders

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:

  1. Open 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.
  2. In the table Search field, type sales_flat_order_address for the table name.
  3. Click Search and watch the first 30 orders display
  4. 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.

Store WordPress Blog images on AWS S3

If you have a self-hosting WordPress blog and would like to avoid storing images locally on your server you can use Amazon AWS S3 service to store your images. Some people prefer to do it in order not to overload their host server with images, movies, mp3 files etc. So here is how it can be done. Assuming you are familiar with AWS and already have all the necessary access keys and user privileges, you can download a WordPress Extension called wp-s3media-master from GitHub and install it. Once you enter proper access keys, all your newly uploaded WordPress media files will automatically be uploaded to Amazon S3. Have fun uploading!