Originally Posted by gbianchi
Just a quick question. You say this is a subscription, so you don't want to store a value (a simple value) on the database. Well, when the subscription ends (because there is a start date that you need to store and maybe, and end date). How will you know how much you have to recharge the user to get the subscription back???
Also, is there is any problem, how will you, for example, return the money???
I will store the transaction once the transaction is completed. I will have orderHistory table that will store stuff like the price they paid and the transaction. But I am talking about while the transaction is still in the stages of being processed(ie they have not finalized the payment).
I will be using IPN once I get the verified back from paypal the transaction will be saved.
I will also have another table that keeps start and end date and will be validated on login.
There will be no automatic re subscription right now since this is for students and the 3 options I will be giving should be good(20weeks,40weeks,1year). It is not a monthly thing and since I am assuming they will have summer vacation and stuff then there is no point of doing automatic subscrption(unless by popular demand).
There will be no refunds since I will give them 7 day free trail and if they can't decide they don't like after 7 full days then thats tough luck(at this stage you should be able to basically know how to use the entire system in like a day). In the future when more stuff is added then I might add a refund.