Stripe payment integration problem

[MADIdeas]

I’m trying to use the Stripe subscriptions integration but there appears to be a problem when cancelling – deleting the user from Stripe sends the subscription ID in the request where the database appears to be holding the customer ID. Note following from logs:

Creation:
[08/30/2019 3:03 PM] – SUCCESS: Stripe Subscription IPN received. Processing request…
[08/30/2019 3:03 PM] – SUCCESS: Sandbox payment mode is enabled. Using test API key details.
[08/30/2019 3:03 PM] – SUCCESS: Stripe Subscription successful.
[08/30/2019 3:03 PM] – SUCCESS: swpm_handle_subsc_signup_stand_alone(). Custom value: subsc_ref=2&user_ip=81.149.225.32, Unique reference: cus_FibvPNraRinNHz
[08/30/2019 3:03 PM] – SUCCESS: Could not find any record using the given email address (rob@robspage.co.uk). Attempting to query database using the unique reference: cus_FibvPNraRinNHz
[08/30/2019 3:03 PM] – SUCCESS: Did not find a match for an existing member profile for the given reference. This must be a new payment from a new member.
[08/30/2019 3:03 PM] – SUCCESS: Creating new member account. Membership level ID: 2, Subscriber ID value: cus_FibvPNraRinNHz

Deletion:
[08/30/2019 3:10 PM] – SUCCESS: Stripe Subscription Webhook received. Processing request…
[08/30/2019 3:10 PM] – SUCCESS: Refund/Cancellation check – lets see if a member account needs to be deactivated.
[08/30/2019 3:10 PM] – SUCCESS: Subscriber ID is present. Retrieving member account from the database. Subscr_id: sub_FibvMzEAClWFc9
[08/30/2019 3:10 PM] – FAILURE: No associated active member record found for this notification.

So is this me, or is it a problem in the integration code?

[mbrsolution]

Hi, please check the following documentation to learn more.

https://simple-membership-plugin.com/how-can-i-cancel-a-stripe-subscription-as-a-merchant/

Let me know how you go.

Thank you

[MADIdeas]

The problem is that, in the documentation, the ID in the SMP database is the subscription, i.e. product ID, which is what Stripe sends for the cancel. However, per the logs above, you can see that when the subscription is set up, the ID being used is the Stripe customer ID:

[08/30/2019 3:03 PM] – SUCCESS: Creating new member account. Membership level ID: 2, Subscriber ID value: cus_FibvPNraRinNHz

rather than the subscription ID:

[08/30/2019 3:10 PM] – SUCCESS: Subscriber ID is present. Retrieving member account from the database. Subscr_id: sub_FibvMzEAClWFc9

and hence mismatch when it tries to delete.

[mbrsolution]

Hi, I have submitted a message to the developers to investigate further your issue.

Thank you

[admin]

Thank you. I have updated the code to fix this. It will go out with the next release. In the meantime, you can download a copy of it from the following URL and use it:
https://simple-membership-plugin.com/wp-content/uploads/simple-membership.zip

Let me know how you go after that.

[Author]

Posts