bulk update member expiration date

  • Unknown's avatar
    attilathehunbruce · Member ·

    I migrated membership data from our old web site to the new one (in CSV file). Unfortunately, the membership expiration date field was incorrectly labeled so my membership information didn’t transfer properly.

    I’m using a WooCommerce Membership plugin. I’m dealing with ~350 members.

    I want to do a database update to transfer the expiration dates (from my CSV file read in as another table) using phpMyAdmin.

    *** Is this a bad idea (assuming proper backup in case something goes wrong)? ***

    Is there a better approach?

    If using the database approach, I’m having a hard time finding the correct field in the database to modify. The expiration field is not in table wp_users. That leaves table wp_usermeta. I’m not seeing any fields there that look like an expiration date.

    *** Where is the WooCommerce Membership expiration date stored in the database? ***

    Thanks.

  • kokkieh · Staff ·

    Hi there,

    You’ve posted in the support forums for the hosting provider, WordPress.com. We only provide help for free sites hosted on our servers in this forum, and you don’t own any sites that are hosted with us.

    For help with the WooCommerce Memberships plugin, please contact WooCommerce support directly at https://woocommerce.com/contact-us/

  • The topic ‘bulk update member expiration date’ is closed to new replies.