How to import multiple prices to products in inFlow Cloud
You can import multiple pricing schemes into inFlow Cloud to use for your sales orders. This can be done with a single spreadsheet! See below for all the steps.
Here are some shortcuts to jump to different parts of this article.
At the moment importing multiple pricing schemes is only available on the inFlow Cloud for Windows app.
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 on this article.
Setting up pricing schemes in inFlow
- Go to Main Menu > Options > Settings.
- Once open, scroll down to the Pricing & Costing tab and click Manage Customer Pricing Schemes.
- This will let you create a pricing scheme for each of the prices you’re about to import.
- 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
- Go to Main Menu > General > Import Data.
- Select Product Details as your data type.
- Select the file you’ve created and click Next.
- 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.
- 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.