Users CSV Format
Along with the User CSV upload user interface, you can also select if you want to send new members their usernames and passwords. If checked, then MemberPress will automatically send each new user their username and password.
Important Note: Importing a User CSV file will NOT and CANNOT associate the user with any memberships in MemberPress. To do that you’ll need to create either a single transactions CSV file for one-time subscriptions, or both a subscription and a transaction CSV file in that order.
Required Columns:
- username — This is the User’s user_login / username field. This is just a small text
- email — This is the User’s user_email. This must be a properly formatted email or the record could fail
Optional Columns:
- role — This is the WordPress user role. Can be ‘subscriber’, ‘contributor’, ‘author’, ‘editor’ or ‘administrator’. Defaults to ‘subscriber,’ even if you don’t specify otherwise with this column header.
- password — Allows you to set the users password. This password will be encrypted/hashed and stored in the database.
- first_name — First name of the user. Can be any small string of text. Defaults to blank.
- last_name — Last name of the user. Can be any small string of text. Defaults to blank.
- website — Website for the user. Can be any small string of text. Defaults to blank.
- address1 — Address Line 1 for user. Can be any small string of text. Defaults to blank.
- address2 — Address Line 2 for user. Can be any small string of text. Defaults to blank.
- city– City for user. Can be any small string of text. Defaults to blank.
- state — State for the user. Can be any small string of text. Defaults to blank.
- zip — Zip Code for the user. Can be any valid zip code string. Defaults to blank.
- country — Country for the user. Can be any small string of text. Defaults to blank.
- *usermeta* — Use the slugs for the Custom User Information Fields you created in the options here to import custom meta for your members.
- registered — The registration date of the user. Must be in format “YYYY-MM-DD hh:mm:ss”. Defaults to the current time during import.
If the username of the user already exists in the system then the user record will be updated with the information in the CSV file associated with the username.
