WordPress.org

Ready to get started?Download WordPress

Forums

Paid Memberships Pro
PMPRO and usermeta (4 posts)

  1. dmokaren
    Member
    Posted 1 year ago #

    Am trying to work thru your scripts and associated dbs to work out a solution for importing existing or offline memberships into PMPRO. I've exported data from wp-usermeta to see some of the sandbox transactions I've done. In some of the earlier user data, I see unfilled fields for
    pmpro_bfirstname, pmpro_blastname, pmpro_baddress1, pmpro_baddress2. pmpro_bcity, pmpro_bstate, pmpro_bzipcode, pmpro_bcountry, pmpro_bphone
    pmpro_bemail, pmpro_CardType, pmpro_AccountNumber, pmpro_ExpirationMonth, and
    pmpro_Expir

    In the later transactions, these are not listed. (If one goes in and adds the userdata into the db fields, the info shows up in the Member Report) But what I'm asking is: where might I have screwed up for these fields to have 'disappeared' in the newer transactions. I have restored a fresh checkout.php

    http://wordpress.org/extend/plugins/paid-memberships-pro/

  2. strangerstudios
    Member
    Plugin Author

    Posted 1 year ago #

    Some tips here RE importing:
    http://www.paidmembershipspro.com/2012/06/how-to-mass-import-members-into-wordpresspmpro/

    Those fields would be empty for users who didn't pay for their membership... i.e. free membership levels or manually created members.

    Those fields aren't too critical. They are only used to prepopulate the checkout field when users checkout again. The real billing information is stored in the orders table.

    I'd be able to give you more support at http://www.paidmembershipspro.com

  3. dmokaren
    Member
    Posted 1 year ago #

    Still messing with import of member dat. Looking at memberlist-csv, I see this, which tells me that data is NOT stored in the orders table, but actually in usermeta, users AND orders table.....

    $theusers = $wpdb->get_results($sqlQuery);
    	$csvoutput = "id,username,firstname,lastname,email,billing firstname,billing lastname,address1,address2,city,state,zipcode,country,phone,membership,initial payment,fee,term,joined,expires";
    
    	//these are the meta_keys for the fields (arrays are object, property. so e.g. $theuser->ID)
    	$default_columns = array(
    		array("theuser", "ID"),
    		array("theuser", "user_login"),
    		array("metavalues", "first_name"),
    		array("metavalues", "last_name"),
    		array("theuser", "user_email"),
    		array("metavalues", "pmpro_bfirstname"),
    		array("metavalues", "pmpro_blastname"),
    		array("metavalues", "pmpro_baddress1"),
    		array("metavalues", "pmpro_baddress2"),
    		array("metavalues", "pmpro_bcity"),
    		array("metavalues", "pmpro_bzipcode"),
    		array("metavalues", "pmpro_bzipcode"),
    		array("metavalues", "pmpro_bcountry"),
    		array("metavalues", "pmpro_bphone"),
    		array("theuser", "membership"),
    		array("theuser", "initial_payment"),
    		array("theuser", "billing_amount"),
    		array("theuser", "cycle_period")
    		//joindate and enddate are handled specifically below
    	);

    [Please post code or markup snippets between backticks or use the code button. Your posted code may now have been permanently damaged by the forum's parser.]

  4. dmokaren
    Member
    Posted 1 year ago #

    er... sorry about posting the code without backticks....

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic