-
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?ma...roducts_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
-
Re: 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
-
Re: 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?
-
Re: 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.
-
Re: Beanstream Payment Module Support Thread
Quote:
Originally Posted by
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.
-
Re: 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:
Code:
// 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
-
Re: Beanstream Payment Module Support Thread
Turn the "Enable Database Storage" flag in admin off. It's not supported yet.
-
Re: Beanstream Payment Module Support Thread
[FONT=Arial]Another Issue: The transaction of our Australian customers get declined with the response text [/FONT][FONT="][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]
-
Re: 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:
Code:
if (strlen($order->billing['state']) > 2) {
Try changing it to this:
Code:
if (strlen($order->billing['state']) > 2 && $province_code_order != '--') {
-
Re: 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
-
Re: Beanstream Payment Module Support Thread
Quote:
Originally Posted by
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.
-
Re: 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
-
Re: 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?
-
Re: Beanstream Payment Module Support Thread
If the shipping address is from outside US or CAN the card will still be rejected...
-
Re: Beanstream Payment Module Support Thread
Would you guys be able to modify the way the module sends shipping info to beanstream as well?
-
Re: 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.
-
1 Attachment(s)
Beanstream hosted payment module?
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
-
Re: Beanstream Payment Module Support Thread
The hosted payment form is not supported.
-
Re: 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
-
Re: 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????
-
Re: Beanstream Payment Module Support Thread
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 ??
-
Re: Beanstream Payment Module Support Thread
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.
-
Re: Beanstream Payment Module Support Thread
Server To Server.
And, make sure you tell them you were referred to them by Zen Cart! :blush: I think there's a spot on the last page for that.
-
Re: Beanstream Payment Module Support Thread
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)
-
Re: Beanstream Payment Module Support Thread
Could anyone please tell me where I should expect to find the transaction log file when I enable the "debug mode" -> "log file" option?
Also, I tried to enable the database storage option in version 1.04 which I just upgraded to, and after successfully performing a transaction on the server using the beanstream payment module, I don't see any new tables anywhere in the database to are storing these transaction records.
Documentation around this module is a little sparse, so could someone please let me know where these can be found? Once in a blue moon, my client has an order that fails... the transaction is successfully processed via the merchant gateway, but there's absolutely no record of the purchase within Zencart itself, so I need some extra logging going to figure out what's happening.
Thanks in advance!
-Justin
-
Re: Beanstream Payment Module Support Thread
Ok - I'm a goof.. I was looking at my dev database rather than my production one, which answers the question of where my transaction log table got to...
However, I am still a little bit puzzled by what/where the "debug log" leaves its messages. Any help on that one would still be appreciated.
Thanks again!
-
Re: Beanstream Payment Module Support Thread
Look in your site's /cache/ folder.
-
Re: Beanstream Payment Module Support Thread
I have having trouble with my beanstream payment module. After trying everything in this thread, I am still getting the following error message:
# Error (0) State/province does not match country
# Shipping state/province does not match country
- Your credit card could not be authorized for this reason. Please correct the information and try again or contact us for further assistance.
I am using Zen Cart version v1.3.8a and BeanstreamCanada_v1.04 and I think I have correctly setup the countries and provinces correctly.
Any directions would be greatly appreciated.
my site is http://ltchealthcorp.com/drspenser/
Thank you.
freshweb
-
Re: Beanstream Payment Module Support Thread
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)
-
Re: Beanstream Payment Module Support Thread
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
-
Re: Beanstream Payment Module Support Thread
First completed transaction run with Interac. Looks good so far - admin->customers->order, email, my account all look correct.
-
Re: Beanstream Payment Module Support Thread
I was missing a step which only becomes obvious when you look at your interac account; the actual payment transfer had not yet been done. It's a multi-step process.
You can see the final confirm being shown on the checkout success page in this image:
http://thecartblog.com/2009/11/05/in...-success-page/
Interac is very fussy about this - you have to show it in this format.
I still have to do refunds.
-
Re: Beanstream Payment Module Support Thread
Thanks for working on this!
-
Re: Beanstream Payment Module Support Thread
You can see what the refund dialog looks like in Admin->Customers->Orders.
http://thecartblog.com/2009/11/07/in...s-in-zen-cart/
Testing is close to complete.
-
Re: Beanstream Payment Module Support Thread
That is great. This mod is one that I have been waiting for for a long time.
-
Re: Beanstream Payment Module Support Thread
LOL! Just as notification of your post arrived, I was bugging the Beanstream guys to set up the test account for refunds so I can test that out. It's pretty close to complete.
-
Re: Beanstream Payment Module Support Thread
Refunds have been verified. I just sent the completed package to the Zen Cart guys for verification; once that's complete they will make it available.
When you open your Interac account, please remember to tell Beanstream that "The Zen Cart guys sent me!" This helps support the project.
Once the download is available, I will create a separate support thread, since this is a separate payment module.
-
Re: Beanstream Payment Module Support Thread
SWGuy.....you are the man !!!!
-
Re: Beanstream Payment Module Support Thread
-
Re: Beanstream Payment Module Support Thread
Back to the Beanstream Payment Module:
We're looking at adding Master Card SecureCode and Verified by Visa support. Stay tuned!
-
Re: Beanstream Payment Module Support Thread
Hi all,
I'm new to Zen Cart and everything to do with setting up a merchant account and I need some help.
I've got the site setup (not completely finished). I have the Beanstream Credit Card Module installed. I have the BeanStream Interac Module installed.
Beanstream is now looking for some information from me with regards to the Interac Module that I cannot find.
They are asking for the URLs for the funded/non-funded/refferrer. They are saying they are part of the setup but I cannot find anything like that anywhere... in Zen Cart or the Interac Module.
Is there anyone who might be able to shed some light on this for me?
Thanks!
Rene
-
Re: Beanstream Payment Module Support Thread
See lines 29-31 in the readme file.
-
Re: Beanstream Payment Module Support Thread
Please also be sure to tell the Beanstream guys that you were sent to them by Zen Cart. This helps the project.
-
Re: Beanstream Payment Module Support Thread
I'm trying to get a ZenCart up and running. I'm using the Beanstream Interac and Credit Card Modules.
Beanstream needs some information that I cannot find. They are asking the following: " If you’re using the ZenCart IOP module, I’ll need the urls for funded/non-funded/referrer that are part of the setup."
Anybody have anything to offer?
Thanks!
Rene
-
Re: Beanstream Payment Module Support Thread
You'll find that information in the documentation files that are part of the Beanstream Interac module zip file.
-
Re: Beanstream Payment Module Support Thread
Quote:
Originally Posted by
renej
I'm trying to get a ZenCart up and running. I'm using the Beanstream Interac and Credit Card Modules.
Beanstream needs some information that I cannot find. They are asking the following: " If you’re using the ZenCart IOP module, I’ll need the urls for funded/non-funded/referrer that are part of the setup."
Anybody have anything to offer?
Thanks!
Rene
:oops:
Ooops... I been away and totally forgot that I already posted this. I knew I had to do it but the mind totally failed me this time! :) Thanks for the previous reply!!!
Rene
-
Re: Beanstream Payment Module Support Thread
BeanStreamers: The next item on my todo list is to add support for 3DSecure (MasterCard SecureCode and Verified by Visa) to Beanstream. Stay tuned!
-
Re: Beanstream Payment Module Support Thread
I'm getting errors when trying to use the Beanstream plugin. I wrote a Beanstream interface myself in the past so I know my Beansream test account is configured in a way that works. My first error was this:
"Transaction Declined. Restricted transaction type"
To fix that, I had to alter my Beanstream account to "allow both purchase and pre-auth transactions"
What is the plugin doing to make this necessary and can I disable it?
Now I'm getting this error:
"Username/Password or hash validation required for this request"
I have no username, password set up in my Beanstream account nor do I have one set up in my zen-cart admin so why is it required?
-
Re: Beanstream Payment Module Support Thread
I think they require it now. Try adding it to your Beanstream account and to your zen admin.
-
Re: Beanstream Payment Module Support Thread
Quote:
Originally Posted by
swguy
I think they require it now. Try adding it to your Beanstream account and to your zen admin.
That solved the problem but that would break existing web sites if they suddenly decided it was a requirement.
I have a working implementation of a Beanstream interface (not for Zen Cart) and this is the first I've even heard of this requirement so I'm wondering if the zen-cart beanstream plugin is sending a form field that triggers this requirement. Perhaps the transaction password and user id are being sent even if they are blank and that's triggering the requirement?
-
Re: Beanstream Payment Module Support Thread
The Beanstream folks just contacted me and said this issue was caused by a side effect of another change. It seems like you should set userid & pass for now until the issue is resolved.
-
1 Attachment(s)
Re: Beanstream Payment Module Support Thread
Important message from Beanstream Support: Refer to attached image
A (Restrict Internet Transaction Processing Types) needs to be unchecked, and B (use username/password validation against transaction) needs to be checked and filled in to match the settings in ZenCart Admin. This is also the way to enable voids/returns. This effects all transactions, IOP included.
-
Re: Beanstream Payment Module Support Thread
I found some information at this link as well:
https://beanstreamsupport.pbworks.co...-API-Passcodes
It looks like some sort of online FAQ page for Beanstream, maybe something on this page that will explain it, although I don't understand the hash thing.
-
Re: Beanstream Payment Module Support Thread
ok...I've installed the Beanstream =module and I've been to my account on their site. From what I'm told, we have to configure the receipt to look whatever way we want it to. Now how do I get the payment forms to look like the one that Zencart produces out of the box (with my header logo of course)?:dontgetit
-
Re: Beanstream Payment Module Support Thread
You don't need to worry about this. It's all taken care of.
-
Re: Beanstream Payment Module Support Thread
Ok.
I tried using one of the test numbers with a $100.00 limit for a $60.00 purchase. Got all the way down to checkout and I get the following error message:
Email Error: Could not instantiate mail function. Please check Admin->Configuration->Email Options->Email Transport.
I have made no changes to email transport. It is still set to PHP. suggestions?:dontgetit
-
Re: Beanstream Payment Module Support Thread
Is there something additional that I need to configure somewhere on the beanstream side, or in Zencart?
-
Re: Beanstream Payment Module Support Thread
another question I have pertains to setting the taxes on the beanstream side. if my business is in Ontario, I do not want to charge PST or HST to out of province customers, only GST. In Ontario, I must charge HST. Out of country customers do not get charged taxes. How do I configure this?
Thanks in advance for your help.
-
Re: Beanstream Payment Module Support Thread
Follow the instructions in the readme. If you're having email trouble with this, I suspect you will have it with other modules too; you'll need to resolve that by searching the forum for info on that.
-
Re: Beanstream Payment Module Support Thread
I have no problems with email other than this. The site has been active for several years, and I just received a new order email notification a few minutes ago (I've disabled beanstream for the time being until I can figure out what to fix).
-
Re: Beanstream Payment Module Support Thread
reread the readme and double-checked that I did everything as stated. No change.:dontgetit
-
Re: Beanstream Payment Module Support Thread
Comment out the call to zen_mail in includes/modules/payment/beanstream.php to stop this from happening. Look at the log in your cache directory and see what it tells you.
-
Re: Beanstream Payment Module Support Thread
I did as you suggested., then attempted a 16.00 purchase using the test VIsa account num bers provided with a 100.00 limit.
I get the following in a big red box at the top of the screen above the terms and Conditions box
Home :: Checkout - Step 1 :: Payment Method - Step 2
Step 2 of 3 - Payment Information
(319) Transaction Declined. Restricted transaction type. - Your credit card could not be authorized for this reason. Please correct the information and try again or contact us for further assistance.
Terms and Conditions
Please acknowledge the terms and conditions bound to this order by ticking the following box. The terms and conditions can be read here.
I have read and agreed to the terms and conditions bound to this order.
Is this what should have happened?
-
Re: Beanstream Payment Module Support Thread
In the literature I thought it said that the sample Visa number I used was an approved card with a 100.00 limit. Should my transaction have gone all the way to the end as though it were real, or is that screen message supposed to happen?:frusty:
-
Re: Beanstream Payment Module Support Thread
I sent you the log file in a private message. Worried about confidential info in public view. Let me know if you want any of it posted here.
-
Re: Beanstream Payment Module Support Thread
You're using Authorize; you need to use Authorize + Capture for test transactions.
-
Re: Beanstream Payment Module Support Thread
thanks for the clarification. I will change that. I had thought that capture meant to "capture" credit card info into the database which I thought we weren't supposed to do anymore. My bad. when I go "live" shoud I change it back to it's current setting of authorize?
What about my original email question. Was your suggestion to comment out that zen_mail line, the solution to the error or a troubleshooting tactic?
Thanks for your help.
-
Re: Beanstream Payment Module Support Thread
excellent! Changing it to Authorize and capture elliminated the error and the sale completes. :clap: Thank You!:bigups:
My only remaining question at this point is about the original email problem. I've commented out the line calling zen_mail that you recommended earlier. Just need to know if I need to leave it like that or if there's anything else I have to do.:blink::blush:
-
Re: Beanstream Payment Module Support Thread
-
Re: Beanstream Payment Module Support Thread
HI SWGuy,
When you have a spare moment, I need an answer to my earlier question determine if I can go online or not. Beanstream is patiently waiting to hear from me.
Quote:
Originally Posted by
highlander
excellent! Changing it to Authorize and capture elliminated the error and the sale completes. :clap: Thank You!:bigups:
My only remaining question at this point is about the original email problem. I've commented out the line calling zen_mail that you recommended earlier. Just need to know if I need to leave it like that or if there's anything else I have to do.:blink::blush:
-
Re: Beanstream Payment Module Support Thread
Yes - this was just preventing the sending of an error email.
-
Re: Beanstream Payment Module Support Thread
thanks a bunch big guy! Should I leave it set to authorize and capture when I go live?
Quote:
Originally Posted by
swguy
Yes - this was just preventing the sending of an error email.
-
Re: Beanstream Payment Module Support Thread
Yes - this is how you will get paid.
-
Re: Beanstream Payment Module Support Thread
Great. Thanks for your help! :cheers:
-
Re: Beanstream Payment Module Support Thread
One final hurdle to overcome SWGUY.
I use the Canada post shipping module and have the latest upgrade to that add-on installed. When Beanstream did their testing, they received the following error message when checking out:
Shipping method must be less than 64 characters
- Your credit card could not be authorized for this reason.
I don't understand. Any suggestions?:frusty:
-
Re: Beanstream Payment Module Support Thread
ok, on a hunch...I edited the Canadapost.php to stop showing the estimated delivery date as shown in an early post, and now I get a different error:
() Communications Error - Please notify webmaster. - Your credit card could not be authorized for this reason. Please correct the information and try again or contact us for further assistance.
any ideas?:huh:
Quote:
Originally Posted by
highlander
One final hurdle to overcome SWGUY.
I use the Canada post shipping module and have the latest upgrade to that add-on installed. When Beanstream did their testing, they received the following error message when checking out:
Shipping method must be less than 64 characters
- Your credit card could not be authorized for this reason.
I don't understand. Any suggestions?:frusty:
-
Re: Beanstream Payment Module Support Thread
This is the reply I got from Beanstream:
Quote:
Whoever is taking care of setting up your shopping cart checkout needs to look into why they are reporting error when the transactions are being approved in Beanstream.
Regards
Is this something that you can look into SWGUY?
-
Re: Beanstream Payment Module Support Thread
You should be putting a request on the commercial help wanted forum for someone to look after your cart.
-
Re: Beanstream Payment Module Support Thread
Are you saying that there is no setting or anything within the Beanstream module or zencart, that could be causing the faulty communication error?
-
Re: Beanstream Payment Module Support Thread
Any updates/mods to the module for 1.3.9h?
Just trying to stay secure...
Thanks for this payment module!
-
Re: Beanstream Payment Module Support Thread
No changes in 1.3.9x required.
-
Re: Beanstream Payment Module Support Thread
This error message was posted previously on this thread but no one has answered it.
Using Zencart and Beanstream, I received this email from a customer
"When trying to confirm an order the site responds with:
Step 2 of 3 - Payment Information
# Error (0) Select your state/province
# Invalid shipping province
- Your credit card could not be authorized for this reason. Please correct
the information and try again or contact us for further assistance.
I put my state information in as QLD then Queensland but both times it came
up with this message.
I am trying to get the order send to QLD Australia. Can you please let me
know what I need to do?"
I tried to send the item myself and I came up with the same error message. Tried to change some things about the shipping address (after reading about the Du Bois problem) but nothing worked.
Any ideas?
-
Re: Beanstream Payment Module Support Thread
I am in the application process with Beanstream. I was wanting to use their hosted payment page... does this module help me do that? If not, is it hard to integrate?
-
Re: Beanstream Payment Module Support Thread
Quote:
Originally Posted by
laurahowes
I am in the application process with Beanstream. I was wanting to use their hosted payment page... does this module help me do that?
No - this is not for the hosted payment page.
-
Re: Beanstream Payment Module Support Thread
Quote:
Originally Posted by
swguy
No - this is not for the hosted payment page.
Thank you for your response, swguy!
You may see a PM from me if I can't figure it out... :P
-
Re: Beanstream Payment Module Support Thread
Hi swguy
I want to use the BeanStream hosted payment page, where BS info says to insert url of their payment page into zencart file but they cannot tell me where to put it, and I cannot figure it out.
The way I want it to work is that after prices+tax+shipping totals, the continue button should being me to the BS page and not to a Zen payment page. I also do not want to capture or store any customer information.
I can navigate the php files and can cut and paste as necessary if I only knew where.
Can you please help?
I am using Zen 1.3.9, hosted on godaddy.
-
1 Attachment(s)
Re: Beanstream Payment Module Support Thread
Customer reported a problem placing an order the other day. Other customers orders are coming through ok.
the error message is attached. I have spoken with Beanstream and they have found the cause. I've attached their findings below. Can you figure out a way to resolve this?
reply from Beanstream, newest is at top, oldest at bottom:
************************
Hi,
############################## Yes, it looks like the Beanstream module is pulling in the full text for the shipping option selected by the customer. I don’t know if you could fix this by adjusting your shipping options or if you have to look for help with the Beanstream module on the ZenCart forums.
Thanks,
Mike

Subject: Re: Processing error?
Thanks !! I guess that means that the issue is with the beanstream module in zencart?
Cheers,
Rob
On 2011-06-25, at 12:43 PM, Michael wrote:
Hi,
I’ve figured it out. The problem is the text being attached to our shippingMethod variable through the ZenCart module. Review my log extraction below, as you can see the URL encoded version of the text from your shipping module is over our 64 character limit for the shippingMethod variable. The problem is the special characters and white spaces must be URL encoded which adds an extra 20-30 characters.
URL Encoded:
&shippingMethod=Canada+Post+%3C%21--%281+box%28es%29%29--%3E+%28Small+Packets+Air%2C+up+to+2+weeks%29
Variable data = 85 characters
Decoded:
&shippingMethod=Canada Post <!--(1 box(es))--> (Small Packets Air, up to 2 weeks)
Variable data = 55 characters without spaces and 65 characters with spaces
Thanks,
-
Re: Beanstream Payment Module Support Thread
-
Re: Beanstream Payment Module Support Thread
Quote:
Originally Posted by
swguy
BeanStreamers: The next item on my todo list is to add support for 3DSecure (MasterCard SecureCode and Verified by Visa) to Beanstream. Stay tuned!
Hi, wonder what the status of this update is.
We are using Beanstream and have had to enable Verified by Visa and Mastercard SecureCode, and this has completely broken the shopping cart checkout process. We definitely do not want to roll back the security.
Our site is Zencart 1.39h, with Wordpress on Zencart and some FedEx modules. It worked properly until the security measures were put in place.
I've emailed you as well, and look forward to hearing back on this topic.
Thanks again.
-
Re: Beanstream Payment Module Support Thread
I'm not sure when I'll get to it.
-
Re: Beanstream Payment Module Support Thread
Quote:
Originally Posted by
swguy
I'm not sure when I'll get to it.
Still looking forward to your reply to my email. We're interested in a quote, at very least.
Thanks,
Patrick Keenan
-
Re: Beanstream Payment Module Support Thread
Hi
I've been a long time lurker here and on my site, http://www.naturallytots.com, I encountered a problem that I noticed was not really answered here.
I recently got an order from Australia and the order was rejected.
After seeing on page 1 of this thread that Beanstream requires the province to be "--" if the country is not Canada or US, I finally figured out this change.
In beanstream.php, at line 290 change:
Code:
if (strlen($order->billing['state']) > 2) {
$sql = "SELECT zone_code FROM " . TABLE_ZONES . " WHERE zone_name = :zoneName";
$sql = $db->bindVars($sql, ':zoneName', $order->billing['state'], 'string');
$state = $db->Execute($sql);
$province_code_order = (!$state->EOF) ? $state->fields['zone_code'] : '--';
}
$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'], '--') : '--');
if (strlen($order->delivery['state']) > 2) {
$sql = "SELECT zone_code FROM " . TABLE_ZONES . " WHERE zone_name = :zoneName";
$sql = $db->bindVars($sql, ':zoneName', $order->delivery['state'], 'string');
$state = $db->Execute($sql);
$province_code_ship = (!$state->EOF) ? $state->fields['zone_code'] : '--';
}
to
Code:
if (in_array($order->billing['country']['iso_code_2'], array('CA','US'))) {
if (strlen($order->billing['state']) > 2 ) {
$sql = "SELECT zone_code FROM " . TABLE_ZONES . " WHERE zone_name = :zoneName";
$sql = $db->bindVars($sql, ':zoneName', $order->billing['state'], 'string');
$state = $db->Execute($sql);
$province_code_order = (!$state->EOF) ? $state->fields['zone_code'] : '--';
}
}
$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'], '--') : '--');
if (in_array($order->delivery['country']['iso_code_2'], array('CA','US'))) {
if (strlen($order->delivery['state']) > 2 ) {
$sql = "SELECT zone_code FROM " . TABLE_ZONES . " WHERE zone_name = :zoneName";
$sql = $db->bindVars($sql, ':zoneName', $order->delivery['state'], 'string');
$state = $db->Execute($sql);
$province_code_ship = (!$state->EOF) ? $state->fields['zone_code'] : '--';
}
}
The lines
Code:
$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'], '--') : '--');
and
Code:
$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'], '--') : '--');
assign "--" as the billing and shipping province if the billing and shipping province is not Canada or US.
The IF statements I added above ensure that the province code, which is assigned by the SQL statements from lines 291 to 293 and 298 to 300, only happens if the country is Canada or US.
I noticed without these extra IF statements, even though the province/state is set to "--", the SQL statements reassign it back to QLD (for Queensland state in my case) which will cause Beanstream to reject the transaction.
This code change seems to work. It probably needs more testing though.
-
Re: Beanstream Payment Module Support Thread
Quote:
Originally Posted by
chmod755
Hi
I've been a long time lurker here and on my site,
http://www.naturallytots.com, I encountered a problem that I noticed was not really answered here.
I recently got an order from Australia and the order was rejected.
After seeing on page 1 of this thread that Beanstream requires the province to be "--" if the country is not Canada or US, I finally figured out this change.
In beanstream.php, at line 290 change:
Code:
if (strlen($order->billing['state']) > 2) {
$sql = "SELECT zone_code FROM " . TABLE_ZONES . " WHERE zone_name = :zoneName";
$sql = $db->bindVars($sql, ':zoneName', $order->billing['state'], 'string');
$state = $db->Execute($sql);
$province_code_order = (!$state->EOF) ? $state->fields['zone_code'] : '--';
}
$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'], '--') : '--');
if (strlen($order->delivery['state']) > 2) {
$sql = "SELECT zone_code FROM " . TABLE_ZONES . " WHERE zone_name = :zoneName";
$sql = $db->bindVars($sql, ':zoneName', $order->delivery['state'], 'string');
$state = $db->Execute($sql);
$province_code_ship = (!$state->EOF) ? $state->fields['zone_code'] : '--';
}
to
Code:
if (in_array($order->billing['country']['iso_code_2'], array('CA','US'))) {
if (strlen($order->billing['state']) > 2 ) {
$sql = "SELECT zone_code FROM " . TABLE_ZONES . " WHERE zone_name = :zoneName";
$sql = $db->bindVars($sql, ':zoneName', $order->billing['state'], 'string');
$state = $db->Execute($sql);
$province_code_order = (!$state->EOF) ? $state->fields['zone_code'] : '--';
}
}
$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'], '--') : '--');
if (in_array($order->delivery['country']['iso_code_2'], array('CA','US'))) {
if (strlen($order->delivery['state']) > 2 ) {
$sql = "SELECT zone_code FROM " . TABLE_ZONES . " WHERE zone_name = :zoneName";
$sql = $db->bindVars($sql, ':zoneName', $order->delivery['state'], 'string');
$state = $db->Execute($sql);
$province_code_ship = (!$state->EOF) ? $state->fields['zone_code'] : '--';
}
}
The lines
Code:
$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'], '--') : '--');
and
Code:
$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'], '--') : '--');
assign "--" as the billing and shipping province if the billing and shipping province is not Canada or US.
The IF statements I added above ensure that the province code, which is assigned by the SQL statements from lines 291 to 293 and 298 to 300, only happens if the country is Canada or US.
I noticed without these extra IF statements, even though the province/state is set to "--", the SQL statements reassign it back to QLD (for Queensland state in my case) which will cause Beanstream to reject the transaction.
This code change seems to work. It probably needs more testing though.
Hi, chmod755,
Actually, you don't need to change anything in your "beanstream mod",
The easiliest and security way to fix this error is to delete all the zones (outsider of Canada and US) at "Locations/Taxes"->"Zones". (note: keep Canada and US Only)
Jing
-
Re: Beanstream Payment Module Support Thread
Quote:
Originally Posted by
highlander
Customer reported a problem placing an order the other day. Other customers orders are coming through ok.
the error message is attached. I have spoken with Beanstream and they have found the cause. I've attached their findings below. Can you figure out a way to resolve this?
reply from Beanstream, newest is at top, oldest at bottom:
************************
Hi,
############################## Yes, it looks like the Beanstream module is pulling in the full text for the shipping option selected by the customer. I don’t know if you could fix this by adjusting your shipping options or if you have to look for help with the Beanstream module on the ZenCart forums.
Thanks,
Mike

Subject: Re: Processing error?
Thanks !! I guess that means that the issue is with the beanstream module in zencart?
Cheers,
Rob
On 2011-06-25, at 12:43 PM, Michael wrote:
Hi,
I’ve figured it out. The problem is the text being attached to our shippingMethod variable through the ZenCart module. Review my log extraction below, as you can see the URL encoded version of the text from your shipping module is over our 64 character limit for the shippingMethod variable. The problem is the special characters and white spaces must be URL encoded which adds an extra 20-30 characters.
URL Encoded:
&shippingMethod=Canada+Post+%3C%21--%281+box%28es%29%29--%3E+%28Small+Packets+Air%2C+up+to+2+weeks%29
Variable data = 85 characters
Decoded:
&shippingMethod=Canada Post <!--(1 box(es))--> (Small Packets Air, up to 2 weeks)
Variable data = 55 characters without spaces and 65 characters with spaces
Thanks,
Hi, highlander, have you solved this problem?
acutally, beanstream only allows 64 characters for the "shipping mothod (description text)". you just need to change the shipping mehtod language at the language file.
if you still have this problem, please let me know. I will send detail about how to change this.
Jing
-
Re: Beanstream Payment Module Support Thread
Well I'm back, I like this module and intend on using it but!
I use a shared server for my hosting and therefore will not pass a full PCI compliance, what this means that I have to pass the customer on to the Beanstream payment page. Right now when I use the module the customer enters their information then it is passed to Beanstream through API, I think
Beanstream notified me today saying "The account notes show that the account was supposed to be using our hosted payment form via your Zen Cart configuration. The problem here is the Zen Cart module with Beanstream uses our API which requires FULL PCI Compliance"
I guess I need to use hosted payment, I'm not sure if there is a module for this, I would assume that it is like the Moneybookers module.
Is there any help on this or can you provide me with direction.
Thanks
Pcsdesign
-
Re: Beanstream Payment Module Support Thread
Quote:
Originally Posted by
pcsdesign
I use a shared server for my hosting and therefore will not pass a full PCI compliance
No, that's an incorrect statement.
There are lots of good "shared server" hosting services out there that have attained PCI Compliance.
A more correct statement for you would be that your host isn't willing to become PCI Compliant, or at least not for their shared-hosting offerings.
And in that case you'd be better off (and serving your customers better too) by changing hosts.
But the topic of hosting services or anything else outside discussing the Beanstream module ... belongs in a more suitable forum thread. This one is about the Beanstream module specifically.
-
Re: Beanstream Payment Module Support Thread
Hello,
My employer recently asked me to add VbV / SC to this zencart module. We are now testing it on our live site, and after one month of review it will be published onto the plugin/mod section. I also fixed several api compliance issues (thanks beanstream support, went extra mile), bugs from the previous version, added order history comments for AVS results (address verification service), along with account age and previous order count to help assess fraud risks.
:cheers:
-
Re: Beanstream Payment Module Support Thread
Thank you @brizzo for sharing your work. I was hoping someone would do this.
-
Re: Beanstream Payment Module Support Thread
Hi:
Presently, I am using 1.3.9h.
I am thinking about updating to Zen Cart version 1.5. Is Beanstream compatible with 1.5?
Dave
-
Re: Beanstream Payment Module Support Thread
I am chomping at the bit waiting for ANY beantream payment module that is ZC1.5 compatible. I thought there was a premium version out there somewhere but I have lost track of it. Anyone got a link?