Fixed price lists

Adds configurable lists of fixed prices with import functionality. The values from the fixed price lists have the highest priority when calculating prices.

If the same product exists on multiple fixed price lists, the one with the best priority wins; if it has the same priority, the first one wins.

Fixed price list priority

By default, the price priority looks like this:

1. Fixed Pricelist List: customer-specific 2. Fixed Pricelist List: common 3. Price Logic: customer-specific 4. Price Logic: Common

The priority is controlled by the setting "Fixed price lists always trump price logics." If the setting is turned off, the prioritisation will be as below:

1. Fixed Pricelist List: customer-specific 2. Price Logic: customer-specific 3. Fixed Pricelist List: common 4. Price Logic: Common

Settings / Products / Prices / Fixed price lists always trump price logics.

When activated, both customer-specific and general fixed price lists are examined before general price logics. If deactivated, we first inspect customer-specific fixed prices and then customer-specific price logic, followed by general fixed prices and then general price logic.

Setting

---

Feature	What it does
Label	Name the fixed price list. This is for internal purposes only.
Priority	Enter a numeric value for priority. A lower value equals better priority.
From date	When the prices in the fixed price list are enabled,
To date	To what date is the fixed price list enabled? After this date, the prices in the fixed price list will not be shown.
Customer connected	If this fixed price list is customer-connected only, If not checked, the fixed price list will be global.
Currency
Currency for fixed sales prices	Only available if the shop supports multiple currencies.

Create

---

1. Enter the part number in the search box that you want to add to the fixed price list, and click Search. A range of results might appear if the text entered matches multiple articles. Select the one you want to use by clicking it.

2. Enter the fixed price for the article.

3. Click OK or Apply to save.

Delete all

---

Use this button to delete all products connected to this fixed price list.

Excel import

---

If you want to add part numbers using an Excel sheet, you can use this function. Click Import to upload and import the Excel file.

If a part number is not unique, you will be notified of which part numbers failed, and the row will not be imported. All other valid rows will be imported. If this happens, please update the excel sheet with the manufacturer in column B.

If a part number already exists in the fixed price list, it will be updated with the new fixed price in the import.

Feature	What it does
Download template	Download a template with the columns needed for the import.
Excel file	Choose the excel file to use for the import
Skip first line	Check this in your Excel sheet, which contains headers.

Export

---

Export the fixed price list to Excel. This file can also be used for import. This is a good way to bulk edit multiple fixed prices.