Import Members via CSV (Free & Paying)

This guide walks you through importing free and paid members into Memberstack 2.0 using a CSV file.

Sample Import File

Important: If migrating from another authentication or payment provider, read this entire article carefully before committing to Memberstack. Some members may not be importable—for example, paying members without a Stripe Customer ID.

Migrating from Memberstack 1.0? Your exported CSV will contain all required columns. Example 1.0 Export

1) Importing Free Members

Your CSV can have up to 10,000 rows and should include:

1. Email Address (required)
2. Password or Hashed Password (optional)
   • If blank, a password is generated automatically.
   • Memberstack 1.0 exports include the "Hashed Password" column.
3. Member ID (recommended)
4. Custom fields (e.g., name, phone, address)
5. Free Plan ID(s): Comma-separated list if assigning multiple. Use lowercase without spaces.
6. Login Redirect (optional)
7. JSON (optional)
8. Metadata (optional)

2) Importing Paid Members

Note: Importing paying members triggers the customer.subscription.updated event in Stripe. Consider disabling any Make or Zapier scenarios that use this event during the import.

In addition to the fields for free members, include:

1. Stripe Customer ID (required)
2. Stripe Subscription ID (required for recurring subscriptions)
   • If a subscription has multiple line items, Memberstack only recognizes the first.
3. Free Plan ID(s) for free plans and one-time payments
   • One-time payments should be imported as free plans. For example, a $499 one-time membership should be associated with a new free plan. Still include the Stripe Customer ID to import their payment methods.

3) Importing Members with Multiple Subscriptions

Currently, the import tool supports only one active subscription per member. To import members with multiple subscriptions:

1. Import the member with one of their subscriptions using the CSV.
2. Manually add additional subscriptions:
   • Go to the Memberstack dashboard.
   • Navigate to the member's profile.
   • Click the "Sync with Stripe" button.

This syncs any additional active subscriptions from Stripe to the member's profile in Memberstack.

4) Import Errors

After import, you will receive an email detailing the number of successfully imported members and any errors.

Payment/stripe.failed-subscription-update

Occurs when Memberstack and Stripe can't find the provided subscription, often due to importing a member with a canceled subscription. These members are imported with their Stripe customer and stored payment info but without a plan.

Signup Rules

If importing members with plans isn't working, ensure no signup rules are blocking the email addresses you are trying to import.

Test Mode Errors

If you encounter sandbox or test mode errors:

• Ensure you do not have multiple tabs open for your Memberstack app.
• Refresh the page to clear any cached modes.

If issues persist, please contact support.

5) Limitations

Free Trials: Migrating active free trials from Memberstack 1.0 isn't supported. Contact us for assistance.

6) FAQs

Can I change a member's paid plan during import?

No, but you can change their paid plan after import. Learn how to change a member's plan.

Can I update members using the import tool?

No, the import tool is for adding new members only.