August 5, 2012 at 8:26 am #7079
I’m not sure I’ve found the answer to this question, but what’s the best way of mass importing (WishList) Member users into WP eMember?
I’ve seen that there is a “Import WP Users” checkbox that can allow WP users to be imported into WP eMember… however this does not sort them into the appropriate levels. I’m aiming to mass import users into their specific eMember levels all in one go, while keeping their existing WP information (details, passwords etc.).
For example, Import 500 Free Users, 300 Bronze Users, 200 Silver Users, and 50 Gold all imported into WP eMember *AND* sorted into the correct membership level. Effectively, I’m looking to migrate users away from the WishList plugin in favour of eMember (simply because it’s got better plugin support! ).
I realise that this may be possible using the CSV to DB plugin (which I’ve used before to import products… Thanks!). However, I’m not sure about what information is required to import the correct information for WP eMember Users.
Some Background Information
1. WishList Member *does* create a WP user profile for members created.
2. WishList Member allows the exporting of CSV files into Membership Levels. e.g. exporting Free members into a CSV, then a separate Bronze members into a CSV.
The header of the CSV file contains the following information:
- Is this enough information to allow me to import users into WP eMember?
- What fields in the database would be required to successfully import users into the wp_eMember_members_tbl table?
- Would the Users’ existing passwords be kept the same?
It’s really important that the migration is seamless – users should not have to change their passwords or update their details but instead just log in with the details they already have!
- Do you have a tutorial on this using the CSV-To-DB plugin?
Ideally, an Add-on plugin that could help migrate digruntled Admins to migrate users would be great. Something to consider maybe? When you have over 5,000 members in a site, features like importing/exporting *quickly* become really important!
Thanks in advance, again.
ZainAugust 5, 2012 at 8:54 am #48099
Is the importing of WP Users into WP eMember “silent”? i.e. does NOT notify users by email when they have been imported?
I’m only asking as I just used the WishList Member export/import feature with the “Do NOT email users” checked and it still sent out an email when I did a test import! ARGGGH! (Thankfully, it was only to 15 users… but still, that sucked!).
Ideally, I’m looking to set up a new membership area using WP eMember and for the transition to go unnoticed by users – they should just be able to log in with existing details but end up in the eMember system.
Thanks!August 5, 2012 at 6:42 pm #48100
After doing a bit of thinking and research, I’m not sure that using “WP CSV to Database” together with the “Import WP Users” feature will work with importing users.
The main issue is that WP CSV to Database seems to only *add* new data – it can’t check against existing data and update it. Importing 1000+ into a particular levels is going to be tricky… :$
Exporting users to a CSV file from the WishList export is problematic – the export doesn’t contain the passwords!
Probably what’s required is plugin which is a mixture of the existing “Import WP Users” and a CSV upload facility.
How it could work would be something like:
- Upload Users CSV file
- Select the Primary Membership Level for uploaded users
(wp_eMember_members_tbl db field: membership_level)
- Checkboxes for additional Membership Levels
(wp_eMember_members_tbl db field: more_membership_levels)
- Loop through CSV.
- Check against headings of: Username, Email.
- Insert/update user with membership level data
Ideally, if the import can work without notifying users that would be great. I can imagine messing up a few times trying to get this to work…
Something like this would definitely be useful – I’m pretty sure people who would like to migrate only stick with their existing systems simply because it’s too difficult to migrate. For example, I have a personal site that has well over 10,000 users – thankfully, I’m already using WP eMember for that one… but if I were ever to try and move it? Well, that would be quite a difficult task!
As a Developer, I also know that there are times when sites need to be migrated, so a good import/export functionality is always appreciated.
Is there any chance someone could help me with this? Updating 1000+ users membership levels based on their emails isn’t a task I’m looking forward to…
Thanks in advance!August 9, 2012 at 4:20 pm #48101
As Affiliates of Aweber, I guess you may already have seen the “MemberMouse” platform. What I found interesting is that they actually provide a way of migrating customers from WishList Member in the form of a plugin.
Not sure if you’ve seen their documentation, but I hope that it may help to provide the eMember team with some ideas about how to do the same.
Here’s the link to how to manually migrate WishList members using SQL for the Member Mouse platform:
I’m hoping at some point, an Add-on for eMember will be created that will do the same. Migrating users is essential – I know a lot of people would like to move, but simply can’t because they don’t know how/don’t have any easy way of doing so.
As a final thought, will eMember have an Add-on for helping users to migrate from MemberMouse in future? I sure hope you guys will!
PS: I’ll be going through those docs to see if I can find a way of migrating the 1000+ users from WishList to eMember… *sigh*August 9, 2012 at 11:38 pm #48102
When using the manual “Import WP Users” feature, eMember is NOT preserving any purchased levels. Instead, this feature “upgrades” a User’s membership level without remembering any previously purchased levels.
- User signs up for the Free level.
- User purchases Membership package 3.
- User purchases Membership package 1.
- Admin decides to upgrade all Users to Membership package 4
- User finds Membership Level 1 goes missing (as it’s been upgraded to Package 4).
Again, this is partly an issue with the importing feature logic. There’s no check against previously purchased membership levels in WP eStore, which should ideally be stored as “Secondary Levels”.
It’s similar to the eMember/eStore shortcode integration issue I raised in this thread: https://support.tipsandtricks-hq.com/forums/topic/emember-v812estore-v676-purchase-history-shortcode-errors
Need To Import Users Into Secondary Levels
Anyway, I’m still looking for a way of importing Users quickly into Secondary levels – there’s well over 1000 to add and if the “import” simply “upgrades a user” then this means that 1000+ Users will need to be *manually* added to secondary levels.
Any suggestions about the best way of doing this? Importing 1000+ users manually isn’t something I’m looking forward to!
Thanks in advance.
- You must be logged in to reply to this topic.