Batch-generate invoice PDFs from a CSV file with Python

What you'll need

• An InvoiceCraftly API key (see the API reference).
• Python 3.9 or later.
• The requests package: pip install requests.
• A CSV file of orders with columns matching the fields below.

Expected CSV columns

invoice_number, seller_name, seller_address, buyer_name, buyer_address, description, quantity, unit_price, tax_rate, currency — one row per invoice, matching the field names in the reference table. An optional issue_date column is used when present; rows without it fall back to today's date.

The batch script

# pip install requests
import csv
import datetime
import os
import requests

API_KEY = os.environ["INVOICECRAFTLY_API_KEY"]
OUTPUT_DIR = "invoices"
os.makedirs(OUTPUT_DIR, exist_ok=True)

def build_invoice(row):
    return {
        "type": "invoice",
        "number": row["invoice_number"],
        "issueDate": row.get("issue_date") or datetime.date.today().isoformat(),
        "currency": row["currency"].strip().upper(),
        "seller": {"name": row["seller_name"], "addressLines": [row["seller_address"]]},
        "buyer": {"name": row["buyer_name"], "addressLines": [row["buyer_address"]]},
        "items": [{
            "description": row["description"],
            "quantity": float(row["quantity"]),
            "unitPrice": float(row["unit_price"]),
            "taxRate": float(row["tax_rate"]),
        }],
    }

with open("orders.csv", newline="") as csv_file:
    reader = csv.DictReader(csv_file)
    succeeded, failed = 0, []
    for row in reader:
        try:
            invoice = build_invoice(row)
            response = requests.post(
                "https://invoicecraftly.com/api/v1/documents/pdf",
                headers={"Authorization": f"Bearer {API_KEY}", "Content-Type": "application/json"},
                json=invoice,
            )
        except (ValueError, KeyError) as exc:
            failed.append((row.get("invoice_number", "?"), "local", str(exc)))
            continue

        if response.status_code == 200:
            with open(f"{OUTPUT_DIR}/{invoice['number']}.pdf", "wb") as pdf_file:
                pdf_file.write(response.content)
            succeeded += 1
        else:
            failed.append((invoice["number"], response.status_code, response.json().get("error", {}).get("code")))

    print(f"Generated {succeeded} invoice(s).")
    if failed:
        print(f"Failed {len(failed)} row(s):")
        for number, status, code in failed:
            print(f"  {number}: {status} {code}")