In this guide, we walk you through the process of importing your Paid Memberships Pro members into your Mailchimp audience. Whether you’re setting up email campaigns, syncing membership data, or organizing your contacts by membership level, this guide will walk you through two supported methods to export and import your member data.

Starting with version 2.0, the Mailchimp Add On automatically syncs two new merge fields, PMPLEVEL (level name) and PMPLEVELID (level ID)  for new or updated members. However, existing members won’t have this data in Mailchimp unless you import them manually, which is what this guide helps you do.

Featured image for Import Your PMPro Members into Mailchimp

Export Your PMPro Members List

To import your members into Mailchimp, you first need to export your member data from Paid Memberships Pro. Depending on how much control you want over the data formatting, there are two ways to do this.

Both methods will give you a .csv file that you can later upload to Mailchimp. The key difference is:

  • Method 1 gives you a general export that requires some formatting.
  • Method 2 provides a ready-to-import file for Mailchimp, however is separated by level.

Choose the method that works best for your setup.

Method 1: Standard Export

  1. In your WordPress dashboard, go to Memberships > Members List.
  2. Use filters (optional) to export only members from a specific level.
  3. Click the “Export to CSV” button to download your list.
Screenshot of the members list with an option to export to CSV

Prepare the CSV for Mailchimp

  • Open the file in your preferred spreadsheet tool.
  • Rename the membership_level columns to PMPLEVEL
  • Add a new column right after PMPLEVEL called PMPLEVELID
    • In this column you add the corresponding Level ID for the PMPLEVEL
  • Ensure email stays as is.
  • Save the cleaned file as a .csv.
Screenshot of the PMPro members list CSV file

Method 2: Built-in Mailchimp Export

This method provides a simpler workflow if you’re using the Mailchimp Add On v2.0 or later. It automatically formats your export to work with Mailchimp — no renaming or cleaning required.

  1. Go to Settings > PMPro Mailchimp in your WordPress dashboard.
  2. Click the “Export your members list for Mailchimp import” link
  3. Choose the list or membership level you want to export
  4. Download the .csv file.

The exported file will already include the correct column names:

  • PMPLEVEL
  • PMPLEVELID

No further changes are needed. You can upload this directly into Mailchimp.

Import Your CSV File into Mailchimp

Once you’ve exported and prepared your list (using either method):

  1. Log in to Mailchimp.
  2. Go to Audience > All Contacts.
Screenshot of Audience screen in Mailchimp
  1. Click “Add Contacts” > “Import Contacts”.
  2. Choose “CSV or tab-delimited text file” and upload your file.
  3. Match the fields:
  • email –  Email Address
  • PMPLEVEL
  • PMPLEVELID
  • firstname and lastname (if available)
  • Note: you can also import custom user fields into MailChimp via this mapping step.
Screenshot of Import Contacts screen in Mailchimp
  1. Check “Auto-update my existing list” so the data updates rather than duplicates.
  2. Choose “Subscribed” as the status (if applicable).
  3. Finish the import.
Cover image from ebook 29 Nuggets of Wisdom Volume 1 - Sample Collection

Download the book: Get 29 insights and ‘aha moments’ for new or veteran membership site business owners. Use these nuggets of wisdom to inspire or challenge you.



Was this article helpful?
YesNo