Skip to main content

Price list template

A grouped list of products and prices, generated from your catalogue so every version you send is current.

Google Docs PDF export No watermark

Free plan, no credit card. Bring your own design or start from this layout.

The actual template Price list template shown in Google Docs

What’s in this template

Every block is bound to a field in your data. The layout stays exactly as designed; only the values change from one run to the next.

  • Header with the list name and effective date {{list.name}} · {{list.effective}}
  • Who the pricing applies to {{segment.name}}
  • Category sections, one per product group loop: {{categories}}
  • Product rows with SKU, unit and price loop: {{categories.products}}
  • Volume breaks or tier columns {{tiers.label}}
  • Currency, tax treatment and validity note {{list.notes}}

How this template fills itself

Connect Airtable, Google Sheets, a SQL database, a CSV or a REST API, map each field to a placeholder, and generate. One run can produce a single document or one per matching record.

Sales & pricing: A grouped list of products and prices, generated from your catalogue so every version you send is current.

Catalogue · Airtable

SKUProductUnit price
AC-114Oak worktop, 3m$412.00
AC-118Oak worktop, 4m$538.00
FX-207Soft-close hinge, pair$9.40

Template: Google Slides or Docs

{{list.name}}

Effective {{list.effective}} · {{segment.name}}

loop: {{categories}} → section

loop: {{categories.products}} → row

{{list.notes}}

a nested loop: a section per category, a row per product inside it

Generated output

DocsPDF

Trade price list 2026

Effective 1 Oct 2026 · Trade accounts

4 categories

126 product rows

Prices exclude tax. Valid to 31 Mar 2027.

Who uses this template

Wholesalers and distributors

Publish a trade list per customer tier from the same catalogue, so no account is ever quoted a price you have already changed.

Read the guide

Manufacturers

Produce a seasonal or regional list from the product table rather than maintaining a separate document for each market.

Read the guide

Service businesses

Turn a rate table into a client-ready list with categories, units and notes in one run.

Read the guide

A price list is a document whose length nobody controls. It is as long as your catalogue is, and it changes whenever a price does — which is why the version people actually have in their inbox is usually months behind the one in your system. Google Docs suits it because tables grow, pages break themselves, and a category added to your data simply becomes another section rather than a layout problem.

Shape the data as categories, then products

The template mirrors your catalogue’s structure, so it is worth getting that structure right before anything else: one table of products, each with a category, SKU, unit and price, rather than pricing spread across several sheets. A nested loop then repeats a section per category and a row per product inside it. Once that holds, the interesting variations are free — a trade list and a retail list are the same template pointed at a different price column, and a regional list is a filtered subset of the same rows.

Common questions, answered

Can I use my own price list design? +
Yes. Build the master in Google Docs with your cover, category headings and table styles, mark the category and product blocks as repeating placeholders, and generate against that. The design is yours; the catalogue decides how many sections and rows appear in it.
Can one product table produce different lists for different customers? +
Yes, and this is the usual reason to automate it. Filter the catalogue to the products and price column that apply to a segment — trade, retail, a region, a single key account — and one run produces a list per segment from the same source data.
How are categories and products nested? +
As a loop inside a loop. The outer loop repeats a section per category and the inner loop repeats a row per product within it, so adding a category in your data adds a section to the document without anyone rebuilding the layout.
Where does the catalogue data come from? +
Airtable, Google Sheets, a SQL database, a CSV upload or your own system through a REST data source. Because the list is generated rather than edited, the effective date on the cover and the prices in the table always come from the same run.

Generate this document from your data

Start on the free plan, connect a data source, and export a real Google Docs document. No watermark, no credit card.