Airtable Shipping & Fulfillment Document Automation: Complete Guide

Key Takeaways:

• McKinsey reports that warehouse errors from manual documentation cost companies 1-3% of total revenue. At $10M in annual shipments, that's $100-300K in preventable losses.
• Airtable + TypeFlow automates the full fulfillment document chain: packing lists, shipping labels with barcodes, bills of lading, commercial invoices, and proof of delivery.
• Order line items populate dynamically from Airtable linked records - the packing list grows with the order, no manual entry.
• Bulk generation handles end-of-day batch processing: generate all packing lists for today's shipments in one click.
• Barcodes and QR codes on labels and packing slips for warehouse scanning - no separate labeling software needed.

Last reviewed May 2026.

Every order that ships needs paperwork. Packing lists, shipping labels, commercial invoices for international orders, proof of delivery when it arrives. When your order data lives in Airtable but documents are created manually, the fulfillment bottleneck isn't picking and packing - it's paperwork.

Deloitte research estimates that batch document automation reduces processing time by up to 80%. For a team shipping 50 orders per day with 3 documents each, that's the difference between 5 hours of admin work and 10 minutes.

This guide covers every fulfillment document type, the Airtable base structure you need, and how to automate the entire chain from order to delivery.

Why Fulfillment Teams Need Document Automation

The daily document burden

A typical fulfillment operation generates multiple documents per order:

At 50 orders per day, that's 100-250 documents created manually. Each one takes 2-5 minutes of copy-paste work. The math is simple: automation saves 3-20 hours per day depending on volume.

TypeFlow vs shipping platforms

Tools like ShipStation, Shippo, and EasyPost handle carrier rates and label printing. But they don't generate custom packing lists, branded commercial invoices, or packaging inserts with your design.

TypeFlow doesn't replace your shipping platform. It handles the document side that shipping platforms don't:

Use both together: ShipStation for shipping rates and carrier labels, TypeFlow for custom branded documents from your Airtable data.

Fulfillment Documents You Can Automate

Packing Lists

The document inside every package. Lists all items, quantities, and the ship-to address. Your warehouse team uses it to verify the pick, and the customer uses it to confirm what arrived.

Order line items from Airtable linked records populate dynamically using loop_0 - the table grows based on how many items are in each order. No manual entry.

Key fields: Order number, customer name, ship-to address, items (linked), quantities, SKUs, special handling notes.

Trigger: Auto-generate when order status changes to "Ready to Pack."

Step-by-step guide: Generate Packing Lists from Airtable →

Shipping Labels

Print-ready labels with address, barcode, weight, and carrier info. TypeFlow supports barcode and QR code generation natively in HTML templates - Code128, QR Code, EAN-13, UPC-A.

Key fields: Ship-to name and address, return address, order number (as barcode), weight, carrier, tracking number.

Trigger: Generate with the packing list or separately when carrier is assigned.

Step-by-step guide: Print Labels from Airtable →

Bills of Lading

Required for freight shipments (LTL, FTL). Documents the shipper, consignee, cargo description, weight, and freight class. The carrier signs at pickup and the receiver signs at delivery.

Key fields: Shipper info, consignee info, carrier, BOL number, commodity description, weight, freight class, handling instructions.

Trigger: Auto-generate when shipment method = "Freight."

Step-by-step guide: Shipping Document Generation from Airtable →

Commercial Invoices

Required for international shipments. Includes HS codes per item, declared values, country of origin, and Incoterms (FOB, CIF, etc.). U.S. Customs and Border Protection requires packing lists for all international shipments.

Key fields: Exporter info, importer info, items with HS codes, quantities, unit values, total value, country of origin, currency, Incoterms.

Trigger: Auto-generate when ship-to country is not domestic.

Step-by-step guide: Shipping Document Generation from Airtable →

Proof of Delivery

Confirms that the shipment arrived and was received. The recipient signs on their phone or tablet using TypeFlow's e-signature. The signed PDF saves back to the Airtable order record automatically.

Key fields: Order number, delivery date/time, recipient name, recipient signature, delivery notes, photos of delivered goods.

Trigger: Driver opens the signing link on arrival, recipient signs on-site.

Step-by-step guide: Generate Proof of Delivery from Airtable →

Packaging Inserts

Print-ready cards included with every order: thank-you message, product care instructions, warranty details, and a QR code linking to a how-to guide or product page. Generated per order with personalized content from Airtable.

Key fields: Customer name, product name, care instructions, QR code URL, warranty terms.

Trigger: Auto-generate when order status changes to "Processing."

Document Summary

How to Structure Your Airtable Base for Fulfillment

We've built a ready-to-use fulfillment base you can copy and start with:

Copy the Shipping & Fulfillment base →

Core Tables

Orders One record per order. The hub of your fulfillment workflow.

• Order number (auto-number), order date
• Customer (linked to Customers table)
• Ship-to address
• Status (Received, Processing, Packed, Shipped, Delivered)
• Shipping method, carrier, tracking number
• PDF attachments (packing list, commercial invoice, POD)

Products Your product catalog.

• Product name, SKU, description
• Weight, dimensions
• HS code (for international), country of origin
• Price, cost
• Product image

Order Items (Line Items) Linked to Orders and Products. Each item in an order.

• Product (linked), quantity, unit price, total
• These become loop_0 line items in your packing list template

Customers

• Name, company, email, phone
• Default shipping address
• International flag (triggers commercial invoice)

Key Relationships

Customers
  └── Orders
        └── Order Items
              └── Products

Views for Fulfillment Workflow

• "Ready to Pack" - Orders with status = Processing, all items confirmed
• "Ship Today" - Orders packed, awaiting carrier pickup
• "International" - Orders requiring commercial invoices
• "Awaiting Delivery" - Shipped orders pending POD
• "Delivered" - Completed orders with signed POD

Setting Up Your First Fulfillment Document

1. Create Your Template

Use Google Docs for packing lists and commercial invoices. Use the HTML Template Builder for labels and packaging inserts where precise sizing matters.

For order items, use loop_0 in a table row - TypeFlow repeats the row for each item in the order.

2. Connect and Map

Select your Orders table, choose your template, and map each variable to its Airtable field. For line items, select the Order Items linked record field and map the sub-fields (product name, SKU, quantity).

3. Add Barcodes and QR Codes

In your HTML template, add barcode variables where you need them. TypeFlow supports Code128, QR Code, EAN-13, and UPC-A natively.

For a packing list with an order barcode at the top and a QR code linking to the tracking page, just add the barcode variable in your template - no external barcode software needed.

Learn more about barcodes and QR codes →

Automating the Fulfillment Document Workflow

The Complete Chain

Order received in Airtable
    |
    v (status = "Processing")
Packaging insert generated (if enabled)
    |
    v (status = "Packed")
Packing list generated automatically
Shipping label generated
    |
    v (status = "Shipped")
Commercial invoice generated (if international)
Bill of lading generated (if freight)
    |
    v (delivery confirmed)
Proof of delivery with e-signature
    |
    v (all docs saved to Airtable record)

Each step is triggered by a status change in Airtable Automations. No manual document creation at any point.

Bulk Generation for Batch Processing

End-of-day fulfillment: open the TypeFlow bulk generate page, filter by the "Ship Today" view, and generate all packing lists in one batch.

Morning prep: generate pick lists for the warehouse team based on today's orders.

Weekly: generate shipping summary reports from a filtered view.

Email Delivery

Send commercial invoices to customs brokers automatically. TypeFlow's email delivery attaches the PDF and sends it to the recipient configured in your flow - the customer, the carrier, or the customs broker.

Real-World Examples

E-commerce brand generates packing lists and packaging inserts automatically when orders change to "Processing." Each insert is personalized with the customer's name, the product they ordered, and a QR code linking to care instructions. 50 orders per day, zero manual document work.

Wholesale distributor creates commercial invoices for international orders. Each invoice pulls HS codes and country of origin from the Products table, calculates totals from line items, and emails the PDF to the customs broker. What took 20 minutes per shipment now takes seconds.

3PL warehouse triggers document generation from WMS status updates via Zapier. Each shipment gets a packing list and bill of lading generated simultaneously. Drivers receive the POD signing link before arriving at the delivery address.

Best Practices

Separate domestic and international workflows

Create different automation triggers for domestic (packing list only) and international (packing list + commercial invoice) orders. Use a formula field or a "Country" single select to route orders automatically.

Use views to control batch generation

The "Ship Today" view should only show orders that are fully packed and ready. Add a "Documents Generated" checkbox that updates automatically to prevent duplicate generation.

Keep HS codes in your Products table

Don't add HS codes per order - store them in the Products table and pull them via linked records. When an HS code changes, it updates everywhere automatically.

Test with real international orders

Commercial invoices are the most error-prone document. Test with a real international order including HS codes, multiple currencies, and Incoterms before going live.

Start Automating Fulfillment Documents

Your order data is in Airtable. Your warehouse team is spending hours on paperwork. The gap is automation.

Connect TypeFlow, create your templates, and generate your first packing list in under 30 minutes. Then add labels, commercial invoices, and proof of delivery as your workflow grows.

Start for Free - 20 documents included, no credit card required.

This guide is based on fulfillment workflows from e-commerce and logistics teams using Airtable and TypeFlow. For warehouse and shipping research, see McKinsey, Deloitte, and Gartner Supply Chain. For international trade requirements, see U.S. CBP, ICC Incoterms, and WCO HS Codes. Last reviewed May 2026.