Skip to Content Skip to Menu

Is the subscription ID from authorize.net in cbsubs?

10 years 8 months ago #242101 by prestoproducts
After a subscription is made with authorize.net for a recurring subscription, does CB Subs store a copy of the subscriptionId with authorize.net?

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48478
  • Thanks: 8281
  • Karma: 1443
10 years 8 months ago #242126 by krileon
Yes, CBSubs stores it to "subscr_id" for the users basket. The below query can be used in CB Query Field to grab the subscr_id of the latest basket.

Code:
SELECT `subscr_id` FROM `#__cbsubs_payment_baskets` WHERE `user_id` = '[user_id]' ORDER BY `time_initiated` DESC LIMIT 1

I'm pretty sure CBSubs lets you substitute this into several locations within CBSubs though. Please be sure to check the CBSubs substitution information as it maybe available depending on what you're needing to do.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

10 years 7 months ago #242140 by prestoproducts
Replied by prestoproducts on topic Is the subscription ID from authorize.net in cbsubs?
THanks, I see the "subscr_id" column there, but all the values are NULL. I have the gateway setup for authorize.net's sandbox test server. I see the subscriptions successfully being created, but the column does not populate with the "subscr_id" in CB Subs. Any ideas why?

Please Log in or Create an account to join the conversation.

10 years 7 months ago #242155 by prestoproducts
Replied by prestoproducts on topic Is the subscription ID from authorize.net in cbsubs?
I had a look in the database of one of our live sites which is using Authorize.net and I see that the 'subscr_id' column is being populated with the subscriptionId from the Authorize.net account. So to finish my question, how can I have the 'subscr_id' column populated when using the sandbox developer account with Authorize.net for testing purposes?

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48478
  • Thanks: 8281
  • Karma: 1443
10 years 7 months ago #242178 by krileon
I've no idea why sandbox doesn't provide a subscriber ID. I'm guessing ARB doesn't work for sandbox to prevent Authorize.net from sending recurring IPNs for a sandbox account and wasting their server resources. I've reviewed the gateway and CBSubs doesn't store the subscription id sent by Authorize.net to anywhere except subscr_id. This assumes x_subscription_id is present in the POST (check the Notification within CBSubs > Notifications to see what data it sent).


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum