Why formula pricing matters for custom Shopify products

Many custom products do not have one fixed price. A custom acrylic panel might depend on width, height, material, thickness, finishing, rush production, and quantity.

A basic Shopify product options app may let you add dropdowns, text boxes, checkboxes, swatches, and simple add-on prices. That works for small customizations.

It becomes limiting when the price needs to be calculated from real inputs.

That is where Appify Custom Product Options is a stronger fit.

What are pricing tables in Appify Custom Product Options?

Pricing tables in Appify Custom Product Options store rate data outside the formula. The formula then looks up the right value using the TABLE() function.

This keeps pricing easier to maintain. Instead of writing a long formula full of nested conditions, you can keep the data in a table and use a cleaner formula.

TABLE("panel_prices", INPUT("WIDTH"), INPUT("HEIGHT"))

Or:

VAR("AREA") * TABLE("material_rates", OPT_TOKEN("MATERIAL"))

This is useful when your pricing comes from a rate sheet, vendor table, print grid, material list, width/drop chart, quantity table, or internal spreadsheet.

How Shopify formula pricing works with pricing tables

A practical formula pricing setup in Appify Custom Product Options usually has five parts.

1. The merchant creates product options for customer inputs.
2. The merchant creates pricing tables for rates, grids, or lookup values.
3. The merchant creates pricing variables to break large calculations into readable pieces.
4. The merchant writes a total price formula that combines inputs, variables, and table values.
5. The shopper configures the product and sees the calculated price before adding to cart.

The result is a self-serve Shopify product calculator instead of a quote request form.

Pricing table modes in Appify Custom Product Options

Appify Custom Product Options supports several pricing table patterns. The right mode depends on how your pricing data is organized.

           | Price
-----------+-------
WOOD       | 2.50
ACRYLIC    | 4.00
METAL      | 6.50

TABLE("materials", OPT_TOKEN("MATERIAL"))

TABLE("materials", OPT_TOKEN("MATERIAL"), "Price")

     | 12   | 24   | 36
-----+------+------+-----
12   | 10   | 16   | 22
24   | 18   | 28   | 38
36   | 26   | 40   | 54

TABLE("panel_prices", INPUT("WIDTH"), INPUT("HEIGHT"))

        | VINYL | PAPER | FOIL
--------+-------+-------+------
12      | 10    | 8     | 14
24      | 18    | 14    | 25
36      | 26    | 20    | 36

TABLE("sheet_prices", INPUT("SIZE"), OPT_TOKEN("MATERIAL"))

Lookup modes: how Appify Custom Product Options matches table keys

Pricing table lookup mode controls how Appify Custom Product Options resolves the value when a formula references a table.

Formula-level lookup mode examples

For a multi-column table:

TABLE("panel_prices", INPUT("WIDTH"), INPUT("HEIGHT"), "nearestUpper")

For a one-column table with an explicit column key:

TABLE("qty_rates", INPUT("QTY"), "Price", "nearestLower")

For example, one product might use nearest upper to avoid undercharging custom sizes, while another product might use interpolation for smoother pricing.

Global pricing tables vs local pricing tables

Appify Custom Product Options supports both global and local pricing tables.

Global tables are useful for maintainability. If the rate changes, you update the shared table instead of editing every product calculator separately.

Local tables are useful when you do not want changes to affect other calculators.

Example setup: custom acrylic panel pricing

Here is how a merchant could set up formula pricing for a custom acrylic panel in Appify Custom Product Options.

Customer-facing options

• Width
• Height
• Material
• Thickness
• Edge finish
• Drill holes
• Rush production
• Quantity

Pricing tables

Pricing variables

Pricing variables make the formula easier to read and maintain.

AREA = INPUT("WIDTH") * INPUT("HEIGHT") / 144

MATERIAL_RATE = TABLE("material_rates", OPT_TOKEN("MATERIAL"))

THICKNESS_MULTIPLIER = TABLE("thickness_multipliers", OPT_TOKEN("THICKNESS"))

Total price formula

A simplified formula might look like this:

MAX(50, VAR("AREA") * VAR("MATERIAL_RATE") * VAR("THICKNESS_MULTIPLIER"))

Then additional fees can apply:

IF(HAS("RUSH", "YES"), 25, 0)

The exact setup depends on the merchant’s pricing rules, but the structure is the same: collect inputs, look up the right rates, calculate the price, and apply fees or discounts.

Why pricing tables are better than giant formulas

A formula can technically hold a lot of logic. But when prices change often, giant formulas become hard to maintain.

Pricing tables keep the rates separate from the math.

A clean setup uses formulas for logic and tables for data.

VAR("AREA") * TABLE("material_rates", OPT_TOKEN("MATERIAL"))

The formula stays short. The merchant can update the material table without rebuilding the calculation.

When to use each pricing table mode

What shoppers experience on the product page

The shopper does not need to understand the formula or pricing table. They simply configure the product.

For example, they enter a width and height, choose acrylic, select a thickness, add edge polishing, choose rush production, and select a quantity. Appify Custom Product Options calculates the price from those selections.

A clear product calculator can also show a pricing summary, so the customer understands how the total was built. That helps reduce confusion for custom products where customers expect the price to change as they configure the order.

What this helps merchants avoid

Appify Custom Product Options is useful when the product price is not just a list of add-ons. It is useful when the price depends on the configuration itself.

How AI-assisted setup can help

Formula pricing can be powerful, but it can also feel intimidating if you are starting from a blank page.

Appify Custom Product Options includes AI-assisted setup features that can help merchants create starter calculators, draft formulas, and explain formula logic in plain English. The merchant still reviews and edits the setup, but AI can help reduce the first-build friction.

That can become a starting formula the merchant can refine inside the normal editor. This is useful for merchants who know their pricing rules but do not want to build every option, table, variable, and formula from scratch.

Best-fit products for Shopify formula pricing with pricing tables

This setup is a strong fit for:

• Custom signs and banners
• Acrylic panels
• Stickers and labels
• Blinds and shades
• Wallpaper and murals
• Flooring and mats
• Packaging and custom boxes
• Fabric and tablecloths
• Print products
• Fabrication and CNC parts
• Building supplies
• B2B configured products
• Made-to-measure furniture
• Products with size, material, finish, quantity, and fee logic

In all of these cases, the pricing problem is bigger than “add C$5 for an option.” The merchant needs a pricing system that can reflect how the product is actually sold.

Why Appify Custom Product Options fits this use case

Appify Custom Product Options is built for Shopify merchants who need advanced product options plus serious pricing logic.

That combination matters because many custom-product stores need more than a form on a product page. They need the product page to become a working calculator.

With Appify Custom Product Options, merchants can turn quote-heavy custom products into configurable Shopify products that shoppers can price and purchase online.