logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error
braintree plugin passing orderID instead of orderNumber 9.0.9
Options
Go to last post Go to first unread
Previous Topic Next Topic
charles25686713  
#1 Posted : Monday, April 21, 2025 4:14:21 PM(UTC)
charles25686713

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 7/1/2022(UTC)
Posts: 74

Thanks: 5 times
Was thanked: 1 time(s) in 1 post(s)
Hi, we recently switched off of authorize.net to braintree. Everything works perfect...

Except our bookkeeper just notified me the braintree reports are showing OrderId instead of OrderNumber. That means she can't cross reference the braintree reports with the AbleCommerce reports because OrderNumber is what's used externally, OrderID is what's used in the underlying table.

How quickly can we get this fixed?

I don't have access to the plugin code or I'd fix it myself pending an official fix.

Thanks,
Charles

P.S. We're on 9.0.9. It doesn't appear this was fixed in 9.0.10?

Edited by user Monday, April 21, 2025 4:15:01 PM(UTC)  | Reason: Not specified
Back to top

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.
Back to top  
ray22901031  
#2 Posted : Wednesday, April 23, 2025 8:26:12 AM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 911

Thanks: 3 times
Was thanked: 15 time(s) in 15 post(s)
Hi Charles,

I have retired, so I no longer use AbleCommerce, but I like to pop in once in a while just to read some of the questions. I tried looking at the export feature in the software, but it doesn't give you the ability to export order IDs. So that's not going to help, and none of the reporting features also list the order IDs.

If you have access to your database with something like an ODBC connection, you can definitely use a product like Crystal Reports to create a custom report that lists the order number and the corresponding order ID. You can also use Excel.

If that is not the case, your best scenario for now, if you cannot get a hold of the back-end code, is to have your accountant match Order amounts against the Braintree report. Of course, this could be slightly problematic if you take out credit card fees at the time of the order, since the amounts would be slightly off.

I'm not sure what information, like zip codes or customer names, are listed on Braintree reports, so it's hard to find criteria to help you match things at the moment.

I know this is not the answer you wanted to hear, but I hope at least some of this helps.

-Ray

Edited by user Wednesday, April 23, 2025 8:27:13 AM(UTC)  | Reason: Not specified
Back to top
charles25686713  
#3 Posted : Wednesday, April 23, 2025 9:29:17 PM(UTC)
charles25686713

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 7/1/2022(UTC)
Posts: 74

Thanks: 5 times
Was thanked: 1 time(s) in 1 post(s)
Originally Posted by: ray22901031 Go to Quoted Post
Hi Charles,

I have retired, so I no longer use AbleCommerce, but I like to pop in once in a while just to read some of the questions. I tried looking at the export feature in the software, but it doesn't give you the ability to export order IDs. So that's not going to help, and none of the reporting features also list the order IDs.

If you have access to your database with something like an ODBC connection, you can definitely use a product like Crystal Reports to create a custom report that lists the order number and the corresponding order ID. You can also use Excel.

If that is not the case, your best scenario for now, if you cannot get a hold of the back-end code, is to have your accountant match Order amounts against the Braintree report. Of course, this could be slightly problematic if you take out credit card fees at the time of the order, since the amounts would be slightly off.

I'm not sure what information, like zip codes or customer names, are listed on Braintree reports, so it's hard to find criteria to help you match things at the moment.

I know this is not the answer you wanted to hear, but I hope at least some of this helps.

-Ray


Hi, thanks for the suggestion. I'm planning on creating a back end admin page that the accountant can upload the export from BrainTree, and then cross ref it with the database and spit back a new spreadsheet with the account number on it.
Back to top
Katie S  
#4 Posted : Wednesday, April 23, 2025 10:17:59 PM(UTC)
Katie S

Rank: Advanced Member

Groups: System, Administrators, Developers, Registered, HelpDesk
Joined: 10/29/2018(UTC)
Posts: 483

Thanks: 4 times
Was thanked: 34 time(s) in 33 post(s)
Hi Charles,

I will report this right away. Got to keep the bookkeepers happy!

Once the fix is confirmed, I can share it here.

We are planning on a release soon. Hopefully, by the end of next month.

Thanks for your support!

Katie
Secure eCommerce Software and Hosting
Back to top
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET 2.2.4.14 | YAF.NET © 2003-2025, Yet Another Forum.NET
This page was generated in 0.310 seconds.