How to migrate existing Stripe customers to Memberstack when switching from WordPress to Webflow without losing paid plan data? Answered

Post author
John Goldman

hello, if this isn't the right place for support i'm sorry. I had an old membership package on WP. i changed the website to WF. And now we are using memberstack/stripe. All my old customers live in stripe. i've imported all the paid plans from stripe. they appear in my memberstack. i've had new customers sign up and use the very same plans using my new website. now i need to import the old members into MS. i was trying to do it manually first to see how the process worked. but when i go add member: the only option it gives me for plan is FREE PLAN. please help! here's a loom if that helps https://www.loom.com/share/cfcaeae9ce4d49e594b44eba3e08dae1?sid=a1f05d8e-8530-414f-a1ec-41ba061cff89

That article has a video that should help but I've watched that like ten times already lol!
 
I wanted to just try one customer at a time to see if I've done it right
 
here's a question, if I create the CSV with the stripe information and I don't have a MS ID number, will MS create one for me?
 
And again, just wondering why if i do manual add one member it doesn't allow me to assign any of our paid plans

Comments

14 comments

  • Comment author
    Tyler Bell

    Yes, to test the import process you'll want to import via the CSV.

    You can add paid plans to your members, but that's done through stripe.

    0
  • Comment author
    John Goldman

    gocha. ok so i'll test it with one member using the fields I see in the video and if I dont have a memberstack ID it will be generated for me

    do i need to create a MS ID column or no
    0
  • Comment author
    Tyler Bell

    Correct but yeah definitely do your testing with a CSV.

    You don't need that column.

    0
  • Comment author
    John Goldman

    Stripe ID and Stripe Sub ID plus name and email are the important ones

    in stripe the PLAN column is the stripe sub ID

    0
  • Comment author
    Tyler Bell

    right

    The sub id's begin with sub_

    0
  • Comment author
    John Goldman

    so that's bizarre. I did a export from stripe selected "all columns" and it didnt generate that ID number

    45 customers I will be importing in.

    0
  • Comment author
    Tyler Bell

    The Stripe customer export is a bit odd.
    It doesn't export subscription data.

    Okay, so here's what you need to do.

    • export the 45 customers from Stripe.
    • in stripe, go here and export the subscriptions. This is the file that will contain those sub_ ids

    You'll then need to add the sub id to your CSV based on the stripe customer id.

    Does that make sense?

    0
  • Comment author
    John Goldman

    oof, and i just noticed in the meta data that there is a field for "platform" which has the old software in it. will this create a problem

    what about my customers who paid for a lifetime / one time payment, they dont have subscriptions but are on a "plan"

    0
  • Comment author
    Tyler Bell

    Nope, that won't be an issue.

    We recommend creating a free plan inside Memberstack and then granting access to that plan for those members.

    Which can be done in the CSV import.

    0
  • Comment author
    John Goldman

    ok terrific thank you i see that now

    what fields would i import then?

    what if i accidentally import people for whom there is already a file in memberstack

    what about the password. how do i set it or get them to set their own?

    0
  • Comment author
    Tyler Bell
    • Create the free plan in memberstack. You can call it something like "Legacy Lifetime", etc.

    Then add a "Free Plan" column to your CSV.
    Copy the ID of the plan you created (it will start with pln_) and paste into the rows that should receive that plan.
    99% of the work here is getting your CSV right. Once you have the CSV, the rest is easy 🙂

    • nothing bad will happen, the members that already exist won't be affected
    • You have two options.

    Option 1 (recommened)

    Don't set a password for your members. The first time they try to login, they would need to go through the forgot password flow.

    Option 2

    Add a password column to your CSV where you can set a password for your members. You would then tell your members "Login with this password, and change your password afterwards"

    0
  • Comment author
    John Goldman

    ok i've had success with one member, thank you. but still need to tweak the CSV to get all the information. really appreciate this help, its been so awesome.

    1. any clever way to get a full name column into the first and last name fields?
    2. there's really no reason I need to import their phone numbers and address if i already have it i suppose. and they can adjust their name if they want i'm assuming?
    3. we had members who bought annual, then upgrade to lifetime. if they're imported on annual, will memberstack retrigger their payment even if i've already disabled it in stripe? or is all of that managed by stripe
    4. and finally, (I think!) some of our lifetimes paid by invoice which didn't create a stripe customer ID number, is that ok. i've created the free paid plan and i'm adding them to that
    5. my users are trying to reset their password as we discussed but no emails are being sent. where / how can I check up on that?
    0
  • Comment author
    Tyler Bell

    glad to hear! and you're welcome!

    1. unfortunately no
    2. yep!
    3. Payments won’t be retriggered.
    4. Yep that’s fine.
    5. You can setup a custom email with us to prevent emails from going to spam. If it's not landed in spam, send me the email address of the users who have tried and not received the reset email.
    0
  • Comment author
    John Goldman

    Thank you so much Tyler Bell - really above and beyond customer service.

    0

Please sign in to leave a comment.