Queued Emails - Ideas and Chat

[burt]

How about an email for when there is only about less than 3 (or whatever you want to set) left

I have set this to invoke if the Stock of any product in the order is <= 5 (this number can be changed by shopowner).

Template:

checkout_stock_tpl.jpg

Produces this Email:

checkout_stock_em.jpg

[14Steve14]

Gary

Do you think this system could this be used to send an email to Trustpilot to help gain reviews that are on Trustpilot. Trustpilot currently suggested sending an order confirmation email BCC to another specific Trustpilot email address, which then activates the Trustpilot system, which sends a review reminder to the customer. Using your system this email could be sent after a select number of days.

[burt]

I'm not familiar with Trustpilot, but this system seems to be a good fit, maybe.

There is a "review request" module included;

1. Customer makes order
- everything is as normal, some emails get scheduled
2. Shopowner after some days "completes" the order in admin
- at this point shopowner can click a checkbox to say "also schedule review request"
3. Customer gets the review request on the schedule.
- hopefully jogs his memory to come back and reviews product(s) from the order.

This existing module is obviously for those shopowners who want to keep Reviews "in house".

TP is obviously not in house. It would really depend on what you want the TP email to say and when it is to be sent, and where it is to go to...does it go to TP? Does it go to the customer? PM me a bit more detail and I can advise further.

[ecartz]

Trustpilot currently suggested sending an order confirmation email BCC to another specific Trustpilot email address,

You don't need this system for that. Just add them to SEND_EXTRA_ORDER_EMAILS_TO. That's not a BCC, but it doesn't matter since that email is sent separately (so not visible to the customer; it will not expose the email address to the customer). Note that this is a solution to the technical problem represented, not a recommendation to proceed.

As you noted in your other post, this seems to have a serious GDPR impact. I can't see how you could possibly do this without notifying the customer and getting them to agree to Trustpilot's Terms & Conditions in a GDPR jurisdiction. And there would have to be some way to implement the right to be forgotten.

[14Steve14]

Trustpilot currently suggested sending an order confirmation email BCC to another specific Trustpilot email address,

You don't need this system for that. Just add them to SEND_EXTRA_ORDER_EMAILS_TO. That's not a BCC, but it doesn't matter since that email is sent separately (so not visible to the customer; it will not expose the email address to the customer). Note that this is a solution to the technical problem represented, not a recommendation to proceed.

As you noted in your other post, this seems to have a serious GDPR impact. I can't see how you could possibly do this without notifying the customer and getting them to agree to Trustpilot's Terms & Conditions in a GDPR jurisdiction. And there would have to be some way to implement the right to be forgotten.

I have been looking into this further and think that this system may be the best way to achieve sending a non marketing email asking for a review on Trustpilot or any other review platform. Looking on the ICO website, an email requesting a review is classed as a 'service' message and not a 'marketing' message, and therefore should not contain any marketing/sales promotions, and is therefore outside of GDPR as it would be considered as a part of the sales process. All it must include is text requesting a review. They do then go on to talk about adding something into the stores privacy policy about obtaining reviews and passing information to the review company, and having a link to the review companies privacy policy in the same was as you would for any payment processor.

I will keep looking.

[burt]

For ideas, perhaps a simple Order Thank you x days after the order shipped.

This would be pretty straightforward and would need to have another checkbox in the admin/orders page;

[ ] tick to schedule a thank you email

I also have, rattling around in my head, some sort of a reorder reminder email ie a consumable was purchased X days/months ago and the customer might want to order again. I'm just not sure how one might set it up since the frequency would likely vary as would the products but perhaps there is a way.

This would be more difficult as you would also need to determine what is a consumable and what is not. That's not massively difficult, just add in a flag on the products DB table "1 or 0", "1" being consumable. And a hook for admin/catalog to allow to choose "1" or "0". Then in the checkout process, loop through the order checking that flag. If found; schedule email for X days/weeks/months away.

Here there is a second problem. What should "X" look like. Maybe some consumable run out weekly? Maybe some monthly. Maybe some every 6 months? Perhaps that also needs an input (or maybe that is the only input needed). So you have a "re-order" input box on the admin/catalog page;

Dog Flea Treatment:
Reorder: 6 months

Dog Food:
Reorder: 1 month

Now say the customer ordered 3 x Dog Food and 1x Flea.

You don't want that customer getting an email in one month asking them to buy more.
Even though your re-order input box says they should.

But what if they're buying that Dog Food for 3 dogs? Then they should get the email in one month.

There's lots of moving parts in this. Do-able but far from straightforward.

If that can be pinned down perhaps a "you might also like" email could be crafted as well.

Similar to the above - some moving parts (as would need to link products together), then would need to work what has been bought and what hasn't), then craft an appropriate email. Again do-able.

it's scary what rattles around in my head.

[radhavallabh]

Hi;
How about a email for upcoming festival reminder which is relevant to the store products and also comes at the same date every year?
Warm Regds./
radhavallabh

[burt]

Hi;
How about a email for upcoming festival reminder which is relevant to the store products and also comes at the same date every year?
Warm Regds./
radhavallabh

I think this:
app.php/addons/paid_addon/events_with_n ... on_emails/

would be a closer idea to what you are thinking.

[burt]

I also have, rattling around in my head, some sort of a reorder reminder email ie a consumable was purchased X days/months ago and the customer might want to order again.

I've been playing with this idea. It's very difficult to get right (see previous post/explanation from earlier on).

Here's an attempt;

Assume you have a hook for admin/catalog.php which shows a new input box when adding/editing a product asks for "repeat reminder", let's call this the "interval". In here you can put a value for each consumable product eg "3 months", "10 days", "5 years" or whatever.

Assuming thats in place, a new Scheduler Module which loops through each Order as it is made and grabs the "interval". If the "interval" is NOT empty [which would mean this is a consumable], schedule an email - assume here that "Oranges" has an interval of "3 Months";

Template

repeat_tpl.jpg

The Email

repeat_em.jpg

Note that the date is not 3 months exactly, but is 3 month minus 10 days.
10 days grace to allow customer to order before their consumable runs out.

--

It would be sweet to also have some type of {{INTERVAL}} merge tag.
So that in the Template you could then do;

Hi {{FNAME}}
Its been about {{INTERVAL}} since you ordered {{PRODUCT_NAME}}

I'll have to have a think about that, as that is not straightforward at all.

--

If an order had a number of products, some with intervals and some not, eg;

Oranges: 3 months
Lemon: 6 months
Grapes: Never

The system would schedule two emails;
Oranges: 3 months - 10 days
Lemon: 6 months - 10 days

[burt]

I'm not super keen on this code, but it shows it's at least somewhat possible to have an {{INTERVAL}} merge tag based on the inputted (per product) "interval";

Template

with_int_tpl.jpg

Email

with_int_em.jpg