- nemsdAsked on August 21, 2014 at 09:41 AM
The "Amount You Pay" field is passed to PayPal.
In the PayPal report there are two types of entries for one transaction "Shopping Cart Item" and "Website Payments Pro API Solution". The Shopping Cart Item shows the payment purpose title "NEMSD-IA" but it's blank for Website Payments Pro API Solution.
Could you please explain why there are two entries?
Thank you for your help
- nemsdAnswered on August 21, 2014 at 10:07 AM
I also moved the more detailed question which I posted on the other thread here. It has the link to the spreadsheet.
Right, it's the PayPal account and like I stated in my request, i'm referring to the PayPal report.
There are two entries for one transaction.
Under the "Type" column there are two types: "Shopping Cart Item" and "Website Payments Pro API Solution" for one transaction. And if you scroll across the spreadsheet, under the "Item Title" column, you will see that only "Shopping Car Item" types display the payment purpose title "NEMSD-IA". We use this title to identify which form is used for the transaction as there are many forms that use the same PayPal account.
It's very important to us that the payment title "NEMSD-IS" is displayed as it does.
In the "Fee" and "Net" columns, you will see that the data corresponds to the "Website Payments Pro API Solution" type. And we need this data as well
We need the data from the two types as it is the whole information about one transaction.
My question again is why are there two entries for one transaction?
How can we have all the information for one transaction under one entry?
Here is the link to the spreadsheet: http://www.nemsd.org/Doc-Vault/paypalreport.xlsx
Thank you for your help!
- JotForm SupportdavidAnswered on August 21, 2014 at 12:14 PM
I believe the two different report types are generated based on whether the user pays with their credit card or with PayPal. One or the other will be blank based on which payment method is used. I did some looking and the "Website Payments Pro API Solution" payments refer to PayPal pro credit card transactions. Different data is passed with each type of transaction and I am unsure if you can change the way this is handled.
- nemsdAnswered on August 21, 2014 at 02:04 PM
I did most of the test transactions and I used credit card only.
If you would look at the original thread may be it would give you the whole picture of the process.This question was moved to a new thread. But I will try to explain it here.
I had created a form and used the transactions wizard to populate the product items with a quantity field used for entering credit hours. Unfortunately, the total field didn't show any decimal places and that confused people even though the correct amount was charged.
So JotForm suggested the passing total from a calculated field solution and I used that. The total field showed decimal places.
With the former method, in the paypal transaction report, a transaction had only on entry and one type: "Website Payments Pro API Solution" and the whole transaction information including item title were displayed.
Withe pass total from calculated field method, a transaction has two entries and two types.
The product items with the new solution are check boxes. Could it be that the total that shows under "Shopping Cart" is pulled from the calculated field , and the "website Payments pro API solution" grabs the data from the check boxes? Is that why there are two entries?
Please help me. I'm trying to explain this to my client that manages the paypal account.
Thank you for your help.
- JotForm SupportdavidAnswered on August 21, 2014 at 02:50 PM
I believe I understand a bit better. It appears previously you were using a PayPal form for the list of items but now you are only using the form to collect the total passed to it by a calculation. If this is the case then yes, the payment information collected by the payment part of your form and the product information collected by the rest of your form, are essentially passed separately. When you products were in the payment section of your form, that information was passed as a package to your submission and to Paypal. If you are now using Check boxes and a value passed to the payment section, these values would indeed by passed separately. The payment section of the form functions as a form within a form. So you would have form data + paypal data rathar than all of the information wrapped into the paypal data part.
If this is not what you were looking for or if I still misinterpreted your question, let us know and we will see if we can clarify a bit more.
- nemsdAnswered on August 21, 2014 at 03:26 PM
Hi David, you got the whole picture. Thank you!
Consolidating the paypal report will be a pain. I wish there could only be one entry with all the data.
This started with decimals not showing in the total field. I really would like to see you awesome and smart people at JotForm come up with a solution for showing decimals in the total field.
Thank you for all your help!
- JotForm SupportdavidAnswered on August 21, 2014 at 03:58 PM
I went ahead and submitted a feature request to allow partial quantities. Say if someone wanted to purchase a half batch of cookies or a quarter batch. That would be nice also. We will update you here when we have a an idea of whether or not this is possible.
- JotForm SupportNeilVicenteAnswered on August 22, 2014 at 07:40 AM
Partial quantities are not accepted by any of PayPal's API solutions - a quantity of 1.5 does not make sense in an e-commerce point of view.
As for your original issue, I believe that that's how the report actually looks like. If you notice, the duplicate reports have the same transaction IDs because one of them refers to the API call and the other refers to the actual transaction.