Have a price for every combination you sell.

A concierge service prices airport meet-and-greets by airport, direction and party size: 25,000 combinations, all kept in a spreadsheet.

Airport greeting 25,000 prices

Cairo, arrival, four passengers.

Airport
Cairo (CAI)
Service
Arrival, fast-track
Passengers
4

One row of a price list that was imported, not typed.

Your price $180
Every combination already priced

Illustrative experience

  • A rule per combination
  • The list lives in your spreadsheet
  • Export, edit, re-import

The finished experience

The price list stays where you can edit it.

A few ordinary questions and the form lands on the exact figure — the price book was imported, not typed.

A good fit for
Anyone whose pricing is a matrix rather than a formula.

  1. 1

    Ask what moves the price

    Airport, direction, party size: each one is an ordinary field the pricing rules can read.

    Gravity Forms

  2. 2

    Get the format from the form

    Build two or three levels by hand and click Export Pricing. The CSV that comes back is the format: one row per combination, the conditions on one side and the price on the other.

    GP Conditional Pricing

  3. 3

    Import it, then spot-check

    Import Pricing Levels takes the file in one go, and Replace All keeps the spreadsheet as the source of truth. Levels match top to bottom, so put the strictest rows first and test the awkward combinations.

    GP Conditional Pricing

What you’ll need.

Start with Gravity Forms. Add the capabilities this solution needs, then make the experience your own.

Before you start

  • A product field to price, and your price list as a CSV in the importer’s format.

Get this built.

A plan covers how many of our plugins you run at once, and on how many sites. Here is what this one needs.

Required

  • GP Conditional PricingPerks

Gravity Perks Basic $59 /year

Covers this on one site. More sites need Advanced or Pro.

See plans for this solution

Every plan renews at the same price, and you can upgrade any time for the difference.

Make it fit
your project.

Is there a limit on how many prices?

Conditional Pricing supports unlimited pricing levels, but the form still has to fit your host’s PHP input limits. The number of products, condition columns and condition rows all contribute to max_input_vars; there is no universal 1,000-row cutoff. Ask your host to review the actual form and test a full export/import before replacing the price list.

What does the CSV have to look like?

Export first. Build a couple of levels in the editor, click Export Pricing, and edit the file that comes back; the documentation links a sample file and a format spec. The concierge build got its file right with support’s help.

What happens when the prices change?

Edit the spreadsheet and import it again with Replace All, which clears the old levels and puts the file in their place. The editor and your spreadsheet stay in step.

Could the prices come straight from our spreadsheet?

For a flat table with one unique key per combination, GC Google Sheets and GP Populate Anything are a possible separate lookup recipe. Verify matching, missing-key behavior and every pricing-rule precedence case before replacing this CSV-based Conditional Pricing build.

  • Clay, CTO
  • Dan, Content Sorcerer
  • Dani, Product Manager
  • David, Founder & CEO
  • Matt, Senior Support Wizard
  • Roxy, Support Wizard

Not quite your build?

Tell us what you are making and we will work out which pieces it takes — or tell you straight if this is not something we can do.

Ask the wizards