Plan expiration date update using script
By Mario on Wednesday, 20 December 2017
Posted in General Issues
Replies 3
Likes 0
Views 732
Votes 0
Hello,

I have the following scenario:

About 400 user wth two active plan:
Plan A: 1 year
Plan B: 6 month

Plan B was activated after a variable period from Plan A activation.

I need to extend Plan B in order to let expire both plan in same time.

What I want to do is tu update using a script the table payplan_subscription, field expiration_date.
I will set expiration_date of Plan B same as expiration_date of Plan A for the same user.

Is this enough or I'm missing someting?
Is ther another way? Maybe an app?

Thanks,
Mario
Hello Mario,

You can use plan extend functionality of payplans, it's available on backend Payplans Subscription screen.
See attached screen shot.

Using this way in 4 times, you can extend the subscription , don't do the changes in database manually.
If you don't want to use the extend feature then you need to write script for this. So i'll suggest you to use extend feature, it's easy.

Let me know if you have any confusion.
Manisha Ranawat
·
Thursday, 21 December 2017 10:37
·
0 Likes
·
0 Votes
·
0 Comments
·
Uhmmm.... i check but I understand I can extend only for a fixed period: example all plans are 6 month extended.

But I need to align expiration date between two different plan belongs to same user.
Mario
·
Thursday, 21 December 2017 23:50
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

Then you need to select the plan in filter's , so you can extend the subscription for the user for specific plan. (you can set different extend time having different plan on same user)
Or your requirement is something different then explain with example , so i can assist you.
Manisha Ranawat
·
Friday, 22 December 2017 12:13
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post