How to Create Airtable Product Labels with Barcodes

You can create product labels with scannable barcodes - EAN-13, Code 128, or QR - directly from your Airtable product records using TypeFlow's HTML/CSS template builder. Map your product fields (name, SKU, price) to a label template, select the barcode type, and generate labels for Avery sheets or thermal printers (Zebra, DYMO). No external barcode software. No CSV exports.

For all label types including shipping and inventory, see our complete label printing guide. For a barcode deep dive including GS1-128 for food traceability, see our barcode generation guide.

What You Need Before Starting

To create product labels with barcodes in Airtable, you set up your product data, connect it to a template, and generate labels using a document tool like TypeFlow. The whole process takes about 15 minutes once your data is ready.

Here's what you'll want to have in place:

Here's an example product label with an EAN-13 barcode generated from Airtable. Click to open the full PDF, or duplicate the demo base:

PDF

Open full PDF ↗

Ready-to-use template

Product Label with Barcode

Duplicate the Airtable base, paste the template in Typeflow, then generate your first PDF in minutes.

Use this template →Duplicate Airtable base ↗

Free tier available • No credit card required

Barcode Formats Supported for Airtable Product Labels

Not all barcodes work the same way. The format you pick depends on where and how you plan to use your labels, so let's look at the three most common options.

EAN-13 and UPC for Retail Products

If you sell products in stores, EAN-13 or UPC barcodes are the standard choice. Point-of-sale systems recognize them, and customers expect to see them on retail packaging. One thing to know: EAN-13 and UPC codes require a registered number from GS1, which is the organization that manages barcode standards worldwide.

Code 128 for Internal SKUs

For internal inventory tracking, Code 128 is more practical. You can generate Code 128 barcodes from your own SKU numbers without any registration or fees. Warehouses, stockrooms, and fulfillment centers often use Code 128 because it's flexible and works with any alphanumeric value.

QR Codes for Links and Extra Data

QR codes store more information than linear barcodes. You can encode a URL, product details, or tracking information in a single square code. Most phones scan QR codes without an extra app, which makes them useful when customers or team members want quick access to product pages or documentation. QR codes are defined by ISO 18004 and hold up to 4,296 characters.

How to Structure Your Airtable Base for Product Labels

The way you organize your Airtable base determines how your labels get generated. A few minutes of planning here saves time later, so let's walk through two common approaches.

Single Product Table with a Quantity Field

The simplest setup uses one table with all your product information. Each row represents one product, and each column holds a piece of data like name, SKU, or price.

If you want to print multiple labels for the same product, add a quantity field. For example, when you have 10 units of a product in stock, the quantity field tells the system to generate 10 labels for that single product.

Linked Records for Variants and Orders

When products have variants like size or color, linked records offer more flexibility. You might have a Products table linked to a Variants table, where each variant has its own SKU and barcode value.

This approach is more complex to set up, yet it handles real-world inventory situations better. If your labels relate to specific orders rather than just products, linked records let you pull order information onto the label too.

• Single table: Works well when each product is straightforward and one record contains everything for the label.
• Linked records: Works better when products have variants or when labels relate to specific orders.

Label Sizes and Templates for Product Labels

Your template dimensions have to match your physical labels. A mismatch causes alignment problems that waste label sheets, so let's cover the two main label types.

Avery Sheet Labels

Avery labels are the most common choice for standard printers. Sizes like 5160 (1" x 2.625") and 5163 (2" x 4") work with inkjet and laser printers you already have.

The exact dimensions are printed on the Avery packaging, and you can also find them on the Avery website by searching for your label number.

Thermal Printer Labels

Thermal printers use label rolls instead of sheets. Common sizes include 2" x 1" for small product labels and 4" x 6" for shipping labels. Printers like Zebra or DYMO are popular choices.

Thermal printing is faster for high-volume work, though it requires a separate hardware investment. If you're printing hundreds of labels per day, thermal makes sense. For occasional printing, Avery sheets work fine.

How to Design a Product Label Template

TypeFlow's HTML/CSS template builder handles the label design. You'll add variables that pull data from Airtable and a special barcode variable that generates the barcode image. Let me walk you through each step.

Step 1: Set the Page Size to Match Your Label

In TypeFlow's template builder, set the page dimensions to match your label stock. If you're using 2" x 1" thermal labels, set the page to 2 inches wide and 1 inch tall.

This step is easy to overlook, yet it's the most common cause of printing problems. When the page size doesn't match the label size, everything prints off-center or gets cut off.

Step 2: Add Product Fields and the Barcode Variable

Type your variables using double curly brackets. The variable name matches the field name in your Airtable base. For barcodes, use the format {{barcode:field_name}} where field_name is the Airtable field containing your barcode value.

Here are the most common variables for product labels:

• {{product_name}} - Pulls the product name from Airtable.
• {{sku}} - Pulls the SKU number.
• {{barcode:sku}} - Generates a barcode image from the SKU field.
• {{price}} - Pulls the price.

Step 3: Insert the Print Label Marker

When printing multiple labels on a sheet, you add a marker that tells the system where each label starts. In TypeFlow, this marker ensures labels repeat in the correct positions on Avery sheets. Without it, all your data would print on a single label.

How to Map Airtable Fields to Your Product Label

Once your template is ready, you connect it to your Airtable data. This mapping tells the system which Airtable field goes into which template variable.

Step 1: Connect Your Airtable Base

Authorize the connection between TypeFlow and your Airtable account. Then select the base and table containing your product data. The whole process takes about 30 seconds.

Step 2: Match Variables to Product Fields

The interface shows each variable from your template alongside a dropdown of available Airtable fields. Match {{product_name}} to your Product Name field, {{sku}} to your SKU field, and so on.

If a variable doesn't have a matching field, you'll see an error before generating labels. This catches mistakes early.

Step 3: Pick the Barcode Format

For barcode variables, you'll see an additional option to select the barcode type. Choose EAN-13 for retail, Code 128 for internal use, or QR for links. The system generates the barcode image from your field value during label creation.

How to Print One or Multiple Labels per Product

You might want one label per product, or you might want 50 labels for a product with 50 units in stock. Both scenarios are straightforward to handle.

One Label per Record

By default, each Airtable record produces one label. If you have 100 products in your table, you get 100 labels. This works well when each product is unique or when you're labeling individual items.

Repeat X Times Based on a Quantity Field

To print multiple labels for the same product, add a quantity field to your Airtable base. When you set up the label generation, point to this field. A product with a quantity of 5 generates 5 identical labels.

This approach is useful for inventory receiving. When a shipment arrives with 20 units of one product, you update the quantity field and generate all 20 labels at once.

How to Generate Product Labels from Airtable

You have three ways to trigger label generation, depending on your workflow. Let's look at when each option makes sense.

Option 1: Airtable Button Field

Add a button field to your table that triggers label generation when clicked. This works well for on-demand printing when you want control over which products get labels.

1. In TypeFlow, scroll to the bottom of the page and click on "Classic Implementation"

2. Copy the URL, it should look like this: "https://app.typeflow.us/api/generate-doc?record_id="&RECORD_ID()&"&table_id=xxx&flow_id=xxx"

3. Go to your Airtable product table and add a new button field

4. Paste the URL from TypeFlow to the URL Formula

You see a product, you click the button, you get a label.

Option 2: Airtable Automation

Set up an Airtable Automation that generates labels when a condition is met. For example, generate a label when a new product is added or when a status field changes to "Ready to Label."

1. Go to Automation in Airtable

2. Click on "Add a trigger" and choose When a Record matches a condition

3. Select the table and field you want to trigger the automation on

4. Click on Add an advanced logic or action

5. Pick Run Script. A new popup appears.

6. Go back to TypeFlow and select Automation in Airtable. Copy the script.

7. Paste the script in the popup.

8. In the left-side of the popup, do not forget to configure the variable input, record_id. You need to select Airtable Record ID from the dropdown.

9. Test your script, and see if it works. Adjust if needed (most of the time the error comes from the record_id variable - see step 8).

Automations remove manual steps from your workflow. Once configured, labels appear without anyone clicking a button.

Option 3: Bulk Generation

Select multiple records in Airtable and generate labels for all of them at once using the TypeFlow Airtable extension. This is the fastest approach for batch printing, like when you receive new inventory or prepare products for a trade show.

Common Issues with Airtable Barcode Labels and How to Fix Them

Even with a good setup, you might run into a few problems. Here are the most common ones and how to solve them.

Barcode Not Showing on the Label

Check your variable syntax first. The barcode variable format is {{barcode:field_name}}, not {{barcode}}. Also verify that the Airtable field contains a value. Empty fields produce empty barcodes, which look like missing images on your label.

Wrong Number of Labels Printed

This usually happens when the quantity field is misconfigured or missing. Double-check that you've mapped the quantity field in your label generation settings. If the field exists but isn't mapped, the system defaults to one label per record.

Labels Misaligned on Avery Sheets

The template dimensions don't match the physical label sheet. Go back to HTML/CSS template builder and verify the page size matches your Avery label dimensions exactly. Also check that margins are set to zero, since even small margins throw off the alignment.

Start Printing Product Labels from Airtable with TypeFlow

Creating product labels with barcodes from Airtable doesn't require coding or complex software. With TypeFlow's HTML/CSS template builder, you can generate professional labels in minutes.

TypeFlow handles the barcode generation, field mapping, and PDF creation. You focus on your products while the system handles the documents. You can find more workflow tips in the Airtable community and r/Airtable on Reddit.

Related Guides

• How to Print Labels from Airtable - All label types: product, shipping, inventory, and cart labels.
• How to Generate Barcodes from Airtable - EAN-13, Code 128, QR, and GS1-128 barcode deep dive.
• Airtable Document Generation - Complete guide to generating any document from Airtable.
• Airtable Certificate of Conformity - COC documents with batch barcodes.
• Airtable Manufacturing Document Automation - Production orders, QC reports, and spec sheets.