Simply want advice on a type of rewards program

[Andrew Watson]

Hi all. I welcome any an all advice you may have for me about how to implement this with Prestashop 1.6

I am building a Webshop for selling coffee. We have an offer that if the customer buys just one case of coffee every two months, the company will insure their coffee machine against breakages. To put it another way, as long as the customer make a purchase of one case of coffee (12 boxes of coffee pods) every two months, if anything goes wrong with their machine, we will fix it or replace it. It's called "Club Cabu".

So. I would like to use Prestsashop as much as possible to manage the club. I would prefer not to change prestashop code. Here’s my rough idea:


Customer buys 12 boxes of capsules and a price rule gives them a discount.
If this purchase is made, the customer is assigned to the group “club” (I think this is the best way because I want a way that the customer can check her/his status) - important, day of entering the club group must be set to zero, if there is no variable which records when a persons group status is change, I will have to add one.
56 days after entering the group (or making the purchase) the customer receives a reminder.
I really I would like the reminder to offer them to one-click repeat purchase
I would set up a chron job to assign any customer who has been in the group “club” over 62 days, back out of the club into the default group.

To put it more simply:
Customer buys 12 boxes, enters in group
get purchase reminder after 56 days
if purchases > then date set back to zero
if still in the group "club" after 62 days, moved out of group.

Is this the easiest way?  I can’t use a standard subscription model because people have an aversion to making that kind of commitment with coffee (we’ve tried). So this is kind of like a manual subscription system.


So here are the things I don’t know how to do and I’m happy for module suggestions or suggestions using exiting features of Prestasho.
I don’t know how to create an action at time of purchase that depends on the Price rule.
or how set a variable (or use existing Prestashop variable) to track time since last purchase
Send an auto email after 56 days

Phew, sorry about all that, if there is anyone still with me, first of all; Thanks. Second I’d love to hear your thoughts on how I can do any of that.

Thanks
Andrew

Edited August 8, 2014 by Andrew Watson (see edit history)

[_beans]

Hi Andrew,

 

Sound a bit like coincidence, but I think our module might be of a help to you. Here is the link to the post:

 

http://www.prestashop.com/forums/topic/347295-free-module-beans-help-you-get-repeat-customers/

 

What do you mean by "if not assigned to another group after 62 days, moved out of group."?

[Andrew Watson]

What I mean by:

"if not assigned to another group after 62 days, moved out of group"

If the customer doesn't buy the product in 62 days they no longer stay as par of the gorup.

 

I should have written (I will edit this abouve so other reading it might understand):

if still in the group "club" after 62 days, moved out of group.

 

I am looking into the beans loyalty system and it looks quite good, but the proble is this is not a rewards program with points. The customer is imply in the program or out, depending on weather they meet the criteria.

 

If I can meke it work through this I will thanks.

[_beans]

I was thinking the same as you at first sight. But your problem can be handle this way:

 

Suppose you set it up so that 1 box of coffee give you 10 points.

Then 12 boxes of coffee give you 120 points.

Now suppose you create a reward with a discount of $10 only if you customers get 120 points.

 

Now it means that everytime your customers bought 12 boxes they get their reward.

 

Is it what you need?

Edited August 8, 2014 by _beans (see edit history)

[Andrew Watson]

Yes, I thought of that, you are right, and I might do something like that, but there is one problem. It can't be that the customer simply get points for the product because then they can simply buy enough to get the insurance when thier machine breaks. It has to be that the must buy 12 boxes every two months. They can buy more, but unless they have a history of buying every two months for at leats 8 consequitive mnths, the customer can't get a replacement machine.

 

The timing is very important.

[El Patron]

you may want to review existing 'subscription' service addon's.  native prestashop does not support this out of the box.

 

https://www.google.com/search?q=prestashop+module+subscriptions&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a&channel=sb

[_beans]

Then you can assume rewards points can be cancelled if there is no purchase within two months.

[Andrew Watson]

you may want to review existing 'subscription' service addon's.  native prestashop does not support this out of the box.

 

https://www.google.com/search?q=prestashop+module+subscriptions&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a&channel=sb

 

Yes, I looked there first of course. But what I have is different to a subscription in that the customer is completely free to make a puchse and stay subscribed or not.

 

BUT you did give me a great idea: I could make a free two month membership/subscription (call it whatever) whenever a customer makes a minimum purchases (say 30€) and then they simply get a reminder to make another purchase to stay a memeber/or stay subscribed. That would work.

 

This sounds like the perfect solution.

 

Now I just have to find a module that will do that, the key thing is that a membership/subscription is an autimatic benefit of making a certain purchase, that's what I need to find.

[Andrew Watson]

Then you can assume rewards points can be cancelled if there is no purchase within two months.

 

I'm sorry _beans but you system is just not suitible for this case. Yes, you could have the points cancell, but that actually serves no purpose. The problem is, there is no way to make sure that no MORE points are added during the two month period.

 

We are offfering a great deal to customers; free insurance. But for this we need them to be a long time customer (remember thay also get a great product) so we have to make sure that there is no way for them to simply buy our product when thier machine breaks.

[_beans]

Yes you are right. I was going to suggest that you do it on a rolling basis but your solution sounds simpler. good luck with your project.

[Andrew Watson]

In the end, I could find no easy way to do this with off the shelf solutions. I am now getting some customization help.

 

I decided to build it like this:

 

1) Make variable in the database called club with a date format.

3) Prestashop configured so that when a purchase is made over 24euro (or with a price rule) is made, the date of purchase is stored in the variable club.

On the front end a status line added to the customer account.  Simply saying “Club status: “. Simple php will display active if the current date is =< club+62 days    - or it will display inactive if the current date is after 62 days or “club” is empty/less than 0.

Then make a simple cron job to send a .html email to the customer on the 56th day after the date in “club".

Edited August 25, 2014 by Andrew Watson (see edit history)