{"id":3299,"date":"2014-05-05T20:27:28","date_gmt":"2014-05-06T00:27:28","guid":{"rendered":"https:\/\/www.inflowinventory.com\/support\/article\/3299\/i-have-a-list-of-prices-for-my-items-how-do-i-quickly-set-them-up-in-inflow\/"},"modified":"2018-05-16T16:31:54","modified_gmt":"2018-05-16T20:31:54","slug":"i-have-a-list-of-prices-for-my-items-how-do-i-quickly-set-them-up-in-inflow","status":"publish","type":"post","link":"https:\/\/onpremise.inflowinventory.com\/support\/article\/36646920\/i-have-a-list-of-prices-for-my-items-how-do-i-quickly-set-them-up-in-inflow\/","title":{"rendered":"I have a list of prices for my items, how do I quickly set them up in inFlow On-Premise?"},"content":{"rendered":"
You can import multiple sales\u00a0pricing schemes into inFlow and to do so there are a couple of things you need to know:<\/span><\/div>\n
    \n
  1. You will need to import them one at a time.<\/span><\/li>\n
  2. You will need to set your default price in inFlow (Main Menu > Options > Settings<\/em>) to the one that you’re importing from your file.<\/span><\/li>\n<\/ol>\n
    Before you start importing your information it\u2019s important to ensure that you\u2019re fully prepared (make a backup!). Have a look at your import file. You will need to ensure that your product codes match what is in the system already (if you have products in the system, if you don\u2019t then they will be created when you import). The easiest way to set up your spreadsheet is as follows:<\/span><\/div>\n
    <\/div>\n
    \"36646920_1\"<\/div><\/div>\n
    <\/div>\n
    In this configuration you have five pricing schemes that can be imported. Each one will need to be imported one at a time.<\/div>\n
    \n

    Before beginning your imports it\u2019s a good idea to set up a pricing scheme for each of the columns you\u2019re going to be importing.<\/p>\n

    To set up pricing schemes in inFlow:<\/p>\n

      \n
    1. Go to the Main Menu > Options > Settings<\/em> window.<\/li>\n
    2. Once open, scroll down to the Pricing & Costing<\/em>\u00a0tab and click Manage Customer Pricing Schemes<\/em>.<\/li>\n
    3. This will allow you to create a pricing scheme for each of the prices you\u2019re about to import.<\/li>\n<\/ol>\n<\/div>\n
      \n

      Once set up you will need to verify which of the pricing schemes is set as the default. You can do this by clicking on the star beside the pricing scheme you want.<\/p>\n

      Once you\u2019ve verified that, you’ll know which of the columns should be imported first. For example, if you set the default to Wholesale Price, you’ll want to make sure your the column that will be imported is your Wholesale Price column.<\/p>\n<\/div>\n

      <\/div>\n
      \n

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

      In this case we\u2019re starting with the Wholesale Pricing scheme and after that initial setup it\u2019s simply a matter of running through an import.<\/p>\n<\/div>\n

        \n
      1. Go to Main Menu > General > Import Data.<\/em><\/span><\/li>\n
      2. Select Product Details<\/em>\u00a0as your data type, select the file you\u2019ve created and click Next<\/em>.<\/span><\/li>\n
      3. Select the columns that match the your current default pricing scheme. For example, as we’ve set Wholesale Price as our default scheme earlier, we want to make sure the “Default Unit Price” is matched to the WHOLESALE price column in our excel file as below:<\/span><\/span>
        \"36646920_3\"<\/div><\/li>\n
      4. \n
        Once this has been completed re-open the Settings window and select one of the other pricing schemes as the default scheme, then repeat your import with the same file but selecting another column of information.<\/span><\/div>\n<\/li>\n<\/ol>\n
        \n

        When you\u2019re finished with the imports the product record will reflect all the pricing schemes that you\u2019ve imported.<\/p>\n\n<\/div>\n

        \n

        \"36646920_4\"<\/div><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

        You can import multiple sales\u00a0pricing schemes into inFlow and to do so there are a couple of things you need to know: You will need to import them one at a time. You will need to set your default price in inFlow (Main Menu > Options > Settings) to the one that you’re importing from […]<\/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\/3299"}],"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=3299"}],"version-history":[{"count":6,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3299\/revisions"}],"predecessor-version":[{"id":25453,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3299\/revisions\/25453"}],"wp:attachment":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/media?parent=3299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/categories?post=3299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/tags?post=3299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}