Adding Braintree payment module

[bislewl]

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.

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?

[andilyn]

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

[bislewl]

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

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

[tesefoti]

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.

[swguy]

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

[bislewl]

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.

[bislewl]

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

[swguy]

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...ypal-and-venmo

[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');