Paypal Line Item Importer Not Recognizing .CSV File

Hello,
After following the steps in the Import CSV Line Items for generating a Paypal .csv file report, when attempting to upload the .csv file, I get the following notification. Importer Error Message

Appreciate any suggestion as to how to resolve, thank you.

Good question, @rianandcourtney.

Right now our importer looks for exacting signatures in the column headers to recognize the import type. If the columns in the CSV don’t match our file-type rules exactly, the CSV is not recognized for import.

For the Paypal importer, the scripts expect this complete list of columns:

  • Date
  • Time
  • TimeZone
  • Name
  • Type
  • Status
  • Currency
  • Gross
  • Fee
  • Net
  • From Email Address
  • To Email Address
  • Transaction ID
  • Shipping Address
  • Address Status
  • Item Title
  • Item ID
  • Shipping and Handling Amount
  • Insurance Amount
  • Sales Tax
  • Option 1 Name
  • Option 1 Value
  • Option 2 Name
  • Option 2 Value
  • Reference Txn ID
  • Invoice Number
  • Custom Number
  • Quantity
  • Receipt ID
  • Balance
  • Address Line 1
  • Address Line 2/District/Neighborhood
  • Town/City
  • State/Province/Region/County/Territory/Prefecture/Republic
  • Zip/Postal Code
  • Country
  • Contact Phone Number
  • Subject
  • Note
  • Country Code
  • Balance Impact

This column matching is particularly susceptible to variances when using non-US versions of exports.

Hope this helps,
Randy

Thank you @randy,
I manually added the above column headers to the .csv file and the importer did indeed accept the file with those header additions, thank you.
However the amounts did not transfer to from the .csv file to the Transactions sheet.
What is the scripts column header that maps to the ‘Amount’ column header in the Transactions sheet?

On a quick peek at the importer rules, it looks like the Amount comes from the Net column in the CSV.

Good luck.