Subscription renewal system
A database will be made available for testing.
Each of our clients can activate this module by providing following data:Start renewal process (example: 4 weeks before "end_date", the "end_date" is in our (MySQL) database.
Repeat date 1, 2, 3
Subscriptions and prices (from database or manually entered)
Once every day the application checks the database for "end_dates" scope of the renewal routine. If so, retrieve: lastname, addition, firstname, subscription name, end_date, e-mail. APPEND]
2a Send e-mail to end user (your subscription will end [end_date] renew now.
2b Reminder to anyone who did not respond to first e-mail
Same. Append list (of users mailed)
2c Reminder to anyone who did not respond to second e-mail
You subscription will expire in 3 days, renew now. [APPEND]
3. RENEWAL (via link in e-mails)
Display current subscription info (type and end date) subscription options
make a choice (renew change) . APPEND
After making a choice (renew or other) the end user must indicate how he wants to pay. Options 1) with my next reservation, 2) now with CC, 3)now with Ideal, 4) monthly installments.
Option 1>>append database (table, column, amount)
Option 2>>Verisign payment procedure
Option 3>>Ideal payment procedure (Ideal is a system of Dutch banks. A client is led to the bank’s website, arranges the payment after which the Bank signals "paid".
APPEND>> payment method, subscription, amount payable, paid.
Append end user record (subscription type and new enddate).
Activity list + Payments list