Request: 2D Lookup Table / Price Matrix Support for Made-to-Measure Pricing

Please add native 2D lookup-table (price matrix) support to Options Price Calculator so merchants can calculate a fixed final price from a width × height pricing grid without creating hundreds of conditional rules.

Problem / Current Limitation

We sell made-to-measure products (e.g., blinds/pleated shades) where the final customer price is defined by a discrete pricing matrix:

• X-axis: Width (in meters, typically 0.1 m increments)

• Y-axis: Height (in meters, typically 0.1 m increments)

• Cell value: Final gross price (already includes shipping costs and VAT)

Because the price is not a simple linear function of area, we cannot use a compact mathematical formula reliably. Today the only way to implement exact matrix pricing is to create a very large number of IF/AND conditions (one per cell). This is:

• time-consuming to set up

• error-prone to maintain

• hard to audit

• not scalable across multiple categories/price groups

Requested Solution

Add a Lookup Table / Pricing Matrix feature that can be used directly in formulas and/or as a pricing option type.

Core capabilities

1. 2D lookup function

   • A function usable in the formula builder, e.g.

     • lookup2d(table_name, width, height)

     • or similar syntax consistent with your app

   • Returns the value from the matrix cell at the resolved width/height.

2. Step rounding / grid mapping

   • Built-in rounding rules before lookup (especially important for mm inputs):

     • Width and height are entered in mm by customers.

     • We need to map them to the grid by always rounding up to the next step.

   • Example rule:

     • width_m = ceil(width_mm / 100) / 10 (100 mm → 0.1 m steps)

     • height_m = ceil(height_mm / 100) / 10

3. Graceful out-of-range handling

   • Configurable behavior when input is outside the table:

     • show validation error, or

     • clamp to min/max, or

     • return default value.

4. Table management

   • Create and manage multiple tables (we have ~10 categories × up to 5 price groups).

   • Import/export via CSV (and ideally bulk update).

   • Clear UI to define:

     • column headers (widths)

     • row headers (heights)

     • numeric cell values (prices)

5. Fixed final price support

   • We need the lookup result to be usable as a fixed final price (not only an add-on), and update live as customers type.

Example (What we want to build)

• Customer enters:

  • width: 1188 mm

  • height: 742 mm

• Grid mapping:

  • width → 1.2 m (round up to 0.1 m)

  • height → 0.8 m (round up to 0.1 m)

• Lookup:

  • price = lookup2d(pg0_brutto, 1.2, 0.8)

• Output:

  • display and charge that exact gross price.

Business Impact

This feature would dramatically reduce setup and maintenance effort and unlock accurate pricing for many industries that rely on matrices (blinds, curtains, wallpaper, stickers, custom panels, etc.).

For our store specifically:

• We can implement exact pricing for ~10 product categories and up to 5 price groups each.

• We can maintain pricing centrally by updating CSV tables instead of editing hundreds of conditions.

• We can ensure pricing is always consistent, auditable, and scalable.

Acceptance Criteria

• A merchant can upload a width×height pricing matrix and retrieve cell values via a formula/lookup.

• Rounding-up-to-grid works with mm inputs.

• The calculated price can be used as the final fixed price and updates live.

If helpful, we can provide sample CSV matrices and a list of expected test cases for QA.