Developer forum

There is no such feature built in. You have to do a SQL query to find those...

BR Nicolai

You could once a day/week run a query that will update 2 custom fields on all users "Next loyalty point expiration" and "Loyalty points about to expire". Then use smart search to find users that is about to get points expired and send an email.

Hi Nicolai,

Thank you for the answer.

Would it be feasible to build a recipient provider instead? I have not investigated yet how loyalty points are stored in the database but if I have an expiration date for each transaction that generated accrual of Loyalty points, maybe I can build a Recipient provider and use Email MArketing to send the email notification.

Do you see this as something that can become part of the standard Rapido? Considering that LS Retail integration will focus on loyalty points?

Thank you,

Adrian

Hi Nicolai,

I have another question about the Loyalty points, that is connected with the question above. When using points to pay for an order, are they used in the same order they have been awarded? First In First Out?

Thank you,

Adrian

And another one. Is it possible to allow Users to use Loyalty points per CustomerNumber?

Meaning all users having the same CustomerNumber (belonging to the same Customer) will be able to use all points awarded for all transactions of that Customer Number regardless of the User that placed the order.

Does it make sense?

Thank you,
Adrian

Hi Adrian

Yes, I think you can build a provider instead. That should be fairly easy. The database schema can be found here: https://doc.dynamicweb.com/documentation-9/ecommerce/payment-shipping/loyalty-points#sideNavTitle2

There are many other things that are more important in relation to Rapido right now - but if you create something useful, we would love to get it and see if we can move it into Rapido.

The points are stored in a list of transaction in the order they are earned and spend. So yes.

2 users cannot share points. So you would have to either make the transactions on all users, or let them impersonate their account or something else.

BR Nicolai

Hi Nicolai,

Thank you for the answer.I think I got what I needed. I will have to think about the common basket of loyalty points per customer.

I totally understand there are things more critical ro Rapido than loyalty points.

I will share with you what we eneded up with and you can decide if you want to use it.

Thank you,

Adrian