Bambora/Beanstream Payment Module Support Thread

05 Apr 2009, 17:02

#1

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Bambora/Beanstream Payment Module Support Thread

The Beanstream Payment Module has been enhanced to allow USD as well as CAD payments. If this feature is important to you, please download the latest version (1.03 as of today) here:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=867

Database changes have been made in this version, so you must go to Admin->Modules->Payment, make note of your existing settings, and then remove and re-install this module.

That Software Guy

08 Apr 2009, 14:37

#2

farhansabir

New Zenner

Join Date:: Feb 2008
Posts:: 29
Plugin Contributions:: 0

Re: Bambora/Beanstream Payment Module Support Thread

I get the following error on test transaction:

1146 Table 'xxxxxxxxxx.TABLE_BEANSTREAM' doesn't exist
in:
[insert into TABLE_BEANSTREAM (id, customer_id, order_id, response_code, response_text, authorization_type, transaction_id, sent, received, time, session_id) values (NULL, 4, 0, 0, 'Invalid card CVD
', 'P', '0 Order Number Code: ', 'Array\n(\n [merchant_id] => *******\n [username] => *******\n [password] => *******\n [RequestType] => BACKE

Where xxxxxxxxxx is our db name. pasted just the initial part. do we need a dollar ($) sign with TABLE_BEANSTREAM or did i miss some installation step??

Regards
Farhan

08 Apr 2009, 14:43

#3

farhansabir

New Zenner

Join Date:: Feb 2008
Posts:: 29
Plugin Contributions:: 0

Re: Bambora/Beanstream Payment Module Support Thread

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?

08 Apr 2009, 22:36

#4

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Bambora/Beanstream Payment Module Support Thread

If it's literally saying TABLE_BEANSTREAM, that indicates that you've missed uploading one or more files, where TABLE_BEANSTREAM is actually defined.

09 Apr 2009, 00:38

#5

swguy

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Re: Bambora/Beanstream Payment Module Support Thread

farhansabir:
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.

09 Apr 2009, 20:43

#6

farhansabir

New Zenner

Join Date:: Feb 2008
Posts:: 29
Plugin Contributions:: 0

Re: Bambora/Beanstream Payment Module Support Thread

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

09 Apr 2009, 23:32

#7

swguy

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Re: Bambora/Beanstream Payment Module Support Thread

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

15 Apr 2009, 14:07

#8

farhansabir

New Zenner

Join Date:: Feb 2008
Posts:: 29
Plugin Contributions:: 0

Re: Bambora/Beanstream Payment Module Support Thread

Another Issue: The transaction of our Australian customers get declined with the response text [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]

15 Apr 2009, 14:33

#9

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Bambora/Beanstream Payment Module Support Thread

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 != '--') {

15 Apr 2009, 16:12

#10

farhansabir

New Zenner

Join Date:: Feb 2008
Posts:: 29
Plugin Contributions:: 0

Re: Bambora/Beanstream Payment Module Support Thread

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

15 Apr 2009, 16:44

#11

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Bambora/Beanstream Payment Module Support Thread

farhansabir:

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.

23 Apr 2009, 14:49

#12

farhansabir

New Zenner

Join Date:: Feb 2008
Posts:: 29
Plugin Contributions:: 0

Re: Bambora/Beanstream Payment Module Support Thread

I appreciate your help.

There are a couple of problem. An order submitted from QC, Canada was rejected by Beanstream because the State/Province field was "--". The module somehow converted the state to --. Not sure why.

The module is not reliable enough to be online. So i have made the default credit card processing option active and disabled the beanstream module. Instead of letting customers go for some reason, its better to charge the credit cards offline.

I hope the module become flawless soon,

Regards
Farhan Sabir
www.CIGear.com

02 May 2009, 23:44

#13

swguy

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Re: Bambora/Beanstream Payment Module Support Thread

Just ran a test order with an address from Quebec and it worked fine. Not sure what the problem you had was. Can you duplicate it?

11 May 2009, 20:52

#14

markpr9

New Zenner

Join Date:: Dec 2007
Posts:: 54
Plugin Contributions:: 0

Re: Bambora/Beanstream Payment Module Support Thread

If the shipping address is from outside US or CAN the card will still be rejected...

12 May 2009, 03:33

#15

markpr9

New Zenner

Join Date:: Dec 2007
Posts:: 54
Plugin Contributions:: 0

Re: Bambora/Beanstream Payment Module Support Thread

Would you guys be able to modify the way the module sends shipping info to beanstream as well?

12 May 2009, 05:17

#16

swguy

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Re: Bambora/Beanstream Payment Module Support Thread

First question: just ran a test order to Barbados, worked fine. What country are you going to, and what code are you getting back?
Second question: unlikely- their API defines how data is sent.

29 Jun 2009, 23:20

#17

crystal_girl

New Zenner

Join Date:: Jun 2009
Posts:: 6
Plugin Contributions:: 0

Re: Bambora/Beanstream Payment Module Support Thread

Hi there,

I am using Zen-Cart v1.3.8a and am trying to set up my Beanstream account to work with ZenCart. I have Zen Cart installed into my new (non public) Joomla 1.5.11 website and I am using the Cartage v2.1 component to display my ZenCart within Joomla.

I am not using Beanstream's API - instead I am using their hosted payment form - since I don't want the hassle and liability of collecting Credit Card information.

I can't see anywhere in the Beanstream module to tell it to use Beanstream's hosted payment form instead of the API. Do I need to download a different module?

Attached is the integration guide PDF from Beanstream in regards to the hosted payment page.

Please tell me what I am doing wrong! :frusty:

Thanks!

Crystal

29 Jun 2009, 23:48

#18

swguy

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Re: Bambora/Beanstream Payment Module Support Thread

The hosted payment form is not supported.

29 Jun 2009, 23:53

#19

crystal_girl

New Zenner

Join Date:: Jun 2009
Posts:: 6
Plugin Contributions:: 0

Re: Bambora/Beanstream Payment Module Support Thread

Thanks for the reply but it's not very helpful. Can you point me anywhere where I might get help or more info on this particular style of payment?

Thanks,

Crystal

04 Jul 2009, 05:30

#20

kramerr

New Zenner

Join Date:: Jun 2009
Posts:: 50
Plugin Contributions:: 0

Re: Bambora/Beanstream Payment Module Support Thread

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????