Need to send email message to everyone who ordered a specific product

7 replies [Last post]

Fri, 01/15/2010 - 17:58

jugney

Offline

Joined: 06/03/2008

Juice: 202

We have been selling a pre-order item which has been delayed on its trip over from the UK. I'd like to send an email update to everyone letting them know the status of the product. Is there a way to do this in Ubercart?

I have UC views set up with some bulk operations, and saw the option for "Send an email." But that asks me to enter addresses for all the recipients. I would like something that pulls in the email addresses of all purchasers and sends them a message that I compose.

Thanks
Jugney

Sat, 01/16/2010 - 02:00

#1 View page

torgosPizza

Offline

Joined: 08/14/2007

Juice: 4110

Re: Need to send email message to everyone who ordered a specifi

There isn't a way to do this out of the box, that I'm aware of. You may need to add a page or something that can grab all the email addresses of users who ordered that item, put it into a CSV or comma-separated list and then paste that into a mail program (or mail campaign site like Mailchimp).

Generally it's not great to send mass emails from your host server in case it gets blacklisted, then some IPs will block that server from being accessed. (And if it's a shared server, that becomes true for all sites on the machine.)

The query to the database itself wouldn't be difficult to come up with. But I do like the idea of notifying people when their pre-order is available.. I might even be able to use that myself. on our site. Perhaps a bounty would convince someone to write it for us?

--
Help directly fund development: Donate via PayPal!

Sat, 01/16/2010 - 21:11

#2 View page

j.mead

Offline

Joined: 07/27/2009

Juice: 385

Re: Re: Need to send email message to everyone who ordered a spe

for a possible solution checkout the who bought what module add-on:
http://drupal.org/project/uc_who_bought_what

shows info on who purchased whichever item you desire from a drop down list. displays every customer for that item plus order #'s and what not. the user emails are displayed in a text box separated by commas, so you could just copy them out and paste into a BCC field in your email program. pretty much exactly what torgosPizza is describing.
I've used it a bunch and it fits this scenario pretty well, but how many emails you need to send and how, is a different issue. if you regularly need to mass email then a third party solution might be worth looking into

the sites i'm always breaking.... www.sew-la-fabric.com
http://lostpetsla.com (though i hope i never break this one too bad)

Sat, 01/16/2010 - 21:22

#3 View page

stephthegeek

Offline

Joined: 10/20/2007

Juice: 575

Re: Re: Re: Need to send email message to everyone who ordered a

This looks like it's going to be a really nice upcoming solution: http://drupal.org/node/647950

Gorgeous original Drupal themes (and Ubercart themes!) ~ Psst: more Ubercart themes on our new site

Sat, 01/16/2010 - 21:28

#4 View page

torgosPizza

Offline

Joined: 08/14/2007

Juice: 4110

Re: Re: Re: Re: Need to send email message to everyone who order

That looks like a cool solution, but not quite what they are looking for. It seems you need to add the Feature to the product, but there's no way to retroactively get the users that have already purchased things. To me longwave's module sounds like a "buy this item and you'll be automatically subscribed" type of deal, whereas the OP needs something to the tune of "Let me know when this out of stock item becomes available." In the latter case, it's less a product feature and more like a Views implementation.

(Hmm.. create a View of all users who have purchased this product, and export as CSV? That might work.)

--
Help directly fund development: Donate via PayPal!

Sat, 01/16/2010 - 22:25

#5 View page

j.mead

Offline

Joined: 07/27/2009

Juice: 385

Re: Re: Re: Re: Re: Need to send email message to everyone who o

not that I have any reason to promote the uc_who_bought_what module other than it worked for me, i just wanted to add that far as the ability to retroactively display info, I have confirmed that the reports do query the database for orders that existed before the module was installed. it also allows export as a csv file. this should at least address the immediate need of the OP, not as a view mind you but a report. pick it apart to make a view maybe?

the sites i'm always breaking.... www.sew-la-fabric.com
http://lostpetsla.com (though i hope i never break this one too bad)

Sat, 01/16/2010 - 22:27

#6 View page

torgosPizza

Offline

Joined: 08/14/2007

Juice: 4110

Re: Re: Re: Re: Re: Re: Need to send email message to everyone w

Cool! In that case, it looks like it still might do what the OP needs. I stand corrected

--
Help directly fund development: Donate via PayPal!

Tue, 01/19/2010 - 14:17

#7 View page

jugney

Offline

Joined: 06/03/2008

Juice: 202

Re: Need to send email message to everyone who ordered a specifi

HOLY CRAP! This is Awesome!

This is exactly what I need. I just had a chance to look at it today, and my God, it actually creates a copy-and-pasteable textarea at the bottom with a comma-separated list of all the email addresses!

Yahoo!

Ubercart

Navigation

User login