Importing Fixed-Price Pricelists

• Find or create the price list you wish to import in to. The price list doesn't have to be empty to import into.

• Attached below is an import template which consists of the columns: 
  

            product_tmpl_id: This column is for a product name or internal reference
            (This needs to be a product in your system)
            applied_on: This column should stay as 'Product' 
            pricelist_id: This column needs to be the exact name of the Price List you are importing to
            fixed_price: This column is the fixed price you would like to set the product to in this pricelist
            min_quantity: This column is the minimum quantity of products to trigger this price list value, the default is 1

• Update the attached import spreadsheet with the data you wish to import (product names and prices)
  
  

• Navigate to the Product Prices list of the system which can be found under 'Products -> Pricelists -> Product Prices'

• On the Product Price List Prices screen, click the import records button

• Load the above spreadsheet that has been created and test/import the price list and then check the data imported is what you expected.