Erock Posted February 27, 2009 Share Posted February 27, 2009 Is this possible? I have a setup a store for a friend that has been rather successful selling on ebay for the past 3-4 years. Now that the web store is ready to launch he would like to notify all of his past customers VIA email. The problem we are seeing is having to go back through 3-4 years of old transactions and using copy/paste to manually create the list. Very tedious indeed. I know that the answer is most likely "NO" but is there any way to automate this task so it doesn't take 3 weeks of c/p to get the list done? Link to comment Share on other sites More sharing options...
ricksteruk2005 Posted February 27, 2009 Share Posted February 27, 2009 I dont know of a automated way, however you can download a CSV or excel sheet from paypal and then just copy the email addresses over to your bulk email client and send them that way, you should be able to do a lot of past customers in one easy go. I dont help with templates (thats what the seller is for) th search function will often help, when it dont try this in google. site:http://www.oscommerce.com/forums then your search word Link to comment Share on other sites More sharing options...
Erock Posted February 27, 2009 Author Share Posted February 27, 2009 Well that would be faster than the way he's currently doing it. I will have him stop by and get me into his paypal, any idea where we should go to look for the CSV file? That's exactly what I was looking for. If it was in excel I could just copy the whole column. Thanks for the tip. Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted February 27, 2009 Share Posted February 27, 2009 SELECT o.customers_id, o.customers_email_address, o.customers_name FROM orders o WHERE payment_method = 'Paypal' GROUP BY o.customers_id Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Erock Posted February 28, 2009 Author Share Posted February 28, 2009 Thanks to the tips above I have this all figured out. Saved a ton of time for the owner. The original list was about 3100 rows, after filtering out the owners transactions and the multiple purchases, the list came up to about 1700 unique email address. So does anybody have any tips for sending this many emails? Should we break it up into phases? Thinking that the mail server may choke down when trying to send that many emails. Of course I have no idea, I have never tried, or considered for that matter, sending that many mails at once. I'm researching bulk mailing apps online but don't want anything that may trigger a spam filter. This will only be a one time mail sent to customers who have previously bought from him on ebay, after the initial mail goes out we will most likely not do it again. Hard to tell how many of those addresses will still be valid anyway. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.