Membership Renewals

Membership Renewals

Hi

I am trying to make a membership website that has a renewal system on it. I would like it to automatically ask users to renewal there online membership. I thought the function would be in SecurityAssist or a maybe in Cookies Toolkit but not really shore. I have the super suite and would really appreciate any help anyone could give me or to direct me to tutorials to learn.

If your host allows it, you could set up a cron job to run a script. For example you could create a page using UE to send an email 365 days after the start of membership date in the database. Have it run on page load as the trigger. Then set the cron job to run everyday and point it to that script page. Very simplistic answer but it depends if you have access to crons. If you have cPanel then you probably can.

What I want to do is build a website where members pay a fee to buy and sell items, a very simple version of ebay I guess. The membership will be for 12 months, after 11 months I would like a renewal button to appear on the member’s page, giving them the option to pay for the account before the renewal date. I also wanted it to lock out members if payment is not made by the due date.

I am still learning how to uses webassist, but can this all be achieved via webassist?If so are there any tutorials on paying registration?

WebAssist tools are built with mySQL and PHP. You can already do anything you want with mySQL and PHP, so anything is possible. You can do anything you can imagine with them even without our tools.

It is kind of like asking if our tractor and basic construction tools can build your house if you have all of the raw materials necessary. It isn't going to build it for you, but it sure is easier that using your bare hands.

Our tools won't design your database, or tell you what you want to do... you will have to do at least some level of thought and work to get it done. I don't know if you can do it or not, but I can explain one way I could imagine doing it, but it won't be achieved by Webassist, it will have to be achieved by you:

In this case you can use powerstore for your store. Powerstore is already set up to keep track of the date of sale and user and include the userid with the sale.

You would have to decide the page(s) where you want your button to appear and add it. Start with that and get it working so that they can buy 12 month memberships constantly.

Then you would want to probably add a field to the order details table to include the "active date" because if someone ups their membership after 11 months you wouldn't want to expire 12 months after, but 12 months after the original membership was created.

This would mean adding a column like: "DetailActiveDate" to the orders table and setting it to the date when someone signs up for their first purchase for the original purchase and based on 12 months from the last ActiveDate on any renewal.

Since you will have a separate button for the renewal you can take advantage of that for the differentiation.... this means adding a column to the cart for the ActiveDate and setting it in the add to cart interface as I explain below.

On the page where the subscription is originally purchased you can set it to <?php echo(date('Y-m-d')); ?>

On the renewal page you would want to get it from the recordset. You will have to create a recordset with the user's most recent purchase in order to find out if it has been more than 12 months since that date, so you can use that same recordset to determine when to show the button as well as what to set the cart column to.