Renew with Authorize.net

[vantagesmedia]

Hello. I am having trouble with members renewing and using Authorize.net as a payment gateway. I have eMember and eStore set up.

The member can join perfectly fine. Pays through Auth.net, gets the registration email, signs up, and gets access. The membership then expires as it’s supposed to.

The member logs in and goes to the Renew page. They can add the same membership type or different membership types, and then checkout through Authorize.net again. Here are the results of my testing:

When signing up for a different membership and using a different email address from when he signed up, member gets a receipt from Auth.net, no emails from eMember, and the account is not upgraded. (I figure using a different email could be the problem here.)

When signing up for a different membership and using the same email address as when he signed up, member gets a receipt from Auth.net and emails from eMember saying the payment was successful and the account was upgraded. But the account is not upgraded nor renewed.

When signing up for the same membership and using the same email address as when he signed up, member gets email from Auth.net, no emails from eMember, and the account is not renewed.

I am using the latest versions of eMember and eStore, plus the latest version of WordPress. I have tried in Firefox and Chrome. Please let me know if you have any thoughts on this.

The website is http://www.profitplays.net/preview. The Auth.net account is in test mode, so please feel free to test with fake credit card numbers.

Thank you.

[vantagesmedia]

To add some more details, I just check my eStore stats. I see two purchases, 1 for the original membership and 1 for the upgrade membership (the second test described above which did generate eMember emails, but not an actual upgrade.) I do not see any purchases for the first and third tests described above which did not generate eMember emails, although I was returned successfully to the website.

[vantagesmedia]

Sorry to be a bother. I should also point out that I have multiple memberships enabled.

In checking the test member, they do have the membership from the “successful” second test added to their account, but they are still listed as expired and cannot access the content (which the new membership should allow.)

Also, with multiple memberships enabled, if the member purchases the same membership that expired, would that not renew them anyway?

[vantagesmedia]

Will try to make this the last post.

I tested without the multiple membership and same results. Purchasing the same membership or different membership did not renew or upgrade member.

BTW, I am using 6.4.2 of eMember and 5.4.4 of eStore.

[amin007]

Please deactivate and delete and existing version of the plugin then get fresh builds of these plugins from here:

https://support.tipsandtricks-hq.com/update-request

Update them following the respective upgrade documentation. Then enable debug in the eStore plugin and share the content of the “subscription_handle_debug” file after a test transaction. This post will explain more on the debug:

https://support.tipsandtricks-hq.com/forums/topic/how-and-when-to-enable-debug-and-what-does-it-do

[vantagesmedia]

Thank you for the help. I did the upgrades and have figured out the issue by looking at the eStore_post_payment_debug.log file.

Here are the 4 tests I did:

Member 1 expired. Renewed with same membership. Accidentally used wrong email address. Upgrade success!

Member 2 expired. Renewed with different membership. Used same email address as sign up. Upgrade fail!

Member 2 still expired. Renewed with same membership. Used same email address as sign up. Upgrade fail!

Member 2 still expired. Renewed with different membership. Used different email address as sign up. Upgrade success!

Looking at the log file below, it seems using an existing email address in the system block the payment as a duplicate purchase:

[06/30/2011 5:28 PM] – Advisory : Log file reset.

---

[06/30/2011 5:30 PM] – SUCCESS :Handling payment data from: authorize

[06/30/2011 5:30 PM] – SUCCESS :Retrieving order details… Key: 4e0cb296d369d Gateway: authorize

[06/30/2011 5:30 PM] – SUCCESS :Retrieved Item Details: 4|Consensus – Daily Pass|1|24.99||eMember_id=1&ip=66.56.29.25

[06/30/2011 5:30 PM] – SUCCESS :Order Received… verifying payment data.

[06/30/2011 5:30 PM] – SUCCESS :Performing post payment processing tasks.

[06/30/2011 5:30 PM] – SUCCESS :Item Number: 4

[06/30/2011 5:30 PM] – SUCCESS :Item Name: Consensus – Daily Pass

[06/30/2011 5:30 PM] – SUCCESS :Item Quantity: 1

[06/30/2011 5:30 PM] – SUCCESS :Item Total: 24.99

[06/30/2011 5:30 PM] – SUCCESS :Item Currency: USD

[06/30/2011 5:30 PM] – SUCCESS :Checking if membership inegration is being used.

[06/30/2011 5:30 PM] – SUCCESS :eMember integration is being used… creating member account… see the “subscription_handle_debug.log” file for details

[06/30/2011 5:30 PM] – SUCCESS :Download Link :

Consensus – Daily Pass – This product does not have any downloadable content

[06/30/2011 5:30 PM] – SUCCESS :Sending product email to : jared@vantagesmedia,com

[06/30/2011 5:30 PM] – SUCCESS :Product Email successfully sent to jared@vantagesmedia,com.

[06/30/2011 5:30 PM] – SUCCESS :Notify Email successfully sent to customer_support@profitplays.net.

[06/30/2011 5:30 PM] – SUCCESS :Performing item specific autoresponder signup if specified.

[06/30/2011 5:30 PM] – SUCCESS :Performing global autoresponder signup if specified.

[06/30/2011 5:30 PM] – SUCCESS :Recording transaction details…

[06/30/2011 5:30 PM] – SUCCESS :Updating Products and Customers Database Tables with Sales Data.

[06/30/2011 5:30 PM] – SUCCESS :Products, Customers, Sales and Coupons Database Tables Updated.

[06/30/2011 5:30 PM] – SUCCESS :===> Start of Affiliate Commission Calculation <===

[06/30/2011 5:30 PM] – SUCCESS :Checking if the WP Affiliate Platform Plugin is installed.

[06/30/2011 5:30 PM] – SUCCESS :WP Affiliate Platform Plugin is not installed.

[06/30/2011 5:30 PM] – SUCCESS :===> End Affiliate Commission Check <===

[06/30/2011 5:30 PM] – SUCCESS :Checking if the Author ID field has been used in any of the purchased product for revenue sharing purpose.

[06/30/2011 5:30 PM] – SUCCESS :Revenue sharing feature is not in use.

[06/30/2011 5:30 PM] – SUCCESS :WP Affiliate Platform Plugin is not installed.

[06/30/2011 5:30 PM] – SUCCESS :End of post payment processing tasks.

[06/30/2011 5:30 PM] – SUCCESS :gateway=authorize, custom=eMember_id=1&ip=66.56.29.25, txn_id=0, txn_type=auth_capture, transaction_subject=(TESTMODE) This transaction has been approved., first_name=Jared, last_name=van Aalten, payer_email=jared@vantagesmedia,com, num_cart_items=, subscr_id=4e0cb296d369d, address=1240 Robinwood Rd., Decatur, GA 30033, , phone=4049695042, coupon_used=, eMember_username=1, eMember_userid=1, mc_gross=24.99, 0=Array,

---

[06/30/2011 5:34 PM] – SUCCESS :Handling payment data from: authorize

[06/30/2011 5:34 PM] – SUCCESS :Retrieving order details… Key: 4e0cb387dd6e1 Gateway: authorize

[06/30/2011 5:34 PM] – SUCCESS :Retrieved Item Details: 3|Consensus – 1 Week|1|65||eMember_id=3&ip=66.56.29.25

[06/30/2011 5:34 PM] – SUCCESS :Order Received… verifying payment data.

[06/30/2011 5:34 PM] – SUCCESS :Performing post payment processing tasks.

[06/30/2011 5:34 PM] – FAILURE :The transaction ID and the email address already exists in the database. So the payment may have already been processed. This could be a server glitch.

[06/30/2011 5:34 PM] – SUCCESS :gateway=authorize, custom=eMember_id=3&ip=66.56.29.25, txn_id=0, txn_type=auth_capture, transaction_subject=(TESTMODE) This transaction has been approved., first_name=Jared, last_name=van Aalten, payer_email=test@vantagesmedia.com, num_cart_items=, subscr_id=4e0cb387dd6e1, address=1240 Robinwood Rd., Decatur, GA 30033, , phone=4049695042, coupon_used=, eMember_username=3, eMember_userid=3, mc_gross=65.00, 0=Array,

---

[06/30/2011 5:42 PM] – SUCCESS :Handling payment data from: authorize

[06/30/2011 5:42 PM] – SUCCESS :Retrieving order details… Key: 4e0cb54c785f2 Gateway: authorize

[06/30/2011 5:42 PM] – SUCCESS :Retrieved Item Details: 4|Consensus – Daily Pass|1|24.99||eMember_id=3&ip=66.56.29.25

[06/30/2011 5:42 PM] – SUCCESS :Order Received… verifying payment data.

[06/30/2011 5:42 PM] – SUCCESS :Performing post payment processing tasks.

[06/30/2011 5:42 PM] – FAILURE :The transaction ID and the email address already exists in the database. So the payment may have already been processed. This could be a server glitch.

[06/30/2011 5:42 PM] – SUCCESS :gateway=authorize, custom=eMember_id=3&ip=66.56.29.25, txn_id=0, txn_type=auth_capture, transaction_subject=(TESTMODE) This transaction has been approved., first_name=Jared, last_name=van Aalten, payer_email=test@vantagesmedia.com, num_cart_items=, subscr_id=4e0cb54c785f2, address=1240 Robinwood Rd., Decatur, GA 30033, , phone=4049695042, coupon_used=, eMember_username=3, eMember_userid=3, mc_gross=24.99, 0=Array,

---

[06/30/2011 5:44 PM] – SUCCESS :Handling payment data from: authorize

[06/30/2011 5:44 PM] – SUCCESS :Retrieving order details… Key: 4e0cb5e616c87 Gateway: authorize

[06/30/2011 5:44 PM] – SUCCESS :Retrieved Item Details: 3|Consensus – 1 Week|1|65||eMember_id=3&ip=66.56.29.25

[06/30/2011 5:44 PM] – SUCCESS :Order Received… verifying payment data.

[06/30/2011 5:44 PM] – SUCCESS :Performing post payment processing tasks.

[06/30/2011 5:44 PM] – SUCCESS :Item Number: 3

[06/30/2011 5:44 PM] – SUCCESS :Item Name: Consensus – 1 Week

[06/30/2011 5:44 PM] – SUCCESS :Item Quantity: 1

[06/30/2011 5:44 PM] – SUCCESS :Item Total: 65

[06/30/2011 5:44 PM] – SUCCESS :Item Currency: USD

[06/30/2011 5:44 PM] – SUCCESS :Checking if membership inegration is being used.

[06/30/2011 5:44 PM] – SUCCESS :eMember integration is being used… creating member account… see the “subscription_handle_debug.log” file for details

[06/30/2011 5:44 PM] – SUCCESS :Download Link :

Consensus – 1 Week – This product does not have any downloadable content

[06/30/2011 5:44 PM] – SUCCESS :Sending product email to : test1@vantagesmedia.com

[06/30/2011 5:44 PM] – SUCCESS :Product Email successfully sent to test1@vantagesmedia.com.

[06/30/2011 5:44 PM] – SUCCESS :Notify Email successfully sent to customer_support@profitplays.net.

[06/30/2011 5:44 PM] – SUCCESS :Performing item specific autoresponder signup if specified.

[06/30/2011 5:44 PM] – SUCCESS :Performing global autoresponder signup if specified.

[06/30/2011 5:44 PM] – SUCCESS :Recording transaction details…

[06/30/2011 5:44 PM] – SUCCESS :Updating Products and Customers Database Tables with Sales Data.

[06/30/2011 5:44 PM] – SUCCESS :Products, Customers, Sales and Coupons Database Tables Updated.

[06/30/2011 5:44 PM] – SUCCESS :===> Start of Affiliate Commission Calculation <===

[06/30/2011 5:44 PM] – SUCCESS :Checking if the WP Affiliate Platform Plugin is installed.

[06/30/2011 5:44 PM] – SUCCESS :WP Affiliate Platform Plugin is not installed.

[06/30/2011 5:44 PM] – SUCCESS :===> End Affiliate Commission Check <===

[06/30/2011 5:44 PM] – SUCCESS :Checking if the Author ID field has been used in any of the purchased product for revenue sharing purpose.

[06/30/2011 5:44 PM] – SUCCESS :Revenue sharing feature is not in use.

[06/30/2011 5:44 PM] – SUCCESS :WP Affiliate Platform Plugin is not installed.

[06/30/2011 5:44 PM] – SUCCESS :End of post payment processing tasks.

[06/30/2011 5:44 PM] – SUCCESS :gateway=authorize, custom=eMember_id=3&ip=66.56.29.25, txn_id=0, txn_type=auth_capture, transaction_subject=(TESTMODE) This transaction has been approved., first_name=Jared, last_name=van Aalten, payer_email=test1@vantagesmedia.com, num_cart_items=, subscr_id=4e0cb5e616c87, address=1240 Robinwood Rd., Decatur, GA 30033, , phone=4049695042, coupon_used=, eMember_username=3, eMember_userid=3, mc_gross=65.00, 0=Array,

---

And Here is the subscription log file:

[06/30/2011 5:28 PM] – Advisory : Log file reset.

---

[06/30/2011 5:30 PM] – SUCCESS :Upgrading member account

[06/30/2011 5:30 PM] – SUCCESS :Using secondary membership level feature… adding additional levels to the existing profile of member ID:1

[06/30/2011 5:30 PM] – SUCCESS :Quering the table :wp_wp_eMember_members_tbl, to retrieve member profile

[06/30/2011 5:30 PM] – SUCCESS :Retrieved member profile. Need to add membership level ID: 5, to this profile

[06/30/2011 5:30 PM] – SUCCESS :Current additional levles for this profile: 4

[06/30/2011 5:30 PM] – SUCCESS :New additional level set: 4,5

[06/30/2011 5:30 PM] – FAILURE :Updating additional levels column for member vantagesmedia1 with value: 4,5

[06/30/2011 5:30 PM] – SUCCESS :Upgrading the primary membership level to the recently paid level. New primary membership level ID for this member is: 5

[06/30/2011 5:30 PM] – SUCCESS :Member signup/upgrade completion email successfully sent to:jared@vantagesmedia,com

[06/30/2011 5:44 PM] – SUCCESS :Upgrading member account

[06/30/2011 5:44 PM] – SUCCESS :Using secondary membership level feature… adding additional levels to the existing profile of member ID:3

[06/30/2011 5:44 PM] – SUCCESS :Quering the table :wp_wp_eMember_members_tbl, to retrieve member profile

[06/30/2011 5:44 PM] – SUCCESS :Retrieved member profile. Need to add membership level ID: 4, to this profile

[06/30/2011 5:44 PM] – SUCCESS :Current additional levles for this profile:

[06/30/2011 5:44 PM] – SUCCESS :Current additional levels for this profile is empty. Adding level: 4

[06/30/2011 5:44 PM] – FAILURE :Updating additional levels column for member test_vantages with value: 4

[06/30/2011 5:44 PM] – SUCCESS :Upgrading the primary membership level to the recently paid level. New primary membership level ID for this member is: 4

[06/30/2011 5:44 PM] – SUCCESS :Member signup/upgrade completion email successfully sent to:test1@vantagesmedia.com

Please let me know if there is a way to resolve this issue within the program, or when an update will be available.

Thank you,

Jared

[amin007]

Everything is working fine when the payment actually goes through. We just need to identify why two different transaction has the same transaction ID when paid via Authorize.net.

I know that auth.net uses the same transaction ID when used in sandbox (testing) mode but the plugin has code to ignore the duplicate transaction ID check when used in sandbox mode. So my question to you are…

– Are you doing live auth.net transaction or test transaction?

– If you are doing test transactions then do you have the “Enable Sandbox” checkbox checked from the eStore’s settings menu?

– You have only one copy of eStore in the plugins directory right? You did delete the old eStore version completely right? Some people like to rename the directory of the older eStore version and keep it in the plugins directory which is the source of many issues.

[vantagesmedia]

Glad to move forward.

To answer your questions:

1) We are doing test Auth.net transactions.

2) We had not enabled eStore’s sandbox setting. I was hopeful, but when we do enable the setting, we get this error when checking out (instead of going to Auth.net’s page):

The following errors have occurred.

(13) The merchant login ID or password is invalid or the account is inactive.

3) We have only one copy of eStore. We deleted the old files and have not renamed the folders.

Thanks for the help!

[amin007]

There you go #2 is the issue. There are two issues here actually:

1. You were doing test transactions with your merchant ID from live account.

2. You did not configure eStore to run in test/sandbox mode.

To rectify the issue create a proper auth.net test account and use merchant details for that test account. You can’t run the store in test mode but use merchant details from your live account (these cannot be mixed). Auth.net will let you create free merchant test/sandbox account. Once you create one of those accounts, please use the details from that account in eStore settings and then test your transactions.

Let me know if that makes sense.

[vantagesmedia]

OK, that did it.

Thank you very much for your time.

[Author]

Posts