No Customer Record Being Created But Everything Else is Working

[lkinca]

I’ve found some people with similar issues that posted in the forum, but none of the solutions offered solved my issue. I’m stumped. Any help would be greatly appreciated.

-I am using PayPal to offer a subscription. $0.01 for first two weeks then $29.99/month.

-Customer payment completes successfully and user is added to proper eMember membership level but no customer record is created in eStore.

-IPN is turned on and according to my PayPal IPN history, IPN delivery status is ‘Sent’ and HTTP response is 200.

-I ran debug mode in eStore, but when I click the debug file links, they are all blank. I tried running debug mode in eMember, but there don’t seem to be any links to the log files.

-I am running in transaction mode, not sandbox mode and the PayPal account is funding the subscription with a credit if that is relevant. Payments for $0.01 are being received by me and debited from the sending account.

I’m stumped. Any ideas as to why the record is not being created in eStore? Or why debug files are blank? The user is actually being added to the Membership Level for the product, so something is connecting properly…just not getting a customer record.

Thanks in advance.

[lkinca]

I should add…

[lkinca]

Also in WP eStore stats, the number of sales increases every time I complete a transaction for the product.

[amin007]

First we need to get debug output going so we can see what is going wrong.

Please go through this checklist to address the debug file empty issue

https://support.tipsandtricks-hq.com/forums/topic/what-to-do-if-the-debug-file-is-empty

[lkinca]

Ok, I had write permission issue on debug files.

eStore Post Payment Debug log content:

[05/01/2011 7:21 PM] – SUCCESS :Performing item specific autoresponder signup if specified.

[05/01/2011 7:21 PM] – SUCCESS :Performing global autoresponder signup if specified.

[05/01/2011 7:21 PM] – SUCCESS :Checking if auto affiliate account creation feature is active.

Is this supposed to show something about adding a customer record? Maybe I am missing a setting?

Subscription Handle Debug Log Content modified for privacy:

[05/01/2011 7:12 PM] – SUCCESS :eMember ID is empty. Checking the database for existing record of this email address..

[05/01/2011 7:12 PM] – SUCCESS :Did not find record in the members table. A new member account will be created for: xxx

[05/01/2011 7:12 PM] – SUCCESS :Creating new member account

[05/01/2011 7:12 PM] – SUCCESS :Member signup URL : http://mysite.com/member-registration?member_id=326&code=5d531018df574653c578f94eff33870c

[05/01/2011 7:12 PM] – SUCCESS :Member signup/upgrade completion email successfully sent to: xxx

[05/01/2011 7:21 PM] – SUCCESS :eMember ID is empty. Checking the database for existing record of this email address..

[05/01/2011 7:21 PM] – SUCCESS :Did not find record in the members table. A new member account will be created for: xxx

[05/01/2011 7:21 PM] – SUCCESS :Creating new member account

[05/01/2011 7:21 PM] – SUCCESS :Member signup URL :http://mysite.com/member-registration?member_id=327&code=e7d7c1df79a68850840895920aba4ad9

[05/01/2011 7:21 PM] – SUCCESS :Member signup/upgrade completion email successfully sent to: xxx

IPN Handle Debug Log Content modified for privacy:

[05/01/2011 7:21 PM] – SUCCESS :Paypal Class Initiated by <ip>

[05/01/2011 7:21 PM] – SUCCESS :Post string : mc_gross=0.01&protection_eligibility=Partially+Eligible+-+INR+Only&address_status=unconfirmed&payer_id=VBD52B4JQYBTJ&address_street=<address>payment_date=12%3A21%3A22+May+01%2C+2011+PDT&payment_status=Completed&charset=windows-1252&address_zip=11231&first_name=<name>&mc_fee=0.01&address_country_code=US&address_name=<name>&notify_version=3.1&subscr_id=I-147T682YX6U2&custom=ip%3D24.5.173.19%26subsc_ref%3D4&payer_status=verified&business=<my email>&address_country=United+States&address_city=Brooklyn&verify_sign=Anx5yx2COnUHzXIYqIH0SF91fHIDA00ZXD1yyMKzAIpQbBwQIGE9G8j6&payer_email=<email>&txn_id=6YA50603YM560784A&payment_type=instant&last_name=<last name>&address_state=NY&receiver_email=<my email>&payment_fee=0.01&receiver_id=SYZHA4B33932A&txn_type=subscr_payment&item_name=<item name>&mc_currency=USD&item_number=1&residence_country=US&transaction_subject=&payment_gross=0.01&ipn_track_id=anu2jQToSW1O821jna9NlA&

[05/01/2011 7:21 PM] – SUCCESS :Paypal Class Initiated by <ip>

[05/01/2011 7:21 PM] – SUCCESS :Post string : amount1=0.01&amount3=29.99&address_status=unconfirmed&subscr_date=12%3A21%3A19+May+01%2C+2011+PDT&payer_id=VBD52B4JQYBTJ&address_street=<address>&mc_amount1=0.01&mc_amount3=29.99&charset=windows-1252&address_zip=11231&first_name=<name>&reattempt=1&address_country_code=US&address_name=<name>&notify_version=3.1&subscr_id=I-147T682YX6U2&custom=ip%3D24.5.173.19%26subsc_ref%3D4&payer_status=verified&business=<my email>&address_country=United+States&address_city=Brooklyn&verify_sign=ABoNyhNd-GmnO2QPlURrAXuxbVAuAa9h6n3Jp7HXC8uq2XpUo25epmhN&payer_email=<email>&last_name=<last name>&address_state=NY&receiver_email=<my email>&recurring=1&txn_type=subscr_signup&item_name=<item name>&mc_currency=USD&item_number=1&residence_country=US&period1=14+D&period3=1+M&ipn_track_id=anu2jQToSW1O821jna9NlA&

[05/01/2011 7:21 PM] – SUCCESS :Connection to http://www.paypal.com successfuly completed.

[05/01/2011 7:21 PM] – SUCCESS :IPN successfully verified.

[05/01/2011 7:21 PM] – SUCCESS :Creating product Information to send.

[05/01/2011 7:21 PM] – SUCCESS :Subscription signup IPN received… nothing to do here(handled by the subscription IPN handler). Check the “subscription_handle_debug.log” file more details.

[05/01/2011 7:21 PM] – SUCCESS :eMember integration is being used… creating member account… see the “subscription_handle_debug.log” file for details

[05/01/2011 7:21 PM] – SUCCESS :Connection to http://www.paypal.com successfuly completed.

[05/01/2011 7:21 PM] – SUCCESS :IPN successfully verified.

[05/01/2011 7:21 PM] – SUCCESS :Creating product Information to send.

[05/01/2011 7:21 PM] – SUCCESS :Transaction Type: Buy Now/Subscribe

[05/01/2011 7:21 PM] – SUCCESS :Item Number: 1

[05/01/2011 7:21 PM] – SUCCESS :Item Name: <item name>

[05/01/2011 7:21 PM] – SUCCESS :Item Quantity: 1

[05/01/2011 7:21 PM] – SUCCESS :Item Price: 0.01

[05/01/2011 7:21 PM] – SUCCESS :Item Shipping:

[05/01/2011 7:21 PM] – SUCCESS :Item Currency: USD

[05/01/2011 7:21 PM] – SUCCESS :Download Link :

Single User License – This product does not have any downloadable content

[05/01/2011 7:21 PM] – SUCCESS :Paypal class finished.

---

[05/01/2011 7:21 PM] – SUCCESS :Product Email successfully sent to <email>

[05/01/2011 7:21 PM] – SUCCESS :Notify Email successfully sent to <my email>.

[05/01/2011 7:21 PM] – SUCCESS :Updating Products, Customers, Coupons, Sales Database Tables with Sales Data.

[05/01/2011 7:21 PM] – SUCCESS :Products, Customers, Coupons, Sales Database Tables Updated.

[05/01/2011 7:21 PM] – SUCCESS :Updating Affiliate Database Table with Sales Data if Using the WP Affiliate Platform Plugin.

[05/01/2011 7:21 PM] – SUCCESS :No Referrer Found. This is not an affiliate sale

[05/01/2011 7:21 PM] – SUCCESS :Paypal class finished.

Here it says products and customers tables were updated, but they were not…at least they are not showing when I navigate to my manage customers list.

[amin007]

Thank you. The debug looks fine to me. Everything seems to have worked as expected. Now, the database tables are not getting updated so I have to assume that the tables might be out of sync. Did you recently do a plugin upgrade and forgot to do do the deactivate and reactivate?

Since you are testing it with a subscription payment did you have a look at this post about testing a subscription payment?

https://support.tipsandtricks-hq.com/forums/topic/testing-a-subscription-payment-in-estore

[lkinca]

I would not say that I forgot, but I did not do a deactivation/reactivation. How do I do that if the plugins are not showing in my plugin menu?

[amin007]

Instructions for upgrading the plugin properly is documented here:

http://www.tipsandtricks-hq.com/ecommerce/wordpress-estore-installation-and-usage-guide-31

When you go to the plugins menu you will be able to see all the active plugins on your site (you may have to search for it if you have a lot of plugins). There is a search plugin option in the WordPress’s plugins menu.

[lkinca]

Ok, I didn’t realize the addition of some new plugins pushed the wp estore plugin to page 2. I have located them and deactivated/reactivated the plugins…still not getting a customer record though.

Anything else that might be preventing the records from being created?

[lkinca]

Check that, the customer record did show up…it looks like it was the plugin reactivation that fixed it.

Thanks for your help troubleshooting this.

[lkinca]

There is one issue though…the emember user ID is not being added to the customer record after signup. I currently do not require users to be logged in to subscribe…is it a requirement that they are logged in in order for the emember ID to be properly added to the customer record?

In my test, as noted, log in was not required, but I did confirm the account. Both a customer record and eMember record adding the user to the proper membership level was created.

[amin007]

WP eMember user ID will only be added to the customer record if a member makes a payment while they are logged into the site (this is how the plugin can determine if this paying customer has a member account and what the member ID is).

[lkinca]

Got it…we will force log in before PayPal sign up then. Thank you.

[lkinca]

Got it…we will force log in before PayPal sign up then. Thank you.

[lkinca]

Ok, so I have wrestled with this a bit. We now force log in before users can access the subscribe buttons.

Users who sign up properly get their account activated and get access to the content they signed up for. However, the eMember user ID is not being added to the customer record. Any reason why that might be happening?

[Author]

Posts