Bambora/Beanstream Payment Module Support Thread

[swguy]

Another question is we have two accounts with beanstream for CAD and USD. which Login ID should i use with this module? or will you be changing it to use both IDs or its totally optional?

If you delete the module and re-install it, you'll see there's space for both ids.

[farhansabir]

I have checked all the 3 files included with the module. Only one file uses TABLE_BEANSTREAM i.e, /includes/modules/payment/beanstream.php as:

  
// Insert the data into the database
$sql = "insert into " . TABLE_BEANSTREAM . "  (id, customer_id, order_id, response_code, response_text, authorization_type, transaction_id, sent, received, time, session_id) values (NULL, :custID, :orderID, :respCode, :respText, :authType, :transID, :sentData, :recvData, :orderTime, :sessID )";

Other than that, TABLE_BEANSTREAM has not been defined or used anywhere. Could you please review? May be there is another file but its not included in the download of Apr 05, 2009?

Thanks
Farhan Sabir
CIGear.com

[swguy]

Turn the "Enable Database Storage" flag in admin off. It's not supported yet.

[farhansabir]

[FONT=Arial]Another Issue: The transaction of our Australian customers get declined with the response text [/FONT][FONT=&quot][FONT=Arial]"Response Text: Select your state/province".

Beanstream is telling me if the country is not US or Canada, the state/province has to be "--" (two dashes). Otherwise our system does not accept the transaction at all. Looks really strange, the country is not US or Canada, but province is there (as entered by the customer). But beanstream would just decline (actually REJECT) the transaction and wont process at all.

It hard to argue with them, as they say we cannot modify our system for one merchant, you have to change the way you submit the transactions. Change ordProvince to -- and then submit it.

Can you help with that?

Regards
Farhan
PS: In authorize.Net module, we had the card information with us. So if the customoer calls back for another order and asks to charge the same card, we can still do it from his previous data. Question: Is there a way to have a similar method of storing credit card information while submitting it to Beanstream?
[/FONT]

[/FONT]

[DrByte]

NOTE: I've NOT tested this, so I'm not entirely certain the net effect on addresses in Canada and US (so, be sure to test those in addition to your Australia address) ... Try the following on your test site:

At line 290 of the module file, you'll see this:

    if (strlen($order->billing['state']) > 2) {

Try changing it to this:

    if (strlen($order->billing['state']) > 2 && $province_code_order != '--') {

[farhansabir]

Thank you so much for that DrByte! The solution seems to work fine. I have tried an Australian billing address with full state/province name as well as 2-letter state. Both went through to Beanstream. Previously it was not being processed at all.

Being the original author, would you be able to fix the database issue as well? :-)

Regards
Farhan Sabir
CI Gear

[DrByte]

Being the original author, would you be able to fix the database issue as well? :-)

Already did ... new version was posted last week in the addons area.
You'll have to make the above code change to that version also.

[kramerr]

I have installed the Beanstream Payment Module into my Zen Cart. When I try and do a test transaction, an error comes up saying. "(0) Invalid merchant id (merchant_id = 0) - Your credit card could not be authorized for this reason. Please correct the information and try again or contact us for further assistance."

What could the problem be and what is the fix????

[soxophoneplayer]

I am looking over Beanstreams application forms. There is a check off box for API integration to select either SOAP or Server to Server.

Which would I check off?

ZC1.3.8a; SLL signed certificate on shared DreamHost server. Currently using Paypal Standard, CC offline mod, money order. Canadian site.

[numinix]

NOTE: I've NOT tested this, so I'm not entirely certain the net effect on addresses in Canada and US (so, be sure to test those in addition to your Australia address) ... Try the following on your test site:

At line 290 of the module file, you'll see this:

    if (strlen($order->billing['state']) > 2) {

Try changing it to this:

    if (strlen($order->billing['state']) > 2 && $province_code_order != '--') {

This really should be in the module. I can confirm it is the solution.

It also needs this:

if (strlen($order->delivery['state']) > 2 && $province_code_ship != '--') {