{"id":3213,"date":"2014-09-05T16:07:02","date_gmt":"2014-09-05T20:07:02","guid":{"rendered":"https:\/\/www.inflowinventory.com\/support\/article\/3213\/i-was-using-a-workaround-for-serial-numbers-last-version-how-do-i-switch-to-the-new-serial-feature\/"},"modified":"2018-03-01T15:46:41","modified_gmt":"2018-03-01T20:46:41","slug":"i-was-using-a-workaround-for-serial-numbers-last-version-how-do-i-switch-to-the-new-serial-feature","status":"publish","type":"post","link":"https:\/\/onpremise.inflowinventory.com\/support\/article\/55455720\/i-was-using-a-workaround-for-serial-numbers-last-version-how-do-i-switch-to-the-new-serial-feature\/","title":{"rendered":"I was using a workaround for serial numbers last version of inFlow On-Premise, how do I switch to the new serial feature?"},"content":{"rendered":"

Note: The serial number tracking feature is only available for premium edition licence holders<\/em><\/h4>\n

If you\u2019ve been tracking serial numbers using version 2 of inFlow On-Premise, the good news is that the new features should make your life much easier! The bad news is that it\u2019ll take some work to migrate your existing data.<\/p>\n

We have been recommending two ways of tracking serial numbers in version 2, as outlined here<\/a>. The first way is to track each serialized unit in a separate product in inFlow, and the second way is using the sublocation work around. Please see below instructions for migrating to the new serial number feature for the method you\u2019ve been using below.<\/p>\n

Ready? Alright, here we go!<\/p>\n

<\/h5>\n

Currently using: \u201cItem Name\/Code\u201d field<\/h2>\n

You will need to export your existing inventory and make it inactive but before doing so you\u2019ll also need to set everything to zero quantity. Here are the steps to make that happen:<\/p>\n

    \n
  1. Export your Stock Levels<\/em>\u00a0(formerly Inventory) from the system so that you have a full list of what serials you have in stock (Main Menu > General > Export Data > Stock Levels<\/em>, click Export<\/em>).<\/li>\n
  2. Open the resulting file in Excel and change the stock quantity to zero for all items that are serialized.<\/li>\n
  3. Use \u201cSave As\u2026\u201d to save this file as a CSV (comma delimited) file named \u201cZeroQuantities.csv\u201d and then close it.<\/li>\n
  4. You\u2019ll want to import the file as the data type Stock Levels<\/em>\u00a0and let inFlow automatically match your columns.<\/li>\n
  5. Click Import<\/em> and you\u2019re done zeroing out your stock.<\/li>\n<\/ol>\n\n

    Next you\u2019re going to take the originally exported file (\u201cinFlow_Inventory.csv\u201d) and import it in as stock levels as well but this time you\u2019ll match your columns like so:<\/p>\n\n\n\n\n\n\n\n\n\n
    \n

    inFlow Field Name<\/strong><\/p>\n<\/td>\n

    		\n

    Your Column of Info<\/strong><\/p>\n<\/td>\n<\/tr>\n

    \n

    Name<\/p>\n<\/td>\n

    		\n

    Description<\/p>\n<\/td>\n<\/tr>\n

    \n

    Location<\/p>\n<\/td>\n

    		\n

    Location<\/p>\n<\/td>\n<\/tr>\n

    \n

    Sublocation<\/p>\n<\/td>\n

    		\n

    Sublocation<\/p>\n<\/td>\n<\/tr>\n

    \n

    Serial<\/p>\n<\/td>\n

    		\n

    Item Name\/Code<\/p>\n<\/td>\n<\/tr>\n

    \n

    Quantity<\/p>\n<\/td>\n

    		\n

    Quantity<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

    The results should be that you end up with a serialized item using your description as its name with all the serial numbers you had in stock, to check this header over to your product list and double click, you should see an ellipsis in your Inventory section to indicate there are serials.<\/p>\n

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

    Currently using: sublocation field<\/h2>\n

    It\u2019s important to note that you\u2019ll have to rename your old items, set your current stock to zero and create new serialized items in this system.<\/p>\n

      \n
    1. Export your Stock Levels<\/em>\u00a0(formerly Inventory) from the system so that you have a full list of what serials you have in stock (Main Menu > General > Export Data > Stock Levels<\/em>, click Export<\/em>).<\/li>\n
    2. Open the resulting file in Excel and change the stock quantity to zero for all items that are serialized.<\/li>\n
    3. Use \u201cSave As\u2026\u201d to save this file as a CSV (comma delimited) file named \u201cZeroQuantities.csv\u201d and then close it.<\/li>\n
    4. Open the originally exported file (inFlow_Inventory.csv) again, you\u2019ll have to give these serialized items a new name, since inFlow can\u2019t create new items with the same name. The final product of these steps might look something like this:<\/li>\n<\/ol>\n

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

      Once you\u2019ve created that file and re-saved it you should be able to import that into your new copy of inFlow and set up your serial numbers. You\u2019ll want to import the file as the data type Stock Levels\u00a0<\/em>and match your columns like so:<\/p>\n\n\n\n\n\n\n\n\n
      \n

      inFlow Field Name<\/strong><\/p>\n<\/td>\n

      		\n

      Your Column of Info<\/strong><\/p>\n<\/td>\n<\/tr>\n

      \n

      Name<\/p>\n<\/td>\n

      		\n

      Item<\/p>\n<\/td>\n<\/tr>\n

      \n

      Location<\/p>\n<\/td>\n

      		\n

      Location<\/p>\n<\/td>\n<\/tr>\n

      \n

      Sublocation<\/p>\n<\/td>\n

      		\n

      Blank<\/p>\n<\/td>\n<\/tr>\n

      \n

      Serial<\/p>\n<\/td>\n

      		\n

      Sublocation<\/p>\n<\/td>\n<\/tr>\n

      \n

      Quantity<\/p>\n<\/td>\n

      		\n

      Quantity<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

      That\u2019s it! Going forward inFlow should be able to track your serial numbers for you using the stock you had and the brand new serials feature!<\/p>\n","protected":false},"excerpt":{"rendered":"

      Note: The serial number tracking feature is only available for premium edition licence holders If you\u2019ve been tracking serial numbers using version 2 of inFlow On-Premise, the good news is that the new features should make your life much easier! The bad news is that it\u2019ll take some work to migrate your existing data. We […]<\/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,31],"tags":[49],"_links":{"self":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3213"}],"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=3213"}],"version-history":[{"count":7,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3213\/revisions"}],"predecessor-version":[{"id":24724,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3213\/revisions\/24724"}],"wp:attachment":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/media?parent=3213"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/categories?post=3213"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/tags?post=3213"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}