1 / 28
Nov 2013

The customers telephone number does not appear in the transaction log - can this field be added to the log?

Apologies - I see that the phone number is buried in the billing and shipping info



so my next question relates to paypal - as I am using paypal to process my credit card transactions, is this number being passed to paypal? It appears not to be as when I use a API to download paypal data to quickbooks, it is not bringing over the phone number

I have checked in admin, make the phone number a mandatory field - but when I click in the cart to pay with a credit card, the phone number field is not marked with a star to make it mandatory

The billing address phone number is not made mandatory, but the shipping address phone number is. The buyer will have to include a phone number to complete the checkout process.



For the transactions where the phone number is not being recorded in Paypal, do you see it on our end?

As an example



Transaction id 0VV058426M9160518 - PayPal Pro (DirectPayment)



I see the phone number in the transaction log for both the billing and shipping address - in paypal I see the billing phone # (should really be the shipping phone #?) - When I run the API - no phone number uploads in to quickbooks



Transaction id 4YK2779580957415P - PayPal Pro (Express Checkout)



I see no phone numbers in the transaction log for both the billing and shipping address - I also do not see a phone number in Paypal - but when I run my API, the phone number gets transferred to Quickbooks



Very strange!!

I'll ask Development to confirm which phone number we can make required for card-based Direct Payments and how we're transmitting that to PayPal.



Note that checkouts going through PayPal's checkout site (i.e., Express Checkout) cannot pick up the Phone Required setting from our end; instead, those checkouts use a setting in your own PayPal account (My Account > Profile > My Selling Tools > Website Preferences > Contact Telephone Number).



Regarding issues your QuickBooks integration API, that would be a matter to troubleshoot with the developer of that integration. You might also consider using ConsoliBYTE to integrate QuickBooks with E-junkie, rather than integrating with PayPal's end:

http://consolibyte.com/quickbooks-integration/ejunkie-quickbooks/



As for the phone number appearing in QuickBooks when no phone number was provided for the order (as in that last order you mentioned), I can only speculate, but perhaps for the API transmission PayPal was pulling billing info directly from the buyer's PayPal account profile independently of what was actually used during checkout for that order, or maybe QuickBooks itself is copying phone info from previous orders by the same buyer?

Express checkout seems to be working fine -



Would appreciate an update from development to confirm which phone number we can make required for card-based Direct Payments and how we're transmitting that to PayPal - because that is my problem

When you enable the Phone Required setting at our end, card-based direct payment checkouts will make the Shipping Phone required, but not Billing. This is because some shipping methods may require a phone number for the recipient in case of delivery issues, so we let sellers make that mandatory if needed, but a Billing Phone is never strictly necessary to charge or ship an order, so we don't require that as it would only tend to deter buyers concerned about privacy and telemarketing from placing an order at all.

Just an update on what Development found in researching this matter:



For card-based Direct Payments, we're transmitting the Billing Phone as PHONENUM and Shipping Phone as SHIPTOPHONENUM, which is what they document for those fields. It sounds like PayPal just isn't displaying Shipping Phone numbers at all for Direct Payments (at least not where you were looking), though this doesn't explain why you ended up with no phones in QuickBooks for 0VV058426M9160518 which does show both numbers in our log, so that sounds like a bug in your QB integration service.



We did discover a bug in our integration with Express Checkouts going thru PayPal's checkout site; we weren't correctly capturing the Shipping Phone from them, so that number wasn't making it into our Transaction Logs, which would explain why you wound up with a Shipping Phone in your QuickBooks that wasn't present in your EJ log for 4YK2779580957415P.

Paypal sent me a sample string of what they are receiving from e-junkie - see below



this string does not include PHONENUM or SHIPTOPHONENUM



DoDirectPaymentRequest

method "DoDirectPayment"

version "58"

user "XXXXXXXXXXX"

subject "XXXXXXXXXXX"

paymentaction "Sale"

ipaddress "XX.XXX.XXX.XXX"

currencycode "USD"

amt "665"

itemamt "665"

shippingamt "0"

taxamt "0"

custom "XXXXX"

invnum "XXXXXXXXXXXX"

buttonsource "E-JUNKIE_ShoppingCart_DP_US"

notifyurl "https://www.fatfreecartpro.com/ecom/12103/ipnres_cart.php"

name "BK901 Bunk Bed FREE SHIPPING Twin over Twin Stairway Bunk Bed + 2 Extra Drawers\, Honey"

number "BK901-HONEY-DRAWERS"

qty "1"

desc "BK901 Bunk Bed FREE SHIPPING Twin over Twin Stairway Bunk Bed + 2 Extra Drawers\, Honey"

creditcardtype "MasterCard"

expdate XXXXXX

firstname "XXXX"

city "XXXXX"

state "XX"

zip "XXXXX"

countrycode "XX"

shiptoname "XXXX"

shiptocity "XX"

shiptostate "XX"

shiptozip "XXXXX"

shiptocountry "XX"

Hi Denis,



Whatever stage they're getting that data from, it's after the stage where they're losing the values we're sending them. I'm the one that initially confirmed our code does in fact send the values, and I just turned on debug capture for our submissions for your account, and they are there. I'll send you an email through our helpdesk here shortly with a couple of the example captures showing that; maybe we can get in on your discussion with PayPal MTS and help them figure this out?

Thanks



can you please send me that email so I can send it to paypal - maybe you can also speak to your paypal contact?

It appears Development already sent that to your bunkbedking.com email on Sunday evening; I've forwarded a copy of that to your bedzking.com email just now.

26 days later

I've referred this to Development, so the matter's in their hands now.

18 days later

To continue



We have the phone number as mandatory in our settings



But the billing phone number is not mandatory (no red asterisk)



But if a customer leaves the billing phone number blank and then enters a shipping phone number - they get the message " Please enter a valid telephone number"



Very confusing for the customer - we only ask them for the shipping phone number, but then when they only provide a shipping phone number, they cannot proceed with the checkout.



Suggest you give us the option to make the billing phone number mandatory (red asterisk) - or change your code so if the billing number is blank and a shipping phone number is entered, the charge will process



Also, any news on :



can you change the request that is made to paypal and have them remove the PHONENUM parameter?



Can you try replacing the "PHONENUM" variable with "SHIPTOPHONENUM". I believe this is the reason it's not returned as it's not a valid parameter for the "DoDirectPayment".



You can find a list of parameters here:

https://developer.paypal.com/webapps/developer/docs/classic/api/ merchant/DoDirectPaymentAPI_Operation_NVP/





POSTED ON: January 14, 2014 @ 06:32 GMT -7

I've just now reminded Development again that your issue remains unresolved.