I have a list of prices for my items, how do I quickly set them up in inFlow?

Not using inFlow Cloud?

You can import multiple pricing schemes into inFlow Cloud to use during your sales. This can be done with a single spreadsheet!

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!

To set 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).

Here’s an example spreadsheet we’ll be importing.

36646920_1

To import:

  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.
  4. Select the columns that match your current default pricing scheme.
    For example, as we’ve set Retail Price as our default scheme earlier, we want to make sure the “Default Unit Price” is matched to the RETAIL price column in our excel file as below:

  5. In the same section, you should see your created pricing schemes as an available field. Select the dropdown and match it to the columns that were in your Excel file.

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

Please note: 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 markup type or change unit price for fixed markup via import.

Yun Ling
Archon Systems
w,
+1.866.923.4974
260 Carlaw Ave #397
Toronto, ON, M4M 3L1
Canada
November 20, 2018

Rate this article

Not enough ratings yet
1 star2 stars3 stars4 stars5 stars
Loading...
  • Did this article help? If not, please let us know so we can improve it.

  • This field is for validation purposes and should be left unchanged.