I have a feeling there is no solution for the issue I have created for myself, but it's worth asking. aMember has been protecting our site for about a year now - actually it is live from a year next week. And that is the problem. When we started we were not entirely clear what our business model would be. So, when setting up free membership, we set them to last for a year. Later we decided that we would make it more or less indefinite, and not limited to a year and so edited it so that free membership expires in 2014. Now we have a situation where several hundred memberships will expire over the next few weeks. I can foresee a barrage of customer emails and a lot of time spent changing the expiry dates on individual accounts. Is there any way around this? Is there a quick way to change all free memberships, backdated, to expire at some far off date in the future? As I say, I suspect not, and am dreading the next few weeks.
Katherine, latest aMember Pro has function named "Mass Subscribe" - it would help. However, there is no such option in your version. You can try to use the following PHP code, create a seperate file in amember/ folder and try it. Backup database first! PHP: <? require 'config.inc.php'; $product_id = 9999; // replace to your product id!!! $date = '2005-01-01'; // new date - format is yyyy-mm-dd $q = $db->query("UPDATE {$db->config[prefix]}payments SET expire_date = '$date' WHERE completed=1 AND product_id=$product_id "); $r = mysql_affected_rows(); print "$r rows changed. check it via control panel"; ?>
Mass Subscribe Does the option "assign the same dates as original..." translate to keep the same START DATE but make a new END date based on the product duration Originally our product was 1 year and then we changed it to 2 years. Half of our customers are on the 2 year and the first half are on 1 year.
I just tried it and it still defaults everyone to a 1 YR term. Is there a way to keep the original JOIN date and extend the expiration date one year using Mass Subscribe?
Unfortunately, there is no such way. You can use fixed expiration date if applicable, or contact support to fix expiration dates after mass subscribe to anything you want.
The initial terms are for 2 years so I would need all the expiration dates to be exactly 2 years after start date.
Is there any way to set a specific date for a product experation? We have a pool membership that runs from April 1st to March 31st, but we have members who may pay dues from January to June that would still need to have an experation date of April 1st. Any thoughts outside of a manual table update?
You can enter fixed date into product "Duration" field. Format is yyyy-mm-dd (for example 2006-03-09)