Bambora/Beanstream Payment Module Support Thread

[kramerr]

I think I have found part of the problem. When I put my Merchant ID # in both the CAN and US fields, then everything works. However, I only have the CAN Merchant ID #. Is there any way to disable the US Merchant ID field and still allow the CAN to work ??

[scrappind]

I just installed the Beanstream payment module and am getting the erroro message:

(0) Invalid transaction amount - Your credit card could not be authorized for this reason. Please correct the information and try again or contact us for further assistance.

I entered my merchant number into both the CDN & USD merchant account numbers and it did not fix the problem.

This is the error from beanstream:

&username=&password=&RequestType=BACKEND&trnLanguage=en&trnType=PA&paymentMethod =CC&trnOrderNumber=10433-9nwh1p&trnCardOwner=Beanstream+Test&trnCardNumber=6223E679C21E2980A8FDE82B817991 57&trnExpMonth=01&trnExpYear=11&trnCardCvd=xxx&trnAmount=0.00&ordItemPrice=0.00& ordShippingPrice=0.00&ordTax1Price=0.00&ordName=Beanstream+Test&ordAddress1=302-2659+XXXXXX+Street&ordAddress2=&ordCity=Victoria&ordProvince=BC&ordPostalCode=XX XXXX&ordCountry=CA&ordPhoneNumber=888-XXX-0811&ordEmailAddress=support%40beanstream.com&shippingMethod=Free+Shipping&trnCo mments=Website+Order&ref1=4276&ref2=October+13%2C+2009%2C+8%3A50+pm&ref3=142.XXX .103.55&ref4=5e345cab237530e1e3203bed0ddd4798&prod_id_1=2069%3A07290311816978a5911d10f53e7&pr od_name_1=AASD9835+Fall+Kids+Clip+Art+Download&prod_quantity_1=1&prod_cost_1=0.0 0&prod_id_2=2020%3A77e2381e4b7e79e9e7e342cceae&prod_name_2=ATWH4646+Halloween+Co okies+Clip+Art+Download&prod_quantity_2=1&prod_cost_2=0.00&prod_id_3=1553%3A543a b0610c485d7ec0a5310ba73&prod_name_3=Lemonade+Download&prod_quantity_3=1&prod_cos t_3=0.00

You can see in the highlighted sections the amounts being sent to them (trnAmount is what we actually charge), plus all of the product info, such as sku, the name, the qty, and the cost. The cart is spitting out a cost of $0 per item, which calculated out comes to $0 to charge.

Any help would be greatly appreciated.

(XXXXX added for privacy)

[swguy]

I have started working on Interac support for Canadian merchants. I'm hoping to have this completed before US Thanksgiving. Thank you for your patience. A new support thread will be created since it will be a separate module.

A new version of the Beanstream Payment module will be available shortly; this version posts the customer's IP address, which Beanstream will use for risk scoring in the future.

Thanks,
Scott

[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.

[DrByte]

Server To Server.

And, make sure you tell them you were referred to them by Zen Cart! I think there's a spot on the last page for that.

[soxophoneplayer]

Thanks Dr Byte; I told them I was a ZC ref when I emailed for info, and when they called; and will tell them again when I follow up ;o)

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

[numinix]

There are further bugs in the code that should be updated.

Find:

$province_code_order = (in_array($order->billing['country']['iso_code_2'], array('CA', 'US')) ? zen_get_zone_code($order->billing['country']['id'], $order->billing['state'], '--') : '--'); 

Replace With:

$province_code_order = (in_array($order->billing['country']['iso_code_2'], array('CA', 'US')) ? zen_get_zone_code($order->billing['country']['id'], $order->billing['zone_id'], $order->billing['state']) : '--'); 

Find:

$province_code_ship = (in_array($order->delivery['country']['iso_code_2'], array('CA', 'US')) ? zen_get_zone_code($order->delivery['country']['id'], $order->delivery['state'], '--') : '--'); 

Replace With:

$province_code_ship = (in_array($order->delivery['country']['iso_code_2'], array('CA', 'US')) ? zen_get_zone_code($order->delivery['country']['id'], $order->delivery['zone_id'], $order->delivery['state']) : '--'); 

[GreggG]

I'm trying to set up the Beanstream payment module in Zen Cart 1.5.4, Apache 2.2.29, Curl 7.12.1, MySQL 5.5.42-37.1, PHP 5.4.43.

Everything seems to be functioning well until I hit the final Confirm button to submit the order for processing. I get an error 324 and the prompt: "Error (324) Order quantity for product '5' greater then quantity available - Your credit card could not be authorized for this reason. Please correct the information and try again or contact us for further assistance."

I have verified that there is sufficient quantity of the product in stock and that the inventory on the Beanstream account site is empty. Beanstream support is asking for the exact query string I'm using to generate the request. Where would I find that? It's not kept in the debug files (just the response from the Beanstream server, which I had already provided) nor in the MySQL db, even with "Enable Database Storage" enabled. Can anyone help?

[swguy]

So the Beanstream guys say they know about this issue and anticipate the fix being ready first week of September.