ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Simple Commerce - Purchase Identification Number “pending”

September 26, 2012 10:49am

Subscribe [2]
  • #1 / Sep 26, 2012 10:49am

    madebycloud

    13 posts

    We’re trying to create a subscription based membership website using the Simple Commerce module.

    There’s an issue with how purchases are handled; The value of ‘Purchase Identification Number (TXN ID)’ is always “pending”. Members are not moved to the correct member group upon successful payment.

    I’ve spent a few hours trying to debug this. There’s nothing in the documentation about this and the notice displayed on the purchase page, “Recurring purchases must be set up through PayPal for full functionality”, doesn’t mean much to anyone here.

    Looking at the PayPal accounts for both the merchant and purchaser shows a successful transaction.

    This is currently holding us back from getting this project completed. Please advise urgently.


    Update: Might have located the issue. Testing now…

    Update 2: Tried update but now worse off. Purchases not even showing up despite being successful.

    Update 3: Tried everything I can think of. Re-installed module. Checked IPN settings. Transactions go through but nothing appears in the module.

    Update 4: Reset everything on the PayPal end. Still not resolved.


    Resolved: See this post

  • #2 / Sep 26, 2012 11:08am

    madebycloud

    13 posts

    Related?

    Trying to update a purchase displays the following PHP errors.

    ...

    Separate issue: Moved to another thread.

  • #3 / Sep 27, 2012 9:33am

    madebycloud

    13 posts

    Whilst awaiting support, I’ve proceeded to create a completely new installation to test Simple Commerce. This was setup whilst closely following the documentation; A completely fresh database installation, new templates, using no third-party add-ons, and completely fresh PayPal credentials.

    Purchases do not appear in the module!

    Transactions are successful.

    This is maddening.


    Update: By logging requests, I can see that the IPN URL is being called.

    Update 1: Confident module is the cause. Debugging shows 4 ‘VERIFIED’ calls to incoming_ipn.

    Update 2: Further debugging shows an issue with the conditional on line 466. Really poor use of “return FALSE” going on in this class.


    Resolved: See this post

  • #4 / Sep 27, 2012 10:50am

    madebycloud

    13 posts

    I can confirm that there is a bug in the software. I’ll report this via the bug tracker and post a link here shortly.

    Bug report and solution: https://support.ellislab.com/bugs/detail/18268

  • #5 / Sep 27, 2012 3:29pm

    Kevin Smith

    4784 posts

    Hi madebycloud,

    Thanks for updating the thread with your solution. If I’m looking at the solution in the bug report correctly, it looks like the only change was adding trim() around the first part of the conditional’s expression. I agree that should be there to account for potentially bad input from a user, but as long as you don’t have any whitespace before or after the address you entered for your paypal account in SafeCracker’s configuration, you shouldn’t have run into a problem there. Was there whitespace in the SafeCracker paypal account config?

    I’ll also follow-up on the bug report since I’m not sure the line number is correct.

    Thanks!

  • #6 / Sep 28, 2012 5:33am

    madebycloud

    13 posts

    The module must save the email without trimming it. I’ve not tweaked any config manually. Worth noting also that this issue occurred during several clean installations, whilst trying to debug the cause.

  • #7 / Sep 28, 2012 3:38pm

    Kevin Smith

    4784 posts

    Well it’s good to know why this was happening nonetheless! Thanks for posting back with your solution, too. That’ll help us improve Simple Commerce.

    Anything else I can help with?

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases