{"id":3259,"date":"2014-05-28T20:03:40","date_gmt":"2014-05-29T00:03:40","guid":{"rendered":"https:\/\/www.inflowinventory.com\/support\/article\/3259\/how-do-i-create-a-customer-or-vendor-list-for-import\/"},"modified":"2018-05-16T10:44:23","modified_gmt":"2018-05-16T14:44:23","slug":"how-do-i-create-a-customer-or-vendor-list-for-import","status":"publish","type":"post","link":"https:\/\/onpremise.inflowinventory.com\/support\/article\/41573190\/how-do-i-create-a-customer-or-vendor-list-for-import\/","title":{"rendered":"How do I create a customer or vendor list for import?"},"content":{"rendered":"<p>You can import customer info \/ vendor info into inFlow On-Premise by using a .csv file. The only required field is &#8220;Name&#8221; , but there are other fields that you can input as well, like address, currency, contact. Please note inFlow does not have &#8220;first name\/ last name&#8221;, only a single field, and that the Name field is unique. inFlow cannot create duplicate records with the same name in inFlow.<br \/>\nIf you&#8217;re looking for a quick way to create a template for your customer (or vendor) data we&#8217;ve got a great trick! First add at least one new customer (or vendor) to your system and then you&#8217;ll export from the system. Go to the <em>Main Menu &gt; General &gt; Export Data<\/em> and select the &#8220;Customer&#8221; (or &#8220;Vendor&#8221;) option. This will give you a .csv file with all the columns inFlow can track. You can use this file as a starting point to fill in your details and add your customers (or vendors) into inFlow.<\/p>\n\n<p>You can also use the <a href=\"https:\/\/cdn2.inflowinventory.com\/inFlowWebsite\/KnowledgeBase\/Resources\/inFlow_Customer.csv\">sample customer<\/a> and <a href=\"https:\/\/cdn2.inflowinventory.com\/inFlowWebsite\/KnowledgeBase\/Resources\/inFlow_Vendor.csv\">vendor import list<\/a> we&#8217;ve exported for you.<\/p>\n\n<p>Before you start importing you&#8217;ll want to make a backup via the <em>Main Menu &gt; General &gt; Backup Data<\/em>. Next try importing your new .csv file in via the <em>Main Menu &gt; General &gt; Import Data<\/em> to see your items updated!<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"<p>You can import customer info \/ vendor info into inFlow On-Premise by using a .csv file. The only required field is &#8220;Name&#8221; , but there are other fields that you can input as well, like address, currency, contact. Please note inFlow does not have &#8220;first name\/ last name&#8221;, only a single field, and that the [&hellip;]<\/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\/3259"}],"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=3259"}],"version-history":[{"count":5,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3259\/revisions"}],"predecessor-version":[{"id":25398,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3259\/revisions\/25398"}],"wp:attachment":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/media?parent=3259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/categories?post=3259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/tags?post=3259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}