Retrieving guest email address in Magento DB

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

Please walk me through how to collect the guest email addresses from mysql, I have tried this code in phpmyadmin but I get an error:

$orderCollection = Mage::getModel("sales/order")->getCollection()

->addFieldToFilter('customer_email',$Customeremail)

->addFieldToFilter('customer_is_guest',1) ->addFieldToSelect('*');

foreach( $orderCollection as $eachorder){

//var_dump($eachOrder)

}

Magento MySQL

Project ID: #11895358

About the project

17 proposals Remote project Active 7 years ago

Awarded to:

wmkosc

hi, I have been magento expert for over 6 years and have much experience in this field. I read your requirement and really interested. I will compare script and show you how to get guest email address, I am sure I can More

$30 AUD in 1 day
(125 Reviews)
6.6

17 freelancers are bidding on average $49 for this job

sapotacorp

Hi sir. What Magento version are you using? I can help you to retrieve the guest email. I can start immediately. M

$34 AUD in 1 day
(906 Reviews)
8.7
Namelessinterest

Hello! I have expreince in mysql administration and will be very happy tohelp you wiht yhis issue right now. Thanks!

$30 AUD in 1 day
(262 Reviews)
6.7
tech4mage

Hi, Try to load customer by email you get from this collection If you get customer id , then this customer has account, and if not , then this is a guest customer, Try to follow this logic. May be it w More

$25 AUD in 1 day
(166 Reviews)
6.9
eGlobalSoft

Dear Sir, I have 4 years of experience in magento/php/html/css. I have gone through your requirement and interested to work on your project. Please check my reviews and feedback for your reference. Thanks & Regards More

$30 AUD in 1 day
(41 Reviews)
5.8
cryan09

Hi there, I would like to help out with this magento guest email situation for you. I've taken a look at what you require and am confident I can take care of it quickly and easily for you without issue. One thing More

$20 AUD in 1 day
(43 Reviews)
4.9
overtservices

Hello, I have analysed your job posted on freelancer and I’m interested to do your project as I have 4+ years of experience in “Magento”. So, I think that I have all the skills you’re looking for. I would like to di More

$30 AUD in 1 day
(22 Reviews)
4.8
Walrusyn

Do you have ssh access to the mysql server? would love to help. looking forward to hearing from you. Best regards, Marco Ramos

$30 AUD in 1 day
(21 Reviews)
3.8
bMagento

Hello, I am a magento developer. I will do this for you. I will do my best for you. Thanks, Bhavin Bhalodia.

$30 AUD in 1 day
(22 Reviews)
3.6