Page 1 of 1

paypal email to username

PostPosted: July 5th, 2011, 4:59 pm
by openmtbmap
I'm really wary of trying to identify users to their paypal payment.

I'ld really need more info regarding the transaction in the user list. Or at least in the email.

Currently I often cannot associate a payment to a user (I have found no single way to find out the user, that belongs to a certain paypal ID).
Best would be to have a (to the user) hidden filed where I can see the email the user used for paying at paypal. And also put that stuff into the new user registration email.

Currently the email looks like:
Code: Select all
New user registration on your site - SITE TITLE :

Username: xxxxxxxxx

E-mail:xxxxxxxxxxx


--- I'ld like to have subscription ID in that mail, plus email used to pay at paypal. Many users use different names to register and different emails. And I have found no way to search my user database for this (all export files drop the s2member specific stuff)

Re: paypal email to username

PostPosted: July 5th, 2011, 9:33 pm
by Cristián Lávaque
You could enable logging and then review the logs.

WP Admin -> s2Member -> PayPal Options -> PayPal Account Details -> Enable Logging Routines
/wp-content/plugins/s2member-logs/

Also, the user's WordPress profile has a Paid Subscr. ID field s2Member adds, which you can use to identify him. From the documentation for that field

The value of Paid® Subscr. ID, can be a PayPal® Standard `Subscription ID`, or a PayPal® Pro `Recurring Profile ID`, or a PayPal® `Transaction ID`; depending on the type of sale. Your PayPal® account will supply this information.


I hope that helps.

Re: paypal email to username

PostPosted: July 6th, 2011, 2:20 am
by openmtbmap
Okay, will have a look at logging, but the users profile Paid Subscr. ID field is useless, if you have to click through all profiles to find it.

Tell me a way to find with one click an account that belongs to Subsr. ID XXXX-XXXX and then I'm set. As long as it's just there, it doesn't help me at all (even more as s2member still deletes that information when demoting members, so it does not help me at all when it's most important - when a member out of error got demoted, then I just end up with a big mess).

Re: paypal email to username

PostPosted: July 6th, 2011, 5:36 am
by openmtbmap
Well I had/have the logs active. But I don't really understand what's in them. It's like 2-4 2.1MB textfiles for each day. They don't really serve that purpose.

All I would need is an easy way to find out the username for an Subscription ID and the other way round once someone got demoted (hint hint hint STOP that **** deletion of information once a user is demoted).

(My problem. Paypal Pro ain't available in my country, Paypal Express checkout I don't understand how to setup, so I have one button where users buy an account for different amount. As one button cannot change two fields, I'm stuck to upgrade the duration for all users that pay more than the minimum amount, however I have no **** usable way to find the User that belongs to a payment, this is really Essential for me..., else within 11 month I'll get loads of users wrongfully demoted and lots of handwork to find out how much they paid (worse as once demoted I loose all their information))

Re: paypal email to username

PostPosted: July 6th, 2011, 12:34 pm
by Cristián Lávaque
I understand. Sorry for not understanding completely earlier.

There isn't an interface to search that yet, but if you have s2Member Pro, you can export the users to a CSV file, open it in Excel or OO Calc, and search the Paid Subscr. ID column. WP Admin -> s2Member -> Import / Export

Or you can create a custom script to search and find the User ID from the Paid Subscr. ID.

Re: paypal email to username

PostPosted: July 6th, 2011, 12:39 pm
by Cristián Lávaque
By the way, Jason here gives an example of how one value in the button's HTML form could be changed dynamically based on another value chosen viewtopic.php?f=36&t=309#p1342

Re: paypal email to username

PostPosted: July 6th, 2011, 4:24 pm
by openmtbmap
Okay I'll have a look at the form. Regarding the export function. Why is there a 250 users limit? In one year time if I have not 2000 users or more, I am probably broke. I'd need about 8k active users to live from that site and do hope to reach that point in a few years. So a few thousands would be nice. If there might be memory problems, then make it configurable somewhere.

Re: paypal email to username

PostPosted: July 7th, 2011, 2:54 am
by Cristián Lávaque
I'll show this suggestion to Jason, thanks.

In the meantime you can use the offset field to export several files to get all the thousands of users.