Hello everyone,
I am trying to setup a social club with members.
Club members pay a fee once a year, they receive a members cards. The members card is used to swipe on the sambapos till, when the card is swiped the member they have discounted prices on products / drinks at the bar. I have this part working okay using price definitions.
When adding a club member using Entities, we add the expiry date of the card. ie if todays date is 17/08/2023 we manually type in 17/08/2024 in to the Entity - Expiry Date field.
When swiping the members card, we have a Sambapos rule which checks the date of the Entity Expiry Date field to the current date of the system. If the date is over 1 year / 365 days a pop up is displayed to day this member has expired. Along with a another rule which change a 2nd field named Member status to 0. This stops sambapos searching the price definition field for members prices.
When a member wants to renew their membership card. They pay a fixed amount for another year, at the moment we have to manually type in the members expiry date field the new date. I have searched and searched through this forum and seen the questioned asked, and tried the examples of others. I was hoping we could come up with a solid answer how to achieve this. I’m sure a lot of you would agree to this, as sambapos does and excellent job for Pubs / Restaurants but we are missing clubs.
I have managed to achieve so far adding 1 year to the expiry date. But this is not adequate enough for a club environment because of these scenarios of club members.
-
Adding a new member, field to automatically enter the date of 1 year from the current system date.
-
Member wanting to renew membership before the expiry date (before card expires). I.E
Today’s date is 17/08/2023
Card Expiry is 30/08/2023
When renewing the expiry date automatically changes to 30/08/2023. Other wise the member loses 13 days of membership. -
Card has expired IE
Today’s date is 17/08/2023
Card expired 17/07/2023 (a month a go)
When renewing the rule will automatically change the date to 17/08/2023 (1 year from current date)
This is screen shots and gif of what I have so far achieve for renewing dates

I’m hoping we could all pull together on this to clear this up once and for all for everyone here.
PS using sambapos 5.5.4
I have read through VIP, Club Members, expiry dates etc for 3 weeks. Completley stumped on this one