close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

eCart - Transaction Not Completed

Thread began 7/11/2019 2:34 pm by lr_leal239405 | Last modified 7/17/2019 12:11 am by Ray Borduin | 62 views | 8 replies |

lr_leal239405

eCart - Transaction Not Completed

I'm getting on Live Paypal checkout - response:

Item total is invalid. 2019-07-11T18:26:47ZFailure6e011587d752cInvalid DataItem total is invalid.10426Error60.0530724211.00
10426
Invalid Data

I know now it's the Paypal not accepting the total but don't know why or where to change.

Can you help me with with this?

Thank you

Sign in to reply to this post

Ray BorduinWebAssist

Looks like too many decimals. If you send me a URL and steps to reproduce the issue and give me FTP access then I can correct this for you.

Sign in to reply to this post

lr_leal239405

below are the details. We launched the Shopping Cart page today. Thanks for all your help.

Sign in to reply to this post

Ray BorduinWebAssist

I can't seem to log into the site to see prices and check out. I tried registering, but the login still won't work for me. What username and password should I be using?

Sign in to reply to this post

lr_leal239405

oh, The registration is not automatic. You would have received an email to confirm your email registration.

We found out the paypal acct also didn't have the Website Payments Pro. I believe we need that (unless you know otherwise ?). So we just completed that process and I will test again to see what other errors I get. For the time being, because the CCs transactions weren't working we have a checkout page where it goes to the Purchase Order ordering only so you wouldn't be able to get there (this all happened as you were trying). I'll post again here and let you know more info so you don't waste more time). Thanks Much.

Sign in to reply to this post

Ray BorduinWebAssist

Post again when you are ready for me to debug further. Include a working username and password so I don't have to jump through any hoops to reproduce whatever issues you are having and I'll help you get any remaining issues sorted.

Sign in to reply to this post

lr_leal239405

Ok, great. We have the right Paypal account now - took over the weekend to be approved by Paypal. So, we just get that error outlined above:

Item total is invalid.
10426
Invalid Data


UPDATE: i checked out more on it and I think what is happening is that we were testing with a fictitious item that cost ($1 (I changed to 1penny)). and the shipping cost had a Promotion for Free Shipping (so UPS charge would come up as $16.66, but then I have the discounts to discount the cost of Shipping altogether). So, there was not enough to pay UPS. Thus we'd get the error. It will not happen on any items where there's enough charge to pay UPS of course, ( changed very last item to $20, and it worked because there was a positive amt. left of about $4.00)

so, I will need to change the code to skip UPS function altogehter if the there's a PROMO in the cart for the item(s).

If you can let me know where to do that, it will speed it up for me, otherwise I'm trying to figure that out.

I guess it's this piece in webassist code?

function WAEC_eCart1_UPSShipping() {
$totalShipping = 0;
if (true && (("UPS"=="UPS")&&(isset($_SESSION["eCart1_UPS_Quote"]))&&(floatval($_SESSION["eCart1_UPS_Quote"]) != 0))) {
$totalShipping += floatval($_SESSION["eCart1_UPS_Quote"]) + 0;//Result
}
return WA_eCart_FormatNumber($totalShipping, $this->ForceDecimalsC, $this->DecimalPlacesC);
}

As of now I have on the Discounts functions:

function WAEC_eCart1_FreeShipping() {
$totalDiscount = 0;
if (true && (($this->ConditionalTotal("Quantity", "ShippingType", "promo") >= 1))) {
$totalDiscount += floatval($_SESSION["eCart1_UPS_Quote"]) + floatVal("4");//Result
}
return WA_eCart_FormatNumber($totalDiscount, $this->ForceDecimalsC, $this->DecimalPlacesC);
}

(the $4 is our handling charge)

Sign in to reply to this post

lr_leal239405

Ok, so it's working except I want to not calculate shipping (with UPS) when there's a value in the cart of either 'promo' or 'ship_collect' from a column named 'Shpping_Type'. I am editing thru the eCart Object editor and tried:

//eCart Rule
function WAEC_eCart1_UPSShipping() {
$totalShipping = 0;
if (true && (($this->ConditionalTotal("Quantity", "ShippingType", "promo") < 1) || ($this->ConditionalTotal("Quantity", "ShippingType", "ship_collect") < 1) && ("UPS"=="UPS")&&(isset($_SESSION["eCart1_UPS_Quote"]))&&(floatval($_SESSION["eCart1_UPS_Quote"]) != 0))) {
$totalShipping += floatval($_SESSION["eCart1_UPS_Quote"]) + 4;//Result
}
return WA_eCart_FormatNumber($totalShipping, $this->ForceDecimalsC, $this->DecimalPlacesC);
}


and tried this:

//eCart Rule
function WAEC_eCart1_UPSShipping() {
$totalShipping = 0;
if (true && (($this->InCart("promo") != true) || ($this->InCart("ship_collect") != true) && ("UPS"=="UPS")&&(isset($_SESSION["eCart1_UPS_Quote"]))&&(floatval($_SESSION["eCart1_UPS_Quote"]) != 0))) {
$totalShipping += floatval($_SESSION["eCart1_UPS_Quote"]) + 4;//Result
}
return WA_eCart_FormatNumber($totalShipping, $this->ForceDecimalsC, $this->DecimalPlacesC);
}

and tried this:

//eCart Rule
function WAEC_eCart1_UPSShipping() {
$totalShipping = 0;
if (true && (($this->InCart("promo") != true) && ($this->InCart("ship_collect") != true) && ("UPS"=="UPS")&&(isset($_SESSION["eCart1_UPS_Quote"]))&&(floatval($_SESSION["eCart1_UPS_Quote"]) != 0))) {
$totalShipping += floatval($_SESSION["eCart1_UPS_Quote"]) + 4;//Result
}
return WA_eCart_FormatNumber($totalShipping, $this->ForceDecimalsC, $this->DecimalPlacesC);
}


But, it Keeps calculating shipping ? I want it to skip altogether. What is wrong with this logic?

Sign in to reply to this post

lr_leal239405

UPDATE: This worked:

//eCart Rule
function WAEC_eCart1_UPSShipping() {
$totalShipping = 0;
if (true && (($this->ConditionalTotal("Quantity", "ShippingType", "promo") < 1) && ($this->ConditionalTotal("Quantity", "ShippingType", "ship_collect") < 1) && ("UPS"=="UPS")&&(isset($_SESSION["eCart1_UPS_Quote"]))&&(floatval($_SESSION["eCart1_UPS_Quote"]) != 0))) {
$totalShipping += floatval($_SESSION["eCart1_UPS_Quote"]) + 4;//Result
}
return WA_eCart_FormatNumber($totalShipping, $this->ForceDecimalsC, $this->DecimalPlacesC);
}

They all have to be true for it to work, not Either / Or.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...