If your custom-product pricing already lives in Excel or CSV, you should not have to redesign it just to sell the product on Shopify.
Give the pricing information to Chat with AI in Appify Custom Product Options, then explain what the numbers mean.
A width-by-height grid can become a pricing table, while a list of quantity breaks can become quantity discount rules. Material rates can feed the product's pricing, setup charges can become fixed fees, and minimum selling prices can become price limits.
The goal is to turn the pricing system your business already understands into something customers can use directly on your Shopify store.
Here is the spreadsheet we use to quote this product. The first sheet contains our width-by-height prices, the second has quantity discounts, and there is a $25 setup fee on every order. Use these values for the calculator.
If you already have years of pricing work sitting in spreadsheets, that is a much better starting point than an empty pricing editor.
Your Spreadsheet May Contain More Than a Price Table
Custom-product businesses use spreadsheets in very different ways.
A blinds company may have hundreds of prices in a width-by-height grid.
A sticker company may have a list of quantity breaks.
A packaging company may have size pricing, print charges, setup fees, and volume discounts in the same workbook.
A manufacturer may have different rate sheets for different materials.
The useful question is: What does each part of this spreadsheet represent in the pricing system?
| What your pricing sheet contains | How it can be used in Appify Custom Product Options |
|---|---|
| Width × height price grid | 2D pricing table |
| Quantity → price list | 1D pricing table or quantity-based pricing structure |
| Quantity discount breaks | 1D quantity discount rules |
| Quantity + size discount matrix | 2D quantity discount rules |
| Material rate sheet | Pricing table or values used by the pricing logic |
| Setup charge | Fixed fee |
| Rush or handling charge | Fixed or conditional fee |
| Minimum selling price | Minimum price |
| Maximum allowed price | Maximum price |
| Several of these together | Combined pricing configuration |
Chat with AI lets you start with the pricing language your business already uses. You tell it which numbers represent what.
Start With the Pricing Sheet Your Team Already Trusts
Imagine your sales team has used the same spreadsheet for years.
When a customer asks for a custom blind, someone enters the Width and Height, finds the appropriate price, checks the fabric group, and applies any extras.
When a customer orders stickers, someone checks the quantity tier.
When a customer orders packaging, someone checks the box size, quantity, print option, and setup fee.
The business already knows how the product should be priced. The ecommerce work is translating that process into a calculator customers can use themselves.
With Chat with AI in Appify Custom Product Options, you can begin with the source your team already understands.
For example:
This is the pricing workbook our sales team uses for roller blinds. Width runs across the top and Drop runs down the left. The cells are our selling prices.
This sheet contains our sticker quantity breaks. At 100 pieces the customer gets 5% off, at 250 they get 10% off, and at 500 they get 15% off.
The first table is our base pricing. The values at the bottom are setup and rush charges.
The spreadsheet provides the numbers. Your explanation provides the context.
Turn Width-by-Height Grids Into Pricing Tables
Some pricing models are naturally tables. Blinds and shades are a classic example.
Suppose the business already has this rate grid:
| Height ↓ / Width → | 24 in | 36 in | 48 in | 60 in |
|---|---|---|---|---|
| 36 in | $92 | $110 | $128 | $148 |
| 48 in | $105 | $126 | $147 | $169 |
| 60 in | $118 | $141 | $165 | $190 |
| 72 in | $132 | $158 | $184 | $212 |
Those numbers may come from a supplier, manufacturing costs, historical pricing, or an established quoting system.
There is no reason to reverse-engineer them into a completely different mathematical formula.
Attach or paste the rate data and tell Chat with AI:
Build a two-dimensional pricing table from this sheet. Width is across the top, Height is down the side, and the cells contain the base selling price.
Appify Custom Product Options supports 1D and 2D pricing tables, including tables created from pasted or attached spreadsheets, rate grids, and screenshots of cells.
The customer can enter measurements on the storefront while the calculator uses the corresponding table value behind the scenes.
A Pricing Table Can Also Be One-Dimensional
Not every rate sheet needs two axes. Sometimes one input determines the value.
For example:
| Quantity | Base price |
|---|---|
| 25 | $42 |
| 50 | $68 |
| 100 | $110 |
| 250 | $225 |
| 500 | $395 |
Or perhaps the business has defined size bands:
| Panel width | Price |
|---|---|
| 24 in | $80 |
| 36 in | $96 |
| 48 in | $115 |
| 60 in | $140 |
Those can fit naturally into a one-dimensional pricing table.
Use Column A as Quantity and Column B as the corresponding base price. Create a one-dimensional pricing table.
1D pricing table: one lookup value determines the result.
2D pricing table: two lookup values determine it.
You do not have to manually recreate every row simply because the original data came from Excel.
Your Spreadsheet May Describe Quantity Discounts
A rate sheet and a discount sheet are not always the same thing.
Suppose the base product price has already been calculated, but larger orders receive a discount:
| Quantity | Discount |
|---|---|
| 25 | 5% |
| 50 | 10% |
| 100 | 15% |
| 250 | 20% |
Those numbers are better treated as quantity discount rules than as a product price table.
Tell Chat with AI what they mean:
These are our quantity discount breaks. Give 5% off at 25, 10% off at 50, 15% off at 100, and 20% off at 250.
Chat with AI in Appify Custom Product Options can configure supported quantity discount rules from the breakpoints you provide.
The discounts can use a percentage off, a fixed amount off, or a target unit price.
The key is that the breakpoints should come from your business.
If you only say:
Make bigger orders cheaper.
There is not enough pricing information to invent the correct discounts.
But if your spreadsheet already contains the real breaks, you can give Chat with AI those numbers instead of creating every tier manually.
Quantity Discounts Can Depend on More Than Quantity
Some businesses cannot use one volume discount schedule for every order.
A 500-piece order of tiny labels may have very different economics from 500 large signs.
A packaging job with a small box may support a deeper quantity discount than a much larger box.
A print business may want different discount schedules depending on area.
Appify Custom Product Options supports both 1D and 2D quantity discount logic.
A 1D quantity discount might simply mean:
At 100 units, give 5% off. At 250, give 10% off. At 500, give 15% off.
A 2D quantity discount can consider quantity plus another value, such as:
- area
- width
- weight
- another relevant pricing input
For example, your pricing sheet might effectively say:
Small products
- 100+ = 10% off
- 500+ = 20% off
Large products
- 100+ = 5% off
- 500+ = 12% off
We will cover the full quantity-discount system in a dedicated guide later. For now, quantity-break information already stored in your pricing sheets can move online with the rest of the pricing model.
Pricing Sheets Often Include Setup Fees Too
Many custom products have charges that should not be buried inside the unit price.
Examples include:
- artwork setup
- machine setup
- tooling
- plate fees
- rush production
- handling
- custom cutting setup
Suppose your spreadsheet contains a separately calculated base price, a $25 setup charge per order line, and a $40 rush-production charge when selected.
Tell Chat with AI:
Add a $25 setup fee once per line. Rush Production adds a $40 fee when selected.
Appify Custom Product Options supports fixed and setup fees as separate pricing components.
A one-time $25 setup charge should not necessarily behave like $25 added to every unit.
And if you later offer quantity discounts, you may not want the setup charge discounted along with the product price.
Keeping fees as fees makes the pricing system easier to understand.
Minimum Prices Can Come From the Same Pricing Rules
A spreadsheet may also contain a minimum charge.
For example:
We charge by size, but no order can be less than $35.
That business rule should not disappear when the product moves to Shopify.
Tell Chat with AI:
Use a minimum product price of $35.
Appify Custom Product Options supports minimum and maximum price caps, including pricing limits that can work alongside more complex pricing.
Your spreadsheet may contain several different kinds of information:
- base rates
- table values
- quantity breaks
- setup charges
- minimums
They do not all have to become the same type of pricing rule.
One Workbook Can Describe the Whole Pricing Model
Imagine a custom packaging company has one workbook containing:
Sheet 1: Base boxes. A size × quantity pricing matrix.
Sheet 2: Printing. Prices for one-color, two-color, and full-color printing.
Sheet 3: Volume discounts. Discount breaks beginning at 500 units.
Notes. A $75 setup fee, a $150 minimum product charge, and a $100 rush-production charge.
The merchant does not need to pretend this is one giant table.
Instead, explain the pieces to Chat with AI:
Sheet 1 contains our base size and quantity pricing. Sheet 2 contains the printing rates. Sheet 3 contains our quantity discount breaks. Add the $75 setup fee once per line, enforce a $150 minimum product price, and add $100 when Rush Production is selected.
Appify Custom Product Options has different tools for different parts of the pricing model, so you do not have to flatten every pricing concept into one workaround.
Use Your Existing Pricing Language
Internal spreadsheets often use shorthand.
Maybe your blinds workbook says:
WDFG-AFG-BMORUSH
Your staff knows exactly what those mean.
Chat with AI may need the context.
Instead of cleaning up hundreds of cells before starting, explain the important terminology:
W means finished Width in inches. D means Drop. FG-A and FG-B are fabric groups. MO is motorized operation.
The quantities in Column A are the start of each discount tier. The percentage in Column B applies from that quantity until the next tier.
This is one of the most practical uses of conversational setup: you provide the business meaning that may be missing from the spreadsheet itself.
Excel and CSV Are Not the Only Ways to Provide the Pricing
The pricing may live in a clean Excel workbook, but it may also come from another system, a PDF, or a short rate sheet.
Chat with AI can work with pricing-table data provided in several ways:
- Attach an Excel file when the workbook is already organized into rows and columns.
- Attach a CSV when the pricing comes from another system or an exported database.
- Paste the data when you have a smaller rate sheet or a short list of quantity breaks.
- Attach a screenshot of a rate grid when the supplier sends a PDF or the grid lives in another system. For supported 1D and 2D pricing tables, Chat with AI can work from a screenshot of the cells.
The goal is to reduce the amount of manual transcription between the pricing source you already have and the Shopify calculator you are trying to build.
Tell Chat with AI What the Numbers Mean
A spreadsheet is often obvious to the person who created it and confusing to everyone else.
Suppose the sheet contains:
| Qty | A | B | C |
|---|---|---|---|
| 100 | 4.20 | 4.75 | 5.30 |
| 250 | 3.60 | 4.10 | 4.65 |
| 500 | 3.10 | 3.55 | 4.05 |
The numbers alone do not explain whether A, B, and C are materials, sizes, print methods, unit prices, or discount percentages.
So tell Chat with AI:
Column A is Matte Vinyl, B is Gloss Vinyl, and C is Reflective Vinyl. The first column is Quantity. All values are target prices per unit.
Now the pricing data has context.
A good rule: give Chat with AI the data, then explain anything a new employee would need to know before using it.
You Do Not Have to Know the Feature Name First
A merchant may not know whether something should be a:
- 1D pricing table
- 2D pricing table
- quantity discount
- fixed fee
- minimum price
Those are software terms. You only need to know how your business prices the product.
You can start with:
Here is how we price this product.
Then describe it.
For example:
Customers choose a Width and Height. Use the price grid in this sheet for the base price. Orders of 25 or more get 5% off, 50 or more get 10% off, and 100 or more get 15% off. There is also a $20 setup fee once per order line.
That description gives Chat with AI the information needed to work with the supported pricing tools. You can start with the pricing model instead of learning the interface first.
Example: A Sticker Pricing Workbook
Suppose a sticker business already has this pricing:
| Quantity | Target unit price |
|---|---|
| 50 | $1.20 |
| 100 | $0.85 |
| 250 | $0.56 |
| 500 | $0.39 |
| 1,000 | $0.27 |
It also charges:
- $15 for rush proofing
- $25 for a special cut setup
The merchant might tell Chat with AI:
These are our quantity tiers and target unit prices. Use the values shown. Rush Proofing adds $15. Special Cut adds a $25 setup fee.
The source data stays the source of truth, and Chat with AI translates it into the supported pricing configuration without making you jump between the spreadsheet and the calculator editor for every tier.
Example: A Blinds Pricing Workbook
A blinds business might have:
- Fabric Group A width × drop table
- Fabric Group B width × drop table
- motor upgrade price
- rush-production fee
- quantity discounts for commercial orders
The merchant could provide those sheets and explain:
These two tabs are our Fabric Group A and Fabric Group B price tables. Width is across the top and Drop is down the side. Use the selected fabric group to determine which pricing data applies. Motorization adds $85. Rush Production adds $40. Commercial orders get 5% off at 10 blinds and 10% off at 25.
The resulting pricing workflow resembles the way the business already quotes the product. The existing process becomes the starting point for the Shopify pricing system.
Example: A B2B Packaging Pricing Sheet
Packaging pricing can combine several moving parts:
- box dimensions
- quantity
- material
- printing
- setup
- finishing
Suppose the spreadsheet contains a size-and-quantity matrix plus these notes:
- Kraft is the base material
- White board adds $0.12 per unit
- full-color printing adds $0.20 per unit
- setup is $75
- orders above 2,500 receive 8% off
Start with those business rules:
Use this matrix for the base pricing. Kraft is included. White board adds $0.12 per unit and full-color printing adds $0.20 per unit. Setup is $75 once per line. Give 8% off at 2,500 units.
You explain how the quote works. Chat with AI handles the supported configuration behind it.
Keep Formula Pricing for the Parts That Need Formulas
Not every number in a spreadsheet belongs in a pricing table or quantity rule.
Sometimes the sheet documents a calculation:
Width × Height ÷ 144 × material rate.
That is formula pricing, which we will cover in the next article.
Appify Custom Product Options does not force every pricing model into tables.
- Use tables for stored rate data.
- Use quantity discount rules for volume breaks.
- Use fees for separate charges.
- Use minimums for price floors.
- Use formulas when the price genuinely comes from a calculation.
A complex product may use several of these together.
Review the Result Against Prices You Already Know
AI can reduce setup work, but your existing pricing should still be the benchmark.
After the pricing has been configured, test real examples.
If your spreadsheet says:
- 36 × 48 blind = $126
- 100 stickers = $85
- setup = $25
- 250 units receive 10% off
run those same examples through the calculator.
Compare the result to the pricing source your business already trusts.
The acceptance test is straightforward: Does the Shopify calculator reproduce the pricing we already use?
If not, adjust the configuration before launch.
Chat with AI can help with that refinement too.
The 36 × 48 example should be $126. Check the pricing setup.
The quantity discount should start at 250, not 200.
The objective is to get from established business pricing to a working calculator with less manual setup, while checking the output against known prices before launch.
Keep the Pricing Model Familiar When Prices Change
This matters again six months later.
Supplier prices rise.
Quantity discounts change.
A new material is added.
The setup fee goes from $25 to $35.
If your Shopify pricing still resembles the underlying business model, those updates are easier to describe.
Replace the Fabric Group B prices with this new sheet.
Our quantity discounts are now 5% at 50, 10% at 100, and 18% at 500.
Change the setup fee from $25 to $35.
You should not have to rediscover how an old calculator was assembled every time a supplier sends a new rate sheet.
A Practical Spreadsheet-to-Shopify Pricing Workflow
1. Start with the pricing source you already use
That might be:
- Excel
- CSV
- pasted rate data
- a rate-grid screenshot
2. Identify what each part represents
Look for:
- rate tables
- quantity breaks
- material prices
- fees
- minimums
- other pricing rules
3. Give the pricing to Chat with AI in Appify Custom Product Options
For example:
This workbook is the pricing we use for custom signs. The first grid is Width × Height pricing. The quantity breaks below it are discounts. Setup is $30 once per line.
4. Explain the business context
Clarify:
- units
- row and column meanings
- material groups
- whether values are total prices or unit prices
- when a fee applies
- what each quantity breakpoint means
5. Let each type of pricing use the right tool
The setup may involve:
- 1D pricing tables
- 2D pricing tables
- quantity discount rules
- fixed fees
- minimum prices
- other supported pricing logic
6. Test known examples
Compare the calculator against orders or quotes you already know are correct.
7. Refine what is wrong
Tell Chat with AI the expected result rather than starting the configuration over.
Bring the Pricing System You Already Have to Shopify
Your spreadsheet contains business knowledge that customers cannot use directly on a Shopify product page.
Appify Custom Product Options can turn its rate grids, quantity breaks, setup charges, minimums, and material rates into storefront pricing logic.
Give Chat with AI the pricing data, explain what the numbers mean, and test the result against quotes you already know are correct.
Bring the pricing system you already have to Shopify.
See how Chat with AI in Appify Custom Product Options can help turn existing pricing sheets into storefront pricing.
Frequently Asked Questions About Pricing Spreadsheets in Appify Custom Product Options
Can Appify Custom Product Options use an Excel pricing sheet?
Yes. Chat with AI in Appify Custom Product Options can work with attached spreadsheet data to create supported 1D and 2D pricing tables.
Can Appify Custom Product Options use CSV pricing data?
Yes. CSV data can also be provided when creating supported pricing tables.
Can Appify Custom Product Options build a pricing table from a screenshot?
Yes. Chat with AI can create supported 1D and 2D pricing tables from screenshots of pricing cells or rate grids. Explain units and axis meanings when they are not obvious.
Can Chat with AI create quantity discounts in Appify Custom Product Options?
Yes. Chat with AI can configure supported 1D and 2D quantity discount rules using quantity breakpoints you provide.
What types of quantity discounts does Appify Custom Product Options support?
Quantity discounts can use percentage off, amount off, or a target unit price. Appify Custom Product Options also supports 2D quantity discounts when the discount depends on quantity plus another value such as size or area.
Will Chat with AI invent quantity discount tiers for me?
Chat with AI is designed to use the pricing information you provide rather than inventing quantity breaks when the only instruction is that larger orders should be cheaper.
Can Appify Custom Product Options add setup fees separately from the product price?
Yes. Appify Custom Product Options supports fixed and setup fees, including charges such as setup, handling, or rush fees.
Can Appify Custom Product Options enforce a minimum product price?
Yes. Minimum and maximum price caps are supported.
Does everything in my spreadsheet have to become a pricing table?
No. Different parts of your pricing may belong in different tools. A grid may become a pricing table, quantity breaks may become quantity discount rules, setup charges may become fees, and calculation-based pricing may use formulas.
Can Appify Custom Product Options combine tables, quantity discounts, fees, and formulas?
Yes. These pricing capabilities can be used together when the product requires them. A pricing table can provide a base value while other supported pricing logic handles discounts, fees, adjustments, or calculations.