Pending subscriptions

  • jimi
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
8 years 1 month ago - 8 years 1 month ago #79311 by jimi
Pending subscriptions was created by jimi
Hii
If a user starts the subscription process and gets to the Secure Checkout stage (we are using the 2CO plugin) then backs out, MP creates a Pending invoice, which shows in the Membership Status module as a Subscription as shown below

If the user never takes it any further what happens to the Pending Subscriptions ?
How do we stop the Status module displaying Pending Subscriptions ?
Attachments:
Last edit: 8 years 1 month ago by jimi.

Please Log in or Create an account to join the conversation.

  • jimi
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
8 years 1 month ago #79504 by jimi
Replied by jimi on topic Pending subscriptions
:whistle: No comments/suggestions/answers ? :(

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #79549 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Pending subscriptions
Hi Jimi

At the moment, we don't have an option to hide these records. Something we can add to next release of Membership Pro

For now, maybe you can publish the plugin "System OS Membership Cleaner"

This plugin will run every 6 hours and will clean/remove these ignore payment subscription records

Regards,

Tuan

Please Log in or Create an account to join the conversation.

  • jimi
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
8 years 1 month ago #79556 by jimi
Replied by jimi on topic Pending subscriptions
Tuan
That looks like it will do the trick, never noticed that plugin before, we'll give it a try and report back.
One thing, is it possible to alter the time period it runs at ? 2CO sometimes takes a while to clear payments through security, I'm concerned that at 6hrs the plugin may remove a subscription before it's cleared. 12 hrs or possibly even 24hrs would be better.
Regards
Jimi

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #79601 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Pending subscriptions
Hi Jimi

Better I will ask an option into the extension to allow hiding these records. It will be part of the next release

Right now, the plugin will clean the record if payment has not been made for 5 hours. If you want to be safe, you can :

1. Open the file plugins/system/osmembershipcleaner/osmembershipcleaner.php

2. Find this line of code
Code:
->where("TIMESTAMPDIFF(HOUR, created_date, '$now') >= 5");

3. Change 5 to a higher number, in your case, change 5 to 24 and it should be OK

Tuan
The following user(s) said Thank You: Jonathan Colls, jimi

Please Log in or Create an account to join the conversation.

  • jimi
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
8 years 1 month ago - 8 years 1 month ago #79629 by jimi
Replied by jimi on topic Pending subscriptions
Thanks Tuan
Tried the plugin and it works fine, we'll run it at default for now and see how we get on, if necessary we can change the timing as per your post (had a look and found the line of code so easy to change if needed) one question when we run an upgrade (next release) will any custom changes to the code be overwritten ?
Last edit: 8 years 1 month ago by jimi.

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #79630 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Pending subscriptions
Yes, of course. Any custom code modification (except modify layout) will be over-write when you upgrade to future releases of the extension

Tuan

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #79638 by Francisco Souza
Replied by Francisco Souza on topic Pending subscriptions
Tuan,

It's a good idea have a option in configurations to set the "interval" of this plugin.
In my case, i should set to 2 days, because in brazil we have a payment model inter banks that take 2 days to process.

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #79690 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Pending subscriptions
OK. Will try to implement it in the next release of the extension

Regards,

Tuan

Please Log in or Create an account to join the conversation.