Page 1 of 1

Automated emails to customers based on products bought

Posted: Tue Jun 08, 2010 7:33 pm
by OC2PS
There is an online gift shop in the UK, called Getting Personal - http://www.gettingpersonal.co.uk

One of the coolest things they do is, about a week after I receive an order, I get an email from them, with the subject "About your order #xxxxx"

Inside the email, they show the product I have bought and urge me to write a review, providing a link to the review section for each individual product.

I think this is amazing. They have amassed tens of thousands of reviews, which is brilliant for marketing their shop - it goes towards credibility and popularity via word of mouth....

Is there a way in Opencart to put an automated system for this sort of review seeking post sale email?

Re: Automated emails to customers based on products bought

Posted: Tue Jun 08, 2010 8:01 pm
by JAY6390
Pretty sure this would be simple enough to implement, you'd just need a cron job once a day to run a script and check how many days ago an order was placed, and retrieve all those orders and implement it

Re: Automated emails to customers based on products bought

Posted: Tue Jun 08, 2010 9:05 pm
by OC2PS
Since I am completely technologically illiterate, any chance of getting a mod or directions (or better still, have this as standard feature in next release of Opencar)?

Re: Automated emails to customers based on products bought

Posted: Tue Jun 08, 2010 10:57 pm
by Qphoria
you could do this without cron as well.. just set a check for all orders older than 24 hours when you login to the admin and auto-send an email for those products. It assumes you login to your site regularly of course

Re: Automated emails to customers based on products bought

Posted: Tue Jun 08, 2010 11:35 pm
by OC2PS
Not sure I follow.

Firstly, I'd want to make a check for the products in a date range - dont want to repeatedly keep sending emails to ALL old customers. So will need to check for something like - orders placed last Tuesday..or something like that...

Next, how do I include links to the review section of the products purchased?

In my template, I've exploded the tabs...take out the review section from tab, and placed an anchor, so that I can have a fixed URL like http://www.csillamvilag.com/shop/Nonfig ... #tabreview

So that's not the problem - problem is that for each customer/order, the products will be different. How do I work that in?

Re: Automated emails to customers based on products bought

Posted: Tue Jun 08, 2010 11:39 pm
by JAY6390
Not sure I follow, how will a product be different for different users?

Re: Automated emails to customers based on products bought

Posted: Tue Jun 08, 2010 11:43 pm
by OC2PS
Didn't use the right words. Products included in each order will be different. So while customer 1 will need to receive links to review sections of products A, B, C, customer 2 will need to receive the same for products D and E

Re: Automated emails to customers based on products bought

Posted: Tue Jun 08, 2010 11:48 pm
by JAY6390
Sure, but that's pretty simple to do with a foreach loop over the product id's

Re: Automated emails to customers based on products bought

Posted: Tue Jun 08, 2010 11:56 pm
by OC2PS
Ok. Sorry, I'm not a programmer or a techie, so sometimes have trouble following everything.

Any way you could provide more specific directions (read code)?

Many thanks!

Re: Automated emails to customers based on products bought

Posted: Wed Jun 09, 2010 12:12 am
by JAY6390
Something as full scale as this can't be explained without you understanding at least basics of php and mysql, so it's pointless trying to explain it in psuedo code, and well, it's going to need quite a bit of work to test and implement it. Had I any use for it myself I would code this out at some point, but it isn't and I have paid work to be getting on with so you're going to have to rely on someone else to do this for you I'm afraid

Re: Automated emails to customers based on products bought

Posted: Wed Jun 09, 2010 5:32 pm
by OC2PS
Hmm...thanks....

Anybody? Any ideas?

Re: Automated emails to customers based on products bought

Posted: Sat Jun 12, 2010 1:48 am
by OC2PS
Help!

Anybody?

Re: Automated emails to customers based on products bought

Posted: Wed Oct 06, 2010 3:05 am
by OC2PS