Thread

Hello All,

I’ve got the majority of the simple commerce module to work, it displays the products, directs the user to paypal, lets them log in and pay.

Problem is, EE2 doesn’t store the purchase after the transaction is completed. I receive the payment, but theres nothing in the control panel, it doesn’t send the email, and most importantly it doesn’t change the users member group.

I’ve added the IPN url to my account, and set my own URL in the website payments preferences.

But i’m not sure what else is wrong? or what other details you might need to help me fix this?

Thanks

Edit> I’m on ee 2.1.3 by the way.

Was that for a logged-in user? Are you using encrypted payments with PayPal?

Yes, user is logged in and currently part of the member group. After payment its supposed to move him to the customer group.

I’m not encrypting payments.

andjon01,

Are you in debug mode at the moment?

Was this a fresh install or an upgrade from a previous version or build?

Are you using any add-ons or using a htaccess?

What does you IPN look like? Does it match the action id if you go into your SQL manager and look for the ipn_notification value in the exp_actions table?

John,

I’m having the same problem. Simple Commerce was working perfectly before I upgraded from 1.6.8 to 2.1.3 Build: 20101220

I’m not in debug mode.

I’m using htaccess to divert visitors to my EE index.php file renamed ‘global’.

I have installed many addons. Do you want me to list them?
It may be relevant that I plan to install Membrr and so have installed OpenGateway but not yet configured it or installed the Membrr module.

My IPN is: http://www.healthyskepticism.org/global?ACT=6
That matches this row in my exp_actions table:
6   Simple_commerce   incoming_ipn

Updating to EE 2.1.3 was the only thing you did on the server? Are you using encrypted payments? Have the purchases all been made by a logged-in PayPal-verified buyer?

Ingrid,

I’ve not made any changes to my server except updating EE and installing addins for EE2. One change that may be relevant is that I have replaced the Exchange Rates module from PutYourLightsOn (which is not being developed for EE2) with the Currency Field from Biber.

I’m not using encrypted links.

The payments, including a test payment by me, have been made by people who logged into my EE2 site then clicked the Simple Commerce link to PayPal. The payments have been recorded by PayPal ok but have not been recorded in exp_simple_commerce_purchases and the people’s memberships have not been changed.

Are these people PayPal verified?

Sue,

Since upgrading from EE 1.6.8 to 2.1.3 I’ve received 5 payments of which 2 were from people who are PayPal verified. All payments were via Simple Commerce but none were recorded by Simple Commerce.

prmansfield,

Can you confirm that you have completed the following or that the notification URL still exists in Paypal?

To enable Instant Payment Notification, login to PayPal, and select “Payment Notifications” from the Profile submenu. Provide PayPal with the ExpressionEngine notification URL by typing or pasting the URL shown in your Simple Commerce control panel.

John,

Sorry about the slow response. My day job is being a medical doctor and I’m on Australian central time.

You have pointed me to the cause of the problem. The notification URL still existed in Paypal but the URL had the wrong ACT number. It was 26 but the ACT number in exp_actions for Simple_commerce : incoming_ipn is now 6. I’ve corrected the URL in Paypal to http://www.healthyskepticism.org/global?ACT=6, made a test payment and am delighted to report that Simple Commerce now works properly.

I think I know why the ACT number changed when I upgraded from EE 1.6.8 to EE 2.1.3. The upgrade wizard did not work for me. It did not like that for some reason I had double entries with the same member_id in exp_member_data. I did delete the double entries and try again but the upgrade wizard still did not work for me. Consequently I did the upgrade by installing EE 2.1.3 fresh then copying tables I thought I needed to keep from the old to the new MySQL databases carefully adding new fields where needed. I did not copy the exp_actions table across so it has different numbers for all the actions in EE 2.1.3 than in EE 1.6.8. This has not caused any problems except with Simple Commerce.

Thanks to all who have helped me solve my problem!

regards,

Peter (prmansfield)

Hi prmansfield,

Excellent and thanks for the follow up.

@andjon1, where are you with this?

Cheers

Greg

Closing up due to lack of activity.