🎉 Celebrate with 10% OFF on All Products! Use Code: GFEX10 Or Buy Any 2+ Items for 30% OFF with Code: GFEX30!

Gravity Forms Price Lookup Tables Setup Guide

Updated 10 min read Gravity Forms Payments & Pricing
On this page
  1. Video walkthrough
  2. What you need
  3. Install and activate
  4. Quick start: a roller blind price grid
  5. Table settings
  6. Rounding rules
  7. The price grid
  8. Import a price list from CSV
  9. Where the price goes
  10. What the customer sees
  11. Out-of-range messages
  12. After submission: entry, merge tags and export
  13. Multi-page forms, conditional logic and payments
  14. Security and privacy
  15. Frequently asked questions
  16. Can I add a surcharge or multiply by a quantity?
  17. My sizes are in millimetres but customers type centimetres.
  18. Can customers type a decimal comma?
  19. Does it work with a Single Product field?
  20. What happens if my license expires?
  21. Does editing an entry in the admin look the price up again?
  22. Changelog

Video walkthrough

Gravity Forms Price Lookup Tables Setup Guide: Width x Height Price Grids, CSV Import & Rounding
Video setup guide: Gravity Forms Price Lookup Tables Watch on YouTube

The Gravity Forms Price Lookup Tables add-on prices a form from a size grid instead of a formula. You type your price list once — widths across the top, heights down the side, a price in every cell — or import it from a spreadsheet, map your form fields to the columns and rows, and the form finds the right price while the customer types. The price goes into a Number field for a Calculation product or straight into a Product price, and the server looks it up again when the form is submitted, so the price cannot be changed in the browser. It is built for made-to-measure sellers: blinds and curtains, signs and printing, glass and mirrors, fabric, doors, fencing and anything else that is priced by size. This guide covers installation, building a table, rounding rules, CSV import, connecting the price to your products, out-of-range sizes and where the results appear after the form is submitted.

A roller blind order form: width 61 cm and drop 101 cm are priced as 90 by 150 cm at 44.00, the Sunscreen fabric adds 12.00, two blinds make a product price and total of 112.00
A roller blind order form: the size is rounded up to the next size in the price grid and the price follows at once.

What you need

  • WordPress 6.5 or newer and PHP 7.4 or newer.
  • Gravity Forms 2.9 or newer (tested with 2.9 and 3.1).
  • A GravityExtra license key for this add-on.
  • A form with the fields the customer fills in (for example Width and Height) and a field that receives the price: a Number field or a Product field with a User Defined Price.

Nothing else is needed: no outside service and no extra library. Every lookup runs on your own server and in the visitor’s browser.

Install and activate

  1. In WordPress go to Plugins → Add New → Upload Plugin, choose the add-on zip file and click Install Now, then Activate.
  2. Go to Forms → Settings → Price Lookup, paste your license key and click Activate License.
  3. Open any form and go to Settings → Price Lookup. This is where the tables of that form live.

Every feature needs an active license: without one the Price Lookup tab is hidden, the form does not look anything up and the merge tags stay empty. Your tables are kept with the form and come back as soon as the license is active again.

Quick start: a roller blind price grid

  1. Add two Number fields to your form: Width (cm) and Drop (cm).
  2. Add a Number field called Blind price. It will receive the price from the table.
  3. Add a Product field with the Calculation price type and a formula such as {Blind price:4} * {Quantity:6}, and a Total field.
  4. Open Settings → Price Lookup and click Add a table. Name it “Roller blinds”.
  5. Under Columns (across) type the label “Width”, the unit “cm”, choose the Width field and the rule Round up to the next size. Do the same for Rows (down) with the Drop field.
  6. In Put the price in choose the Blind price field.
  7. Type your widths in the first row of the grid, your drops in the first column and a price in each cell, then click Save tables.

Open the form: as soon as the customer types a width and a drop, the Blind price field shows the price, a small “Priced as 90 × 150 cm” note appears under it, and your product price and total follow.

The Price Lookup table editor: table name and merge tag, 2D table type, the Width columns and Drop rows mapped to form fields with the round-up rule, the Blind price field that receives the price, the out-of-range message and the price grid with widths 60 to 150 and drops 100 to 200
The table editor under Form Settings: axes, rounding rules, the price field and the grid.

Table settings

  • Table name — shown on the entry screen and in the export.
  • Merge tag name — used in {lookup:name}. Letters, numbers and underscores, starting with a letter. Leave it empty and it is made from the table name.
  • Table type — 2D grid (columns × rows, for example width × height or size × material) or 1D list (one row of sizes and prices, for example the length of a fence panel).
  • Columns (across) and Rows (down) — each axis has a label, a unit, the form field it reads, a rounding rule and what happens below the smallest size.
  • Put the price in — the field that receives the price.
  • Out-of-range message — your own text when a size cannot be priced.

A form can have as many tables as you need: one for the blind, one for the fabric surcharge, one for the fitting kit. Each table reads its own fields and writes into its own price field, and your calculation adds them up.

Rounding rules

Each axis has its own rule, so you can round the width up and match the material exactly in the same table.

  • Round up to the next size — the usual rule for made-to-measure goods. With sizes 60, 90, 120 and 150, a width of 61 is priced as 90 and a width of 90 stays 90.
  • Nearest size — the closest size wins; when a value is exactly half-way, the larger size is used. 74 is priced as 60, 76 and 75 as 90.
  • Exact size only — only the sizes in the table are accepted, for example standard door heights or fixed panel lengths. Any other value shows a message listing the sizes you offer.

Below the smallest size decides what happens to a value smaller than your first size: Use the smallest size (a 40 cm blind costs the same as a 60 cm one) or Out of range (the customer sees your message). A value larger than your largest size is always out of range, because the grid has no price for it.

Sizes do not have to be numbers. A column of words such as Oak, Walnut and Ash, or Foamex, Dibond and Acrylic, matches the choice in a drop-down or radio field exactly (upper and lower case do not matter). Use this for size × material or quantity × finish tables.

The price grid

Type the column sizes in the first row and the row sizes in the first column, and a price in each cell. + Column and + Row add sizes; the small × beside a size removes it with its prices. Sizes are sorted from small to large when you save, and each price moves with its size, so you can add a new width at the end of the grid. Leave a cell empty when a combination is not made (for example a very narrow and very tall blind): the customer then sees “This size is not available”. Prices may be typed with a currency sign or a decimal comma; they are cleaned when you save, and a cell that is not a number is left empty with a warning.

Import a price list from CSV

Most price lists already live in a spreadsheet. Open Import or copy CSV under a table, choose a CSV file or paste the CSV text, and click Import CSV. The sizes and prices of that table are replaced; its fields, rules and messages are kept.

  • 2D tables: the first line holds the column sizes (the first cell is a corner label and is ignored), each following line starts with a row size and then the prices.
  • 1D tables: either two columns (size, price) on each line, with an optional header line, or two lines (sizes, then prices), with an optional label in the first cell.
  • Comma, semicolon and tab separated files all work, as do quoted cells, a byte order mark and Windows line endings, so a file saved from any spreadsheet program can be used as it is.

Example for a 2D table:

Drop \ Width,60,90,120,150
100,25,35,45,55
150,30,44,58,70
200,,57,74,92.50

Show this table as CSV writes the current grid into the text box, ready to copy into a spreadsheet, change and import again.

Where the price goes

Choose one of two field types in Put the price in:

  • A Number field. Use it in a Product field with the Calculation price type, for example ( {Blind price:4} + {Fabric surcharge:5} ) * {Quantity:6}. This is the most flexible choice: add surcharges from other tables, multiply by a quantity or add a fitting fee. If you do not want customers to see the number, set the field’s Visibility to Hidden.
  • A Product field with a User Defined Price. The looked-up price becomes the product price directly.

The price field becomes read-only on the form. When the form is submitted, the add-on reads the sizes the customer sent, looks the price up again on your server and writes it into the price field before Gravity Forms validates, calculates and saves the entry. Whatever the browser sent for the price is ignored: the entry, the order total and any payment use the price worked out on the server. If the Total field checks the submitted total, an order whose total was changed in the browser is refused because it no longer matches.

What the customer sees

The price is looked up while the customer types and again when a field changes. Under the price field a short note shows the size that was priced, for example “Priced as 90 × 150 cm: £44.00”, so the customer understands why a 61 cm blind costs the same as a 90 cm one. When a size cannot be priced, the message appears under the field that is out of range and the price is cleared, so an order can never go through with an old price. The same message is shown by the server if the form is submitted anyway.

The roller blind form on a phone: width 118 cm and drop 145 cm are priced as 120 by 150 cm at 58.00 with the Thermal fabric surcharge and the total
The same form on a phone.

Out-of-range messages

Without a message of your own, customers see clear default texts: “Width: 151 cm is outside the sizes we price (60 to 150 cm).”, “Width: please choose one of these sizes: 60, 90, 120, 150 cm.”, “This size is not available. Please choose another size.” and “Width: please enter a number.”. Your own message replaces the first three and can use these placeholders:

  • {axis} — the label of the axis that is out of range, such as Width
  • {value} — what the customer typed
  • {unit} — the unit of that axis
  • {min} and {max} — the smallest and largest size
  • {sizes} — every size, separated by commas

Example: “We cut {axis} from {min} to {max} {unit}. Please call us for {value} {unit}.”

After submission: entry, merge tags and export

Every lookup is saved on the entry: the size the customer entered, the size it was priced as and the price.

  • Entry screen: a Price lookup box lists each table with the entered size, the priced size and the price.
  • Merge tags for notifications and confirmations: {lookup:name} (the price with your currency), {lookup:name:size} (the priced size, such as 90 × 150 cm), {lookup:name:input} (what the customer entered) and {lookup:name:raw} (the price as a plain number). They are listed in the merge tag menu of the form editor.
  • Entries list and export: a Lookup price column for each table and a Lookup sizes and prices column, which you can show in the entries list and tick in Forms → Import/Export → Export Entries.
The Price lookup box on the entry screen: Roller blinds entered as 61 by 101 cm, priced as 90 by 150 cm at 44.00, and Fabric Sunscreen at 12.00, each with its merge tag
The Price lookup box on the entry screen.

Multi-page forms, conditional logic and payments

The sizes can be on one page and the price on another: the price is looked up again on each page and on submit. A field hidden by conditional logic counts as empty, so its table gives no price. Because the price is written into normal Gravity Forms product fields, payment add-ons charge the price worked out on the server.

Security and privacy

The add-on makes no outside connection; only the license and update checks talk to gravityextra.com. Tables are saved with the form and can be changed only by users who may edit forms; every save is checked with a WordPress nonce and every size and price is cleaned before it is stored. The price grid is sent to the browser for the live price, so do not put anything in a table that customers should not see.

Frequently asked questions

Can I add a surcharge or multiply by a quantity?

Yes. Send each table’s price to its own Number field and combine them in a Calculation product, for example table price plus fitting fee times quantity.

My sizes are in millimetres but customers type centimetres.

Use the same unit in the table and in the field label, or add a note under the field. The add-on compares numbers as they are typed.

Can customers type a decimal comma?

Yes. 89,5 and 89.5 are both read as eighty-nine and a half, and 1,200 is read as one thousand two hundred.

Does it work with a Single Product field?

Use a Product field with a User Defined Price, or a Number field in a Calculation product. A Single Product field has a fixed price that Gravity Forms protects, so it cannot receive a looked-up price.

What happens if my license expires?

The lookup stops: the price field becomes an ordinary field again and the Price Lookup tab is hidden until the license is active. Keep the license active on any form that takes paid orders.

Does editing an entry in the admin look the price up again?

No. Entries keep the price that was charged. Change the price field by hand if you edit the sizes of an existing order.

Changelog

1.0.0 (October 31, 2026) — Initial release: 1D and 2D price lookup tables per form, grid editor, CSV import, rounding up, nearest or exact per axis, below-the-smallest rule, text axes, out-of-range messages, price into a Number field or a User Defined Price product, live price on the form, server lookup on submit, entry box, merge tags and export columns.

Still need help?

Our support team answers tickets every day, usually within a few hours.

0
0
Your Cart
Your cart is emptyReturn to Shop
🔥 FREQUENTLY BOUGHT TOGETHER
Complete Combo & Save 40%!
ITEM IN YOUR CART
Gravity Forms Klaviyo Add-on
$39.00/yr
+
🎁 RECOMMENDED ADD-ON SAVE 40% OFF
Original Price: $39.00/yr
Bundle Special Price: $23.40/yr