{"id":3250,"date":"2014-06-13T16:22:39","date_gmt":"2014-06-13T20:22:39","guid":{"rendered":"https:\/\/www.inflowinventory.com\/support\/article\/3250\/how-do-i-import-product-details-into-inflow\/"},"modified":"2018-10-05T12:52:53","modified_gmt":"2018-10-05T16:52:53","slug":"how-do-i-import-product-details-into-inflow","status":"publish","type":"post","link":"https:\/\/onpremise.inflowinventory.com\/support\/article\/44652340\/how-do-i-import-product-details-into-inflow\/","title":{"rendered":"How do I import product details into inFlow On-Premise?"},"content":{"rendered":"<h4><\/h4>\n<p>An import can create records in inFlow from a list that you already have. In order to use your file for import, you\u2019ll need to be sure it\u2019s in the right format. Here\u2019s an example of a <em>Product Details<\/em> (<strong>doesn&#8217;t include stock levels<\/strong>) file for import:<\/p>\n\n<p><div class=\"article-image\"><img loading=\"lazy\" class=\"aligncenter\" src=\"https:\/\/cdn2.inflowinventory.com\/inFlowWebsite\/images\/KBImages\/Create-Import-File-v3.png\" alt=\"\" width=\"280\" height=\"104\" \/><\/div><\/p>\n\n<blockquote><p>NOTE: This is very small example. You can add more columns to import more information.<\/p><\/blockquote>\n<p>Based on this example inFlow will create four products, each including the <a href=\"http:\/\/support.inflowinventory.com\/v3\/article\/38738410\/how-do-i-choose-my-product-type\">item type<\/a>, corresponding price and cost from the adjacent columns. The example only contains four columns, but you can add more, \u00a0such as barcode, vendor price, category, etc.<\/p>\n\n<h2>What happens if I already have the same products in inFlow?<\/h2>\n<p>Not to worry, there won&#8217;t be any duplicates! inFlow looks at the Item Name field (in the file) to determine whether the same item already exists in the program. If it doesn&#8217;t exist, then inFlow will create them as new items. If it does exist, then inFlow will\u00a0<strong>update<\/strong> the details in the program to match the details in the file.<\/p>\n<p>For example, if there&#8217;s already an item named 10201 with a unit price of $10 in the program, then following the example in the image above, the import will update item 10201 to use a unit price of $12.99.<\/p>\n<p>A few things to remember:<\/p>\n<ul>\n<li>The product name (<em>Item Name\/Code<\/em>) is a required field in inFlow and must be <strong>unique<\/strong>.<\/li>\n<li>Item Type is a permanent choice in inFlow and cannot be changed. If not specified in the import file, it will automatically be set to <em>Stockable<\/em>.<\/li>\n<li>Any information going into one field must all be in the same column, as inFlow can\u2019t import into one field from two columns.<\/li>\n<\/ul>\n<h2>Importing serialized products:<\/h2>\n<p>For importing products with serials, you&#8217;ll need a couple extra columns in the <em>Product Details<\/em> import file, which are specific to serialized products only: <em>TrackSerials<\/em> (TRUE for serialized, False for non-serialized), <em>SerialPrefix, SerialNextNumber<\/em>, and <em>SerialSuffix<\/em> columns.<\/p>\n\n<p><div class=\"article-image\"><img loading=\"lazy\" class=\"aligncenter\" src=\"https:\/\/cdn2.inflowinventory.com\/inFlowWebsite\/images\/KBImages\/Create-Import-File-2-V3.png\" alt=\"\" width=\"547\" height=\"57\" \/><\/div><\/p>\n\n<p>In this example above, inFlow will create a product record named &#8220;BEL-LED-2350-HD&#8221;, and &#8220;BEL0007LED&#8221; would be the next serial number generated in inFlow if you were to add more stock to this product.<\/p>\n\n<h2>Saving as .csv file<\/h2>\n<p>Once you have your list open in Excel, make sure it&#8217;s saved as a CSV. To do so:<\/p>\n<ol>\n<li>Choose <em>Save As<\/em> from the drop down menu.<\/li>\n<li>At the bottom of this window you\u2019ll see a field <em>Save as Type<\/em>. Choose <em>CSV (comma delimited)<\/em> from the drop down.<\/li>\n<li>Click <em>Save<\/em>.<\/li>\n<li>Excel will warn you about the loss of formatting, this is not a problem, please click <em>Yes<\/em> to complete your save.<\/li>\n<\/ol>\n\n<p>Ready to import? See <a href=\"https:\/\/onpremise.inflowinventory.com\/support\/article\/41121884\/how-do-i-import-data-to-inflow\/\">how to import data from your file into inFlow<\/a>,\u00a0or check out this <a href=\"https:\/\/onpremise.inflowinventory.com\/support\/wp-content\/uploads\/sites\/4\/2014\/05\/inFlow_ProductDetails_v36.csv\">sample product import file<\/a>.<\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>An import can create records in inFlow from a list that you already have. In order to use your file for import, you\u2019ll need to be sure it\u2019s in the right format. Here\u2019s an example of a Product Details (doesn&#8217;t include stock levels) file for import: NOTE: This is very small example. You can add [&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,203,192,271,49,284],"_links":{"self":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3250"}],"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=3250"}],"version-history":[{"count":9,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3250\/revisions"}],"predecessor-version":[{"id":26614,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3250\/revisions\/26614"}],"wp:attachment":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/media?parent=3250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/categories?post=3250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/tags?post=3250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}