Purpose
Procedure
Tips and Tricks
- Most of the differences are minor heading wording in field names.
- The import module looks for specific wording in the heading.
- Hence if the Paypal download gives different formats for some countries (other than NZ, AU, UK), it will need to be resolved manually by editing the import module's files or by normalising the downloaded file to an acceptable format before import.
Resources
- import_paypal FA Extension @ Unofficial GitHub Repo
- Forum Post
Formats
PayPal Download History has many fields and some are present only for certain Countries / Currencies. This module was written for NZ/AU/UK and the fields are listed here:
- Date
- Time
- Time Zone
- Name
- Type
- Status
- Subject (For AU only)
- Currency
- Gross
- Fee
- Net
- From Email Address
- To Email Address
- Transaction ID
- Counterparty Status
- Address Status
- Item Title
- Item ID
- Shipping and Handling Amount (NZ, AU)
- Postage and Packing Amount (UK)
- Insurance Amount
- Sales Tax (NZ)
- GST (AU
- VAT (UK)
- Option 1 Name
- Option 1 Value
- Option 2 Name
- Option 2 Value
- Auction Site
- Buyer ID
- Item URL
- Closing Date
- Escrow Id (NZ, UK only)
- Invoice Id (NZ, UK only)
- Reference Txn ID
- Invoice Number
- Custom Number
- Receipt ID
- Balance
- Address Line 1
- Address Line 2/District/Neighborhood (NZ)
- Address Line 2/District/Neighbourhood (AU, UK)
- Town/City (NZ, UK)
- Suburb (AU)
- State/Province/Region/County/Territory/Prefecture/Republic
- Zip/Postal Code (NZ)
- Postcode (AU, UK)
- Country
- Contact Phone Number