Grids
A grid is a table of values with two fields: one for the columns and one for the rows. The value where the column and the row meet is put into a third field, which the price formula can use.
Example: a price table by width (columns) and height (rows).
| 100 | 200 | 300 | |
|---|---|---|---|
| 50 | 10 | 18 | 25 |
| 100 | 18 | 30 | 42 |
| 150 | 25 | 42 | 60 |
With width 250 and height 120, the value is 30 (column 200, row 100).
Add a grid
- Click Add grid.
- Choose the Field to set, the Field for the columns and the Field for the rows.
- Enter the values: paste from a spreadsheet, click Choose a CSV file, or click Fill in an example.
The first line holds the column headings and starts with an empty cell. Every other line starts with the row heading, then one value for each column:
,100,200,300
50,10,18,25
100,18,30,42
150,25,42,60Then use the field to set in the price formula, for example [grid_price].
How grids work
- A number heading covers every value from that number up to the next heading. The last heading has no upper limit.
- A value below the first heading finds nothing, and the field keeps its own value. An empty cell sets nothing.
- Number headings must go from small to large.
- Text headings must be equal to the field value, for example the option value of a dropdown.
- Grids run from top to bottom, after the conditions, intervals and field formulas, and before the price formula.
- The value is used for the price only. It is not shown in the field on the product page.
Limits: 10 grids, 50 columns, 200 rows and 2,500 cells per grid.
