Length & Width Lookup Function For Pricing

Shopify Discussion

Topic summary

Pricing needs to be driven by customer-entered length and width, using a range-based table lookup rather than a single formula. Inputs are in 200mm increments; the correct price is the value where both dimensions fall within defined ranges.

Example matrix provided (widths: 1000–1800mm; lengths: 1000–1600mm) with sample prices (e.g., width 1000mm × length 1200mm → 59). Goal is a 2D lookup that returns the intersecting price based on the nearest range the inputs fall between.

Additionally, the product should support add-ons selected via images that apply extra costs on top of the base price.

Attachment: A Google Sheets snippet is central to understanding the lookup table and increment structure.

Status: Open request for guidance; no solutions or decisions yet. Key question: How to implement a range-based 2D lookup for pricing in Shopify and enable image-based add-on selectors with additional charges.

Summarized with AI on December 26. AI used: gpt-5.
1

Hello,

I am wondering if there are any way to set a product price based on a customers input. There will be two fields primarily. A length and width input box. However, there is no real formula for the input. It is based on each element (length and width).

The easiest way to explain it, is if the customer inputs a length within a certain range, (between

width: 1000mm and length: 1200mm for example), then this should show the price of 59 for example from the table example below. The price will need a lookup function to retrieve the values both, width and length, then what they fall between.

Ultimately, the pricing will get the user input from both the width and length, then whichever range the customer input falls between, will show that particular price. I’ve attached a snippet of a Google sheets example for how the lookup should work. The increments go up every 200mm for both the width and length. Each increment the price changes.

WIDTH → 1000 1200 1400 1600 1800
LENGTH ↓
1000 56 65 70 75 82
1200 59 67 73 78 88
1400 63 70 76 85 92
1600 67 73 83 90 97

Additionally, there are also add-ons that can be applied to the product. Is there a way to add image selectors that also incur additional costs to the costs above?

Any assistance or guidance with this would be greatly appreciated!

Thanks!