Linking your Braintree Subscriptions with your PMPro Member records is actually pretty easy with the “Import Members from CSV for Paid Memberships Pro” plugin.
To successfully link Paid Memberships Pro and your existing Braintree subscriptions, you’ll need to make sure you have all of the required information in the import .csv
file.
As a result, the import .csv
file will need to minimally include the following columns of data:
ID
/user_login
/user_email
membership_id
pmpro_braintree_customerid
membership_status
membership_gateway
membership_gateway_environment
membership_payment_subscription_id
membership_initial_payment
membership_billing_amount
membership_cycle_number
membership_cycle_period
You can obviously add a lot of other information too. Information such as billing information fields, etc.
You don’t need to include any of that information if the the member’s user record/membership is on the server. That is, unless you want to update the info again.
Keep in mind that if you import the start and/or end date for the user’s membership – I.e. the membership_startdate
and membership_enddate
columns – those date values have to use the MySQL datetime
format.
I know i keep reiterating this in multiple places, but it seems like something people forget.
Here it is again;
If the date formats in the Import Members from CSV (.csv
file) do not conform to the YYYY-MM-DD HH:MM:SS
format, the data in that row in the .csv
import file will not be imported.
If you can’t find the membership_payment_subscription_id
data on your local system, you can find it for all of your active Braintree Subscriptions in your Braintree dashboard.
When the export is complete, it’s available for download as a .csv
file from Braintree (covered in the How-To video below).
The How-To is both quick and silent: