Hotel Membership Management and Subscription Workflow

Start of the Workflow/Process.

Create a new entry in the 'Membership Applications' data model when a user submits a registration form.

Update existing member details (address, contact info, tier level) in the 'Members' data model.

Retrieve the current subscription tier and expiration date from the 'Subscriptions' data model.

Calculate the new expiration date by adding 12 months to the current membership start date.

Create a task for the Membership Manager to review and approve the submitted application.

A set of sub-tasks to verify ID documents, email verification, and payment method validity.

Update the status of the membership entry from 'Pending' to 'Active' upon approval.

Create a new entry in the 'Digital Assets' data model containing the unique membership QR code.

Send a welcome email to the new member with their benefits summary and login instructions.

Sum the 'Subscription Fee' property from all 'Active Subscriptions' created this month.

Retrieve the total accumulated points from the 'Loyalty Program' data model for the member.

Create a task for the Customer Success team to reach out to members whose subscriptions expire in 30 days.

Send an SMS notification to the member's phone number 3 days before their membership expires.

Update the membership status to 'Cancelled' and set the end date in the 'Subscriptions' data model.

Generate a report showing the number of cancelled vs. renewed memberships for the current period.

Delete incomplete membership applications that have been inactive for more than 90 days.

Calculate the percentage of points required to move from 'Silver' to 'Gold' tier based on current points.

Calculate the average number of days between 'Join Date' and 'Cancellation Date' for churned members.

End of the Workflow/Process.