[Done 1.3.9a] Linkpoint API Error SGS-002301 - Another One

[pinkchalkstudio]

I have 3 outstanding re-creatable Linkpoint API errors. Each slightly different in their basket make-ups. A customer encountered this combination yesterday:

Error Message:

Subtotal miscalculation. Please notify the storeowner.
SGS-002301: Charge total must be the sum of subtotal, tax, value added tax, and shipping.

Linkpoint Debug Data - FAILURE
Sep-15-2008 03:12:29
=================================

Response Code:

Sending to Gateway:
result = LIVE
oid = 1071-VnvCJQ
ip = <removed>
ponumber =
subtotal = 39.425
tax = 0
shipping = 4.95
chargetotal = 44.375
cardnumber = ******
cardexpmonth = 11
cardexpyear = 08
cvmindicator = provided
cvmvalue = ******
userid = 552
customerid = 552
name = <removed>
company =
address1 = <removed>
address2 =
city = <removed>
state = Arizona
country = US
phone = <removed>
email = <removed>
addrnum = <removed>
zip = <removed>
sname = <removed>
saddress1 = <removed>
saddress2 =
scity = <removed>
sstate = <removed>
szip = <removed>
scountry = US
comments = Website Order
ordertype = SALE
host = secure.linkpt.net
port = 1129
keyfile = /home/admin/public_html/includes/modules/payment/linkpoint_api/<removed>
configfile = <removed>
transactionorigin = ECI
terminaltype = UNSPECIFIED


Result:
(
[r_csp] =>
[r_time] => Mon Sep 15 16:12:32 2008
[r_ref] =>
[r_error] => SGS-002301: Charge total must be the sum of subtotal, tax, value added tax, and shipping.
[r_ordernum] => 1071-VnvCJQ
[r_message] =>
[r_code] =>
[r_tdate] =>
[r_score] =>
[r_authresponse] =>
[r_approved] =>
[r_avs] =>
)

I have set up a testing database where I took this customer's order configuration and was able to re-create her error as well as the previous errors.

The other error is located in this thread:
http://www.zen-cart.com/forum/showthread.php?t=103208

This latest instance is the most simple in construct. No sales tax and no coupon codes involved. No sale products either.

I'm really hoping someone can get to the bottom of this.

As a side question: Should I consider dropping my credit card provider and finding a new one that uses a different API?

Thank you!

Kathy

[pinkchalkstudio]

Additional information on this transaction:

Shopping cart had the following items:

Product ID Qty Products Price
53 .5 9.00
125 .5 9.00
136 .5 9.00
232 .5 9.00
350 .5 15.95
354 .5 17.95
357 .5 8.95

No discount codes, no items were on sale, no sales tax applied to this customer.

I have a testing area set up that contains a sample customer with this shopping cart and I can re-create the error.

I would really like to get this fixed if anyone can take a look.

Thank you!

Kathy

[pinkchalkstudio]

I have 4 different Linkpoint API failures which I can re-produce. To consolidate and make this easier to see all in a single place I created a spreadsheet with the product cart information for each scenario and other characteristics of the customer's checkout that may be contributing to the errors.

I've attached that file to this post.

I have 3 of the 4 Linkpoint log files which I can provide on request. They contain personal customer information so I'm not attaching them.

The one common thread across all 4 cases is that they contain a partial quantity of a product (either .5, 1.25 or 1.5) and the calculated cost of that partial quantity (product price x quantity ordered) results in an amount that has more than 2 places to the right of the decimal.

I have many successful checkouts of products that contain partial quantities where the final amount is more than 2 places to the right of the decimal so that can't be the only driving force behind a failure.

Thank you!

Kathy
Pink Chalk Fabrics

[pinkchalkstudio]

I've experienced two more of these failures in the past week. It's driving me nuts and costing me money to see orders lost!

Can someone please let me know if this can be fixed within a reasonable time frame and if so what that time frame is?

Can I pay someone to fix this error? Is this the type of job I should post on the thread in the forums? I'm concerned about finding someone with the skill to repair this but I'm more than willing to pay to have it fixed.

If that is not reasonable can I please get a recommendation on whether I should move to Paypal for my integrated credit card processing or look for a credit card vendor that uses the authorize.net gateway. I don't want to migrate to a new vendor only to encounter similar problems with the stability of the module.

I don't want to be a nag but I need to move forward on a solution. I realize it's difficult to debug and repair this error but I need to make a decision on how to proceed as my business grows.

Thank you!

Kathy

[DrByte]

I've been working on this off and on for some time.

The attached file is STRICTLY a beta which will hopefully address the problem you reported. I'd be interested in your test results.

My preliminary test seems to show it to be okay. However, I've not tested it with every possible combination of things, including extra order-total addon mods etc.

[pinkchalkstudio]

Thanks Dr. Byte! I'll test this out as soon as I get my kids off to school! I have 6 cases set up in my testing environment and they're all a bit different. I'll let you know the results.

Kathy

[pinkchalkstudio]

Thank you Dr. Byte! 6 for 6 test cases went through successfully. I can't even begin to tell you how happy this makes me. I've moved the fix into my production environment.

Have a fabulous week!

Kathy

[kburner]

Thank you Dr. Byte! 6 for 6 test cases went through successfully. I can't even begin to tell you how happy this makes me. I've moved the fix into my production environment.

Have a fabulous week!

Kathy

I just opened my store and have the same error and I use Linkpoint. Before I install file from Dr. Byte...Have you had any more errors? And do you use additional payment options like Paypal? I have only Linkpoint and was getting ready to install paypay.

Thanks,
Kim

[pinkchalkstudio]

Hi Kim,

No errors! Yay! This fix definitely did the trick. I was averaging several of those failures a month and I've had no problems for the last 30 days.

I also take Paypal (the one where the customer leaves the shop to go pay and then they come back).

Good luck!

Kathy

[kburner]

Hi Kim,

No errors! Yay! This fix definitely did the trick. I was averaging several of those failures a month and I've had no problems for the last 30 days.

I also take Paypal (the one where the customer leaves the shop to go pay and then they come back).

Good luck!

Kathy

I just installed. Thanks for the reply. I am getting ready to add paypal too.