Jump to content


Corporate Sponsors


Latest News: (loading..)

* * * * * 2 votes

CCBill Gateway Module


23 replies to this topic

#1 sunshynevideo

  • Community Member
  • 60 posts
  • Real Name:David c

Posted 27 November 2007, 23:32

Has anyone managed to get CCBill to work as a payment processor?

If so would you mind sharing the secret or module?


CCBill told me it could be done and they sent me an email with some help...

Dear Client,
 
Per our telephone conversation, I have provided some helpful information below:
 
"POSTBACK"
Our Postback system is designed to pass back variables to a specified location on your server. For downloads, our postback system can pass back a unique code, or variable to distinguish between what download was purchased and thus giving them access accordingly. This system is recommended when dealing with a high volume of downloadable content, and will save you a lot of time.
 
Below you will find an "example" postback script, that will hopefully explain a bit more about how it implements between your server, and our systems. Please note: This script is only an example, and we cannot be responsible for functionality if you so choose to use this exact script.
 

#!/usr/bin/perl

use CGI ":standard";
print "Content-type: text/html\n\n";

###########  Instructions ##################
#
# This is a sample approval post cgi
# to show how you can capture data 
# sent from the approval post url
#
# Make sure to chmod this file to 755
# Place an empty file ("test.txt") in 
# the same directory as this file.  
# Chmod the empty file to 666.  Have 
# the approval post url point directly
# to this script.
#
############################################

$customer_fname = param("customer_fname");
$customer_lname = param("customer_lname");
$email = param("email");
$username = param("username");
$password = param("password");
$productDesc = param("productDesc");
$price = param("price");
$subscription_id = param("subscription_id");
$clientAccnum = param("clientAccnum");
$clientSubacc = param("clientSubacc");


open(test, ">>test.txt");
print test "$customer_fname\n$customer_lname\n$email\n$username\n$password\n$productDesc\n$price\n$subscription_id\n$clientAccnum\n$clientSubacc\n\n\n";

print "$customer_fname\n$customer_lname\n$email\n$username\n$password\n$productDesc\n$price\n$subscription_id\n$clientAccnum\n$clientSubacc\n\n\n";


http://ccbillhelp.ccbill.com/content/bckgn...t_guide_prm.htm

"DATALINK"
The CCBill DataLink System allows CCBill clients to access raw transaction data from CCBill's database such as: Rebills, Expired Subscriptions, Voided subscriptions, Chargebacks, Refunds, and New subscriptions by running a query string.
You can utilize the Datalink system to update your database or server with current customer cancellations, expirations, etc. by creating a custom script to run once per hour (as that is the time limit allotted for our clients). You are also only allowed to run a data query for a 24 hour period (may be expanded upon approval / request). Unfortunately we do not have example scripts regarding how to implement this system with your servers, however you may manually run this data with the example strings given in the documentation. I have attached a datalink document to this email.
In order to utilize the DataLink system, you will need to contact the Client Support department to set up your account to accept DataLink connections, or set them up manually via Premium Features -> Value Added Features -> Data Link Services Suite. To configure an account to accept DataLink requests Client Support will need the following information:

* Client Account Number
* Client Sub-Account Number (if desired to be restricted to a single Sub-Account)
* Username
* Password
* IP Addresses/Range

Edited by sunshynevideo, 27 November 2007, 23:44.


#2 sunshynevideo

  • Community Member
  • 60 posts
  • Real Name:David c

Posted 28 November 2007, 03:30

I might add that if there is one for sale I would be interested in seeing this.

#3 JamesA99

  • Community Member
  • 3 posts
  • Real Name:James Alston

Posted 09 May 2008, 08:23

Sorry to resurrect an old thread, but has anyone successfully integrated CCBill yet as a payment processor into OSCommerce?

Or else what are people's thoughts of how hard it would be to do? I'm new to OSCommerce, but a PHP programmer by trade.

Thanks very much!

#4 power182

  • Community Member
  • 15 posts
  • Real Name:Jake Powers

Posted 07 August 2008, 17:19

View PostJamesA99, on May 9 2008, 01:23 AM, said:

Sorry to resurrect an old thread, but has anyone successfully integrated CCBill yet as a payment processor into OSCommerce?

Or else what are people's thoughts of how hard it would be to do? I'm new to OSCommerce, but a PHP programmer by trade.

Thanks very much!

This module will be release in the next few days.... I will post when it is completed. You will need to do a few things in the CCBill Admin as well as get approval from client support for "Dynamic Pricing" but other than that it will work out of the box.

#5 power182

  • Community Member
  • 15 posts
  • Real Name:Jake Powers

Posted 09 August 2008, 00:23

Released

CCBill Payment Module

#6 kenm

  • Community Member
  • 3 posts
  • Real Name:ken

Posted 01 September 2008, 21:16

Hey there. I have installed the CCbill module and gotten approval from CCbill. Jake, how should the check out process now work? Should check out work like normal where the price that is displayed in the cart updates "dynamically" to the CCbill form that pressing "confirm order" in Oscommerce takes you to? When I click "confirm order", it either does one of 2 things: 1.) if i have a price added in ccbill's admin in displays that price only or 2.) if I remove any price in ccbill's admin the message I get is "no price option added" or something similar. I really appreciate the help.. and if I can help anyone in the process feel free to contact me.

Ken



View Postpower182, on Aug 7 2008, 01:19 PM, said:

This module will be release in the next few days.... I will post when it is completed. You will need to do a few things in the CCBill Admin as well as get approval from client support for "Dynamic Pricing" but other than that it will work out of the box.


#7 kenm

  • Community Member
  • 3 posts
  • Real Name:ken

Posted 03 September 2008, 17:35

Has anyone else tried implementing this?

#8 power182

  • Community Member
  • 15 posts
  • Real Name:Jake Powers

Posted 09 September 2008, 18:45

View Postkenm, on Sep 1 2008, 02:16 PM, said:

Hey there. I have installed the CCbill module and gotten approval from CCbill. Jake, how should the check out process now work? Should check out work like normal where the price that is displayed in the cart updates "dynamically" to the CCbill form that pressing "confirm order" in Oscommerce takes you to? When I click "confirm order", it either does one of 2 things: 1.) if i have a price added in ccbill's admin in displays that price only or 2.) if I remove any price in ccbill's admin the message I get is "no price option added" or something similar. I really appreciate the help.. and if I can help anyone in the process feel free to contact me.

Ken

Ken,

You need to contact CCBill and get your subaccount setup to what they call "dynamic pricing". This will allow your cart to pass in the price that is to be charged instead of using what you setup in the admin (for pricing). Contact them at clientsupport@ccbill.com to get this setup or PM me if you have questions.

#9 kenm

  • Community Member
  • 3 posts
  • Real Name:ken

Posted 09 September 2008, 22:47

I PM'd you back. I asked them to set as a dynamic account.. I better contact them again, lol.

View Postpower182, on Sep 9 2008, 02:45 PM, said:

Ken,

You need to contact CCBill and get your subaccount setup to what they call "dynamic pricing". This will allow your cart to pass in the price that is to be charged instead of using what you setup in the admin (for pricing). Contact them at clientsupport@ccbill.com to get this setup or PM me if you have questions.


#10 enael

  • Community Member
  • 1 posts
  • Real Name:real

Posted 17 September 2008, 23:59

i just take a look at your module. Is there anything like paypal IPN with ccbill ?

Edited by enael, 18 September 2008, 00:00.


#11 power182

  • Community Member
  • 15 posts
  • Real Name:Jake Powers

Posted 27 September 2008, 00:10

View Postenael, on Sep 17 2008, 04:59 PM, said:

i just take a look at your module. Is there anything like paypal IPN with ccbill ?

Yes, there are two methods. First is the background post which is real time and happens with the transaction. You can configure this to go to any URL you wish by configuring the destination in the CCBill Admin (there is one for approvals and one for denials). Additionally there is a system called datalink to import the data on a scheduled basis. CCBill Client Support can help you setup either or both of these options.

#12 ajnavy

  • Community Member
  • 2 posts
  • Real Name:Aj

Posted 16 December 2008, 02:03

View Postpower182, on Sep 27 2008, 12:10 AM, said:

Yes, there are two methods. First is the background post which is real time and happens with the transaction. You can configure this to go to any URL you wish by configuring the destination in the CCBill Admin (there is one for approvals and one for denials). Additionally there is a system called datalink to import the data on a scheduled basis. CCBill Client Support can help you setup either or both of these options.

CCBill offers absolutely no support for approval postback or datalink. The code posted here is only for the posting of credit card info to their signup page, not signup from them and post back to the site. This code will not update current "members" if they cancel their account or expire which is not a big deal if your only charging 1 time. For those who have rebill customers, you have to have the "datalink" code to update, which ccbill does not provide. There is a link to the approval post and datalink extract code that is universal written in PHP. https://www.wsn123.com/hosting/helpdesk/ind...cement&id=1

#13 power182

  • Community Member
  • 15 posts
  • Real Name:Jake Powers

Posted 17 December 2008, 20:51

View Postajnavy, on Dec 15 2008, 07:03 PM, said:

CCBill offers absolutely no support for approval postback or datalink. The code posted here is only for the posting of credit card info to their signup page, not signup from them and post back to the site. This code will not update current "members" if they cancel their account or expire which is not a big deal if your only charging 1 time. For those who have rebill customers, you have to have the "datalink" code to update, which ccbill does not provide. There is a link to the approval post and datalink extract code that is universal written in PHP. https://www.wsn123.com/hosting/helpdesk/ind...cement&id=1

You are using OSCommerce for recurring billing membership sites? Honestly I never intended this to be supported as OSCommerce is more for one time purchases of downloadable content. Which modules (OSCommerce) are you using to support recurring membership? I will look into support this if you can point me in the direction of how the install looks. Thanks!

#14 harootun

  • Community Member
  • 7 posts
  • Real Name:Jay Hart

Posted 23 December 2008, 04:49

I'm a newbie setting up my first shop. Interested in using the CCBill Gateway Module. Does anyone know if it works with another contribution, Super Download Shop? Is Super Download shop helpful with this Module? Any advice appreciated!

#15 power182

  • Community Member
  • 15 posts
  • Real Name:Jake Powers

Posted 23 December 2008, 17:57

View Postharootun, on Dec 22 2008, 09:49 PM, said:

I'm a newbie setting up my first shop. Interested in using the CCBill Gateway Module. Does anyone know if it works with another contribution, Super Download Shop? Is Super Download shop helpful with this Module? Any advice appreciated!

While I haven't directly tested it using both modules at first glance I don't see any issues with using both of them. The CCBill module is a fairly standard payment module so there are no quirky customizations that break other modules. I have tested the CCBill module using the download manager in OSCommerce and this just looks like an enhancement to that. Let me know if you run into any issues.

#16 ajnavy

  • Community Member
  • 2 posts
  • Real Name:Aj

Posted 24 December 2008, 09:34

View Postpower182, on Dec 17 2008, 09:51 PM, said:

You are using OSCommerce for recurring billing membership sites? Honestly I never intended this to be supported as OSCommerce is more for one time purchases of downloadable content. Which modules (OSCommerce) are you using to support recurring membership? I will look into support this if you can point me in the direction of how the install looks. Thanks!

Below is the install.txt file included with the php code to get an idea of how it works. It is not a module, it is a code that runs from cron jobs in the background to update the mySQL database. Included is a generic mySQL database file for people who don't have a members database but you can change the text code for the fields to work with any members fields.

Information on how to install datalink post, approval post, and cron job in 8 detailed easy steps

####################################################
##Name this file "install.txt" ##
##CCBill data extract is compatible with all versions of PHP on all platforms. ##
##The script is limited to licensee ##
##Redistribution of the script is not permitted. ##
##Developed and published by Web Spade Network LLC ##
##Email: sales@wsn123.com ##
##Toll free: 888-539-5527 ##
##Fax: 888-202-7721 ##
####################################################

(Included Files)
install.txt - detailed installation instructions
memberDB.sql - sql member database
approvalPost.php - file to approve subscription when customer signs up with CCBill
approve.inc - file to modify to connect to database
parsing.php - file that parses data from parse.txt file
datalink.php - file that passes parse.txt file data to the SQL member database
account.inc - file to modify to connect to database and ccbill
passToFile.php - file that gets data from CCBill and inserts to parse.txt
parse.txt - empty text file that holds CCBill data from passToFile.php (chmod 777)
Cron_Job_Command.txt - Basic Cron commands for manual setup
CCBill Provided Documentation Folder


1. Create your database to hold member information
*Create you mySQL database(**remember your database name, user name, and password for step 2)
*insert the "memberDB.sql" file to your database. The table name is "member"(need it for the code)
*(the table names are already created and set per CCBill guidelines)

2. Make sure you modify your "approve.inc" and "account.inc" file to connect to your mySQL database and CCBill account (****These are the only 2 files that you need to modify****)

3. Upload your "approvalPost.php" and "approve.inc" to your website and make sure both files are in the same directory.(DO NOT password protected the directory you upload this file to. CCBill is not part of your server and would be denied access)

4. Upload your "datalink.php", "parsing.php", "passToFile.php, and "account.inc" to your website.(You should password protected the directory so someone doesn't access your script accidentally or on purpose)

5. Upload the "parse.txt" file in the same folder as step 4 and make sure to chmod this file to 777 (which is drwxrwxrwx).

6. How to set up your approval post to add members to your database as soon as a customer signs up
*Go to http://ccbill.com
*In the top-right screen after login click on "premium features"
*On the tab, click on "value added features"
*Scroll down and click on "Background Post"
*Select sub account (typically "0000 - sitename.com) and click "go"
*in the empty space under "Approval Post URL" enter the entire address location to the approvalPost.php file where you uploaded it. ex. "http://www.mysite.com/approvalPost.php"

7. How to set up your datalink extract post to add/update members to your database
*Go to http://ccbill.com
*In the top-right screen after login click on "premium features"
*On the tab, click on "value added features"
*Scroll down and click on "Data Link Services Suite"
*Select Sub Account (usually "0000 - sitename.com")
*Click "Add User"
*Enter a user name (this is the same user name in your "passToFile.php" file
*Enter a password (this is the same password in your "passToFile.php" file
*Retype your password
*Where valid IPs, enter the IP address of your website (Note:your website ip might not be the ip displayed(if you did a whois)needed especially if you are on a shared server. Your best bet is to ask you host provider(The people who host your website) what IP address to use.
*Click "Store User"
*You might need to get this function activated by CCBill(call CCBill at 800-510-2859) just to make sure!

8. Setting up a Cron Job for your site in Cpanel
*log onto your cpanel ex. "http://mysite.com/cpanel" then enter your username and password
*At the bottom of the page under "Advanced", click on the "cron jobs" icon
*Click on "standard"
*in entry1 enter without the quotations "php -q /home/your server user name/public_html/password protected subDirectory/passToFile.php"
*if your file is in the root directory, just remove the "password protected subDirectory/" part or change the subDirectory to whatever your subDirectory is
*Select 0 Minutes, Every Other Hour, Every Day, Every Month, Every Week(This will run your passToFile.php code every other hour)CCBill only allows parsing once every other hour so don't set it sooner than that or you will hanve problems!!
*Click "Save Crontab"
*Go back to your crontab and click on "standard" again
*in entry2 enter "php -q /home/your server user name/public_html/password protected subDirectory/datalink.php"
*if your file is in the root directory, just remove the "password protected subDirectory/" part or change the subDirectory to whatever your subDirectory is
*Select 2 Minutes, Every Other Hour, Every Day, Every Month, Every Week(This will run your datalink.php code every other hour and 2 minutes)After your "passToFile.php" inserts data to your "parse.txt file", setting will get data 2 minutes after every other hour to make sure passToFile.php has had time to update the parse.txt file.
*Click "Save Crontab"


Congratulations!! You are now getting immediate member information(approvalPost.php) and hourly member update information(passToFile.php to datalink.php) from CCBill. All you have to do is code your website to receive the member login and password info from your database.
If you need to set up a cron job manually, included is the "Cron_Job_Commands.txt" file for basic commands.

#17 power182

  • Community Member
  • 15 posts
  • Real Name:Jake Powers

Posted 24 December 2008, 15:19

Have you considered using the CCBill user management system? They offer the client install script in php that supports MySQL. You would have to modify the script to use the OSCommerce database but that would by fairly simply as all you would need to do is update the queries to the new database schema. If you wanted to use the OSCommerce login as the username and password you could simply set the form system up to accept passed in usernames and passwords and pass them in during the signup process. The only reason I would think this would be a better solution is this allows their customer support to update usernames and passwords if a consumer has forgot their login information.... Just some food for thought.

#18 harootun

  • Community Member
  • 7 posts
  • Real Name:Jay Hart

Posted 24 December 2008, 17:41

Jake, thanks for the quick response.

I've just set up my ccBill account and am trying to set up the subaccount properly. In your instructions to your contribution, you give the Approval URL and Denial URL for the form, but is it the same for the subaccount? I think so, but want to make sure. Also, since I'm a total idiot, do we put in anything where the %% are in the URL, or do they stay %%.

Also, going forward, in selling downloadable content (one time only), do I need to create a new subaccount for each item? And will purchasers be able to buy more than one item at the same time?

Any advice appreciated!

#19 power182

  • Community Member
  • 15 posts
  • Real Name:Jake Powers

Posted 24 December 2008, 19:11

View Postharootun, on Dec 24 2008, 10:41 AM, said:

Jake, thanks for the quick response.

I've just set up my ccBill account and am trying to set up the subaccount properly. In your instructions to your contribution, you give the Approval URL and Denial URL for the form, but is it the same for the subaccount? I think so, but want to make sure. Also, since I'm a total idiot, do we put in anything where the %% are in the URL, or do they stay %%.

Also, going forward, in selling downloadable content (one time only), do I need to create a new subaccount for each item? And will purchasers be able to buy more than one item at the same time?

Any advice appreciated!

Yes the denial URL and approval URL are settings on the subaccount level so you are on the right track. The %% attributes will be string replaced with real values by the CCBill system when the URLs are called after an action is take so leave them in tack as is.

If you anticipate making multiple sales to a single consumer in a short period (each shopping cart checkout is considered one sale to CCBill; even if it has 10 products in it so I am saying one consumer checking out multiple times in a short period (days)) of time contact CCBill and ask them to have "multisub" turned on for your account. Their fraud team will have to review your request before they can institute it but as long as it legitimate they will do so.

Products do NOT need to be registered with CCBill so one subaccount per site should suffice, as long as they turn on multisub, access management for the download should be handled by OSCommerce (their download products feature) not CCBill.

Hope that helps! Good luck!

#20 harootun

  • Community Member
  • 7 posts
  • Real Name:Jay Hart

Posted 02 February 2009, 18:11

Jake,

Another question for you. I'd like to enable cookies in osCommerce so I can have user's log-ons work with a forum on my site as well as the osC store. Does this module work if cookies are enabled?

Thanks in advance for any info!