{"id":3241,"date":"2014-07-25T15:18:08","date_gmt":"2014-07-25T19:18:08","guid":{"rendered":"https:\/\/www.inflowinventory.com\/support\/article\/3241\/downloading-orders-from-paypal-into-inflow\/"},"modified":"2018-06-12T17:55:42","modified_gmt":"2018-06-12T21:55:42","slug":"downloading-orders-from-paypal-into-inflow","status":"publish","type":"post","link":"https:\/\/onpremise.inflowinventory.com\/support\/article\/50083644\/downloading-orders-from-paypal-into-inflow\/","title":{"rendered":"Downloading orders from Paypal into inFlow On-Premise"},"content":{"rendered":"

You can download CSV files from PayPal once you\u2019ve made your sales. To do so:<\/p>\n

    \n
  1. Log into PayPal (be sure you’re logging into an admin account).<\/li>\n
  2. Click the HISTORY link under the MY ACCOUNTS tab on your main vendor page (as soon as you log in).<\/li>\n
  3. If available be sure to choose to show your transactions in your home currency (there is a dropdown in the top right which allows you to choose).<\/li>\n
  4. Filter the list to show the orders you wish to download.<\/li>\n
  5. Click the DOWNLOAD: CSV link in the top right of the table<\/li>\n
  6. You will see a window pop up where you can choose which file you’d like to download (for example you can download only payment completed transactions or all transactions).<\/li>\n
  7. If your file is too large the system will email you a link once the file has been created. This link will log you back into PayPal and allow you to download the file. If it is reasonably small then the system will load you straight into the window where you can download the file.<\/li>\n<\/ol>\n
    <\/div>\n
    \n

    Importing the file to inFlow<\/strong><\/p>\n

    Once you have a file from PayPal you can import it into inFlow in the following manner:<\/p>\n

      \n
    1. Go to Main Menu > General > Import Data.<\/em><\/li>\n
    2. Choose Sales Orders<\/em> as your data type.<\/li>\n
    3. Click Browse<\/em> and select the file that you\u2019d like to import (the one you made in step one).<\/li>\n
    4. Click Next<\/em>.<\/li>\n
    5. Choose whether you want to import your orders as open or closed.<\/li>\n
    6. Match the columns within your PayPal file to the columns in inFlow. We suggest the following matches:<\/li>\n<\/ol>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
      inFlow Field<\/strong><\/td>\nPayPal Field<\/strong><\/td>\n<\/tr>\n
      <\/td>\n<\/tr>\n
      Customer Information<\/strong><\/td>\n<\/tr>\n
      Customer<\/td>\nName<\/td>\n<\/tr>\n
      Phone<\/td>\nContact Phone Number<\/td>\n<\/tr>\n
      Email<\/td>\nFrom Email Address<\/td>\n<\/tr>\n
      <\/td>\n<\/tr>\n
      Addresses (Billing Address)<\/strong><\/td>\n<\/tr>\n
      Address Line 1<\/td>\nAddress Line 1<\/td>\n<\/tr>\n
      Address Line 2<\/td>\nAddress Line 2\/District\/Neighborhood<\/td>\n<\/tr>\n
      City<\/td>\nTown\/City<\/td>\n<\/tr>\n
      State\/Province<\/td>\nSate\/Province\/Region\/Country<\/td>\n<\/tr>\n
      Country<\/td>\nCountry<\/td>\n<\/tr>\n
      Zip\/Postal Code<\/td>\nZip\/Postal Code<\/td>\n<\/tr>\n
      <\/td>\n<\/tr>\n
      Order Info<\/strong><\/td>\n<\/tr>\n
      Order Date<\/td>\nDate<\/td>\n<\/tr>\n
      Order Number<\/td>\nTransaction ID<\/td>\n<\/tr>\n
      Order Remarks<\/td>\nNote<\/td>\n<\/tr>\n
      Freight<\/td>\nFee<\/td>\n<\/tr>\n
      Amount Paid<\/td>\nNet<\/td>\n<\/tr>\n
      <\/td>\n<\/tr>\n
      Item Info<\/strong><\/td>\n<\/tr>\n
      Item Name\/Code<\/td>\nItem Title<\/td>\n<\/tr>\n
      Item Subtotal<\/td>\nGross<\/td>\n<\/tr>\n
      Custom 1<\/td>\nReceipt ID<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

      7. Click Next<\/em> to finish.<\/p>\n\n

      If you are having trouble:<\/p>\n

        \n
      1. Check to be sure that your refunds haven\u2019t been imported as Fully Shipped orders. If so, cancel them.<\/li>\n<\/ol>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

        You can download CSV files from PayPal once you\u2019ve made your sales. To do so: Log into PayPal (be sure you’re logging into an admin account). Click the HISTORY link under the MY ACCOUNTS tab on your main vendor page (as soon as you log in). If available be sure to choose to show your […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_et_pb_use_builder":"","_et_pb_old_content":""},"categories":[20,27],"tags":[46,49],"_links":{"self":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3241"}],"collection":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/comments?post=3241"}],"version-history":[{"count":4,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3241\/revisions"}],"predecessor-version":[{"id":25771,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3241\/revisions\/25771"}],"wp:attachment":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/media?parent=3241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/categories?post=3241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/tags?post=3241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}