Moving existing 'members' into eMember

[TurboWebs]

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?

[amin007]

If your user’s are already in WordPress (wp users) then simply use the eMember’s “Import WP Users” menu to import them into eMember.

[TurboWebs]

Hi. They’re not WP users yet.

[amin007]

Update: 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:

http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

[TurboWebs]

Can payment expiry dates be imported successfully?

[amin007]

Nope, 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.

[TurboWebs]

Thanks. 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?

[amin007]

Each 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).

[TurboWebs]

Hi 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?

[amin007]

In 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:

http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

[TurboWebs]

If I create a spreadsheet in order to do a CSV import into eMember, can the subscr_id column be included in the import?

[TurboWebs]

Don’t worry – I see it in the CSV file you created for importing members.

[TurboWebs]

Now 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?

[amin007]

I 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.

[orjanmen]

Hi.

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.

[Author]

Posts