Mapping from CSV file into PayPal MultiOrder Shipping

Mr_Fantastic
Contributor
Contributor

I am having a challenge when I use PayPal MultiOrder from a file:

 

I have a my CSV file of orders> Open PayPal MultiOrder Shipping> Import from File> Import CSV file> I Map fields. It the goes to showing errors like this:

 

"The MultiOrder Shipping tool was unable to import the file you attempted to upload due to invalid or unreadable required data in row=35 column=5. Please check your file and try again."

 

I look at the file through Excel. This is a address cell. I don't understand. Is the program checking for valid address and not stating to me as such?

 

I remove the order entry (I thought I would just single order entry it. I get another row/ column error. And another. And another.... 

 

I have yet to be able to successfully utilize the Import File feature in PayPal MultiOrder Shipping.

 

Also, I have successfully used the same file in order to import into another shipping program with no issues. 

 

Any help in guiding me to a successful import would be most appreciative.

 

 

Login to Me Too
2 REPLIES 2

ORS
New Community Member

I was able to solve this using a compbination of:

- Removing any unused columns from the spreadsheet (that arn't being mapped)

- Filling blank cells (ie most of 'Address Line 2' fields with some text (like NA))

Login to Me Too

ORS
New Community Member

I just got the error again on a larger sheet. I removed all . at the end of St. Rd. etc. This didn't work. I exported as a TSV instead of CSV and it worked ...

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.