Jump to content
Sign in to follow this  
junaid

SETCOM payment module?

Recommended Posts

Hi,

 

I am using Setcom as my secure payment service provider, and haven't seen a module contribution that supports it. Does anyone have a module for this that they would like to contribute?

 

Thanks,

Junaid

Share this post


Link to post
Share on other sites
Hi,

 

I am using Setcom as my secure payment service provider, and haven't seen a module contribution that supports it. Does anyone have a module for this that they would like to contribute?

 

Thanks,

Junaid

 

No-one? :( Perhaps I should give it a bash myself - I'm surprised that Setcom hasn't offered this themselves yet, given that it would encourage more people to adopt their service. Here in South Africa one has to jump through too many hoops with the other service providers.

Share this post


Link to post
Share on other sites

hi,

Installed the updated setcom v 2.0 module today but can't get it to work as it should. I've done everything as per the readme file...created setcom account, set auto redirect on etc etc

 

the problem is when testing a new purchase with the details provided by setcom (testbuyer) it does redirect to setcom but after finishing the transaction at setcom it goes back to the login page and NOT checkout_process. the order does not complete as no order is created. when loggin in again the item is still in the shopping cart. I have tried both checkout and buynow options in the setcom module settings.

 

my service provided said that the WDDX functions are not yet installed but they will schedule an update now. could this be the problem?

 

thanks!

:D

Share this post


Link to post
Share on other sites

I think the problem has got to do with the cookie setup on your site.

 

In the includes/configure.php, check that the "Cookie Domain" and "Cookie Path" are correct. That should solve the problem.

Share this post


Link to post
Share on other sites

Thanks for your help last week. The cookie setup was the problem and everything works now as it should.

 

Just one question, when testing the implementation with the testbuyer login (as provided by setcom) it comes back declined. Should this be the case? How can I be sure it works now without using my own credit card details?

 

Thanks!

Share this post


Link to post
Share on other sites
Thanks for your help last week. The cookie setup was the problem and everything works now as it should.

 

Just one question, when testing the implementation with the testbuyer login (as provided by setcom) it comes back declined. Should this be the case? How can I be sure it works now without using my own credit card details?

 

To get an approved transaction use one of the testseller accounts as a seller and the testbuyer account as a buyer.

To get a declined transaction us your own account as a seller and the testbuyer account as a buyer.

Share this post


Link to post
Share on other sites

I tried to insert the Setcom Contribution to my Webstore.

 

Everything was going well until I tried to insert Setcom_SQL file into my Phpadmin.

 

I got:

 

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 39

 

Any ideas? Any help please???

 

Thank you in advance

Share this post


Link to post
Share on other sites

Try using the following code instead:

 

DROP TABLE IF EXISTS `setcom`;

CREATE TABLE `setcom` (

`s_setcom_id` int(11) NOT NULL auto_increment,

`s_order_id` int(11) default NULL,

`s_customers_id` int(11) default NULL,

`s_date_today` varchar(255) default NULL,

`s_status` varchar(255) default NULL,

`s_otransid` varchar(255) default NULL,

`s_identi` varchar(255) default NULL,

`s_musername` varchar(255) default NULL,

`s_mreference` varchar(255) default NULL,

`s_busername` varchar(255) default NULL,

`s_bemailadd` varchar(255) default NULL,

`s_ptype` varchar(255) default NULL,

`s_brand` varchar(255) default NULL,

`s_cardname` varchar(255) default NULL,

`s_cardnum` varchar(255) default NULL,

`s_famount` varchar(255) default NULL,

`s_currency` varchar(255) default NULL,

`s_ttransID` varchar(255) default NULL,

`s_ttype` varchar(255) default NULL,

`s_sellreference` varchar(255) default NULL,

`s_stype` varchar(255) default NULL,

`s_dateadded` varchar(255) default NULL,

`s_sreference` varchar(255) default NULL,

`s_errorcode` varchar(255) default NULL,

`s_authonum` varchar(255) default NULL,

`s_transactionkey` varchar(255) default NULL,

`s_samount` varchar(255) default NULL,

`s_fee` varchar(255) default NULL,

`s_tax` varchar(255) default NULL,

`s_rollreserve` varchar(255) default NULL,

`s_nett` varchar(255) default NULL,

`s_balance` varchar(255) default NULL,

`s_rollreservebal` varchar(255) default NULL,

`s_fundsavail` varchar(255) default NULL,

`s_rollreserveavail` varchar(255) default NULL,

`s_curlerror` varchar(255) default NULL,

PRIMARY KEY (`s_setcom_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Share this post


Link to post
Share on other sites

I still get

 

"MySQL said:

 

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 39 "

Share this post


Link to post
Share on other sites
I still get

 

"MySQL said:

 

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 39 "

 

 

Try removing the 'DEFAULT CHARSET=latin1'

 

DROP TABLE IF EXISTS setcom;

CREATE TABLE setcom (

s_setcom_id int(11) NOT NULL auto_increment,

s_order_id int(11) default NULL,

s_customers_id int(11) default NULL,

s_date_today varchar(255) default NULL,

s_status varchar(255) default NULL,

s_otransid varchar(255) default NULL,

s_identi varchar(255) default NULL,

s_musername varchar(255) default NULL,

s_mreference varchar(255) default NULL,

s_busername varchar(255) default NULL,

s_bemailadd varchar(255) default NULL,

s_ptype varchar(255) default NULL,

s_brand varchar(255) default NULL,

s_cardname varchar(255) default NULL,

s_cardnum varchar(255) default NULL,

s_famount varchar(255) default NULL,

s_currency varchar(255) default NULL,

s_ttransID varchar(255) default NULL,

s_ttype varchar(255) default NULL,

s_sellreference varchar(255) default NULL,

s_stype varchar(255) default NULL,

s_dateadded varchar(255) default NULL,

s_sreference varchar(255) default NULL,

s_errorcode varchar(255) default NULL,

s_authonum varchar(255) default NULL,

s_transactionkey varchar(255) default NULL,

s_samount varchar(255) default NULL,

s_fee varchar(255) default NULL,

s_tax varchar(255) default NULL,

s_rollreserve varchar(255) default NULL,

s_nett varchar(255) default NULL,

s_balance varchar(255) default NULL,

s_rollreservebal varchar(255) default NULL,

s_fundsavail varchar(255) default NULL,

s_rollreserveavail varchar(255) default NULL,

s_curlerror varchar(255) default NULL,

PRIMARY KEY (s_setcom_id)

) ENGINE=MyISAM;

Share this post


Link to post
Share on other sites

It worked !!! :)

 

Thank you so much for your great support :thumbsup:

 

 

1 last thing though ...

 

I tried to place an order from my site , of course using the TESTBUYER@SETCOM.COM user, when I chose the Credit Card to pay, I was redirected to:

www.mydomain.com/store/checkout_payment.php?error_message=Your+credit+card+could+not+be+authorised+for+the+following+reason%3A+Pending+or+Declined

 

 

and got this messager:

Your credit card could not be authorised for the following reason: Pending or Declined

 

 

Is this suppose to happen? Is everything working now?

 

I hope the answer is yes and I hope our customers will start paying through your services.

 

Best Regards,

Arames

Share this post


Link to post
Share on other sites

If you are using your own account, then yes

 

When testing:

 

To get an approved transaction use one of the testseller accounts as a seller and the testbuyer account as a buyer.

To get a declined transaction us your own account as a seller and the testbuyer account as a buyer.

Share this post


Link to post
Share on other sites

Thanks again to EarlyQ for all his help with this contribution.

 

If anyone has a problem with testing the implementation please read the following (provided by EarlyQ):

 

The testseller accounts work the same as your own account.

First you have to visit setcom.com and log into one of them and then click Profiles -> Selling Preferences -> Website Payment Preferences. Then insert the location of your checkout_process.php file in the Auto Redirect URL box. (step 1 of the readme file).

 

As an example:

 

1. You decide you are gonna use testseller1 as the test account.

 

2. In the setcom payment module in admin section of your store you insert:

Mechant ID: 1234567891

Username: testseller1@setcom.com

Password: testseller.

 

3. You would visit setcom.com and log into the testseller1 account with the username 'testseller1@setcom.com' and the password 'testseller'.

 

4. Then click Profiles -> Selling Preferences -> Website Payment Preferences.

Then insert the location of your checkout_process.php file in the Auto Redirect URL box, and check AutoRedirect to 'on'.

Then click 'save'. (If there is already a url in the box, just delete it and insert your own)

 

5. Now perform a test purchase at your store using the login testbuyer@setcom.com, password testbuyer.

It should work fine now.

 

 

 

I have done the above and my implementtation works 100%

Share this post


Link to post
Share on other sites

I have copuons by Ingo installed and have updated the supplied setcom.php payment module file with adding the following before // Create form data for Delivery Cost (if any):

 

// Create form data for voucher (if any)

global $coupon_redeem_value, $coupon_code_code;

if (tep_session_is_registered('coupon_redeem_value') && tep_session_is_registered('coupon_code_code') && ($coupon_redeem_value>0)) {

$sCoupon = $coupon_redeem_value * $order->info['currency_value'] * (-1);

if (!empty($sCoupon)) {

$j++;

$process_button_string .= tep_draw_hidden_field('LIDSKU' . $j, 'vouche') .

tep_draw_hidden_field('LIDDesc' . $j, 'Discount Coupon') .

tep_draw_hidden_field('LIDPrice' . $j, number_format($sCoupon, 2, '.', '')) .

tep_draw_hidden_field('LIDQty' . $j, '1') .

tep_draw_hidden_field('ShippingRequired' . $j, '0') .

tep_draw_hidden_field('IsVoucher' . $j, '0');

}

}

 

(this is actually just a modifcation of the "check for delivery cost" part of the script and it works fine before finalising payment at setcom. The Discount Coupon description shows as well as the negative coupon value amount but as soon as you click the pay now button it creates an error which looks like xml code with all the variables etc etc. on the next page.

 

what can be the problem?

Share this post


Link to post
Share on other sites
I have copuons by Ingo installed and have updated the supplied setcom.php payment module file with adding the following before // Create form data for Delivery Cost (if any):

 

// Create form data for voucher (if any)

global $coupon_redeem_value, $coupon_code_code;

if (tep_session_is_registered('coupon_redeem_value') && tep_session_is_registered('coupon_code_code') && ($coupon_redeem_value>0)) {

$sCoupon = $coupon_redeem_value * $order->info['currency_value'] * (-1);

if (!empty($sCoupon)) {

$j++;

$process_button_string .= tep_draw_hidden_field('LIDSKU' . $j, 'vouche') .

tep_draw_hidden_field('LIDDesc' . $j, 'Discount Coupon') .

tep_draw_hidden_field('LIDPrice' . $j, number_format($sCoupon, 2, '.', '')) .

tep_draw_hidden_field('LIDQty' . $j, '1') .

tep_draw_hidden_field('ShippingRequired' . $j, '0') .

tep_draw_hidden_field('IsVoucher' . $j, '0');

}

}

 

(this is actually just a modifcation of the "check for delivery cost" part of the script and it works fine before finalising payment at setcom. The Discount Coupon description shows as well as the negative coupon value amount but as soon as you click the pay now button it creates an error which looks like xml code with all the variables etc etc. on the next page.

 

what can be the problem?

Share this post


Link to post
Share on other sites

Oops, dont know what happened there!

 

Hi !

 

I am having the same problem : "when testing a new purchase with the details provided by setcom (testbuyer) it does redirect to setcom but after finishing the transaction at setcom it goes back to the login page and NOT checkout_process. the order does not complete as no order is created. when logging in again the item is still in the shopping cart.

 

As per instructions, have changed the cookie settings also as I am working on my temp URL : http://75.126.124.164/~tpvrkftv/commerce

My original domain is www.chronicare.co.za, and i have therefore changed the cookie domain to 75.126.124.164/~tpvrkftv-Is this correct?

 

I am still having the same problem as above though?

Is the url maybe incorrect? My checkout confirmation url is:

http://75.126.124.164/~tpvrkftv/commerce/c...93fe91e60fb24f4

Would the checkout_process.php not therefore be: http://75.126.124.164/~tpvrkftv/commerce/c...out_process.php ??

 

Anybody with any ideas? I am so close to being finished and now a brick wall!

 

Many thanks in advance

Michelle

Share this post


Link to post
Share on other sites

Hi! Anybody out there?

 

In response to my previous email, i ave searched oscommerce forums , emailed setcom , searched vodahost forums and even googled and this seems to be a very! common problem with many payment modules. (the redirecting to login), and very few people seems to get replies or responses to makes sense of this problem and offer solutions!

 

Really desperate for an answer!

I am keen for my oscommerce to get going and have been happy with it thus far.

Thanks in advance to all you boffins out there- i know i can count on you!

Michelle

Share this post


Link to post
Share on other sites

When i click the link of your website:

 

http://75.126.124.164/~tpvrkftv/commerce

 

it redirects to

 

http://www.voda13.com/~tpvrkftv/commerce/

 

 

So what you could also try this:

 

1. open the following file:

 

/includes/configure.php

 

edit the following lines to:

 

define('HTTP_COOKIE_DOMAIN', 'www.voda13.com');
define('HTTPS_COOKIE_DOMAIN', '');
define('HTTP_COOKIE_PATH', '/~tpvrkftv/commerce/');
define('HTTPS_COOKIE_PATH', '');

 

 

2. Use the following as the url to your checkout process file:

 

http://www.voda13.com/~tpvrkftv/commerce/checkout_process.php

Share this post


Link to post
Share on other sites

Hi.

 

Can someone please help me. I would like to make it that when someone buys a product off the site, if they decide to use Setcom, it charges them another 5% on top of everything.

 

Regards

 

Itai Etzman

Share this post


Link to post
Share on other sites

Hey, I hope someone here can help me, I have followed all the instructions, and everything seems fine, until I get to the checkout_process.php file. The redirect from setcom works, it goes to the url, and adds a variable, see below.

 

checkout_process.php?tnxid=751ad1a5-e827-4c5f-8d32-4e0df564f372&checksum=0E6EB29A4969C1E64415FC6C70B30B3A&parity=8196170

 

My problem is that this goes to the site, but only opens a blank page. Even if I view the source of the page, it is completely empty.

 

Also, the purchase is not recorded in the oscommerce website either.

 

I would really appreciate some assistance with this.

 

Thanks

 

Francois

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×