Import/Export Members via CSV

Export Existing Members

This will give you a CSV template with all of the fields relevant to your members/membership plans

1. In the Admin Panel, navigate to WooCommerce > Memberships
2. At the top of the page click on the “Import/Export” tab.
3. If needed, you can select specific plans, statuses and date ranges.
4. Select “Include profile fields” if you have any. If unsure, select it anyway.
5. It is rarely required, but you can also select “Include additional meta data” if needed.

Import New/Update Existing Memberships

1. If you do not have a CSV template already, follow the steps under Export Existing Members. Alternatively download the sample attachment below.The sample attachment shows the main fields that need to be entered when adding new members.If you are replacing existing member details, user memberships can be match either by user membership ID, or by a combination of user ID, login name or email address and a membership plan ID or slug.
2. Make sure all of the column titles are unaltered
3. In the WordPress Admin Panel, navigate to WooCommerce > Memberships.
4. At the top of the page click on the “Import/Export” tab.
5. Select “Import from CSV”
6. Browse to find your CSV file.
7. If adding new memberships/users, select:
   • “Create new user memberships if a matching user membership is not found”; and
   • “Create a new user if no matching user is found”
   • If required, select “Send new account notification emails when creating new users during an import”
8. Click “Upload file and import”

Additional information can be found here: https://docs.woocommerce.com/document/woocommerce-memberships-import-and-export/