Adding Braintree payment module

There was a bug in previous versions that caused the db_prefix to be dropped, please make sure you are using the most recent version of the module, check your database definitions, and also your database. making sure the defines in the DB match the DB table name.

Please Let us know. This issue sounds like that solved above.

andilyn:

I'm losing my mind trying to get this figured out
When making trial purchases Braintree shows the funds processing
Customer gets an email order confirmation
Admin shows all order info
on step 3 of checkout however this error message is given:

WARNING: An Error occurred, please refresh the page and try again.

Upon refresh the customer is told the transaction was declined

I also get this message in my log file:

[27-Apr-2014 08:41:53] PHP Fatal error: 1146:Table 'andilyn_zncr5.braintree' doesn't exist :: INSERT INTO braintree (order_id, txn_type, module_name, module_mode, reason_code, payment_type, payment_status, pending_reason, first_name, last_name, payer_business_name, address_name, address_street, address_city, address_state, address_zip, address_country, payer_email, payment_date, txn_id, parent_txn_id, num_cart_items, settle_amount, settle_currency, exchange_rate, date_added) VALUES ('1546', 'cart', 'braintree_api', 'USA', '', 'Credit Card(MasterCard)', 'Completed', '', 'Sean', 'Paul', '', 'SeanPaul', '8010 Presidents Drive', 'Orlando', 'Florida', '32809', 'United States of America', 'littlebearhugs2######################', now(), 'bv5rtbm', '', '1', '0.01', 'USD', '1', now()) in /home4/andilyn/public_html/cherrypitcrafts.com/includes/classes/db/mysql/query_factory.php on line 120

Any suggestions?

I've read through the entire thread and tried everything suggested. I'm using the latest version of the plugin and zen cart
I'm still getting nowhere fast

when you look in your phpMyAdmin do you have a table "braintree" or "zen_braintree" or TABLE_BRAINTREE or any similar to those?

Hi guys,

Im having a strange issue with the Braintree plugin.

When I put through a transaction, my order total is €1, but in braintree its €1.41

On the site admin and customer invoice the order is showing as €1, but the card is charged €1.41. If I put through a transaction of €5 it is showing up in the Braintree dashboard as €7.01. I thought it may be something got to do with currencies but the currency is set to Euro in both my site and in Braintree

Has anybody come across a similar issue or can shed some light on it?

colmhol:

Hi guys,

Im having a strange issue with the Braintree plugin.

When I put through a transaction, my order total is €1, but in braintree its €1.41

On the site admin and customer invoice the order is showing as €1, but the card is charged €1.41. If I put through a transaction of €5 it is showing up in the Braintree dashboard as €7.01. I thought it may be something got to do with currencies but the currency is set to Euro in both my site and in Braintree

Has anybody come across a similar issue or can shed some light on it?

I also have that problem. Looks like some exchange rate/currency issue. Did you found a solution?

I'm trying to fix it if i find a workaround I will post.

Has anyone used Venmo or ApplePay with this integration? I don't know if those are supported yet.

I do know from experience that the currency issue, has several factors.

You should have at least 2 processing accounts one for USD and one for EUR, and you need to make sure you are using the correct one. Don't forget the configuration has you OMIT the currency on the end of the processing account.

swguy:

Has anyone used Venmo or ApplePay with this integration? I don't know if those are supported yet.

Those are not supported in the module. However I know that Braintree can support Venmo, bitcoin, apple pay & Paypal.

However I don't' see that in their php documentation.
https://github.com/braintree/braintree_php

That's a shame. I did a bit more digging and looked at their updated docs, where they say "Note: Venmo is not currently supported for Web."

https://developers.braintreepayments.com/javascript+php/sdk/client/paypal-and-venmo

The fix submitted in version 4 is not correct - new installs will create TABLE_BRAINTREE instead of <prefix>braintree.

The solution is to include the file which defines the table name on line 6 of includes/modules/payment/braintree_api.php.

require_once(DIR_FS_CATALOG . 'includes/extra_datafiles/braintree_api.php');

Alternately, a one time definition could be made:

if (!defined('TABLE_BRAINTREE')) define('TABLE_BRAINTREE', DB_PREFIX . 'braintree');

swguy:

The fix submitted in version 4 is not correct - new installs will create TABLE_BRAINTREE instead of <prefix>braintree.

The solution is to include the file which defines the table name on line 6 of includes/modules/payment/braintree_api.php.

require_once(DIR_FS_CATALOG . 'includes/extra_datafiles/braintree_api.php');

Alternately, a one time definition could be made:

if (!defined('TABLE_BRAINTREE')) define('TABLE_BRAINTREE', DB_PREFIX . 'braintree');
We opted to define the table on the admin side too.

v1.2.1 has been released on Numinix.com and will be available on Zen-Cart.com once reviewed for compliance.

Hi Guys,

I'm having trouble with the braintree module and i just can't see whats wrong so i hope someone can help me.

I have installed the 1.2.2 version of the braintree module onto the latest version of zencart 1.5.4 and i have put in all my keys etc.

When i go to checkout i input the card details then go to the confirmation page as usual but when i click complete it goes back to step 2 and says sorry we cannot process your order, Please try again.

I turned on debug and recieved 2 emails as below.

Email 1

before_process - DP-1
braintree_api
Beginning DP Mode

Email 2

before_process - DP-5
braintree_api
Result:

Thats all i get everytime i try to order.

SSL is on the site an enabled properly in the config files etc but i cant seem to get around this.

Hope you can help

Thanks
Andy

Transactions with American Express (AMEX) seem to not work - has anyone else experienced this? AMEX is configured in the Braintree Dashboard.

There's a bug in version 6. In includes/modules/payment/braintree_api.php line 781 you need to global $messageStack.

[10-Feb-2015 16:18:02 America/New_York] PHP Fatal error: Call to a member function add() on a non-object in /Users/scott/Sites/site/includes/modules/payment/braintree_api.php on line 809

This is Fixed in 1.3.1. Should be submitted for moderation today or tomorrow.
Also 1.3.0 now support zencart 1.5.4

swguy:

There's a bug in version 6. In includes/modules/payment/braintree_api.php line 781 you need to global $messageStack.

[10-Feb-2015 16:18:02 America/New_York] PHP Fatal error: Call to a member function add() on a non-object in /Users/scott/Sites/site/includes/modules/payment/braintree_api.php on line 809

Much obliged. Any thoughts about AMEX?

When I had an issue with it.

I did the following:
1.) ZenCart Admin Configuration->Credit Cards
Set Credit Card Enable Status - AmericanExpress to 1
2.) In Braintree Verified: Settings -> Processing -> Merchant Accounts -> Accepted Payment Methods
Displays AMEX

swguy:

Much obliged. Any thoughts about AMEX?

OMG I can't believe I missed that. Thanks for the clue.

Hey, another small thing: if you fail to enter the CVV, you get the message

Please make the following corrections:

(i.e. the actual error message is missing.)

As a suggestion, it would be nice to use the image_url attribute to display credit card images

https://developers.braintreepayments.com/ios+ruby/reference/response/credit-card#image_url