- 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 your file each time.
Before beginning your imports it’s a good idea to set up a pricing scheme for each of the columns you’re going to be importing.
To set up pricing schemes in inFlow:
- Go to the Main Menu > Options > Settings window.
- Once open, scroll down to the Pricing & Costing tab and click Manage Customer Pricing Schemes.
- This will allow you to create a pricing scheme for each of the prices you’re about to import.
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.
Once you’ve 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.
In this case we’re starting with the Wholesale Pricing scheme and after that initial setup it’s simply a matter of running through an import.
- Go to Main Menu > General > Import Data.
- Select Product Details as your data type, select the file you’ve created and click Next.
- 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:
Once this has been completed, re-open the Settings window and select one of the other pricing schemes as the default scheme.
Repeat your import with the same file but selecting another column of information.
When you’re finished with the imports the product record will reflect all the pricing schemes that you’ve imported.