Tips and Tricks HQ Support Portal › Forums › WP eMember › Moving existing 'members' into eMember
- This topic has 15 replies, 4 voices, and was last updated 9 years, 8 months ago by admin.
-
AuthorPosts
-
June 22, 2011 at 9:04 am #3640TurboWebsMember
Hi,
I have a site where we’ve been selling memberships first via PayPal, and now via eStore, handling renewals fairly manually, and only using the built-in WordPress password protection to protect members-only pages.
We now want to start using eMember to automate a lot of this, and to have separate usernames and passwords for each member instead of one single password for everyone (and nothing to prevent former members from still using it).
I’ve set up a temporary username and password to use in the interim while migrating everyone (approx 300 members with various PayPal/eStore once-off/subscription payment types) over to eMember via eStore payment. And we’re switching from a hodge-podge of payment amounts and durations to just monthly subscriptions and annual buy now or subscriptions (undecided).
I’m thinking that as memberships in the ‘old’ system expire, we’ll get them into eMember by getting them to ‘renew’ via the new eStore buttons, and then they’ll start using their own personal usernames and passwords. I’m not sure what to do with people who are on PayPal subscriptions directly and via the eStore – how to cancel them and get them into eMember.
What’s the best way to go about it?
June 23, 2011 at 12:46 am #33623amin007ParticipantIf your user’s are already in WordPress (wp users) then simply use the eMember’s “Import WP Users” menu to import them into eMember.
June 24, 2011 at 2:29 am #33624TurboWebsMemberHi. They’re not WP users yet.
June 24, 2011 at 6:42 am #33625amin007ParticipantUpdate: You can also use the bulk member data importer addon:
http://www.tipsandtricks-hq.com/wordpress-membership/bulk-member-data-importer-addon-853
In that case, one option would be to use the PHPMyAdmin tool to import your members data into the eMember database. This article might be of some help:
June 24, 2011 at 7:33 am #33626TurboWebsMemberCan payment expiry dates be imported successfully?
June 25, 2011 at 12:02 am #33627amin007ParticipantNope, can’t import expiry dates because eMember does not work based on hard expiry dates for membership expiry. It calculates the expiry date based on the membership level and the join date.
June 25, 2011 at 11:53 pm #33628TurboWebsMemberThanks. If a customer is already on a monthly recurring payment via eStore and PayPal, is there any way to add them as eMember members and make PayPal notify eMember when they cancel their subscription?
And since we already have eStore products set up for membership plans (not yet hooked up with eMember), what would happen if I edited these existing products so that they are now hooked up with eMember levels?
June 26, 2011 at 4:33 am #33629amin007ParticipantEach member has a subscriber ID attached to them which is used to uniquely identify a PayPal subscription payment notification (this subscriber ID originally comes from PayPal). Once you get get the subscriber ID you can hook that particular subscription payment notification to a particular eMember user. WP eStoer does capture the subsciber ID for each subscription but to do this you will have to manually find out each subscriber ID and modify the member’s record to attach the subscriber ID (there is no way to automate this).
June 26, 2011 at 7:06 am #33630TurboWebsMemberHi Amin,
Once I’ve found out the PayPal subscriber ID, where do I enter it in eMember? And just to clarify, would that mean that if the member cancelled their PayPal subscription, eMember would then be notified?
June 27, 2011 at 12:26 am #33631amin007ParticipantIn the WP eMember’s member database. You will have to log into your PHPMyAdmin and go to to your WordPress database and find the following table:
wp_eMember_members_tbl
You will be able to see all your member’s record there and add the subscriber ID of each member to the “subscr_id” column of that table.
This tutorial might be of some help if you are not familiar with the PHPMyAdmin tool:
June 27, 2011 at 1:32 am #33632TurboWebsMemberIf I create a spreadsheet in order to do a CSV import into eMember, can the subscr_id column be included in the import?
June 27, 2011 at 1:54 am #33633TurboWebsMemberDon’t worry – I see it in the CSV file you created for importing members.
June 27, 2011 at 2:16 am #33634TurboWebsMemberNow that I’ve got the subscriber ID’s from phpMyAdmin, for all the purchases via eStore, and I’m filling out the members.csv you created so that I can import them in via the CSV import plugin, does that mean eMember will be notified by PayPal when one of these imported members cancels their subscription?
June 27, 2011 at 5:28 am #33635amin007ParticipantI am not sure if the CSV import plugin will work correctly in this situation but yes, if each member’s “subscriber ID” is filled in then when a subscription cancellation IPN is received by eStore it will be able to deactivate the account associated with that subscription.
February 3, 2015 at 10:05 pm #33636orjanmenMemberHi.
In the “add/edit member” site, I am trying to insert the PayPal Subscriber ID in the field called “Unique Reference/Subscriber ID”. When I come back after saving, the field is empty. Any known reason why it will not save properly? Every other field get saved perfectly fine.
-
AuthorPosts
- You must be logged in to reply to this topic.