[Done v1.3.9] Linkpoint - problem with coupons in v1.3.8

[Jeff_Mash]

Hi Dr Byte and team,

We recently upgraded to 1.3.8a from 1.3.7. Things are running fine, except we are getting an abnormal amount of customers saying that their credit card is being declined.

I already reupdated the linkpoint files from the build by first uninstalling the module, then reuploading the new 1.3.8a files, and then reinstalling the module. I thought this would fix the problem but it hasn't and people are still complaining.

I went ahead and did a test transaction for a small dollar item and it went through without problems. Likewise, we do see an occassional CC order come through, but we are getting a lot more people saying that it's not.

So do you know of any known issues by any chance? I just went ahead and turned my Linkpoint Debug Mode to "Failure Alert Only" to see what happens, but if you think this should be changed to "Log and Email" for better troubleshooting, let me know.

[Jeff_Mash]

I just got a particular failure and I see this error in the log:

[r_error] => SGS-002301: Charge total must be the sum of subtotal, tax,
value added tax, and shipping.

Any idea what would cause that?

The full log is here:

Response Code:

Sending to Gateway:
result = LIVE
oid = 12801-kWvOOE
ip = 212.28.224.192
ponumber =
subtotal = 290.78
tax = 0
shipping = 57.75
chargetotal = 299.37
cardnumber = ******
cardexpmonth = 07
cardexpyear = 08
cvmindicator = provided
cvmvalue = ******
userid = 3409
customerid = 3409
name = *****
company =
address1 = street espace ****,building *****
address2 =
city = Zouk ****, ****, 0000
state = Zouk ****, Lebanon
country = LB
phone = ***************
email = *******##########################
addrnum = ***********
zip = 0000
sname = ********
saddress1 = ********
saddress2 =
scity = Zouk ******
sstate = Zouk **********
szip = 0000
scountry = LB
comments = Website Order
items = Array
(
[0] => Array
(
[id] => 3170
[description] => Ash Pen Pro by Magic Dream
[quantity] => 1
[price] => 11.59
)

[1] => Array
(
[id] => 1648
[description] => Flash Cord
[quantity] => 1
[price] => 11.59
)

[2] => Array
(
[id] => 3595
[description] => Seo Paper Streamer (white) by Seo Magic
[quantity] => 1
[price] => 43.65
)

[3] => Array
(
[id] => 3620
[description] => Parasol Anywhere by Joker Lam
[quantity] => 1
[price] => 43.60
)

[4] => Array
(
[id] => 3619
[description] => Parasol Box Set (7 Parasols)
[quantity] => 1
[price] => 67.90
)

[5] => Array
(
[id] => 686
[description] => Flash Cotton by Fantastic Flash
[quantity] => 1
[price] => 6.79
)

[6] => Array
(
[id] => 685
[description] => Flash Pads by Fantastic Flash
[quantity] => 1
[price] => 4.85
)

[7] => Array
(
[id] => 1643
[description] => Flash Powder White A&B
[quantity] => 1
[price] => 10.67
)

[8] => Array
(
[id] => 683
[description] => Flash String by Fantastic Flash
[quantity] => 1
[price] => 12.61
)

[9] => Array
(
[id] => 54
[description] => D'Lite Pair - Red
[quantity] => 1
[price] => 19.39
)

[10] => Array
(
[id] => 1513
[description] => Silk Streamers from Italy - 4" x 3 met.
[quantity] => 1
[price] => 7.75
)

[11] => Array
(
[id] => 4045
[description] => Electric Deck Bicycle - Red
[quantity] => 1
[price] => 14.50
)

[12] => Array
(
[id] => 3256
[description] => Card Castle by Uday (Normal Size cards)
[quantity] => 1
[price] => 19.40
)

[13] => Array
(
[id] => 3096
[description] => 12'' Silk - 12-pack (Assorted)
[quantity] => 1
[price] => 16.49
)

)

ordertype = PREAUTH
host = secure.linkpt.net
port = 1129
keyfile = *****.pem
configfile = 1018371
transactionorigin = ECI
terminaltype = UNSPECIFIED


Result:
(
[r_csp] =>
[r_time] => Wed Mar 5 11:31:13 2008
[r_ref] =>
[r_error] => SGS-002301: Charge total must be the sum of subtotal, tax,
value added tax, and shipping.
[r_ordernum] => 12801-kWvOOE
[r_message] =>
[r_code] =>
[r_tdate] =>
[r_score] =>
[r_authresponse] =>
[r_approved] =>
[r_avs] =>
)

Moderator note: private data obscured

[Jeff_Mash]

Keep in mind that the customer above has a gift certificate CREDIT of $20.08 that I believe he was trying to apply. We also have another discount code that would take percentages off the entire order.

[Kim]

Jeff-

What were the numbers on the Order Confirmation?

[Jeff_Mash]

I did see that you had a Linkpoint_api fix for the Low Order Fee module. I wasn't using that module, but I looked and for some reason, it was enabled in my config. So I disabled it AND installed your updated Linkpoint_api file.

I didn't make any edits to it though, even though I am using other OT_ modules (ot_coupon, ot_gv, etc)

If you think I need to edit to accommodate those, please let me know.

[Jeff_Mash]

Kim....nothing for that transaction came through in Linkpoint......In other words, the transaction never went through to authorize or fail. All I got was that Failure Alert email.

[DrByte]

I'd check out these as well:
http://www.zen-cart.com/forum/showth...397#post504397
http://www.zen-cart.com/forum/showpo...92&postcount=5

[Jeff_Mash]

Dr Byte....

I just put in the first suggestion:

$myorder["shipping"] = ($order->info['shipping_cost'] == 'f') ? 0 : $order->info['shipping_cost'];

I had already did the second suggestion prior to the upgrade, so that didn't change. I will have the customer try to resubmit and report the findings.

[Jeff_Mash]

Still failing with the same error:

[r_error] => SGS-002301: Charge total must be the sum of subtotal, tax,
value added tax, and shipping.

I think this must have something to do with using gift certificates AND/OR Coupons.

Edit: This also appears to be happening with others:
http://zen-cart.com/forum/showthread...ght=SGS-002301
http://zen-cart.com/forum/showthread...ght=SGS-002301

[Jeff_Mash]

Ok, it's definitely something to do with the OT_COUPON. I just placed a test order. My subtotal page looks like this:


Qty. Item Name Total
1 x Plastic Wallet for Cards $0.97

Sub-Total: $0.97
United States Postal Service (First-Class Mail (2 - 5 days)): $1.30
Discount Coupon/Lifetime 10% Discount Code: ******: -$0.10
TOTAL: $2.17

Then when I go to confirm the transaction, I get the following messages:

- Success Congratulations you have redeemed the Discount Coupon
- Error Subtotal miscalculation. Please notify the storeowner.
SGS-002301: Charge total must be the sum of subtotal, tax, value added tax, and shipping.
- Warning Your card has been declined. Please re-enter your card information, try another card, or contact the store owner for assistance.

Finally, my response code from the transaction:

Response Code:

Sending to Gateway:
result = LIVE
oid = 12802-m1xpUj
ip = 69.225.40.144
ponumber =
subtotal = 0.97
tax = 0
shipping = 1.3
chargetotal = 2.17
cardnumber = ******
cardexpmonth = 05
cardexpyear = 08
cvmindicator = provided
cvmvalue = ******
userid = 3
customerid = 3
name = ************
company =
address1 = ********* Road
address2 =
city = Wellfleet
state = Massachusetts
country = US
phone = 209-***-****
email = ****######################
addrnum = ********** Road
zip = 02667
sname = *
saddress1 = ****** Road
saddress2 =
scity = Wellfleet
sstate = Massachusetts
szip = 02667
scountry = US
comments = Website Order
items = Array
(
[1] => Array
(
[id] => 1881
[description] => Plastic Wallet for Cards
[quantity] => 1
[price] => 0.97
)

)

ordertype = PREAUTH
host = secure.linkpt.net
port = 1129
keyfile = *****.pem
configfile = 1018371
transactionorigin = ECI
terminaltype = UNSPECIFIED


Result:
(
[r_csp] =>
[r_time] => Wed Mar 5 12:35:23 2008
[r_ref] =>
[r_error] => SGS-002301: Charge total must be the sum of subtotal, tax,
value added tax, and shipping.
[r_ordernum] => 12802-m1xpUj
[r_message] =>
[r_code] =>
[r_tdate] =>
[r_score] =>
[r_authresponse] =>
[r_approved] =>
[r_avs] =>
)