The Price Matrix is primarily designed for calculations in the backend, but of course you can have the result displayed in the frontend.
In order to make use of external price lists in your configuration, it is necessary to prepare a formally correct csv-file, containing the necessary dimensions and prices.
In the following example, we consider a carpet manufacturer, who wants his customers to be able to select a customized carpet product.
The actual price should be taken out of three different price lists. Wich price list is valid, depends on which carpet type is selected.
How to set up a price list as a csv-file
In order to import a price list in the configuration logic, you first have to prepare an Excel or Pages file. This file is basically just a classic table with two dimensions (for example the x- and y-dimension). In the following example we see such a table, prepared in Numbers (same in Excel):
Dimension 1 (horizontal): Length (60-300 cm)
Dimension 2 (vertical): Width (40-300 cm)
The two dimensions represent the length and width of the carpet. In this case this is a price list for one specific carpet type out of three. So in case we have 3 different base products that have different prices for the same size, we also have to make use of 3 different price lists. The configurator then is able to decide which one of the price lists shall be used, according to the previous selection of the carpet type. How this works is, will be explained later.
After you have finished your price list preparation in Excel or Numbers, use the export functionality, in order to generate a CSV-file (CSV = Comma separated values).
Make sure that you are using UTF-8 encoding while exporting the file. You can also use semicolons as separator for the values.
Note: Sometimes Excel adds additional columns or rows while exporting the table. You can check the CSV-file with the help of the text editor for example. Here you can check if the file contains any superflous collumns or rows. An indicator would be additional semicolons at the end of the row. You actually can not see that is excel or numbers.
Here an example of a correct exported price list (via textEdit):
Here an example of a CSV-export that could lead to problems because of additional empty cells. In this case, make sure that the CSV-file has a format, like in the example above!
Congrats, you are now ready to import the price list, in order to use it in your configuration!