Search user by IP or paypal email

[qba82]

Hi,

we should be able to find user by his IP or paypal email in search.

I think this option is very useful, important and should be easy to implement.

[Jono]

Blesta has no knowledge of what email is stored in paypal, and payments could be made from multiple accounts.  That being said, if the paypal email is the same one that is recorded in Blesta the smart search or client search will support searching on it.  As for IP, users may login from multiple IPs.  If we were to try and implement IP search how would you envision it working?  Perhaps if the user had ever logged in from the given IP?

[Paul]

We do store the PayPal Payer email for the transaction now I believe, would a transaction search pull that up @Jono

[Jono]

17 hours ago, Paul said:

We do store the PayPal Payer email for the transaction now I believe, would a transaction search pull that up @Jono

Unfortunately this is stored in the transactions.reference_id field which is not currently included in the transactions search.

[Paul]

5 hours ago, Jono said:

Unfortunately this is stored in the transactions.reference_id field which is not currently included in the transactions search.

Do you see any reason we shouldn't search those fields in a transaction search? I know we added the reference_id after the search was originally written, but it's a field we should probably be searching.

[Jono]

Nope, CORE-3573

[qba82]

On 4/13/2020 at 7:24 PM, Jono said:

Blesta has no knowledge of what email is stored in paypal, and payments could be made from multiple accounts.  That being said, if the paypal email is the same one that is recorded in Blesta the smart search or client search will support searching on it.  As for IP, users may login from multiple IPs.  If we were to try and implement IP search how would you envision it working?  Perhaps if the user had ever logged in from the given IP?

It is not so easy to create multiply paypal accounts, that why we could make blacklist of abusive users paypal accs, so they can't create more accounts. Regarding to IP, yes You can use other IP, but abusers often doesn't change them. It would also help in finding customer, that was seen on website monitoring like analytics or matomo.

[Paul]

On 4/18/2020 at 2:53 AM, qba82 said:

It is not so easy to create multiply paypal accounts, that why we could make blacklist of abusive users paypal accs, so they can't create more accounts. Regarding to IP, yes You can use other IP, but abusers often doesn't change them. It would also help in finding customer, that was seen on website monitoring like analytics or matomo.

I'm not sure I understand what you're asking. CORE-3573 has been completed for 4.10, which allows for searching the reference_id column for transactions, which contains the PayPal payer's email address.

But it sounds like you want the ability to ban users based on PayPal account or IP address? That sounds like a different feature entirely. You can make an official request at https://requests.blesta.com 

[qba82]

On 4/21/2020 at 12:33 AM, Paul said:

I'm not sure I understand what you're asking. CORE-3573 has been completed for 4.10, which allows for searching the reference_id column for transactions, which contains the PayPal payer's email address.

But it sounds like you want the ability to ban users based on PayPal account or IP address? That sounds like a different feature entirely. You can make an official request at https://requests.blesta.com 

Poul, I'm talking about only searching, when 4.10 will be released?

[Paul]

9 hours ago, qba82 said:

Poul, I'm talking about only searching, when 4.10 will be released?

Beta should be soon, probably next couple weeks.