Community Forums 

Main Content

exporting shipping to paypal question

    May 30 2011 06:05:59

    #1

    Medusa

    Join date : 2011-05-22      Posts : 105

    I am trying to export shipping addresses to paypals multi order order shipping.
    1.) I downloaded a batch to a csv file from Mals
    2.) then, in paypal I import the file
    3.) in Paypals multi order shipping has you mapout the shipping, but I get an error, because Paypal asks for first name and last name separate, but mals has full name as one field.
    what do I do?

    WWW.MEDUSASMAKEUP.COM




    May 30 2011 14:35:40

    #2

    Alan

    Join date : 2008-09-18      Posts : 2950

    I would you edit the .csv file, adding a field delimiter to separate the two fields.

    Alan
    Some shipping help documents are available at www.stoner.org.uk/mals/




    May 30 2011 18:13:23

    #3

    Medusa

    Join date : 2011-05-22      Posts : 105

    I'm not sure how to edit the csv file as you described, any help would be greatly appreciated. Also, does that mean I would have to edit the file every time I download a batch of orders?

    WWW.MEDUSASMAKEUP.COM




    May 31 2011 05:57:41

    #4

    Alan

    Join date : 2008-09-18      Posts : 2950

    The .csv file will have a field delimiter, which defaults to a comma, and optionally a text delimiter which defaults to double quotes.

    The name in the string might be
    ,"William Shakespeare",

    in which case you'd need to change it to
    ,"William"," Shakespeare",

    You could make the change in an editor such as notepad, or in a spreadsheet by inserting a column and using cut and paste.

    Yes this solution would need to be applied to all orders.

    Alan
    Some shipping help documents are available at www.stoner.org.uk/mals/