Formula-based pricing on Shopify lets you calculate a product’s price from customer inputs instead of forcing every possible configuration into variants. It is useful when shoppers enter measurements, choose materials, select add-ons, request rush production, upload artwork, or buy in quantities that affect the final price.
Appify Custom Product Options is a Shopify product options and advanced pricing app for merchants who need formulas, pricing tables, measurement inputs, quantity discounts, fixed fees, pricing variables, conditional adjustments, AI-assisted setup, and checkout-ready calculated pricing. It is built for stores that need a Shopify product calculator, not just extra fields on a product page.
Direct answer: To set up formula-based pricing on Shopify, map your real pricing rule, collect the customer inputs needed for that rule, use formulas and pricing tables to calculate the total, then test the result against real quotes before publishing it to your product page.
For merchants selling custom signs, stickers, blinds, flooring, wallpaper, packaging, print products, fabrication, apparel printing, or made-to-measure goods, formula-based pricing turns manual quoting logic into a storefront buying flow. The customer configures the product, sees the calculated price, and adds the custom item to cart.
Who Needs Formula-Based Pricing?
Formula-based pricing is a strong fit when your product price depends on a rule, not a fixed menu of choices.
| Product type | Common pricing rule |
|---|---|
| Custom signs and banners | Width × height × material rate + finishing fees |
| Stickers and labels | Size, shape, material, finish, proofing, and quantity |
| Blinds and shades | Width/drop lookup table + fabric or hardware options |
| Flooring and wallpaper | Area, waste factor, material, box quantity, and minimums |
| Packaging and boxes | Dimensions, board type, print coverage, die fee, and quantity |
| Fabrication, CNC, or 3D printing | Material, volume, machine time, setup fee, and tolerance |
| Apparel printing | Garment, print location, artwork colours, setup, and quantity |
This buyer is usually not searching for a broad explanation of product options. They are trying to solve a specific commercial problem: “How do I let customers configure this product and get the right price without manual quoting, spreadsheets, custom code, or hundreds of variants?”
Why Formula-Based Pricing Is Easier in Appify
Formula pricing is powerful, but it can feel intimidating when merchants have to write every calculation from scratch. Appify is designed to make that setup easier by combining a formula engine with AI-assisted pricing tools.
Instead of starting with a blank formula field, merchants can describe the pricing rule in plain English.
Calculate the price for a custom acrylic sign. Use width times height, multiply by the selected material rate, apply a CA$35 minimum, and add a rush fee when rush production is selected.
Appify can help turn that plain-English instruction into a starter formula that references the right customer inputs, options, variables, and pricing tables. Merchants can then review, edit, and test the result before publishing.
That matters because many Shopify merchants already know exactly how they price their products. The hard part is translating that pricing rule into working calculator logic. Appify reduces that setup friction with several AI-supported workflows.
| Appify AI feature | How it helps formula pricing |
|---|---|
| AI calculator building | Generates a starter calculator from a product description instead of forcing merchants to build from a blank page. |
| AI formula writing | Converts plain-English pricing rules into formula drafts. |
| AI formula explanation | Explains existing formulas in plain English so teams can understand and maintain them later. |
| AI-assisted structure | Helps create options, pricing logic, layout, variables, and tables as a starting point. |
| Editable AI output | Keeps the merchant in control because AI-generated setup can be reviewed and changed in the normal editor. |
This is especially useful for products with multi-step math, minimum prices, measurement rules, quantity logic, table lookups, and conditional fees. A sign shop, sticker printer, packaging supplier, or made-to-measure merchant can describe the pricing rule they already use, then use Appify’s AI tools to get closer to a working calculator faster.
Important: AI does not replace pricing review. It gives merchants a controlled starting point. You still test the calculator against real quotes, adjust the formulas, confirm the table lookups, and publish only when the storefront price matches your business rules.
Map the Pricing Rule First
Before building the calculator, write down the rule you use to quote the product manually.
For example, a custom sign shop might price like this:
Price = width × height × material rate + finishing fee + setup feeA sticker shop might use:
Price = size rate × quantity × finish multiplier + proofing feeA flooring store might use:
Price = room area × waste factor × material price + installation add-onsThis step prevents the calculator from becoming a random collection of fields. Each option should either collect a value needed for the formula, control a visible choice, trigger a fee, or help fulfillment.
Start Faster With AI-Assisted Calculator Setup
Start by creating a calculator for the product or product group you want to sell. In Appify, you can build manually, start from templates, or use AI-assisted setup.
For formula-based pricing, AI-assisted setup is one of the biggest advantages. You can describe what you sell and how the product is priced, then use Appify to generate a starter calculator with options, pricing logic, and layout.
I sell custom acrylic signs. Customers enter width and height, choose material, choose finish, and select rush production. Price is based on area, material rate, a CA$35 minimum, and an optional rush fee.From there, Appify can help create the calculator structure and formula draft. You can refine it with follow-up changes, then edit everything manually in the normal calculator editor.
This makes formula-based pricing easier because merchants do not have to begin by memorizing formula syntax. They can start from their real pricing rule, let AI create a draft, and then test and adjust the calculator until it matches their manual quote examples.
Add the Customer Inputs
Next, add the options customers need to complete the product configuration.
| Shopper input | Appify option type |
|---|---|
| Width | Number, length, or dimensions input |
| Height | Number, length, or dimensions input |
| Material | Dropdown, radio buttons, or swatches |
| Finish | Dropdown, radio buttons, or swatches |
| Mounting holes | Checkbox or switch |
| Rush production | Switch or radio buttons |
| Artwork upload | File upload |
| Quantity | Quantity input |
Use clear option keys because formulas reference those keys.
| Option | Suggested key |
|---|---|
| Width | WIDTH |
| Height | HEIGHT |
| Material | MATERIAL |
| Finish | FINISH |
| Rush production | RUSH |
Formula readability matters. A formula like this is much easier to understand:
INPUT("WIDTH") * INPUT("HEIGHT")than one built from unclear option names.
Set the Initial Price
The initial price is the starting price before additional pricing logic is applied. In Appify, the base can be a fixed number or the selected Shopify variant price. The base can also be referenced in formulas with:
VAR("BASE_PRICE")- Use a fixed base price when every order starts with the same amount, such as a setup charge or starting product cost.
- Use the selected variant price when the Shopify variant still matters, such as garment type, frame type, substrate, or base product size.
- Use a low or zero base price when the calculator should determine the full price from inputs, tables, variables, fees, and quantity rules.
Use Pricing Tables for Rate Sheets
Many custom products are not priced by one simple equation. They use vendor sheets, material tables, width/drop grids, quantity brackets, or internal price lists.
In Appify, pricing tables store lookup data outside the formula. You can reference them with the TABLE() function.
| Pricing table | Use case |
|---|---|
material_rates |
Material → price per square inch |
blind_prices |
Width × drop → base blind price |
sticker_rates |
Size bracket × quantity bracket → unit price |
box_rates |
Box style × board type → base price |
A material lookup might look like this:
TABLE("material_rates", OPT_TOKEN("MATERIAL"))A width-and-height lookup might look like this:
TABLE("blind_prices", INPUT("WIDTH"), INPUT("HEIGHT"))Pricing tables are especially useful when your pricing data changes over time. Instead of rewriting formulas every time a supplier updates rates, you can update the table and keep the formula structure stable.
Create Pricing Variables
Pricing variables make formula-based pricing easier to maintain. Instead of building one long formula, break the calculation into reusable pieces.
| Variable | Formula |
|---|---|
AREA |
INPUT("WIDTH") * INPUT("HEIGHT") |
MATERIAL_RATE |
TABLE("material_rates", OPT_TOKEN("MATERIAL")) |
MATERIAL_SUBTOTAL |
VAR("AREA") * VAR("MATERIAL_RATE") |
Then your total price formula can be simpler:
VAR("MATERIAL_SUBTOTAL")Variables are helpful for merchants and agencies because they make the pricing logic easier to inspect, explain, and update later.
Configure the Total Price Formula
The total price formula is where the calculator turns base price, customer inputs, variables, table lookups, and rules into the final line price.
A simple area-based formula might be:
VAR("AREA") * VAR("MATERIAL_RATE")A formula that keeps the Shopify base price and adds a calculated custom amount might be:
VAR("BASE_PRICE") + VAR("AREA") * VAR("MATERIAL_RATE")A formula with a minimum price might use logic like:
MAX(35, VAR("AREA") * VAR("MATERIAL_RATE"))A formula with a premium finish multiplier might look like:
VAR("AREA") * VAR("MATERIAL_RATE") * IF(HAS("FINISH", "PREMIUM"), 1.2, 1)The exact formula depends on how your business prices the product. The important part is to keep pricing logic close to how you already quote orders.
Add Fixed Fees
Some charges should sit on top of the calculated product price instead of being buried inside the main formula.
| Fee | Example |
|---|---|
| Setup fee | CA$15 artwork setup |
| Rush fee | CA$25 rush production |
| Proofing fee | CA$10 manual proof review |
| Handling fee | CA$8 oversized handling |
| Machine setup fee | CA$40 CNC setup |
A flat setup fee can be:
15A conditional rush fee can be:
IF(HAS("RUSH", "YES"), 25, 0)When a fee evaluates to zero, Appify can hide it from the shopper. That keeps the price summary clean while still showing fees that actually apply.
Add Conditional Price Adjustments
Price adjustments are useful when certain selections should modify the calculated price without making the main formula harder to read.
| Condition | Adjustment |
|---|---|
| Width is over 48 inches | Add oversize surcharge |
| Premium material selected | Apply multiplier |
| Outdoor use selected | Add weatherproofing charge |
| Fragile item selected | Add packaging fee |
| Very small order | Apply minimum price logic |
For example, you might use a price adjustment for an oversized sign instead of adding more nested logic to the total formula. This helps keep the main formula focused while still supporting real-world pricing exceptions.
Add Quantity Discounts When Volume Changes the Price
Many formula-priced products also need quantity discounts. Sticker shops, label printers, packaging suppliers, apparel decorators, and B2B stores often need price breaks as quantity increases.
| Quantity | Discount |
|---|---|
| 50–99 | 5% |
| 100–249 | 10% |
| 250–499 | 15% |
| 500+ | 20% |
For more advanced products, quantity discounts may depend on quantity plus another value, such as area, width, or weight. This matters when a large product should not receive the same discount structure as a small product.
Show a Price Summary
A transparent price summary helps customers understand why the final price changed.
| Summary line | Example |
|---|---|
| Area | 6 sq ft |
| Material | Acrylic |
| Material subtotal | CA$72 |
| Rush fee | CA$25 |
| Quantity discount | -10% |
| Total | CA$87.30 |
This is especially important for custom products because shoppers may be comparing the calculated price against a manual quote, an internal budget, or a previous supplier.
Test the Calculator Before Publishing
Test formula pricing with real quote examples before it goes live.
| Test case | What to verify |
|---|---|
| Smallest allowed size | Minimum price works |
| Largest allowed size | Maximums, surcharges, and layout work |
| Cheapest material | Baseline price is correct |
| Premium material | Table lookup or multiplier is correct |
| Rush selected | Conditional fee appears |
| Rush not selected | Fee hides or evaluates to zero |
| High quantity | Quantity discount applies correctly |
| Variant change | Base price behaviour works |
| Cart and checkout | Calculated price carries through |
Do not publish until the calculator matches your manual quoting examples.
Publish the Calculator to Shopify
After testing, publish the calculator and place it on the Shopify product page using Appify’s theme integration.
- Assign the calculator to the right Shopify product.
- Enable the Appify app embed.
- Add the calculator block to the product page template.
- Add a price summary block if you want shoppers to see the breakdown.
- Preview the storefront.
- Add the configured product to cart.
- Confirm the calculated price and selected options are present.
The shopper should be able to configure the product, see the calculated price, and add the product to cart without asking for a quote.
What Happens at Checkout?
When a customer configures a product with an Appify calculator and adds it to cart, Appify saves the customer’s selections and computed price with the cart item. At checkout, the customer is charged the calculator-computed amount, and the order includes the option selections needed for fulfillment.
That matters because formula-based pricing should not be just a visual estimate. The calculated price needs to carry through to checkout and order details so the store can sell and fulfill the custom product reliably.
Example: Formula-Based Pricing for Custom Signs
A custom sign merchant sells acrylic signs, aluminum signs, and foam board signs.
The customer chooses:
- Width
- Height
- Material
- Finish
- Mounting holes
- Rush production
- Quantity
The merchant creates:
| Appify setup item | Purpose |
|---|---|
WIDTH input |
Customer enters width |
HEIGHT input |
Customer enters height |
MATERIAL dropdown |
Customer selects material |
AREA variable |
Calculates width × height |
material_rates table |
Stores material price by material |
MATERIAL_RATE variable |
Looks up selected material rate |
| Total price formula | Calculates area × material rate |
| Rush fixed fee | Adds rush charge only when selected |
| Quantity discount | Applies volume pricing |
| Price summary | Shows how the price was built |
Example formulas:
AREA = INPUT("WIDTH") * INPUT("HEIGHT")MATERIAL_RATE = TABLE("material_rates", OPT_TOKEN("MATERIAL"))TOTAL = MAX(35, VAR("AREA") * VAR("MATERIAL_RATE"))This avoids building variants for every possible width, height, material, finish, and quantity combination.
Common Formula Pricing Mistakes to Avoid
- Do not start with the formula before mapping the pricing rule.
- Do not hardcode every rate into one long formula if a pricing table would be easier to maintain.
- Do not use unclear option keys like
OPTION_1orFIELD_Awhen readable keys likeWIDTH,HEIGHT, andMATERIALmake formulas easier to audit. - Do not publish without testing real quote examples.
- Do not hide the final price logic from customers when a price summary would reduce confusion.
- Do not assume variant pricing alone can handle complex custom products. Variants are useful, but formula-based products often need customer inputs, table lookups, fees, conditional logic, and checkout-ready calculated totals.
Formula-Based Pricing Setup Checklist
- The real pricing rule is written down.
- Every customer input has a purpose.
- Option keys are readable.
- AI-generated formulas have been reviewed and tested.
- The initial price is correct.
- Pricing tables are used for rate sheets or grids.
- Variables are used for repeated calculations.
- The total price formula matches real quote examples.
- Fixed fees are separate where appropriate.
- Conditional adjustments are tested.
- Quantity discounts work at each threshold.
- The price summary is clear.
- The calculator is assigned to the correct product.
- The storefront, cart, checkout, and order details are tested.
The Bottom Line
To set up formula-based pricing on Shopify, start with your real pricing logic and build a product calculator around it. Use customer inputs for dimensions and choices, pricing tables for rate sheets, variables for reusable calculations, fixed fees for separate charges, and a total price formula for the final line price.
Appify Custom Product Options helps Shopify merchants sell complex custom products with formula pricing, pricing tables, measurement-based pricing, quantity discounts, AI-assisted setup, price summaries, and checkout-ready calculated prices.
The biggest advantage is that merchants do not have to face formula setup alone. Appify can help build starter calculators, draft formulas from plain-English pricing rules, and explain complex formulas so teams can understand and maintain them. You stay in control of the final logic, but AI helps remove the blank-page problem.
For merchants selling signs, stickers, labels, blinds, flooring, wallpaper, packaging, print products, fabrication, or made-to-measure goods, Appify turns manual quoting logic into a product page customers can use.
Build Shopify formula pricing without variant clutter
Use Appify Custom Product Options to create formula pricing, pricing tables, AI-assisted formula drafts, custom product calculators, and checkout-ready calculated prices.
Explore Appify Custom Product OptionsFAQs
Can Shopify do formula-based pricing with variants?
Shopify variants can handle predefined combinations like size, colour, or style, but formula-based pricing usually needs a product options app, product calculator, or custom development when the price depends on customer-entered measurements, lookup tables, conditional fees, or quantity-based calculations.
Does Appify make formula pricing easier with AI?
Yes. Appify includes AI-assisted setup for building starter calculators, writing formulas from plain-English pricing rules, and explaining existing formulas in plain English. This helps merchants move from “I know how I price this product” to a working Shopify calculator faster, while still keeping control over the final formula, pricing table, and published setup.
What is the best way to price custom dimensions on Shopify?
Use measurement inputs for width, height, length, area, volume, or weight, then reference those inputs in a pricing formula. For example, a basic area formula can multiply width by height and then multiply that result by a material rate.
Can Appify price by width and height?
Yes. Appify can use customer-entered dimensions in formulas, store intermediate calculations as variables, and combine those values with pricing tables, materials, fees, discounts, and minimum prices.
When should I use pricing tables instead of formulas?
Use pricing tables when your prices come from a rate sheet, vendor grid, size chart, material table, or width/drop matrix. Use formulas when the price follows a calculation. Many advanced products use both.
Can AI help create formula-based pricing in Appify?
Yes. Appify can help generate a starter calculator, write formulas from plain-English descriptions, and explain existing formulas. The merchant should still review, edit, and test the result before publishing.
Does the calculated price carry through to checkout?
Yes. When a shopper adds a configured product to cart, Appify saves the customer’s selections and computed price with the cart item, then applies the calculated amount at checkout.
What products are a good fit for formula pricing?
Formula pricing is useful for custom signs, banners, stickers, labels, blinds, shades, wallpaper, flooring, packaging, apparel printing, fabrication, CNC services, 3D printing, furniture, building supplies, and B2B configured products.