Hi, Josh works for me and I wanted to provide an update as we now understand the cause of the issue. We offer a couple of sign up options, one via s2Members PayPal integration, but we also have some customers whom we invoice via our invoicing system. When we invoice we setup blocks of users via a CSV upload, but we set the wp_s2member_subscr_id to the invoice number - which seemed logical as it’s the equivalent to the PayPal transaction ID. The format of our invoice numbers is 123456.
We discovered that where the incorrect account was updated, the User ID matched the Invoice Number. So for example:
Day 1 - Mr Smith was invoiced and setup, his invoice number is 123456
Day 2 - Mr Jones pays via paypal, his User ID is 123456
Therefore, Mr Smith’s account us updated (EOT is added to), but Mr Jones’ account is not updated.
So we now understand the cause, just need to rectify this, for what is thousands of users.
My thoughts are using a mySQL query to move the invoice numbers to another field - but the question is which field?
I am wondering if the Custom Value field is an option?
I know I could add a new field of Invoice ID for example, but this will sit under the meta_key of s2member_custom_fields - so i’d have to append the invoice numbers some how - I have no idea how to do that in mySQL.
Other key point is that it must be a searchable field.
Any suggestions are appreciated!