Forum Replies Created
-
Posts
-
Hello,
OK I let it run twice and it worked as expected now for scenario 1. It only upgraded the test account I had as ‘active’ and not the others I tested that were ‘unsubscribed’ or ‘inactive’.
For scenario 2, it still doesn’t change status from ‘unsubscribed’ after the expiration date, from what I can tell that is how your plugin has it designed so I will follow up via E-mail about a customization.
Thank you!
Hello,
Possibly I didn’t wait long enough for the daily cron to fully run, I have turned on debug and set auto upgrade to 1 day to test so I’ll give it another day+ to run to see the outcome.
Regarding customization, I did remove the && $member->account_state != ‘unsubscribed’
from emember scheduled upgrade account state check, because I do not want unsubscribed to be auto upgraded, only the active status.
What I am trying to achieve is:
User signs up to site for trial membership level 1, which has is valid for X numbers of days. Lets say 7.
Then around day 7 one of two things should happen:
1. If user did not cancel subscription within the 7 days (which is made thru payment gateway ccbill) then are still ‘active’ status and get auto upgraded to membership level 2.
2. If user cancelled subscription within the 7 days, then they have been set to status ‘unsubscribed’ by ccbill and around day 7 they should be changed to ‘expired’ because the subscription length has run out.
So basically after 7 days, there would be no such thing as an ‘active’ user on level 1, they would be changed to one of the two above scenarios.
I wasn’t sure if having the membership level 1 “subscription duration” set as the same numbers of days as “auto upgrade” for that level was causing an issue or if one or the other should have an extra day.
I’ll wait for the cronjob to fully run and update with what happens.
OK I see.
actually I think there’s another way to do what I need, I will submit a customization request.
Hello,
I was trying to troubleshoot with ccbill to see if they could figure out anything but I’m still having the same issue. The only thing they noted is the screenshot for Webhooks in your ccbill setup instructions looks slightly different than the webhooks page in ccbill currently, they have “versions” now, not sure if that would affect anything, [https://kb.ccbill.com/Webhooks+User+Guide]
I ran a new test and here is the wp_pg_debug.log from the Payment Gateway Settings in it’s entirety. But to answer your question above about it looking incomplete, no, the “SUCCESS :event type: Cancellation” is the last line in the log.
[01/13/2019 4:33 AM] – SUCCESS : Log file reset
[01/13/2019 4:34 AM] – SUCCESS :==========Submitting data to CCBILL Subscription==========
[01/13/2019 4:34 AM] – SUCCESS : <form id=”gateway_form” method=”post” action=”https://bill.ccbill.com/jpost/signup.cgi”>
<input type=”hidden” name=”clientAccnum” value=”9XXXXX”>
<input type=”hidden” name=”clientSubacc” value=”0000″>
<input type=”hidden” name=”formName” value=”9XXXXX-0000cc-1″>
<input type=”hidden” name=”formPrice” value=”0″>
<input type=”hidden” name=”formPeriod” value=”1″>
<input type=”hidden” name=”formRecurringPrice” value=”29.99″>
<input type=”hidden” name=”formRecurringPeriod” value=”30″>
<input type=”hidden” name=”currencyCode” value=”840″>
<input type=”hidden” name=”formRebills” value=”99″>
<input type=”hidden” name=”formDigest” value=”945908cd23b6fcb7a1c699e9645b6e00″>
<input type=”hidden” name=”WpPgOrderId” value=”5c3abff17a585″>
<input type=”submit” value=”Click Here”>
</form>
[01/13/2019 4:34 AM] – SUCCESS :==========End of submission==========
[01/13/2019 4:36 AM] – SUCCESS :===Received data from CCbill===
[01/13/2019 4:36 AM] – SUCCESS :
Array
(
[customer_fname] => X
[customer_lname] => X
[email] => X
[username] => X
[password] =>
[productDesc] =>
[price] => $2.99 for 2 days ** $29.99 recurring every 30 days **
[subscription_id] => 0219012601000010135
[denialId] =>
[clientAccnum] => 9XXXXX
[clientSubacc] => 0000
[address1] =>
[city] =>
[state] => CA
[country] => US
[phone_number] => X
[zipcode] => X
[start_date] => 2019-01-12 21:36:16
[referer] =>
[ccbill_referer] =>
[affiliate] =>
[reservationId] =>
[referringUrl] => [https://bill.ccbill.com/]
[reasonForDecline] =>
[reasonForDeclineCode] =>
[formName] => 9XXXXX-0000cc-1
[cardType] => MASTERCARD
[responseDigest] => 1a82f11b762ac75b082bb6d0867c70a4
[WpPgOrderId] => 5c3abff17a585
[typeId] => 0
[initialPrice] => 0
[initialPeriod] => 1
[recurringPrice] => 29.99
[recurringPeriod] => 30
[rebills] => 99
[initialFormattedPrice] => $2.99
[recurringFormattedPrice] => $29.99
[ip_address] => 91.207.175.165
)
[01/13/2019 4:36 AM] – SUCCESS :===End of data from CCbill===
[01/13/2019 4:36 AM] – SUCCESS :initializing Payment Processing for CCbill Recurring Billing
[01/13/2019 4:36 AM] – SUCCESS :Processing post payment data received from CCbill
[01/13/2019 4:36 AM] – SUCCESS :payment status: not_processed
[01/13/2019 4:36 AM] – SUCCESS :CCbill Subscription – Successfully retrieved cart information for subscription ID: 0219012601000010135, orderID: 5c3abff17a585
[01/13/2019 4:36 AM] – SUCCESS :=== Cart Details ===
Cart ID: 5c3abff17a585
Currency: USD
Cart Shipping: 0
Cart Tax Rate: 0%
Cart Total Tax: 0
Cart Sub Total: 29.99
Cart Total: 29.99
Cart Return URL: [https://X.com]
Cart Custom Data: eMember_id=5&ip=91.207.175.165&subsc_ref=4
[/email]
Item ID: 1
Item Name: Trial then Monthly Subscription
Item Price: 29.99
Item Quantity: 1
Item Tax: 0
Item Shipping: 0
Item Weight:
Item URL:
Item Sub Total: 29.99
[01/13/2019 4:36 AM] – SUCCESS :=== End of Cart Details ===
[01/13/2019 4:36 AM] – SUCCESS :=== Matching responseDigest ===
[01/13/2019 4:36 AM] – SUCCESS :=== ResponseDigest genereated: 1a82f11b762ac75b082bb6d0867c70a4 ===
[01/13/2019 4:36 AM] – SUCCESS :=== ResponseDigest received: 1a82f11b762ac75b082bb6d0867c70a4 ===
[01/13/2019 4:36 AM] – SUCCESS :=== ResponseDigest Matched ===
[01/13/2019 4:36 AM] – SUCCESS :CCbill Subscription – Successfully retrieved customer reference for subscription ID: 0219012601000010135, OrderID: 5c3abff17a585
[01/13/2019 4:36 AM] – SUCCESS :Updating customer information
[01/13/2019 4:36 AM] – SUCCESS :=== Customer Details ===
Cart ID: 5c3abff17a585
Customer ID: 5c3abff17a5a5
First Name: X
Last Name: X
Email: X
Phone: X
Address:
City:
State: CA
Zip: X
Country: US
First Name:
Last Name:
Email:
Phone:
Address:
City:
State:
Zip:
Country:
Gateway: ccbill_subsc
Is eStore Checkout: 1
[01/13/2019 4:36 AM] – SUCCESS :=== End of customer Details ===
[01/13/2019 4:36 AM] – SUCCESS :marked payment status as processed
[01/13/2019 4:36 AM] – SUCCESS :preparing for storing subscription details
[01/13/2019 4:36 AM] – SUCCESS :CCBILL subscription start date: 2019-01-12
[01/13/2019 4:36 AM] – SUCCESS :saving subscription details to database
[01/13/2019 4:36 AM] – SUCCESS :Post payment processing task for gateway: ccbill_subsc Is eStore CO: 1
[01/13/2019 4:36 AM] – SUCCESS :Doing WP eStore specific post payment processing tasks…
[01/13/2019 4:36 AM] – SUCCESS :
Array
(
[gateway] => ccbill_subsc
[custom] => eMember_id=5&ip=91.207.175.165&subsc_ref=4
[txn_id] => 0219012601000010135
[txn_type] =>
[transaction_subject] =>
[first_name] => X
[last_name] => X
[payer_email] => X
[num_cart_items] => 1
[subscr_id] => 0219012601000010135
[address] => X, , , CA, 90046, US
[phone] => X
[coupon_used] =>
[eMember_username] => 5
[eMember_userid] => 5
[mc_gross] => 29.99
[mc_shipping] => 0
[mc_tax] =>
[address_street] =>
[address_city] =>
[address_state] => CA
[address_country] => US
[address_zip] => 90046
[background_post] => yes
)
[01/13/2019 4:36 AM] – SUCCESS :Converted cart items into eStore items array
[01/13/2019 4:36 AM] – SUCCESS :
Array
(
[0] => Array
(
[item_number] => 1
[item_name] => Trial then Monthly Subscription
[quantity] => 1
[mc_gross] => 29.99
[mc_shipping] => 0
[mc_currency] => USD
[subs_product] => 1
)
)
[01/13/2019 4:36 AM] – SUCCESS :calling normal payment processing function
[01/13/2019 4:36 AM] – SUCCESS :End of eStore post payment processing tasks! Redirecting the customer to the Return URL.
[01/13/2019 4:36 AM] – SUCCESS :===Received CCBILL event notification===
[01/13/2019 4:36 AM] – SUCCESS :
Array
(
[clientAccnum] => 9XXXXX
[clientSubacc] => 0000
[eventType] => NewSaleSuccess
[eventGroupType] => Subscription
[accountingCurrency] => USD
[accountingCurrencyCode] => 840
[accountingInitialPrice] => 2.99
[accountingRecurringPrice] => 29.99
[billedCurrency] => USD
[billedCurrencyCode] => 840
[billedInitialPrice] => 2.99
[billedRecurringPrice] => 29.99
[bin] => 523668
[cardType] => MASTERCARD
[country] => US
[dynamicPricingValidationDigest] => 1a82f11b762ac75b082bb6d0867c70a4
[email] => X
[expDate] => 1122
[firstName] => X
[formName] => 9XXXXX-0000cc-1
[initialPeriod] => 1
[ipAddress] => 91.207.175.165
[last4] => 5199
[lastName] => X
[nextRenewalDate] => 2019-01-13
[paymentAccount] => 7b9934b83d3f9256000000008f7e331
[paymentType] => CREDIT
[phoneNumber] => 3103337289
[postalCode] => 90046
[priceDescription] => 2.99(USD) for 2 days ** 29.99(USD) recurring every 30 days **
[rebills] => 99
[recurringPeriod] => 30
[referringUrl] => [https://bill.ccbill.com/]
[state] => CA
[subscriptionCurrency] => USD
[subscriptionCurrencyCode] => 840
[subscriptionId] => 0219012601000010135
[subscriptionInitialPrice] => 0
[subscriptionRecurringPrice] => 29.99
[subscriptionTypeId] => 0
[timestamp] => 2019-01-12 21:36:26
[transactionId] => 0219012601000010135
[username] => X
[X-WpPgOrderId] => 5c3abff17a585
)
[01/13/2019 4:38 AM] – SUCCESS :===Received CCBILL event notification===
[01/13/2019 4:38 AM] – SUCCESS :
Array
(
[clientAccnum] => 9XXXXX
[clientSubacc] => 0000
[eventType] => Cancellation
[eventGroupType] => Subscription
[reason] => Only interested in trial subscription
[source] => customerSupport
[subscriptionId] => 0219012601000010135
[timestamp] => 2019-01-12 21:38:47
)
[01/13/2019 4:38 AM] – SUCCESS :Starting to Process CCBILL Subscription event
[01/13/2019 4:38 AM] – SUCCESS :event type: Cancellation
[01/13/2019 4:39 AM] – SUCCESS :===Received CCBILL event notification===
[01/13/2019 4:39 AM] – SUCCESS :
Array
(
[clientAccnum] => 9XXXXX
[clientSubacc] => 0000
[eventType] => Cancellation
[eventGroupType] => Subscription
[reason] => Satisfied Customer
[source] => customerSupport
[subscriptionId] => 0119012601000054849
[timestamp] => 2019-01-12 21:11:30
)
[01/13/2019 4:39 AM] – SUCCESS :Starting to Process CCBILL Subscription event
[01/13/2019 4:39 AM] – SUCCESS :event type: Cancellation
[01/13/2019 4:40 AM] – SUCCESS :===Received CCBILL event notification===
[01/13/2019 4:40 AM] – SUCCESS :
Array
(
[clientAccnum] => 9XXXXX
[clientSubacc] => 0000
[eventType] => Cancellation
[eventGroupType] => Subscription
[reason] => Only interested in trial subscription
[source] => customerSupport
[subscriptionId] => 0219012601000010135
[timestamp] => 2019-01-12 21:38:47
)
[01/13/2019 4:40 AM] – SUCCESS :Starting to Process CCBILL Subscription event
[01/13/2019 4:40 AM] – SUCCESS :event type: Cancellation
[01/13/2019 4:44 AM] – SUCCESS :===Received CCBILL event notification===
[01/13/2019 4:44 AM] – SUCCESS :
Array
(
[clientAccnum] => 9XXXXX
[clientSubacc] => 0000
[eventType] => Cancellation
[eventGroupType] => Subscription
[reason] => Only interested in trial subscription
[source] => customerSupport
[subscriptionId] => 0219012601000010135
[timestamp] => 2019-01-12 21:38:47
)
[01/13/2019 4:44 AM] – SUCCESS :Starting to Process CCBILL Subscription event
[01/13/2019 4:44 AM] – SUCCESS :event type: Cancellation
[01/13/2019 4:49 AM] – SUCCESS :===Received CCBILL event notification===
[01/13/2019 4:49 AM] – SUCCESS :
Array
(
[clientAccnum] => 9XXXXX
[clientSubacc] => 0000
[eventType] => Cancellation
[eventGroupType] => Subscription
[reason] => Only interested in trial subscription
[source] => customerSupport
[subscriptionId] => 0219012601000010135
[timestamp] => 2019-01-12 21:38:47
)
[01/13/2019 4:49 AM] – SUCCESS :Starting to Process CCBILL Subscription event
[01/13/2019 4:49 AM] – SUCCESS :event type: Cancellation
[01/13/2019 4:51 AM] – SUCCESS :===Received CCBILL event notification===
[01/13/2019 4:51 AM] – SUCCESS :
Array
(
[clientAccnum] => 9XXXXX
[clientSubacc] => 0000
[eventType] => Cancellation
[eventGroupType] => Subscription
[reason] => Satisfied Customer
[source] => customerSupport
[subscriptionId] => 0119012601000054849
[timestamp] => 2019-01-12 21:11:30
)
[01/13/2019 4:51 AM] – SUCCESS :Starting to Process CCBILL Subscription event
[01/13/2019 4:51 AM] – SUCCESS :event type: Cancellation
[01/13/2019 4:57 AM] – SUCCESS :===Received CCBILL event notification===
[01/13/2019 4:57 AM] – SUCCESS :
Array
(
[clientAccnum] => 9XXXXX
[clientSubacc] => 0000
[eventType] => Cancellation
[eventGroupType] => Subscription
[reason] => Only interested in trial subscription
[source] => customerSupport
[subscriptionId] => 0219012601000010135
[timestamp] => 2019-01-12 21:38:47
)
[01/13/2019 4:57 AM] – SUCCESS :Starting to Process CCBILL Subscription event
[01/13/2019 4:57 AM] – SUCCESS :event type: Cancellation
[/email]
Hello,
Here’s what I believe are the pertinent logs. I redacted the specific account numbers and emails. Let me know if you need anything else.
The gateway one was quite long, but I see there’s the cancellation information in there at the end, but do not see any reference about the cancellation in the eMember or eStore logs.
So from what I can see, the site did receive the cancellation in the gateway plugin, but seems like it didn’t pass that info along to eStore/eMember?
This is the logs for the process of registering as a new free user at 6:36AM on logs, and then paying for a trial at 6:38AM.
And then at 6:41AM, cancelling as the user on [https://support.ccbill.com]
eStore_post_payment_debug.log
[01/09/2019 6:38 AM] – SUCCESS :Performing post payment processing tasks.
[01/09/2019 6:38 AM] – SUCCESS :Item Number: 2
[01/09/2019 6:38 AM] – SUCCESS :Item Name: Trial Membership
[01/09/2019 6:38 AM] – SUCCESS :Item Quantity: 1
[01/09/2019 6:38 AM] – SUCCESS :Item Total: 29.95
[01/09/2019 6:38 AM] – SUCCESS :Item Currency: USD
[01/09/2019 6:38 AM] – SUCCESS :Checking if membership inegration is being used.
[01/09/2019 6:38 AM] – SUCCESS :eMember integration is being used… creating member account… see the “subscription_handle_debug.log” file for details
[01/09/2019 6:38 AM] – SUCCESS :This item is a physical item. Item name: Trial Membership
[01/09/2019 6:38 AM] – SUCCESS :Download Link: [hidden]
[01/09/2019 6:38 AM] – SUCCESS :Checking if a key needs to be issued for product id: 2 Requested quantity: 1
[01/09/2019 6:38 AM] – SUCCESS :This product does not have any serial key available.
[01/09/2019 6:38 AM] – SUCCESS :Incremental counter value: 3
[01/09/2019 6:38 AM] – SUCCESS :Incremental counter value: 3
[01/09/2019 6:38 AM] – SUCCESS :Value of current cart item: 1
[01/09/2019 6:38 AM] – SUCCESS :eStore_apply_post_payment_dynamic_tags() – Constructing product details for a subscription
[01/09/2019 6:38 AM] – SUCCESS :Incremental counter value: 3
[01/09/2019 6:38 AM] – SUCCESS :Incremental counter value: 3
[01/09/2019 6:38 AM] – SUCCESS :Applying filter – eStore_notification_email_body_filter
[01/09/2019 6:38 AM] – SUCCESS :Sending product email to : newtesting@email
[01/09/2019 6:38 AM] – SUCCESS :Product Email successfully sent to newtesting@email
[01/09/2019 6:38 AM] – SUCCESS :Incremental counter value: 3
[01/09/2019 6:38 AM] – SUCCESS :Incremental counter value: 3
[01/09/2019 6:38 AM] – SUCCESS :Notify Email successfully sent to mike@email
[01/09/2019 6:38 AM] – SUCCESS :Creating transaction result display value
[01/09/2019 6:38 AM] – SUCCESS :Checking if additional action data needs to be displayed on the Thank You page.
[01/09/2019 6:38 AM] – SUCCESS :Transaction result display value set
[01/09/2019 6:38 AM] – SUCCESS :This is a background post so GA tracking will not be performed
[01/09/2019 6:38 AM] – SUCCESS :Performing item specific autoresponder signup if specified. Email: newtesting@EMAIL
[01/09/2019 6:38 AM] – SUCCESS :Performing global autoresponder signup if enabled. Email: newtesting@EMAIL
[01/09/2019 6:38 AM] – SUCCESS :Recording transaction details…
[01/09/2019 6:38 AM] – SUCCESS :Updating Products and Customers Database Tables with Sales Data.
[01/09/2019 6:38 AM] – SUCCESS :Product ID: 2.Current available copies value: Sales count value: 2
[01/09/2019 6:38 AM] – SUCCESS :New available copies value: New sales count value: 3
[01/09/2019 6:38 AM] – SUCCESS :Products, Customers, Sales and Coupons Database Tables Updated.
[01/09/2019 6:38 AM] – SUCCESS :End of post payment processing tasks.
eStore subscription_handle_debug.log:
[01/09/2019 6:38 AM] – SUCCESS :*** Using the new architecture. The membership profile creation and update will be handled directly via emember.
[01/09/2019 6:38 AM] – SUCCESS :*** Check the wp-eMember/ipn/ipn_handle_debug_eMember.log file for log data.
[01/09/2019 6:38 AM] – SUCCESS :*** eMember task complete.
eMember_debug.txt:
[01/09/2019 6:36 AM] – SUCCESS :Processing signup request of membership for: newtest@email
[01/09/2019 6:36 AM] – SUCCESS :reCAPTCHA is valid… creating membership account: newtest@email
[01/09/2019 6:36 AM] – SUCCESS :Processing signup request of membership for: newtesting@email
[01/09/2019 6:36 AM] – SUCCESS :reCAPTCHA is valid… creating membership account: newtesting@email
[01/09/2019 6:36 AM] – SUCCESS :Creating a new account for free membership or for the level specified in the shortcode. Member Email: newtesting@email
[01/09/2019 6:36 AM] – SUCCESS :Processing registration submission…
[01/09/2019 6:36 AM] – SUCCESS :Authenticating login request for username: newusertesting. Request came from IP Address: XX
[01/09/2019 6:36 AM] – SUCCESS :Authentication completed for username: newusertesting. IP Address: XX
[01/09/2019 6:36 AM] – SUCCESS :Redirecting member to the after login redirection page.
[01/09/2019 6:38 AM] – SUCCESS :emember_membership_changed action hook handler. Retrieving user record for member ID: 7
[01/09/2019 6:38 AM] – SUCCESS :emember_membership_changed action hook handler. Member account is active. Invoking level specific autoresponder signup functionality.
[01/09/2019 6:38 AM] – SUCCESS :emember_membership_changed action hook handler. Updating user role if applicable
ipn_handle_debug_eMember.txt:
[01/09/2019 6:38 AM] – SUCCESS :eMember_handle_subsc_signup_stand_alone(). Membership Level: 4
[01/09/2019 6:38 AM] – SUCCESS :Modifying the existing membership profile… Member ID: 7
[01/09/2019 6:38 AM] – SUCCESS :Not using secondary membership level feature… upgrading the current membership level of the member.
[01/09/2019 6:38 AM] – SUCCESS :Executing DB update. Debug data: active|4|2019-01-09
[01/09/2019 6:38 AM] – SUCCESS :Member signup/upgrade completion email successfully sent to: newtesting@email
Payment Gateway wp_pg_debug.log:
[01/09/2019 6:38 AM] – SUCCESS :Converted cart items into eStore items array
[01/09/2019 6:38 AM] – SUCCESS :
Array
(
[0] => Array
(
[item_number] => 2
[item_name] => Trial Membership
[quantity] => 1
[mc_gross] => 29.95
[mc_shipping] => 0
[mc_currency] => USD
[subs_product] => 1
)
)
[01/09/2019 6:38 AM] – SUCCESS :calling normal payment processing function
[01/09/2019 6:38 AM] – SUCCESS :End of eStore post payment processing tasks! Redirecting the customer to the Return URL.
[01/09/2019 6:38 AM] – SUCCESS :===Received CCBILL event notification===
[01/09/2019 6:38 AM] – SUCCESS :
Array
(
[clientAccnum] => 9XXXXX
[clientSubacc] => 0005
[eventType] => NewSaleSuccess
[eventGroupType] => Subscription
[accountingCurrency] => USD
[accountingCurrencyCode] => 840
[accountingInitialPrice] => 2.95
[accountingRecurringPrice] => 29.95
[address1] => XX
[billedCurrency] => USD
[billedCurrencyCode] => 840
[billedInitialPrice] => 2.95
[billedRecurringPrice] => 29.95
[bin] => XXX
[cardType] => VISA
[city] => XX
[country] => US
[dynamicPricingValidationDigest] => XXXacf0d15bc0a
[email] => newtesting@email
[expDate] => XXXX
[firstName] => XX
[formName] => 211cc
[initialPeriod] => 2
[ipAddress] => XX
[last4] => XX
[lastName] => XX
[nextRenewalDate] => 2019-01-10
[paymentAccount] => XX
[paymentType] => CREDIT
[postalCode] => XX
[priceDescription] => 2.95(USD) for 2 days ** 29.95(USD) recurring every 30 days **
[rebills] => 99
[recurringPeriod] => 30
[referringUrl] => [https://bill.ccbill.com/]
[state] => CA
[subscriptionCurrency] => USD
[subscriptionCurrencyCode] => 840
[subscriptionId] => X
[subscriptionInitialPrice] => 2.95
[subscriptionRecurringPrice] => 29.95
[subscriptionTypeId] => 0
[timestamp] => 2019-01-08 23:38:25
[transactionId] => X
[01/09/2019 6:41 AM] – SUCCESS :===Received CCBILL event notification===
[01/09/2019 6:41 AM] – SUCCESS :
Array
(
[clientAccnum] => 9XXXXX
[clientSubacc] => 0005
[eventType] => Cancellation
[eventGroupType] => Subscription
[reason] => Satisfied Customer
[source] => customerSupport
[subscriptionId] => XX
[timestamp] => 2019-01-08 23:40:25
)
[01/09/2019 6:41 AM] – SUCCESS :Starting to Process CCBILL Subscription event
[01/09/2019 6:41 AM] – SUCCESS :event type: Cancellation
[/email]
