New to Xcoin? Sign up today
Email Address Password  
Remember Me? Forgot your password?
 
 
Import Wizard
Payment Solutions
How to Export Buyer Names & Addresses from Paypal to a CSV File
If your buyers use PayPal to pay for their purchases, you can quickly export all names and addresses to a type of spreadsheet known as a CSV file and then use that spreadsheet to import the shipping information into other programs like Stamps.com or Endicia. Here’s how:
How does it work?
1. Log in to your PayPal Account. Go to My Account. In the Account Overview, look for the Payments Received link towards the bottom of the window. Click on it.



2. This will take you to your History area, where you can find payment information sorted by date. You can choose dates based on a defined period, like “Past Month” or by specified “To” and “From” parameters. PayPal’s history is very comprehensive, so that you can go back literally for years.

Be aware that the more transactions there are in your history, and the more data you are requesting, the longer it will take PayPal to process your request. If you are a high volume seller, PayPal may notify you that you will receive an email telling you when the information is ready. Do not be alarmed. Even for large amounts of data, the processing time is usually a matter of minutes rather than hours.

In your History area, begin to set up your Search criteria.

Set the Show criteria to “Payments Received

Select the appropriate date range by clicking on the radio button for either “Within” or “From.” Then enter the period or dates you want to use.

When you are ready, click the Search button.

Your results will appear in a table at the bottom of the screen.



3. Now look at the top left hand side of your screen. You will see a navigation bar labeled “History.” Look for the link “Download My History” and click on it. This will take you to a new page, called Download History, where you will begin to prepare your data for the CSV export.



4. When you reach the Download History page, look for the Customize Download Fields link on the right hand side. This is your starting point. Click on the link.




You will now be presented with a large number of options, for both website and auction payments. For the purposes of exporting for address labels, all eBay sales, no matter what their listing format (auction, store, fixed price) should be considered Auction Payments. Web site payments will not include eBay payments.

Since you are using this CSV file to create shipping labels, you will probably want to keep your included fields minimal: include the information you need to identify the item, the buyer, and the ship to address.

5. Be sure to choose the same column option - either Single Column or Multi-Column Shipping Address - for both your website and PayPal payments. To simplify converting your finished CSV file to address labels, I recommend you choose Multi Column Shipping Address.



6. Select only the fields you need to identify your buyer, the item, and the shipping address. Click Save when you are finished. You can go back and change these options as often as you wish.

7. After saving your Customized Download Fields, you will be returned to the Download History page.

Here you will see a date range option.

The more often you use the export function, the more likely it is that you’ll opt for Last Download to Present. It is not only a time saver, but it ensures that you do not accidentally miss any payments.

However, while you are first setting up this feature, I recommend that you select Custom Date Range.



Under both “Custom Date Range” and “Last Download to Present,” you will see a drop down list called File Type to Download. This menu is keyed to the date range. Be sure to select from the “File Type to Download” list that is beneaththe date range option that you wish to use.

8. From the drop down list, choose Comma Delimited – Completed Payments



9. Now click on the Download History button.

Remember, if you have a lot of data, or if you are a high volume seller, this process will take a bit longer. In that case, don’t wait until you are running out the door to print your shipping labels.



10. PayPal will begin to download the new CSV file to your computer. You will see a dialogue box asking if you wish to open or save the file. Choose Save, and then select a folder on your computer where you want to place these files. Make a note of the location, since you will need to be able to find the file from third party applications like Stamps.com.




Congratulations! You have successfully exported the CSV file to your computer, where it is ready for use.


 About Us  |  Contact Us  |  Account Types  |  Payment Solutions  |  Developers
Import Wizard  |  CEO Blog  |  Team Blog  |  Referral  |  Privacy  |  Terms of Use  |  Fees


©2000-2014 Xcoin (USA) Inc. All Rights Reserved.
Designated trademarks and brands are the property of their respective owners.