What a Shopify Product Options App Should Be Able to Calculate: A Buyer's Checklist

A product options app should be able to calculate any price your store quotes. Not only add a fixed amount to a choice. If your price depends on a size, a material and a quantity together, the app has to do that math.

Here are ten things to check before you install one. For each, you get what the job is and how Appify Custom Product Options does it, so you can test it against any app on your list.

1. Can the price come from a number the customer types?

Width times height times your rate. That is the start of most made-to-measure pricing. The app has to read the raw number, not a preset.

In Appify Custom Product Options, a formula on an option can read what the customer entered. A formula as short as INPUT("WIDTH") * INPUT("HEIGHT") * 0.50 prices by area. Number inputs also have a Decimal places setting, so fractional sizes can be entered. See the Formula Editor and option settings.

Selling by length uses the same idea with one number. Here is what to look for in an app for selling fabric by the yard or metre.

New to formulas? What formula pricing actually means explains it in plain words.

2. Can it read your rate sheet?

Many shops already have a price grid: widths down the side, heights across the top. The app should let you keep that grid as it is.

A pricing table holds the grid. Formulas look it up with TABLE(), using a typed size or a selected material as the key. A lookup mode decides what happens to a size between two rows: nearest lower, nearest upper, nearest, interpolate or exact. One table can serve many products, and you update it once. Using tables in formulas has the syntax.

Not sure whether you need a table or a formula? Formulas vs pricing tables helps you choose, and pricing from a rate sheet walks through the setup.

3. Can you name a number once and reuse it?

Area shows up in the price, in the weight and in a discount rule. Typing the same width-times-height formula in each place invites mistakes.

With pricing variables, you define AREA or MATERIAL_RATE once. Later formulas call it with VAR("AREA"). Rules can use it as a condition too. Variables run top to bottom, so one can build on the one above it.

4. Is there real math behind the formula?

Pricing is rarely only multiplication. You need to round up to a whole box, cap a value, or branch on a choice.

The formula editor has logic functions (IF, AND, OR, NOT), math (MIN, MAX, CLAMP, SQRT, POWER and more), rounding (ROUND, CEILING, FLOOR, TRUNC) and text functions. It can also count: COUNT() gives the number of checked boxes in a multi-select, and CHARCOUNT() gives the length of typed text, which is how per-letter engraving gets priced.

You do not have to write any of it by hand. The Describe with AI tab turns "charge 2.50 per square foot with a 25 minimum" into a formula. Explain formula reads one back in plain English.

5. Can the rate change with the customer's choices?

Premium material costs more per square foot. Oversize panels carry an upcharge. The rate has to move when a choice does.

Two tools cover it. A formula can branch, for example IF(HAS("MATERIAL", "PREMIUM"), VAR("AREA") * 1.25, VAR("AREA")). Or a price adjustment can add a condition and an amount: add a flat 50 when AREA is over 100, or add 15% when the material is Premium. Conditions can be combined with All or Any logic.

The full walkthrough is in conditional pricing rules.

6. Does it enforce a minimum and a maximum price?

Small jobs still cost you setup time. A tiny size should not come out at 2 when your floor is 10. A very large one may need a ceiling.

The total price formula has a minimum price and a maximum price. Leave one blank for no limit. A formula can also hold the floor itself: MAX(25, OPT("QTY") * 2.50). The deeper how-to is in how to set a minimum price.

Here is the idea with small numbers. A 12 by 6 inch acrylic panel is 0.5 square feet. At 4.00 per square foot, that is 2.00. With a minimum of 10, the customer pays 10.00.

7. Can fees stay whole?

A setup charge or rush fee should not shrink when the order gets big.

Fixed fees sit on top of the calculated price. Discounts never touch them, they show as their own line in the price summary, and a fee that works out to zero is hidden. A fee can be a formula, so a rush fee only appears when the customer picks Rush.

8. Do quantity discounts follow your price list?

"10% off at 50" is the simple case. Your list may also change with size, or with the material.

The quantity discount rules cover each version:

• Simple (1D) tiers by quantity alone.
• Advanced (2D) tiers by quantity and a second number, such as width or area. Wider signs can have smaller discounts.
• Conditional tables use a different schedule for Vinyl than for Paper, with a default for everything else.
• Discount types are percent off, amount off, or a target unit price at each break.
• Aggregation decides whether tiers count per line, per product, per calculator or per configuration.

You can paste tiers in from a spreadsheet with Import table. Discounts apply at checkout as line item discounts, with no codes. See tiered and volume pricing for a worked example, or try the quantity breaks on the Stickers by Buttons demo.

9. Does it price per unit or for the whole line?

A sticker is priced each. A banner order might be priced as one job. The app should let you pick.

The total price formula has a Per unit mode, where the formula gives one unit's price and quantity multiplies it. It also has a Total mode, where the formula already includes quantity. The starting point is yours too: a fixed amount, or the Shopify variant price the customer selected, available in formulas as VAR("BASE_PRICE"). Read Initial Price and how pricing works for the order the stages run in.

10. Is the calculated price the price at checkout?

A live price on the page means little if the cart charges something else.

When a customer adds a configured product, Appify Custom Product Options saves their choices and the calculated price with the cart item. At checkout, the price is set to that calculated total, whatever the product's own Shopify price says. There is nothing to set up. The order carries the customer's selections for fulfillment.

What if a price looks wrong?

It will happen once, while you build. Check that the app shows you why.

Under the live price, Price looks wrong? opens the Troubleshoot tab. It runs the formula for the choices in the preview and shows what each part is worth. Type the number you expected, and it points to the likely cause, such as a table row that does not match a choice. You can also tell Chat with AI that a price is wrong and give the case, for instance "Large with rush should be 12 but shows 9." It opens the same tab with a note on what to check first.

Where do you start?

Take one product with a rate card behind it. Describe the rate card to Chat with AI, then check three prices by hand against what it builds. A starting prompt:

Price this panel by width times height in inches, divided by 144, times a rate per square foot that depends on the material. Add 15% for the premium material. Set a minimum price of 10. Add a rush fee that quantity discounts never reduce. Give 10% off at 50 units and 20% off at 100.

For the bigger picture, how to price complex custom products shows how these pieces fit together.

FAQ

What should a Shopify product options app be able to calculate?

Prices from typed sizes, rate sheets, conditional rates, minimum and maximum prices, fees, and quantity discounts. Appify Custom Product Options covers each with formulas, pricing tables, variables, price adjustments, fixed fees and quantity discount rules.

Can an options app use a pricing table or rate sheet?

Yes. Pricing tables hold a grid of prices, and formulas look them up with a typed size or a selected material as the key.

Can I set a minimum price?

Yes. The total price formula has a minimum price and a maximum price, and a formula can set a floor of its own.

Can quantity discounts change by size or material?

Yes. Advanced (2D) rules tier by quantity and a second number such as width. Conditional tables use a different schedule for each material or other choice.

Is the calculated price what the customer pays?

Yes. The calculated price is applied at checkout automatically, with no discount codes needed.