Info
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
- 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.
Delete all
Use this button to delete all products connected to this fixed price list.
Excel import
Info
Click Import to upload and import the Excel file.
Warning
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.
Warning
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
Info
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.
