I need to import an entire membership database with a membership defined as "Special Guest". This is an unpaid lifetime membership, which is specified with the current date as the start date and December 31, 2037 as the expiration date. I have done a test import numerous times, carefully specifying which field goes where, and making sure that all required fields are filled in correctly, but all of the imports come in as "Expired". What might I be doing wrong?
A new wrinkle. I see Status as "Expired" when I use "Browse Users," and indeed in the Mysql database, in that field the imports show a "0" while the Active members show a 1. But when I looked at Payments, under Reports, the imports are listed as paid up and Active. Am I missing an intermediate step necessary to update the status properly?
Try a rebuild after the import. You can also do a mass add in the product area after the import. David
I had similar issue. I mistakenly made product duration 3 days, instead 365. So got almost 1000 members "expire". I updated product and ran sql query in amember_members to up date all to active UPDATE `db_name`.`amember_members` SET `status` = '1' they all did update to active but next day they showed up again as expired. Now I am running the query again and will rebuild DB.
This will not help because status field will be updated automatically by amember depends on subscriptions that user have. So you need to fix expiration date of these user's subscriptions. Contact me in helpdesk and provide aMember CP access also example of users who have this issue I will provide exact query that you can use.