Version: 1.3.9e

Is there a way to permanently turn off the sending of the individual item information and/or subtotal information to the gateway in the FirstData/Linkpoint api? Are there lines in the code of the module that can be easily commented out to not send the information and just send the total?

Silly question ... why?

Kim:

Silly question ... why?

Because It is throwing the "SGS-002301: Charge total must be the sum of subtotal, tax, value added tax, and shipping." error. DrByte had fixed this in an earlier beta version of the module which basically did not send subtotal information. It would help when there are rounding errors involving discounts and such that prevent Linkpoint from processing an order because the difference may amount to a penny in the way it is added up in Zen vs. Linkpoint.

If you are having problems with rounding errors you need to report them and the exact circumstances so we can fix them. Please provide details.

Kim:

If you are having problems with rounding errors you need to report them and the exact circumstances so we can fix them. Please provide details.

Ok, here goes:

Database: MySQL 5.0.91-community
PHP Version: 5.2.10 (Zend: 2.2.0) PHP Memory Limit: 128M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 6M POST Max Size: 8M
Database Data Size: 3,122 kB Database Index Size: 1,105 kB

Zen Cart 1.3.9e
Database Patch Level: 1.3.9c
v1.3.9c [2010-05-25 19:16:33] (Version Update 1.3.8->1.3.9c)
v1.3.8 [2008-02-04 16:01:05] (Fresh Installation)

Most orders go through. Here is an example of one that does not.
If you notice below, the subtotal + shipping + tax (calculated at 5.5% includes subtotal and shipping) = 83.51, chargetotal shows 83.52

Linkpoint debug email shows: (edited)

Linkpoint Debug Data - FAILURE

Response Code: SGS-002301: Charge total must be the sum of subtotal, tax,
value added tax, and shipping.

Sending to Gateway:
result = LIVE
oid = xxxx-xxxxxx
subtotal = 69.67
shipping = 9.49
tax = 4.35
chargetotal = 83.52
items = Array
(
[1] => Array
(
[id] => xxx
[description] xxx
[quantity] => 3
[price] => 16.99
)
[2] => Array
(
[id] => xxx
[description] xxx
[quantity] => 2
[price] => 9.35
)
)
ip = xx.xxx.xxx.xxx
ponumber =
cardnumber = ******
cardexpmonth = xx
(cut non-important & personal stuff)
comments = Website Order
ordertype = SALE
host = secure.linkpt.net
port = 1129
keyfile = specified
configfile = xxxxxx
transactionorigin = ECI
terminaltype = UNSPECIFIED

Result:
(
[r_csp] =>
[r_time] => Mon Aug 9 13:11:10 2010
[r_ref] =>
[r_error] => SGS-002301: Charge total must be the sum of subtotal, tax,
value added tax, and shipping.
[r_ordernum] => XXXX-XXXXXX
[r_message] =>
[r_code] =>
[r_tdate] =>
[r_score] =>
[r_authresponse] =>
[r_approved] =>
[r_avs] =>
)
Customer saw blank page after submitting order.
Also in the debug log, there is this:
[09-Aug-2010 13:11:08] PHP Fatal error: Cannot redeclare class lphp in /home/siriusro/public_html/ishop/includes/modules/payment/linkpoint_api/class.linkpoint_api.php on line 25

Same result on another order:
4 x Item 1 $67.97
1 x Item 2 $59.99
1 x Item 3 $39.90
1 x Item 4 $114.95
1 x Item 5 $54.95

Sub-Total: $337.76
Table Rate (Best Way): $33.78 (Calculated as 10%) (33.776?)
Total: $371.53
Same error from linkpoint and same debug error.
Hope that is enough info to start!

Any suggestions?

The errors you're getting are peculiar. I'm having trouble recreating them.

If you absolutely must skip sending the details as part of the transaction, lines 414-415 contain this:// send request to gateway $result = $this->_sendRequest($myorder);Just add this above those lines:```
unset($myorder["items"]);

Please Help! I am getting the same error code (SGS-002301: Charge total must be the sum of subtotal, tax, value added tax, and shipping.) on everything that does not ship for free with the Free Shipping Options module total > $99.99 The other shipping method I use is Table Method 99.98:4.99

Here is an example:

Response Code: SGS-002301: Charge total must be the sum of subtotal, tax,
value added tax, and shipping.

=================================

Sending to Gateway:
result = LIVE
oid = 76-qU7IPF
subtotal = 84.99
chargetotal = 89.98
items = Array
(
[1] => Array
(
[id] => 128
[description] => Mini Stepper - Low Impact Exerciser
[quantity] => 1
[price] => 84.99
)

)

ip = 75.143.187.35
ponumber =
cardnumber = ******
cardexpmonth = 08
cardexpyear = 12
cvmindicator = provided
cvmvalue = ******
userid = 3
customerid = 3
name = Kelly Conklin
company =
address1 = 162 Dartmouth Street
address2 =
city = Schenectady
state = New York
country = US
phone = 5183934887
email = [email protected]
addrnum = 162 Dartmouth Street
zip = 12304
sname = Kelly Conklin
saddress1 = 162 Dartmouth Street
saddress2 =
scity = Schenectady
sstate = New York
szip = 12304
scountry = US
comments = Website Order
ordertype = PREAUTH
host = secure.linkpt.net
port = 1129
keyfile = specified
configfile = 1001225252
transactionorigin = ECI
terminaltype = UNSPECIFIED

Result:
(
[r_csp] =>
[r_time] => Mon Nov 8 07:59:15 2010
[r_ref] =>
[r_error] => SGS-002301: Charge total must be the sum of subtotal, tax,
value added tax, and shipping.
[r_ordernum] => 76-qU7IPF
[r_message] =>
[r_code] =>
[r_tdate] =>
[r_score] =>
[r_authresponse] =>
[r_approved] =>
[r_avs] =>

I'm getting the exact problem duplicated as "docdalek" in his August 10, 2010 post.

Error reads,"SGS-002301: Charge total must be the sum of subtotal, tax, value added tax, and shipping."

Also confirmed is a one penny difference between the "chargetotal = 767.05" and the addition of three separate items,
"subtotal = 699.00 / shipping = 11.24 / tax = 56.82".

I read DrByte's comment about this being peculiar (Aug 21,2010) and I have this thought to offer. Most orders go through. I suspect that in New York State (which is where the error occasionally occurs and where this business is located) with over 2,500 different sales tax percentages to apply that the instance of a one penny discrepancy (rounding up) happens more frequently.

The bad part is that a sale was lost. The customer tried twice to make the sale go through. We were fortunate the customer contacted the company. That's how we new it was not just a rejected or fraudulent credit card but a real sale gone sour.

Now I'm asking for help with a solution. I see above that DrByte offers a sort of fix but has there been any better solutions or fixes since then?

I have employ the above solution but does that mean that on every sale the client will only see one lump sum (of item, tax, and shipping all together)? Please let me know. It there's one lump sum this could lead to a problem of mistrust by the customer.

Many thanks for your help.

I'm not sure how to prove out this solution. How can I recreate the same sale from the same location (incurring the same tax for the same item and have it passed to linkpoint)? Don't quite know how to do this as a dummy sale.

I need some serious help. I wrote the above entry Dec 20, 2010. I made the changes suggested by DrByte in the entry on Aug 21, 2010. I checked it and it was completed exactly. However the same error of one penny difference has happened again!

The discrepancy is between the "Zen rounded up" total of $367.45 and the actual total of the three items - subtotal = 329.00, shipping = 8.50, and tax = 29.95 (totaling $367.45). The sale did not go through and very luckily the customer called to complain and the sale was saved via phone.

Fixing this is beyond my skills. Clients patience is being tested and mine too.

Here's the details of this thwarted transaction (private info is altered), shows same error code:
Sending to Gateway:
result = LIVE
oid = 20-3GnQZV
subtotal = 329.00
shipping = 8.50
tax = 29.95
chargetotal = 367.46
ip = 00.108.205.96
ponumber =
cardnumber = ******
cardexpmonth = 03
cardexpyear = 12
cvmindicator = provided
cvmvalue = ******
userid = 25
customerid = 25
name = Jane Doe
company = Doe Realty
address1 = 111 West 23456th Street #A
address2 =
city = NY
state = New York
country = US
phone = 0001111111
email = JaneDoe######################
addrnum = 111 West 23456th Street #A
zip = 10024
sname = Jane Doe
saddress1 = 111 West 23456th Street #A
saddress2 =
scity = NY
sstate = New York
szip = 10024
scountry = US
comments = Website Order
ordertype = SALE
host = secure.linkpt.net
port = 1129
keyfile = specified
configfile = 1001227482
transactionorigin = ECI
terminaltype = UNSPECIFIED

Result:
(
[r_csp] =>
[r_time] => Thu Jan 13 10:55:43 2011
[r_ref] =>
[r_error] => SGS-002301: Charge total must be the sum of subtotal, tax,
value added tax, and shipping.
[r_ordernum] => 20-3GnQZV
[r_message] =>
[r_code] =>
[r_tdate] =>
[r_score] =>
[r_authresponse] =>
[r_approved] =>
[r_avs] =>
)

I am very happy to supply any other details necessary for the Zen Team to solve this issue. Just lemme know what is needed.

A thought is to write code that ignores a one penny difference. Or passes a total to the gateway that's flexible by one penny. But what do I know?

Anxiously awaiting your reply. Thank you.

Oops! Previous post price correction - The "Zen rounded up" chargetotal was actually= 367.46. That makes a one penny difference.

See previous posts.

Has anyone found or attempted to find a solution for this problem that makes a one penny difference between the chargetotal = 367.46 and the sum of the three (subtotal = 329.00, shipping = 8.50, tax = 29.95) totaling $367.45 ?

One penny difference prevents the credit card from passing to the gateway?

I have to find s solution or use alternate program.

Please respond. Thank you.

If I start with a brand new clean install of Zen Cart without any products, what steps do I need to take to recreate exactly the same scenario you're reporting?
ie: I'll need some products with a certain price, taxes configured a certain way, shipping set up a specific way, sales/specials set up a certain way, store address and customer address set a certain way, and so on.

Thank you for responding. Following is the info you requested. If something additional is needed just let me know. Again I suspect it's a rounding discrepancy triggered by the over 2261 New York State Sales Tax percentages often fractions.

First there are no sales/specials.

In both cases the problem email subject line says:
Subject: Linkpoint Debug Data - FAILURE
Response Code: ##SGS-002301: Charge total must be the sum of subtotal, tax, value added tax, and shipping.

ITEM PRICES and Ship to LOCATIONs----------------
For Prices use the two items that separately demonstrated the problem.
$329. ship to Zip Code 10024 in New York City, NY
$699. ship to Zip Code 13326-1331 in Cooperstown, NY

SHIPPING-----------------------------------------------
For shipping we selected only Fedex Ground
Ship from store in NY City: Brooklyn NY 11206
We have an account.
Drop off 1
Fedex Domestic surcharge $1
Fedex Domestic variable surcharge? -55.6%
Residential surcharge? -.27

TAXES-----------------------------------------------
Location / Taxes / Countries - none selected
Location / Taxes / Zones - none selected
Location/Taxes/Zone Definitions - Taxes, Payment and Shipping
Zone Name Zone Description Status
New York State New York State yellow
Location / Taxes / Tax Classes
ID Tax Classes
1 Taxable Goods
Location / Taxes / Tax Rates
Location / Taxes / Local Sales Tax
There are 114 pages showing 2261 different tax rates (several are fractional rates).
The sales tas module was downloaded at:
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=623

I installed v 2.4 (current version is 2.5). However I modified v 2.4 to recognize zip code+4 (that's the extra 4 digits that the post office and some people add to the base zip code of 5 digits).

Am looking forward to your solution.

Darla:

I'm getting the exact problem duplicated as "docdalek" in his August 10, 2010 post.
I was looking back at docdalek's post, and he/she indicated that they're using v1.3.9e.

In v1.3.9h there are numerous changes built-in since 1.3.9e to prevent one-penny differences in the calculations of transaction data being submitted.

I notice your posts are devoid of any information about your site, including ZC version, PHP version, MySQL version, hosting platform, etc.

I recommend upgrading to the latest version to benefit from the improvements added to handle the concerns you're reporting.

I waited one month after upgrading to v1.3.9h as you suggested. So far no more problems with the one penny difference in the totals between Link Point's charge total and the sum of the subtotal ( tax, value added tax, and shipping).

Many many thanks. You saved the day!

Thanks for reporting back that using the latest version has resolved your problems.