Incorrect Donation Values

[[email protected]]

Hello:

We have been experiencing an issue over the course of the past few days with our Visualforce pages where some donations are adding an extra zero onto the total and overcharging donors.

We had a sponsor who wanted to donate $1,000 and was accidentally charged $10,000 two times in a row - we credited them in the virtual terminal, ran the donation ourselves, and everything worked correctly so we assumed it was simply user error. In this case, the donor never received receipts for those transactions.

However, yesterday I ran a test donation for a $500 sponsorship and was theoretically charged $5,000. This time, I received a receipt and our reply-to email received an error report on the donation. No opportunity was created in Salesforce. This happened again within the same time frame on our standard donation form when I ran a test transaction for $10 and was theoretically charged $110. This time I received no receipt but an opportunity WAS created in Salesforce.

We need to resolve this issue as soon as possible as registration is currently open for our sponsors and potential registrants for our largest annual fundraiser. I've already granted C&P access in our system and our Org. ID is 00Di0000000iX2P

[[email protected]]

What would the proper terminology be?

They are pages we have created in Salesforce which C&P processes.

These are the two we have experienced issues with:

https://cforr.secure.force.com/donate/GTK2014Sponsor

https://cforr.secure.force.com/donate/GTK2014Individual

[CnP.Support]

Good day!

May I ask what you mean by "our Visualforce" pages? Would you please send me a link or an image of the page you referring to?

We don't have any VF pages that are designed for the public to use as our pages are only inside Salesforce and the only one that does payment is the Virtual Terminal.

Do you have problem with the Virtual Terminal?

This message is posted to the API- PaaS which is the SOAP service API and not Salesforce yet you are referring to VisualForce pages. Sorry but I am a bit confused as to what issue we are dealing with.

[CnP.Support]

Good day!

This is a custom form designed by your team based on the API Class Library. Debugging your code in Salesforce needs to be assigned to a developer and not something that may easily be done by support.

I will request the development team to review it and we will get back to you when we have an answer.

[CnP.Support]

Good day!


We have reviewed your form and the following is our finding:


Line 182: <input id="SendReceipt" name="SendReceipt" type="hidden" value="False" />


The above line sets the form NOT to send the system receipt. You may be sending the receipts through the autoresponder in Salesforce.


As for $1000 versus $10000 it is not really something we can test. You have a number of JavaScripts that you have written and any of those may be at fault.

In reviewing the XML that was posted to us the following shows 10000 was posted directly from the form:

<Transaction>
<TransactionType>Payment</TransactionType>
<CurrentTotals>
<TotalDiscount>0</TotalDiscount>
<TotalTax>0</TotalTax>
<TotalDeductible>1000000</TotalDeductible>
<Total>1000000</Total>
</CurrentTotals>
</Transaction>

Please note that the value is in pennies so $10,000 is actually posted as 1000000

To debug the code please change the posting URL to https://Verify.FaaS.Cloud.ClickandPledge.com

The above is line: 164

<form action="https://VERIFY.faas.cloud.clickandpledge.com" class="doValidate" id="Donation" method="post">

The verify service will show you exactly what you are posting to us. As you have a number of JavaScripts it is not possible for us to debug your code as we really can't debug custom code. The verify service will help you in determining what is causing the value to change.

As for the receipts:

I reviewed your forms and you have 3 autoresponders in Salesforce:

• Thank You - GTK Sponsor
• Thank You - Recurring
• Thank you

The one for the GTK Sponsor has the following conditions:

• Transaction Campaign IS 2014 GTK Lunchean
• AND SKU IS DON-GTK2014

In reviewing your forms I don't see any campaigns in either of the forms. I searched for "Campaign" and did not find any matching text. Not finding that text says the campaign is not listed. If the campaign is not posted then the above conditions will not meet considering the condition is AND between the Transaction Campaign & SKU.

Of course you have also set the send receipt for the form to not send the receipt as stated above so neither the system receipt NOR the autoresponder are being sent.

By the way the forms you sent me are both set to OrderMode=Test so the forms only work with 4111 card number - just want to make sure you know this.

I hope the above helps you in finding the issue. As stated I highly recommend you change the form post to verify and do transactions - the form will show you a table of all variables that is being posted to it.

Let me know what you find out and if we can be of any further assistance.

[CnP.Support]

Good day again!

After reviewing your code a little more I realized what is going on. Look at the following image:


Your code allows for any number of items to be selected. If someone does not pay attention any number of items may be selected and for all the UnitPrice1 is being posted which is 10000. I tried to uncheck one option and I could not. If I selected the Platinum level the Presenting Sponsor is still selected.

I did several tests and all post a unitprice of 10000

I hope you see the problem. It was not obvious to me until I copied your code and posted it to https://verify.faas.cloud.clickandpledge.com and then noticed that any test I do the unitprice is 10000. See the result of the test below:



Please let us know if we can be of any further assistance.

[[email protected]]

Thank you for your response! I didn't receive a email on this thread and was unaware that you replied so I apologize for the delay.

In this case, I don't understand why, if the code was wrong, we successfully processed a $1,000 donation after a donor had trouble with it. But then shortly after, we tested a $500 donation which posted at $5,000. If the Unit Price was the issue, wouldn't each donation pass as $10,000 if I'm understanding correctly?

Also, this past weekend, we had a donor give $5 on our Event Page but we received an error report and the transaction did not create an opportunity.

The Order # was 1403141908077052648 and the error read "Upsert failed. First exception on row 0; first error: ENTITY_IS_DELETED, entity is deleted: []"

Any idea why this may have happened? We are concerned that there is a deeper issue since these errors are occurring for both our custom pages and the C&P pages.

[CnP.Support]

Good day!

These are totally different issues. Your form needs to seriously be fixed since there is a major bug in the form. Please test it yourself - when you click on any level the first choice is not deselected. This is a major bug and your web developer needs to address it.

Please grant us access to your account so we can review that order. It appears that the transaction has been deleted but we need to login and review your account.

How to grant access: http://forums.clickandpledge.com/showthread.php?t=1065

[[email protected]]

Thanks, I will refer this to our developer - log in access has been granted.

[[email protected]]

It looks like the radio buttons are working fine. Our developer looked at this earlier in the week but we didn't understand why, as I mentioned before, if the code was wrong it would sometimes function correctly and then sometimes add a zero onto donations. Could you take a look at this form now and see if the bug is corrected?

I'll be waiting to hear back on that order - Thank you!

[CnP.Support]

Good day!

The problem was not a "sometimes" issue - I could duplicate it every single time. The steps I stated before was easily reproducible.

Based on checking the radio button it seems to be working fine. Now when I click on an option the previous selection is no longer selected whereas before it would stay checked.

I strongly recommend that your developer test his/her code by posting the form to https://Verify.FaaS.Cloud.ClickandPledge.com and make sure it works. We can't certify a third party code and verify that all aspects of it is working since that requires an elaborate test plan and execution. I can simply state that the radio buttons are now working and selections should post as identified by the form.

It is a good idea if you leave the form in test mode and test it yourself by randomly clicking on each option and completing the form to make sure it works.

Please let us know if we can be of more help.

[[email protected]]

Today is the first time we have attempted to go live with this form on our website since experiencing the "extra zero" issue and it occurred once again today when I ran a test transaction. I selected the $500 radio button and was charged $5,000. The Unit Prices all correspond and the values are correct. Could you please take a look and see what might be going on here? Every time we get this page functioning correctly, this issue has come up repeatedly over the course of the past few weeks.

Here is the URL:

https://cforr.secure.force.com/donate/GTK2014Sponsor

[CnP.Support]

Good day Caroline,

Would you please post back the URL that this transaction took place. You had listed 2 domains before and I need to make sure we test the right page.

[CnP.Support]

Good day!

We tried to test the form but copying it to our servers somehow disables the submit button. It seems like there is a lot of validation that are based on relative path.

Please do the following:

• Line 164: change the posting URL to: https://verify.faas.ClickandPledge.com
• Save and publish

Do your tests and see what values are being posted to the API. Your select list seems to be OK but we can't test your validations or other scripts. Something is changing your value before it posts to us.

Once you have changed the post let us know and we can test it and hopefully we can narrow it down.

[[email protected]]

Good day Caroline,

Would you please post back the URL that this transaction took place. You had listed 2 domains before and I need to make sure we test the right page.

This is the form:

https://cforr.secure.force.com/donate/GTK2014Sponsor

Order numbers for both $500 donations:

1404021012595381111

1404021003187611111

Now, I ran two $2,000 donations a few minutes ago and the form worked correctly. That is the strangest part of this issue - it has been intermittent for the past few weeks even when no changes are made to the form.