VirtueMart Forum

VirtueMart Dev/Coding Central: VM1 (old version) => Development Projects, Modifications, Hacks & Tweaks. VM1.1 => Payment Modules => Topic started by: Shibumi on March 15, 2006, 15:43:52 PM

Title: Canadian experience with payment processors?
Post by: Shibumi on March 15, 2006, 15:43:52 PM
I am setting up a store in Canada and I am wondering if anyone has had any experience setting up a store with payment processors other than paypal or 2checkout?  I am looking at a system from beanstream which is apparently a division or sister company of TD Canada Trust.  Their web site is http://www.beanstream.com/website/merchant_services/ccprocessing/ccprocessing.asp

I am trying to find the best and potentially the easiest solution and would greatly appreciate any help with this.

One thing I have noticed while looking at payment processors is that most of the bigger ones that list supported shopping carts - none of them have VirtueMart, or even phpShop listed as a recognised cart - osCommerce is almost always listed, which is really kind of sad as I have tried osCommerce as well and I dont like the interface and ease of use as much as I like VirtueMart.

Thanks
Title: Re: Canadian experience with payment processors?
Post by: independis on March 15, 2006, 20:54:44 PM
I am interested too... Beanstream and Moneris are required by my customers.

Anybody experience with these two?

Ralf
Title: Re: Canadian experience with payment processors?
Post by: Shibumi on March 17, 2006, 20:59:32 PM
With regards to a BeanStream payment processor module, I have attached a copy of the API interface developers manual... maybe we get get some programmers to have a look and see what we can do to create a plugin for the processor... I am sure that there are a lot of us in Canada that would love to have this as an option for a payment processor. 

Or, Soeren, if you can give me some quick pointers on where to start, I can try and develop something myself.

Lets see if this amazing community can come up with something quick with this and help a lot of us Canadians, eh?

Many thanks

[attachment deleted by admin]
Title: Re: Canadian experience with payment processors?
Post by: jabberwock on March 21, 2006, 22:34:31 PM
Just looking to set up a store with a payment processor based on Beanstream. I'm familiar with the innards of mambo so this seems like the right shop to use rather than using something like osCommerce and having to learn the code structure from scratch.

If you or anyone else has started on this and has any code written or information about how to do the integration that would be great.



Title: Re: Canadian experience with payment processors?
Post by: Shibumi on March 22, 2006, 05:34:38 AM
Hi jabberwock,

From what I could tell in the API manual for Beanstream, there is not a lot of PHP coding required, but it is creating the module for VM that could be a little tricky...  I dont know if you can use one of the other payment modules as an example to start the beanstream one... I asked Soeren for any pointers or tips on where to start, but I know he is pretty busy (and judging by his requests for moderators and assistance wherever and whenever possible, getting even busier) so I havent heard anything back from him yet... I do know that Soeren does do his best to try and reply to most of the posts.

It would be nice if we could get some (if there are any?) Canadian (or North American) members of this community who have good programming backgrounds to have a look into some of the Canadian and North American aspects of VM and come up with some good modules for things like shipping, and payment processors - another key issue seems to be our multiple tax rates and how the provinces have different rates and charged in different manners as well in some cases.  Maybe some of the features that already exist in osCommerce can be "ported" over to VM?

I have heard that future issues of VM will more than likely support the ability to sellect multiple currencies similar to osCommerce so that shop visitors can switch currencies.  Some other features that would be nice would be the abilty to generate quotes, without any payment processing (ie.: select "quote" as a payment method), just create an order that gets stored in the db with the shoppers info, but gets "flagged" as a Quote and not an actually order?  An RMA (Return Merchandise Authorization) request system that would allow shoppers to submit a request to return merchandise purchased online.  The only drawback I see to features like the "quotation system" is that some shoppers are potentially going to submit false contact information.  Maybe some kind of account email verification before purchases can be made?

We CAN make this a more Canadian friendly cart with every bit us Canadian members contribute!  So, I put out a call to ALL Canadian members, developers, programmers, users and so on, to get together and do what ever we can to help Soeren and the rest of the VM dev team make this product even better!!

Maybe Soeren can even create a new Canadian or North American VM Forum for development discussions, ideas, feature requests and so on, that all of us Canadian and North American members can collaborate in!!

Cheers!
Title: Re: Canadian experience with payment processors?
Post by: jabberwock on March 23, 2006, 01:04:08 AM
OK so out of necessity I've started creating the payment processor for Beanstream. It's already processing the basic card types correctly so I'll have a rough version up for testing sometime tommorow.

If there is anyone else out there who would be interested in helping out with testing just contact me and we'll be able get this up and running in a few days.

Cheers

Jabberwock.
Title: Re: Canadian experience with payment processors?
Post by: Shibumi on March 23, 2006, 01:07:48 AM
Sounds great!

I already have a test BeanStream Account set up so I can help you with the testing process!

Cheers,
Title: Re: Canadian experience with payment processors?
Post by: steph on March 24, 2006, 21:17:40 PM
 Wow, Could you keep us updated.  I would love to go with beanstream as well but the fact that it doesn't integrate with vm was stopping me.
I have no programing knowlege but I could go set up a test account with beanstream and help with testing.
Title: Re: Canadian experience with payment processors?
Post by: Shibumi on March 24, 2006, 23:00:35 PM
Hey Steph, sounds great! Maybe send Jabberwock a pm to let him know that you can help test the module... I havent heard from him in a couple of days, so I don't know where he's at with this right now...

Thanks,
Title: Re: Canadian experience with payment processors?
Post by: jabberwock on March 29, 2006, 05:20:17 AM
OK was wanting to get all the extra processing options (verified by visa) built but haven't had time to get that done yet. That said here's a basic processor that works well without.

Unzip the attached php files to adminsitrator/com_virtuemart/classes/payment/   

Then in administrator/com_virtuemart/languages/english.php add the following code:
   // Beanstream Processor Text Strings
var $_PHPSHOP_ADMIN_CFG_ENABLE_BEANSTREAM_TESTMODE = 'Enable Test Mode:';
var $_PHPSHOP_ADMIN_CFG_ENABLE_BEANSTREAM_TESTMODE_EXPLAIN = 'Select \'Yes\' while testing. Select \'No\' for enabling live transactions. Must match the setting set in the Beanstrem admin area.';
var $_PHPSHOP_ADMIN_CFG_BEANSTREAM_USERNAME = 'Beanstream Merchant ID:';
var $_PHPSHOP_ADMIN_CFG_BEANSTREAM_USERNAME_EXPLAIN = 'This is your Beanstream acount id.';
var $_PHPSHOP_ADMIN_CFG_BEANSTREAM_KEY = 'Click to set secure transaction key:';
var $_PHPSHOP_ADMIN_CFG_BEANSTREAM_KEY_EXPLAIN = 'This is your Beanstream Transaction Key for signing encrypted communications. It needs to be set in the Beanstream admin area too. Set it nothing to not use the transaction key';
var $_PHPSHOP_ADMIN_CFG_BEANSTREAM_KEY_EXPLAIN2 = 'This is your Beanstream Transaction Key for signing encrypted communications';
var $_PHPSHOP_PAYMENT_BS_RECURRING = 'Use recurring billing:';
var $_PHPSHOP_PAYMENT_BS_RECURRING_TOOLTIP = 'Define wether you want recurring billings.';
var $_PHPSHOP_PAYMENT_BS_VERIFIED_BY_VISA = 'Enable Verified by Visa:';
var $_PHPSHOP_PAYMENT_BS_VERIFIED_BY_VISA_TOOLTIP = 'NOT YET BUILT. Use the Verified by Visa checking.';
var $_PHPSHOP_PAYMENT_BS_VALIDATE_YESNO = 'Use username/password validation against transaction:';
var $_PHPSHOP_PAYMENT_BS_VALIDATE_YESNO_TOOLTIP = 'Use username/password validation against transaction. Must be enabled in the Beanstring admin area.';
var $_PHPSHOP_PAYMENT_BS_VALIDATE_USER = 'User Name:';
var $_PHPSHOP_PAYMENT_BS_VALIDATE_USER_TOOLTIP = '';
var $_PHPSHOP_PAYMENT_BS_VALIDATE_PASSWORD = 'Password:';
var $_PHPSHOP_PAYMENT_BS_VALIDATE_PASSWORD_TOOLTIP = '';
//end Beanstream Processor Text Strings

Add it to line 1480 just after the line
var $_VM_BROWSE_ORDERBY_FIELDS_LBL_TIP = 'Choose the "Sort-by" fields for the browse page. Each one defines a sort method for the product browse page. If you deselect all, the Order-By-Form will not be shown.';


Then in Virtuemart create a new payment processor and make sure to fill in the following values:
Code: BS
Payment class name: ps_beanstream
Payment method type: credit card
And fill in the information under the configuration tab


Updated: Working now with CW2 Numbers too (thanks Cipher)

[attachment cleanup by admin]
Title: Re: Canadian experience with payment processors?
Post by: Shibumi on March 29, 2006, 07:11:41 AM
Have implemented this and I am testing... Using the BeanStream test Visa numbers, but there is no test CVV number to test, so the processor tells me invalid CVV2 number - and if I turn off the CVV check in VM and even in Beanstream, I get:
QuoteError: You need to enter your Credit Card Code to proceed.
?

btw, excellent job so far Jabberwock!!
Title: Re: Canadian experience with payment processors?
Post by: Shibumi on March 29, 2006, 14:36:47 PM
Okay, tried again this morning
- I have CVV turned off in BeanStream, and also turned off in VM
- tried with BeanStream test Visa 403000010001234 and exp 12/2008

getting this error:

Quote
Error: Authorization Failed

Error: Failure in Processing the Payment (ps_beanstream)

- Dont know if this matters or not, but we are not running on SSL at this time

Jabberwock,  I have VM 1.0.4, and there is no Line 1480 in my /administrator/components/com_virtuemart/languages/english.php - I think the highest line number is 1478 after adding your code... so I just stuck it in near the other payment types (right after var $_PHPSHOP_ADMIN_CFG_CYBERCASH_AUTENTICATIONTYPE_EXPLAIN = ) and the module seems okay, just not authorizing. 

- Nice to know that with the CVV on in both BeanStream and VM that the check is working
- going to call my contact at BeanStream today and see if we can trouble shoot my problem

Cheers
Title: Re: Canadian experience with payment processors?
Post by: jabberwock on March 29, 2006, 15:15:17 PM
Yup it wasn't working with the CVVD codes. I've updated the file in my last post to fix the issue.
Title: Re: Canadian experience with payment processors?
Post by: r0tt3n on March 29, 2006, 21:42:08 PM
I'm a programmer consultant who has clients located in Canada.  I'm still familiarizing myself to a certain degree with VirtueMart, but I'm interested in seeing what I can do to help in your testing or debugging efforts.
Title: Re: Canadian experience with payment processors?
Post by: Shibumi on March 30, 2006, 17:33:53 PM
Quote from: jabberwock on March 29, 2006, 05:20:17 AM(Added by CiPHeR): Updated instructions for BeanStream Payment Processor (note - addition of components/ to the path)

1. Unzip the attached php files to adminsitrator/components/com_virtuemart/classes/payment/
- you will have 2 new files (ps_beanstream.php and ps_beanstream.cfg.php) to upload to the adminsitrator/components/com_virtuemart/classes/payment/

2. Then in administrator/components/com_virtuemart/languages/english.php add the following code:
// Beanstream Processor Text Strings
var $_PHPSHOP_ADMIN_CFG_ENABLE_BEANSTREAM_TESTMODE = 'Enable Test Mode:';
var $_PHPSHOP_ADMIN_CFG_ENABLE_BEANSTREAM_TESTMODE_EXPLAIN = 'Select \'Yes\' while testing. Select \'No\' for enabling live transactions. Must match the setting set in the Beanstrem admin area.';
var $_PHPSHOP_ADMIN_CFG_BEANSTREAM_USERNAME = 'Beanstream Merchant ID:';
var $_PHPSHOP_ADMIN_CFG_BEANSTREAM_USERNAME_EXPLAIN = 'This is your Beanstream acount id.';
var $_PHPSHOP_ADMIN_CFG_BEANSTREAM_KEY = 'Click to set secure transaction key:';
var $_PHPSHOP_ADMIN_CFG_BEANSTREAM_KEY_EXPLAIN = 'This is your Beanstream Transaction Key for signing encrypted communications. It needs to be set in the Beanstream admin area too. Set it nothing to not use the transaction key';
var $_PHPSHOP_ADMIN_CFG_BEANSTREAM_KEY_EXPLAIN2 = 'This is your Beanstream Transaction Key for signing encrypted communications';
var $_PHPSHOP_PAYMENT_BS_RECURRING = 'Use recurring billing:';
var $_PHPSHOP_PAYMENT_BS_RECURRING_TOOLTIP = 'Define wether you want recurring billings.';
var $_PHPSHOP_PAYMENT_BS_VERIFIED_BY_VISA = 'Enable Verified by Visa:';
var $_PHPSHOP_PAYMENT_BS_VERIFIED_BY_VISA_TOOLTIP = 'Use the Verified by Visa checking.'; // NOT YET BUILT
var $_PHPSHOP_PAYMENT_BS_VALIDATE_YESNO = 'Use username/password validation against transaction:';
var $_PHPSHOP_PAYMENT_BS_VALIDATE_YESNO_TOOLTIP = 'Use username/password validation against transaction. Must be enabled in the Beanstring admin area.';
var $_PHPSHOP_PAYMENT_BS_VALIDATE_USER = 'User Name:';
var $_PHPSHOP_PAYMENT_BS_VALIDATE_USER_TOOLTIP = '';
var $_PHPSHOP_PAYMENT_BS_VALIDATE_PASSWORD = 'Password:';
var $_PHPSHOP_PAYMENT_BS_VALIDATE_PASSWORD_TOOLTIP = '';
//end Beanstream Processor Text Strings


(Added by CiPHeR): look through the code til you find other payment types and insert at the end of the existing types and it will work fine. For example, I looked around line 1010 and inserted the code between Cybercash and Advanced Search:


var $_PHPSHOP_ADMIN_CFG_CYBERCASH_URL = 'CyberCash PAYMENT URL';
var $_PHPSHOP_ADMIN_CFG_CYBERCASH_URL_EXPLAIN = 'CyberCash PAYMENT URL is the URL provided by Cybercash for secure payment';
var $_PHPSHOP_ADMIN_CFG_CYBERCASH_AUTENTICATIONTYPE = 'CyberCash AUTH TYPE';
var $_PHPSHOP_ADMIN_CFG_CYBERCASH_AUTENTICATIONTYPE_EXPLAIN = 'CyberCash AUTH TYPE is the Cybercash authentication type provided by Cybercase';
// Beanstream Processor Text Strings

                insert beanstream code here

//end Beanstream Processor Text Strings
var $_PHPSHOP_ADVANCED_SEARCH = 'Advanced Search';
var $_PHPSHOP_SEARCH_ALL_CATEGORIES = 'Search All Categories';
var $_PHPSHOP_SEARCH_ALL_PRODINFO = 'Search all product info';
var $_PHPSHOP_SEARCH_PRODNAME = 'Product name only';

3. Save the file then upload to adminsitrator/components/com_virtuemart/languages/

4. Then in Virtuemart create a new payment processor and make sure to fill in the following values:
Payment Method Name: Credit Card or Visa, or Mastercard, (whatever you want to show in checkout for payment option)
Code: BS
Payment class name: ps_beanstream  (must be ps_beanstream)
Payment method type: credit card

Save the payment type then go back...

5. And fill in the information under the configuration tab

If you select username and password verification, note that you must setup a username and password in your BeanStream Account

BeanStream Account --> Administration --> Account Settings --> Order Settings

- the username and password can be anything you want, then enter that username and password in the appropriate fields

It is important to note that your settings in your Beanstream Admin MUST sync with your settings in VirtueMart

Updated: Working now with CW2 Numbers too (thanks Cipher)

6. If the ps_beanstream.php still shows this code at line 321:
            'ordName' => substr($dbbt->f("first_name"), 0, 32) . substr($dbbt->f("last_name"), 0, 32) ,

replace it with:
            'ordName' => substr($dbbt->f("first_name"), 0, 32) ." ". substr($dbbt->f("last_name"), 0, 32) ,

and the same for line 332:
            'shipName' => substr($dbst->f("first_name"), 0, 32) . substr($dbst->f("last_name"), 0, 32),

replace it with:
            'shipName' => substr($dbst->f("first_name"), 0, 32) ." ". substr($dbst->f("last_name"), 0, 32),

this fixes the order and shipping names adding a single whitespace between First and Last name

Have not tested this extensively yet, but the module does work with CVV verification, username and password is great for verifying the process is legit.  Beanstream will give you a test account to try this out, and they are fairly helpful with regards to getting you up and running.  Orders will show payment processed sucessfully in VM, and you can also track your orders in Beanstream as well as issue refunds, or void transactions - even on test account.

Beanstream seems to use the session id for the order numbers, and not the actual order number from VM - this is something jabberwock and I are looking into to see if we can get the actual order from VM to be passed, and not the session id - this will make it easier to match up orders.

[attachment cleanup by admin]
Title: Re: Canadian experience with payment processors?
Post by: r0tt3n on April 04, 2006, 16:37:22 PM
Oh boy oh boy, I can't wait to try out this new toy.  Once I get into it in a few days I'll post back my results.  beautiful work cipher.
Title: Re: Canadian experience with payment processors?
Post by: Shibumi on April 04, 2006, 20:09:59 PM
Hey r0tt3n,

before I say thanks, I didnt really create it, jabberwock did, I helped out by doing some testing and code clean up, but full credit goes to jabberwock... without him, we wouldn't have this processor for us Canadians eh!

As far as I know, between jabberwock and myself, we have discovered that the Verified By Visa checks use a different test account for testing purposes, so you would need to contact your BeanStream rep or tech support to find out more before you can test the VbV.  But, it should work for live accounts.

We are looking for any help with the Verified by Visa portion of this payment processor - this module is about 90% complete, and this is the only portion that is not fully functional... and I have tested it (without VbV) successfully on Visa and M/C test accounts both Approved and Declined. I have not tested the Verified by Visa check as of yet.

We have discovered some small issues regarding how VM passes the session_id stored in $order_number and that session_id is what ends up being your "Order Number" in Beanstream Administration and emailed receipts to customers... makes it a little confusing when trying to match orders. Also noticed that in VM Order Admin, it does not show any "Confirmation" or "Authorization" Number.

We are working on getting more concise transaction report data to be displayed at the bottom of the order detail admin page.

The masking of the CVV code in the admin Order Details page and email confirmations has now been added by Jabberwock and the file is attached for uploading to your /administrator/components/com_virtuemart/classes/payment/ folder... download the file and overwrite the existing ps_beanstream.php, then log in to VM Admin, go to List Payment Methods, click on your beanstream payment method and in the Configuration Tab, add this code to the Payment Extra Info text area...


<?php
if (isset($_SESSION["bs_auth_code"])) {
echo 'Transaction Authorization Code:' . $_SESSION["bs_auth_code"];
unset($_SESSION["bs_auth_code"]);
}
?>

[attachment cleanup by admin]
Title: Re: Canadian experience with payment processors?
Post by: icw on April 28, 2006, 15:19:42 PM
Well Canucks, looks good so far...

What about a spin off towards a internetsecure payment modual.

I have an internetsecure account and have also used that of Zencart(spin off of OSC, but way way better), I'm not a programmer, but know there are many internetsecure users like that of myself and we sincerely need something like this.

VM has a great future, but todate I get the feeling it is not very Canadian or North American friendly.

I can help in testing and French translations. Currently I have a test site of Joomla and VM running in both French and English, some minor items in this regards. VM's attributes options are a dog to work with in my opinion at this point as well. Take Zencart or OSC, one product is created, attributes are added with multiple options. When using more then one language, there is only on main product and the translated version in stage with this, you add attributes and still only one product is required. VM on the otherhand ends up with parent-child products, this in terms of attributes the VM way ends up with mutiple copies of the same product in my case: product plus 4 size formats(same product, just different sizes) that in terms adds the need to translate 4 times the same product after the parent product, that is a nasty workload when you have many products in a dual language setup.



Title: Re: Canadian experience with payment processors?
Post by: r0tt3n on August 17, 2006, 14:35:09 PM
Any new news in regards to this payment processor?
Title: Re: Canadian experience with payment processors?
Post by: dsendecki on August 19, 2006, 06:38:48 AM
Hey Rott3n -- I need this one, too -- could we interest anybody in finishing the development? I'd be happy to donate time and money to the cause!
Title: Re: Canadian experience with payment processors?
Post by: jabberwock on August 19, 2006, 10:32:44 AM
Hello there.

The current version does work correctly for processing payments and has been used for the past few months without problem.


I'm currently thinking of adding the ability for Verified by Visa to the processor but it requires many more changes to the main virutemart checkout code that I haven't added it yet.

Have fun.

Jabb
Title: Re: Canadian experience with payment processors?
Post by: Anthony C. on October 16, 2006, 21:09:03 PM
Hi,

Thank for your support on this payment module.

I am lucky to see your post. I just have one question. What is the Verified by Visa ? If that is not supported, will that affect the security of the transaction?

Thank you
Title: Re: Canadian experience with payment processors?
Post by: Burner on October 23, 2006, 21:50:20 PM
Anyonen here had any successful w/ the Moneris pp mod?
Title: Re: Canadian experience with payment processors?
Post by: r0tt3n on October 23, 2006, 21:55:02 PM
Is there a Moneris payement processor module for VirtueMart?  To the best of my knowledge there isn't one, but I'd be really interested if there were...
Title: Re: Canadian experience with payment processors?
Post by: Burner on October 23, 2006, 22:03:39 PM
Yes, but Moneris & the mod seem quite difficulut so far to get working. There are several people looking at it for the Canadian use but we lack coding experience to used the setup & if it's working right. Mod desinger is a good help but he has been busy.

See

http://virtuemart.net/index.php?option=com_smf&Itemid=99999999&topic=21491.0
Title: Re: Canadian experience with payment processors?
Post by: r0tt3n on October 23, 2006, 22:07:51 PM
Thanks for the link Burner - I apparently missed that one.  I'll definately have to take a look at it.  I am a programmer, so if this ends up being the payment processor my client wishes to use, I'll definately take a look.  By the way, has anyone done a cost comparison of the different online payment processors available to Canada?  I thought Moneris was the only one in Canada for the longest time, and then I heard of Beanstream... how much do they charge for setup fees and per transaction?  Are there others to consider?
Title: Re: Canadian experience with payment processors?
Post by: Burner on October 23, 2006, 22:20:19 PM
I'm doiing this for a client so I'm not sure but it seems out West that Moneris is the one in bed w/ RBC

Which banks are using Beanstream?
Title: Re: Canadian experience with payment processors?
Post by: r0tt3n on October 23, 2006, 22:23:00 PM
TD I Think - I wonder what Scotiabank offers...
Title: Re: Canadian experience with payment processors?
Post by: Burner on October 23, 2006, 22:33:19 PM
No idea. I'm just wanting to get Moneris going.

I wish there was an special committee in VM that would work on Payment Modules as they are really needed & the future of continuing VM success w/ Joomla!, Mambo & etc.
Title: Re: Canadian experience with payment processors?
Post by: r0tt3n on October 23, 2006, 23:52:52 PM
I made a CPPPC, found here  (Canadian Payment Processor Price Comparison) (http://virtuemart.net/index.php?option=com_smf&Itemid=71&topic=22780.0).
Title: Error: <LI>Invalid Card Number<br>
Post by: Anthony C. on October 31, 2006, 00:18:03 AM
After setting up the testing account from Beanstream,
I got this error:

Error: <LI>Invalid Card Number<br>
Error: Failure in Processing the Payment (ps_beanstream)

Does anyone know how I can troubleshoot this problem?

I tried to use both the testing creditcard number and my own credit card number, but didn't work at all.

thanks

Anthony
-----------------------------------------


Sorry i got it fixed..@@ input into the wrong fields..


Title: Re: Canadian experience with payment processors?
Post by: Anthony C. on October 31, 2006, 00:56:28 AM
Another questions:
about this
QuoteBeanstream seems to use the session id for the order numbers, and not the actual order number from VM - this is something jabberwock and I are looking into to see if we can get the actual order from VM to be passed, and not the session id - this will make it easier to match up orders.

Anyone got it solved?
Thank you..
Title: Re: Canadian experience with payment processors?
Post by: Anthony C. on November 06, 2006, 17:54:48 PM
I was able to send the order_id to beanstream.
Now I tested the system. Everything works fine except when we use a non US or Canada address for shipping address. The VM can't varify the order. I checked the database, in the jos_vm_order_user_info, there is record of the order, however, in the order_id is set to '0' which means it doesn't relate to other table.

Anyone got the same problem? or if anyone's vm with beanstream works for foreign addresses, please tell me.
Thank you

Anthony
-----------------------------------------------------------------
Problem Solved:

in my shipping items, I have " ' " in the field which makes errors in sql syntax.

Just to remind myself and ppl, don't put ' in the fields unless it is meants to only display as text fields.

^^

Anthony
Title: Re: Canadian experience with payment processors?
Post by: Chirag Shah on November 09, 2006, 04:09:46 AM
Hi ,We are going to open a canadian store using virtuemart.
We need some help.

We want to add module for payment processor from canadian company.
As i went to this forum and find out that you have made a module and it is working good.

I request you to give us files  to install and instructions to install and use this module.

Thanks
Quote from: CiPHeR on March 30, 2006, 17:33:53 PM
Quote from: jabberwock on March 29, 2006, 05:20:17 AM(Added by CiPHeR): Updated instructions for BeanStream Payment Processor (note - addition of components/ to the path)

1. Unzip the attached php files to adminsitrator/components/com_virtuemart/classes/payment/
- you will have 2 new files (ps_beanstream.php and ps_beanstream.cfg.php) to upload to the adminsitrator/components/com_virtuemart/classes/payment/

2. Then in administrator/components/com_virtuemart/languages/english.php add the following code:
// Beanstream Processor Text Strings
var $_PHPSHOP_ADMIN_CFG_ENABLE_BEANSTREAM_TESTMODE = 'Enable Test Mode:';
var $_PHPSHOP_ADMIN_CFG_ENABLE_BEANSTREAM_TESTMODE_EXPLAIN = 'Select \'Yes\' while testing. Select \'No\' for enabling live transactions. Must match the setting set in the Beanstrem admin area.';
var $_PHPSHOP_ADMIN_CFG_BEANSTREAM_USERNAME = 'Beanstream Merchant ID:';
var $_PHPSHOP_ADMIN_CFG_BEANSTREAM_USERNAME_EXPLAIN = 'This is your Beanstream acount id.';
var $_PHPSHOP_ADMIN_CFG_BEANSTREAM_KEY = 'Click to set secure transaction key:';
var $_PHPSHOP_ADMIN_CFG_BEANSTREAM_KEY_EXPLAIN = 'This is your Beanstream Transaction Key for signing encrypted communications. It needs to be set in the Beanstream admin area too. Set it nothing to not use the transaction key';
var $_PHPSHOP_ADMIN_CFG_BEANSTREAM_KEY_EXPLAIN2 = 'This is your Beanstream Transaction Key for signing encrypted communications';
var $_PHPSHOP_PAYMENT_BS_RECURRING = 'Use recurring billing:';
var $_PHPSHOP_PAYMENT_BS_RECURRING_TOOLTIP = 'Define wether you want recurring billings.';
var $_PHPSHOP_PAYMENT_BS_VERIFIED_BY_VISA = 'Enable Verified by Visa:';
var $_PHPSHOP_PAYMENT_BS_VERIFIED_BY_VISA_TOOLTIP = 'Use the Verified by Visa checking.'; // NOT YET BUILT
var $_PHPSHOP_PAYMENT_BS_VALIDATE_YESNO = 'Use username/password validation against transaction:';
var $_PHPSHOP_PAYMENT_BS_VALIDATE_YESNO_TOOLTIP = 'Use username/password validation against transaction. Must be enabled in the Beanstring admin area.';
var $_PHPSHOP_PAYMENT_BS_VALIDATE_USER = 'User Name:';
var $_PHPSHOP_PAYMENT_BS_VALIDATE_USER_TOOLTIP = '';
var $_PHPSHOP_PAYMENT_BS_VALIDATE_PASSWORD = 'Password:';
var $_PHPSHOP_PAYMENT_BS_VALIDATE_PASSWORD_TOOLTIP = '';
//end Beanstream Processor Text Strings


(Added by CiPHeR): look through the code til you find other payment types and insert at the end of the existing types and it will work fine. For example, I looked around line 1010 and inserted the code between Cybercash and Advanced Search:


var $_PHPSHOP_ADMIN_CFG_CYBERCASH_URL = 'CyberCash PAYMENT URL';
var $_PHPSHOP_ADMIN_CFG_CYBERCASH_URL_EXPLAIN = 'CyberCash PAYMENT URL is the URL provided by Cybercash for secure payment';
var $_PHPSHOP_ADMIN_CFG_CYBERCASH_AUTENTICATIONTYPE = 'CyberCash AUTH TYPE';
var $_PHPSHOP_ADMIN_CFG_CYBERCASH_AUTENTICATIONTYPE_EXPLAIN = 'CyberCash AUTH TYPE is the Cybercash authentication type provided by Cybercase';
// Beanstream Processor Text Strings

                insert beanstream code here

//end Beanstream Processor Text Strings
var $_PHPSHOP_ADVANCED_SEARCH = 'Advanced Search';
var $_PHPSHOP_SEARCH_ALL_CATEGORIES = 'Search All Categories';
var $_PHPSHOP_SEARCH_ALL_PRODINFO = 'Search all product info';
var $_PHPSHOP_SEARCH_PRODNAME = 'Product name only';

3. Save the file then upload to adminsitrator/components/com_virtuemart/languages/

4. Then in Virtuemart create a new payment processor and make sure to fill in the following values:
Payment Method Name: Credit Card or Visa, or Mastercard, (whatever you want to show in checkout for payment option)
Code: BS
Payment class name: ps_beanstream  (must be ps_beanstream)
Payment method type: credit card

Save the payment type then go back...

5. And fill in the information under the configuration tab

If you select username and password verification, note that you must setup a username and password in your BeanStream Account

BeanStream Account --> Administration --> Account Settings --> Order Settings

- the username and password can be anything you want, then enter that username and password in the appropriate fields

It is important to note that your settings in your Beanstream Admin MUST sync with your settings in VirtueMart

Updated: Working now with CW2 Numbers too (thanks Cipher)

6. If the ps_beanstream.php still shows this code at line 321:
            'ordName' => substr($dbbt->f("first_name"), 0, 32) . substr($dbbt->f("last_name"), 0, 32) ,

replace it with:
            'ordName' => substr($dbbt->f("first_name"), 0, 32) ." ". substr($dbbt->f("last_name"), 0, 32) ,

and the same for line 332:
            'shipName' => substr($dbst->f("first_name"), 0, 32) . substr($dbst->f("last_name"), 0, 32),

replace it with:
            'shipName' => substr($dbst->f("first_name"), 0, 32) ." ". substr($dbst->f("last_name"), 0, 32),

this fixes the order and shipping names adding a single whitespace between First and Last name

Have not tested this extensively yet, but the module does work with CVV verification, username and password is great for verifying the process is legit.  Beanstream will give you a test account to try this out, and they are fairly helpful with regards to getting you up and running.  Orders will show payment processed sucessfully in VM, and you can also track your orders in Beanstream as well as issue refunds, or void transactions - even on test account.

Beanstream seems to use the session id for the order numbers, and not the actual order number from VM - this is something jabberwock and I are looking into to see if we can get the actual order from VM to be passed, and not the session id - this will make it easier to match up orders.
Title: Re: Canadian experience with payment processors?
Post by: Anthony C. on November 14, 2006, 20:53:54 PM
Hi Chirag,


Just go to the first post and download the files from the thread.

Follow instructions then you probably will get it to setup.

Read through this topic post, usually the answers are here.


Anthony
Title: Re: Canadian experience with payment processors?
Post by: Winston Bromley on November 22, 2006, 22:39:19 PM
yes, if there is anybody who has created an INTERNET SECURE MODULE that would be great. willing to donate $$ to get this done for Canada!!!! ;)



Quote from: icw on April 28, 2006, 15:19:42 PM
Well Canucks, looks good so far...

What about a spin off towards a internetsecure payment modual.

I have an internetsecure account and have also used that of Zencart(spin off of OSC, but way way better), I'm not a programmer, but know there are many internetsecure users like that of myself and we sincerely need something like this.

VM has a great future, but todate I get the feeling it is not very Canadian or North American friendly.

I can help in testing and French translations. Currently I have a test site of Joomla and VM running in both French and English, some minor items in this regards. VM's attributes options are a dog to work with in my opinion at this point as well. Take Zencart or OSC, one product is created, attributes are added with multiple options. When using more then one language, there is only on main product and the translated version in stage with this, you add attributes and still only one product is required. VM on the otherhand ends up with parent-child products, this in terms of attributes the VM way ends up with mutiple copies of the same product in my case: product plus 4 size formats(same product, just different sizes) that in terms adds the need to translate 4 times the same product after the parent product, that is a nasty workload when you have many products in a dual language setup.




Title: Re: Canadian experience with payment processors?
Post by: floatingworld on February 20, 2007, 03:37:15 AM
I have followed the instructions but I am getting:

Error: Authorization Failed
Error: Failure in Processing the Payment (ps_beanstream)

When I confirm the order.

Does anyone have any idea?
Title: Re: Canadian experience with payment processors?
Post by: floatingworld on February 20, 2007, 04:03:54 AM
I don't know what I did, But now I get:

Error: Authorization Failed - Access lockout contact support
Error: Failure in Processing the Payment (ps_beanstream)
Title: Re: Canadian experience with payment processors?
Post by: David Millar on February 20, 2007, 17:05:30 PM
There appears to be a bug on line 51 in ps_beanstream.php

<? echo BS_LOGIN ?>

should be

<?php echo BS_LOGIN ?>
Title: Re: Canadian experience with payment processors?
Post by: floatingworld on February 20, 2007, 20:33:31 PM
One of my problems was cause by Vmart not publishing the state/provinces variable:

Got it...

For some reason, virtuemart.cfg.php was defaulting to not allowing selection of State/Province .

(line 93 was set to: define('CAN_SELECT_STATES', '');
when it should have been set to: define('CAN_SELECT_STATES', '1');

Because the server was not detecting a state, it was throwing an error.

Once I fixed this problem in the config, and added the state to the test ship-to address, everything worked great.

Thanks to koltz for posting this on another thread.

So it seems to work!!! I'm not getting a confirmation email yet- but maybe that's because it's in test mode.

Aaron
Title: Re: Canadian experience with payment processors?
Post by: Anthony C. on February 26, 2007, 23:46:56 PM
hi Aaron,

you should get a confirmation email even it is in test mode.

I am letting beanstream to test the payment module and hope it will go well.

Anthony
Title: Re: Canadian experience with payment processors?
Post by: floatingworld on February 27, 2007, 04:01:23 AM
I wonder why I'm not getting a confirmation email then? ??? The payment appears to go through....

Any ideas would be appreciated...
Title: Re: Canadian experience with payment processors?
Post by: floatingworld on February 27, 2007, 04:02:25 AM
Never mind! It seems to be working now
Title: Re: Canadian experience with payment processors?
Post by: Anthony C. on April 27, 2007, 22:10:12 PM
Are there any Canadian interested in helping with this section?

the beanstream file is working however the VbV (verified by Visa) is not implemented yet.

Can anyone help who has experiences in this part?

Thank you,

Anthony C.
Title: Re: Canadian experience with payment processors?
Post by: floatingworld on April 27, 2007, 23:25:16 PM
Are you sure that the VBV isn't working?
Title: Re: Canadian experience with payment processors?
Post by: Anthony C. on April 28, 2007, 01:33:44 AM
Hi

I am sure..
i looked into the codes
that part was commented out

how about yours? working in your site?

Anthony
Title: Re: Canadian experience with payment processors?
Post by: floatingworld on April 28, 2007, 01:51:54 AM
I'll report back soon.
Title: Re: Canadian experience with payment processors?
Post by: Anthony C. on May 02, 2007, 21:51:20 PM
Any news on the VbV function?
Just want to say hi ..  no rush to get it out.

^^ Thanks

Anthony
Title: Re: Canadian experience with payment processors?
Post by: Anthony C. on June 30, 2007, 21:54:32 PM
Seems not a lot of people are using this gateway.... 

I hope someday the VbV is avaiable  or anyone can point me to the right direction.
Title: Re: Canadian experience with payment processors?
Post by: JoeJoomla on October 31, 2007, 15:36:41 PM
Hi there,

I'm just investigating VirtueMart for possible use with Canadian websites. Lack of fully functioning Beanstream payment compatibility will be a show stopper. Where does VirtueMart sit at the moment in this regard? It appears that some of the people in this thread may know the most about it.
Title: Re: Canadian experience with payment processors?
Post by: VisiGod on April 18, 2008, 20:16:13 PM
I've been helping a client who runs a VM site with beanstream and it seems that the BS payment isn't charging the client when he checks out and uses his CC.

Does anyone have the same problem or any suggestion to this problem?
Title: Re: Canadian experience with payment processors?
Post by: Syn on July 12, 2010, 19:36:46 PM
Does this work with the lastest versions of Joomla (1.5.14 - 1.5.18) and Virtuemart (1.1.3 and 1.1.4)?