Select Page
Common searched topics: Manufacturing, Label printing, Sales order
Browse features guide
Managing products
Imports, exports & integrations
Sales
Stock level reports
inFlow settings
Manufacturing
Imports, exports & integrations
  • Products
  • Pricing
Import multiple prices

How to import multiple pricing schemes to products in inFlow

You can import multiple pricing schemes into inFlow to use for your sales orders. This can be done with a single spreadsheet! See below for all the steps.

Web

Before you start

Before you start importing your information, it’s important to ensure that you’re fully prepared!

  • If you already have products in inFlow, be sure the product names on your spreadsheet match what’s in inFlow. If the names don’t match exactly, new products will be created when you import.
  • Create the pricing schemes in inFlow before you begin the import. Otherwise, they won’t show up as an available field for import!
  • Make sure your products are set to Fixed Price, not Fixed Markup. To update prices with Fixed Markup, follow the steps in this article.

Setting up pricing schemes in inFlow

  1. Go to inFlow’s Order settings. (Main Menu > Options > Orders.)
  2. Select Pricing Schemes.
  3. Click Add new pricing scheme to add a new pricing option to inFlow.
  4. Select the star icon to set a pricing scheme as your default.
  5. Click Save when done. 

In our example, our default pricing scheme is set to Retail Price (pictured below).

inFlow’s Pricing scheme settings with multiple pricing schemes that have been created.

Formatting your CSV

Here’s an example spreadsheet we’ll be importing. The ProductName field needs to be on the CSV so that inFlow knows which products to add the pricing too.

Pricing scheme CSV formatting example.

Importing to inFlow

  1. Go to Main Menu > Import.
  2. Select Product Details from the Data type drop-down menu.
  3. Select the file you’ve created and click Next.
  4. Match the Product name field to the matching field in the drop-down menu if it hasn’t been mapped for you. 
  5. Next, match the Default unit price to the pricing scheme that you’d like to be the default. 
  6. Below, match the remaining pricing scheme fields to the matching fields in the drop-down menus. 
  7. Click Import when done. 

Steps on how to import multiple pricing schemes

When the import is complete, the product record will reflect all the pricing schemes that you’ve imported.

inFlow product record highlighting the newly imported pricing schemes

Can’t see all your pricing schemes? Select Show all to display them.

Importing fixed markup pricing on non-default pricing

It is not currently possible to change the fixed markup unit price on non-default pricing schemes using this method. If you wish to do this, you’d need to temporarily change that pricing scheme to your default. Follow the steps here to change the markup type or change the unit price for fixed markup via import.

Windows

Before you start

Before you start importing your information, it’s important to ensure that you’re fully prepared!

  • If you already have products in inFlow, be sure the codes on your spreadsheet match what’s in inFlow. If the codes don’t match exactly, they will be created when you import.
  • Create the pricing schemes in inFlow before you begin the import. Otherwise, they won’t show up as an available field for import!
  • Make sure your products are set to Fixed Price, not Fixed Markup. To update prices with Fixed Markup, follow the steps in this article.

Setting up pricing schemes in inFlow

  1. Go to Main Menu > Options > Settings.
  2. Once open, scroll down to the Pricing & Costing tab and click Manage Customer Pricing Schemes.
  3. This will let you create a pricing scheme for each of the prices you’re about to import.
  4. Click the star icon to set a pricing scheme as your default.

In our example, our default scheme is set to Retail Price (pictured below).

Formatting your CSV

Here’s an example spreadsheet we’ll be importing. The ProductName field needs to be on the CSV so that inFlow knows which products to add the pricing too.

Importing to inFlow

  1. Go to Main Menu > General > Import Data.
  2. Select Product Details as your data type.
  3. Select the file you’ve created and click Next.

When you’re finished with the imports, the product record will reflect all the pricing schemes that you’ve imported.

Importing fixed markup pricing on non-default pricing schemes

It is not currently possible to change the fixed markup unit price on non-default pricing schemes using this method. If you wish to do this, you’d need to temporarily change that pricing scheme to your default. Follow the steps here to change the markup type or change the unit price for fixed markup via import.

Was this guide helpful?
Yes, thanks!
Not really
Thank you for your input, your feedback is important to us!

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

In this tab
  • Before you start
  • Setting up pricing schemes in inFlow
  • Formatting your CSV
  • Importing to inFlow
  • Importing fixed markup pricing on non-default pricing
  • Before you start
  • Setting up pricing schemes in inFlow
  • Formatting your CSV
  • Importing to inFlow
  • Importing fixed markup pricing on non-default pricing schemes
Similar articles

A complete guide on how to set up inFlow.

Get advice and answers from the inFlow Support team