Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SETCOM payment module?


junaid

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

Link to comment
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.

Link to comment
Share on other sites

  • 5 months later...
  • 3 months later...

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

Link to comment
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!

Link to comment
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.

Link to comment
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

Link to comment
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;

Link to comment
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 "

Link to comment
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;

Link to comment
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 [email protected] 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

Link to comment
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.

Link to comment
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: [email protected]

Password: testseller.

 

3. You would visit setcom.com and log into the testseller1 account with the username '[email protected]' 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 [email protected], password testbuyer.

It should work fine now.

 

 

 

I have done the above and my implementtation works 100%

Link to comment
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?

Link to comment
Share on other sites

  • 5 months later...
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?

Link to comment
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

Link to comment
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

Link to comment
Share on other sites

  • 3 weeks later...

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

Link to comment
Share on other sites

  • 2 months later...
  • 1 month later...
  • 6 months later...

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

Link to comment
Share on other sites

  • 1 year later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...