{"id":21646,"date":"2017-04-04T17:23:53","date_gmt":"2017-04-04T21:23:53","guid":{"rendered":"https:\/\/www.inflowinventory.com\/support\/?p=21646"},"modified":"2018-10-05T12:55:14","modified_gmt":"2018-10-05T16:55:14","slug":"how-do-i-import-my-bill-of-materials-list-into-inflow","status":"publish","type":"post","link":"https:\/\/onpremise.inflowinventory.com\/support\/article\/21646\/how-do-i-import-my-bill-of-materials-list-into-inflow\/","title":{"rendered":"How do I import my Bill of Materials list into inFlow On-Premise?"},"content":{"rendered":"

You should import your product details into inFlow On-Premise first<\/a> before importing Bill of Materials. Once you’ve done so, your file would need to look like this:<\/p>\n\n

\"\"<\/div><\/p>\n\n

FinishedItem<\/strong>: This is the item name\/code of the finished product. You’ll need to repeat this in the next rows for each component. In the example above, 9400 has 2 components (20101 and 46101) so it’ll take up 2 rows.<\/p>\n

ComponentItem: <\/strong>This is the item name\/code of the component product.<\/p>\n

Quantity<\/strong>: This is the quantity of the ComponentItem<\/strong> needed in order to make 1 of the finished product. In the example above, 1 unit of 9400 requires 2 units of 20101 and 1 unit of 46101.<\/p>\n\n

It’s important to make sure all rows of the same FinishedItem<\/strong> are grouped together, so that inFlow can put them all in the same Bill of Materials.<\/p>\n\n

Saving as .csv file<\/h2>\n

Once you have your list open in Excel, make sure it\u2019s saved as a CSV. To do so:<\/p>\n

    \n
  1. Choose\u00a0<\/span>Save As<\/em>\u00a0<\/span>from the drop down menu.<\/li>\n
  2. At the bottom of this window you\u2019ll see a field\u00a0<\/span>Save as Type<\/em>. Choose\u00a0<\/span>CSV (comma delimited)<\/em>\u00a0<\/span>from the drop down.<\/li>\n
  3. Click\u00a0<\/span>Save<\/em>.<\/li>\n
  4. Excel will warn you about the loss of formatting, this is not a problem, please click\u00a0<\/span>Yes<\/em>\u00a0<\/span>to complete your save.<\/li>\n<\/ol>\n

    Ready to import? See\u00a0<\/span>how to import data from your file into inFlow<\/a>, or check out this\u00a0sample bill of materials import file<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

    You should import your product details into inFlow On-Premise first before importing Bill of Materials. Once you’ve done so, your file would need to look like this: FinishedItem: This is the item name\/code of the finished product. You’ll need to repeat this in the next rows for each component. In the example above, 9400 has […]<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"closed","ping_status":"closed","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\/21646"}],"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\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/comments?post=21646"}],"version-history":[{"count":9,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/21646\/revisions"}],"predecessor-version":[{"id":26615,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/21646\/revisions\/26615"}],"wp:attachment":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/media?parent=21646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/categories?post=21646"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/tags?post=21646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}