Not all Custom Button Transaction Data Exports

mapper66
New Community Member

I created a custom button with 3 drop-down options and one text field. It works fine. We receive orders (purchases) just fine. When I review the details of a transaction I see the information the user entered for the drop-downs and text field; however, when I export my transactions to a CSV or tab delimited file only data for the first two drop-downs is included. I'm missing the data for the last drop-down and the text field. It simply isn't included in the export. I created a test button to test this and the same thing happened: only data for the first two options of a custom button is included. Is there a fix for this?

PayPal support has not been very helpful. Thanks.

Login to Me Too
5 REPLIES 5

snowshoe
Frequent Advisor
Frequent Advisor

Unfortunately the export to CSV file will only show the first 2 options.  (There's no tricks or tips to change this behaviour.)

Login to Me Too

wabamaine
New Community Member

This is really a big hole in the button usage. Why create options if you can't download the data? So what am I left with, individually scraping data off of each order? This is not user or data analytic friendly. Is there any chance this will be updated soon?

 

Login to Me Too

PayPal_Nate
PayPal Employee
PayPal Employee

Hi mapper66,

 

 

I have to say that this is surprising.  I'll be getting in touch with the Product Manager for reporting (history.paypal.com) to find out if there is anything I can do to help get this added to the History Download.  I can't make any promises, or provide any timelines, but I'll look into it for sure. Follow up with me in a few days if I don't update this thread and I'll do my best to get you an update.

 

As a possible solution you may want to look into Payment Data Transfer, or Instant Payment Notification.

 

I tested the below button with all 10 options, and Payment Data Transfer and Instant Payment Notificaion have the variables and values.

 

<form action="https://www.sandbox.paypal.com/cgi-bin/webscr" method="POST" target="_blank">
<input type="hidden" id="cmd" name="cmd" value="_xclick">
<input type="hidden" id="business" name="business" value="<accountEmail>">
<input type="hidden" id="notify_url" name="notify_url" value="http://<myIPNURL>.com/ipns/ipn.php">
<input type="hidden" id="item_name" name="item_name" value="ItemName">
<input type="hidden" id="amount" name="amount" value="10.00">
<input type="hidden" id="item_number" name="item_number" value="ABC1234567">
<input type="hidden" id="invoice" name="invoice" value="7654321CBA">
<input type="hidden" id="custom" name="custom" value="BN013">
<input type="hidden" id="bn" name="bn" value="PP_BuyNow_WPS_US">
<input type="hidden" id="shipping" name="shipping" value="4.99">
<input type="hidden" id="shipping2" name="shipping2" value="1.99">
<input type="hidden" id="quantity" name="quantity" value="2">
<input type="hidden" id="tax" name="tax" value="1.00">
<input type="hidden" id="on0" name="on0" value="OptionName0">
<input type="hidden" id="on1" name="on1" value="OptionName1">
<input type="hidden" id="on2" name="on2" value="OptionName2">
<input type="hidden" id="on3" name="on3" value="OptionName3">
<input type="hidden" id="on4" name="on4" value="OptionName4">
<input type="hidden" id="on5" name="on5" value="OptionName5">
<input type="hidden" id="on6" name="on6" value="OptionName6">
<input type="hidden" id="on7" name="on7" value="OptionName7">
<input type="hidden" id="on8" name="on8" value="OptionName8">
<input type="hidden" id="on9" name="on9" value="OptionName9">
<input type="hidden" id="os0" name="os0" value="OptionSelect0">
<input type="hidden" id="os1" name="os1" value="OptionSelect1">
<input type="hidden" id="os2" name="os2" value="OptionSelect2">
<input type="hidden" id="os3" name="os3" value="OptionSelect3">
<input type="hidden" id="os4" name="os4" value="OptionSelect4">
<input type="hidden" id="os5" name="os5" value="OptionSelect5">
<input type="hidden" id="os6" name="os6" value="OptionSelect6">
<input type="hidden" id="os7" name="os7" value="OptionSelect7">
<input type="hidden" id="os8" name="os8" value="OptionSelect8">
<input type="hidden" id="os9" name="os9" value="OptionSelect9">
<input type="image" name="submit" border="0" src="https://www.paypalobjects.com/webstatic/en_US/btn/btn_buynow_pp_142x27.png" alt="PayPal - The safer, easier way to pay online">
</form>

Here is the IPN/PDT Data for the above button which contains the option names and option values:

SUCCESS
mc_gross=27.98
invoice=7654321CBA
protection_eligibility=Eligible
address_status=confirmed
payer_id=N9DBPUZ67JDBC
tax=1.00
address_street=1+Main+St
payment_date=09%3A08%3A34+Dec+04%2C+2015+PST
payment_status=Completed
charset=windows-1252
address_zip=95131
first_name=Test
option_selection1=OptionSelect0
option_selection2=OptionSelect1
option_selection3=OptionSelect2
option_selection4=OptionSelect3
mc_fee=1.11
option_selection5=OptionSelect4
address_country_code=US
option_selection6=OptionSelect5
address_name=Test+Buyer
option_selection7=OptionSelect6
option_selection8=OptionSelect7
option_selection9=OptionSelect8
custom=BN013
payer_status=verified
business=<accountEmail>
address_country=United+States
address_city=San+Jose
quantity=2
payer_email=nate-buyer%buyer.com
option_name1=OptionName0
option_name2=OptionName1
option_selection10=OptionSelect9
option_name3=OptionName2
option_name4=OptionName3
option_name5=OptionName4
contact_phone=408-520-5199
option_name6=OptionName5
option_name7=OptionName6
option_name8=OptionName7
txn_id=17Y51258FP247314L
payment_type=instant
option_name9=OptionName8
last_name=Buyer
address_state=CA
receiver_email=n8%40x.com
payment_fee=1.11
option_name10=OptionName9
shipping_discount=0.00
insurance_amount=0.00
receiver_id=JKNGDPP2UU3VC
txn_type=web_accept
item_name=ItemName
discount=0.00
mc_currency=USD
item_number=ABC1234567
residence_country=US
shipping_method=Default
handling_amount=0.00
transaction_subject=BN013
payment_gross=27.98
shipping=4.99

 

- PP_N8

Login to Me Too

AustinSwingDanc
New Community Member

I'm also having this problem, Nate. Any ideas? If you like, I can direct you to a payment button in my profile in a private message.

 

Thanks!!!

Login to Me Too

IvanP
New Community Member

I just got back from a chat with a "technical support" person form PayPal and her answer was to go transaction by transaction to look at the 3rd custom field. This is very lame.

 

If anybody from PayPal reads this, could you guys help resolving this issue? At least prevent adding more than 2 fields in payment buttons to be consistent with the history reporting.

Login to Me Too

Haven't Found your Answer?

It happens. Hit the "Login to Ask the community" button to create a question for the PayPal community.