Fixed Price Lists
Last updated
Last updated
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.
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.
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.
Enter the fixed price for the article.
Click OK or Apply to save.
Use this button to delete all products connected to this fixed price list.
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.
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 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.
