Membership questions about the dates

When we go to Membership->All Members we can only see one date called "level expires" which shows the date that the membership expires.

Question: How can we see the date when the subscription was created?

Suggestion: For monthly recurring subscriptions with no end date, the field "level expires" shows the date of the next renewal which is not really an expiration date. Please ask your developers to clarify this on the form as it is confusing.

Thanks!

  • Michael Bissett

    Hey @Hector Torres, hope you're doing well today! :slight_smile:

    Question: How can we see the date when the subscription was created?

    Aside from seeing when someone started a subscription in the "News" section, that's something that would be a feature to consider (and I've taken the liberty of moving this thread over to the Features and Feedback section, so that this can be voted on).

    Suggestion: For monthly recurring subscriptions with no end date, the field "level expires" shows the date of the next renewal which is not really an expiration date. Please ask your developers to clarify this on the form as it is confusing.

    Sure, that's something that could be suggested to them, I can see where that might be confusing.

    Kind Regards,
    Michael

  • Ash

    Hello @Hector Torres

    I hope you are well today.

    Please go to /plugins/membership/membershipincludes/classes/membershipadmin.php line no 2255 and replace:

    $columns = array(
    						        "username" => __('Username', 'membership'),
    						        "name" => __('Name', 'membership'),
    						        "email" => __('E-mail', 'membership'),
    						        "active" => __('Active', 'membership'),
    						        "sub" => __('Subscription', 'membership'),
    						        "level" => __('Membership Level', 'membership'),
    						        "expires" => __('Level Expires', 'membership'),
    						        "gateway" => __('Gateway', 'membership')
    						    );

    with

    $columns = array(
    						        "username" => __('Username', 'membership'),
    						        "name" => __('Name', 'membership'),
    						        "email" => __('E-mail', 'membership'),
    						        "active" => __('Active', 'membership'),
    						        "sub" => __('Subscription', 'membership'),
    						        "level" => __('Membership Level', 'membership'),
    							"start" => __('Level Starts', 'membership'),
    						        "expires" => __('Level Expires', 'membership'),
    						        "gateway" => __('Gateway', 'membership')
    						    );

    Then go to line 2463 and add these lines:

    <?php // LEVEL COLUMN // ?>
    										<td <?php echo $style; ?>>
    										<?php
    									        $usersubs = $user_object->get_relationships();
    									        if ($usersubs) {
    									            $exps = array();
    									            foreach ($usersubs as $sub) {
    									                $exps[] = date("Y-m-d H:i", mysql2date("U", $sub->startdate));
    									            }
    									            echo implode(", ", $exps);
    									        }
    										?>
    										</td>

    Then you should be able to see the start date in the table.

    Please note that, this changes will be lost in next update. So it's worth to note down this changes somewhere and apply again after your updates.

    These are stored in PREFIX_m_membership_relationships table in the database.

    Hope it helps :slight_smile: Please feel free to ask more question if you have.

    Cheers
    Ash

  • Hector Torres

    Hello Ashok,

    Thanks for the reply. We will try these changes.

    Please ask your developers to make this change in the next release. Knowing when the subscription starts is very important for many reasons. We use this Membership module on other sites as well and it will be a LOT of work for us to have to make these changes every time there is a new release.

    Also, if you can ask your developers to Create a REPORT that allows us to print or export ( to CSV or Excel file ) those fields shown on that screen so we can do marketing and follow up with the subscribers. Thanks!

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.