How can I quickly change the markup type (fixed markup/fixed price) for multiple products?

Please note: we will sunset inFlow On-Premise on July 31, 2024. After sunset we will stop selling or activating new licenses for inFlow On-Premise and stop providing support (including online KB articles).

In the meantime we will still provide technical support to customers with an active Support Plan.

If you want to change your product pricing to fixed markup or fixed price for many products at the same time, use a Product Details import.

If you have more than one pricing scheme, you’ll need to repeat these steps for each scheme.

Make a backup of your database: Main Menu > General > Backup Data.
If you have more than one pricing scheme, choose the pricing scheme you would like to update as the default pricing scheme in your settings:.
1. Go to the Main Menu > Options > Settings > Pricing and Costing > Manage customer pricing schemes.
2. Select the star next to the pricing scheme you want to update.
3. Click Save and Close
Export your Product Details for that pricing scheme.
1. Main Menu > General > Export Data > select Product Details as the data type
2. Click Export.
Open the resulting Product Details export file, and change the value in the “IsFixedMarkup” column to
- “TRUE” for all products you’d like to have a fixed markup.
- “FALSE” for all products you’d like to have a fixed price.
Click Save As > select file type “CSV – Comma Delimited” at the bottom of the window.
Import your adjusted Product Details file into inFlow
1. Main Menu > General > Import Data > select file type “Product Details”
2. Click Next
3. On the following screen, make sure “Default Unit Price” is mapped to the correct pricing scheme (the one you chose in step 2 above).
If you have more than one pricing scheme, repeat the above steps for each of your pricing schemes to update them one by one.