qhkm Make Invoice Skill
Generate professional invoices as HTML or PDF. Works for any order — Lazada, Shopee, manual, or custom.
Setup
export INVOICE_COMPANY_NAME="Kedai Ahmad Sdn Bhd"
export INVOICE_COMPANY_ADDRESS="No 12, Jalan Usahawan, 47500 Subang Jaya, Selangor"
export INVOICE_CURRENCY="MYR"
Install wkhtmltopdf (for PDF output):
# macOS
brew install wkhtmltopdf
# Ubuntu/Debian
sudo apt install wkhtmltopdf
Generate HTML Invoice
cat > /tmp/invoice.py << 'EOF'
import os, sys, json
from datetime import datetime
data = json.load(sys.stdin)
company = os.environ.get("INVOICE_COMPANY_NAME", "My Company")
address = os.environ.get("INVOICE_COMPANY_ADDRESS", "")
currency = os.environ.get("INVOICE_CURRENCY", "MYR")
inv_no = data.get("invoice_number", f"INV-{datetime.now().strftime('%Y%m%d%H%M')}")
customer = data.get("customer", {})
items = data.get("items", [])
total = sum(i["quantity"] * i["unit_price"] for i in items)
rows = "\n".join(f"""
<tr>
<td>{i['description']}</td>
<td style="text-align:right">{i['quantity']}</td>
<td style="text-align:right">{currency} {i['unit_price']:.2f}</td>
<td style="text-align:right">{currency} {i['quantity']*i['unit_price']:.2f}</td>
</tr>""" for i in items)
print(f"""<!DOCTYPE html>
<html><head><meta charset="utf-8"><style>
body{{font-family:Arial,sans-serif;max-width:800px;margin:40px auto;color:#333}}
h1{{color:#1a1a1a}} table{{width:100%;border-collapse:collapse;margin-top:20px}}
th{{background:#f5f5f5;padding:10px;text-align:left;border-bottom:2px solid #ddd}}
td{{padding:8px 10px;border-bottom:1px solid #eee}}
.total{{font-weight:bold;font-size:1.1em}} .meta{{color:#666;font-size:0.9em}}
</style></head><body>
<h1>INVOICE</h1>
<p><strong>{company}</strong><br>{address}</p>
<hr>
<table><tr><td>
<p class="meta">Bill To:</p>
<strong>{customer.get('name','')}</strong><br>
{customer.get('email','')}<br>{customer.get('address','')}
</td><td style="text-align:right">
<p class="meta">Invoice No: <strong>{inv_no}</strong></p>
<p class="meta">Date: {datetime.now().strftime('%d %B %Y')}</p>
<p class="meta">Due: {data.get('due_date', 'Upon Receipt')}</p>
</td></tr></table>
<table><tr>
<th>Description</th><th style="text-align:right">Qty</th>
<th style="text-align:right">Unit Price</th><th style="text-align:right">Amount</th>
</tr>{rows}
<tr><td colspan="3" style="text-align:right" class="total">TOTAL</td>
<td style="text-align:right" class="total">{currency} {total:.2f}</td></tr>
</table>
<p style="margin-top:40px;color:#666">{data.get('notes','Thank you for your business!')}</p>
</body></html>""")
EOF
# Example: generate invoice from JSON
cat << 'INVOICE_DATA' | python3 /tmp/invoice.py > /tmp/invoice-INV001.html
{
"invoice_number": "INV-2026-001",
"customer": {
"name": "Siti Rahimah binti Aziz",
"email": "siti@example.com",
"address": "Kuala Lumpur, Malaysia"
},
"items": [
{"description": "Premium Widget x2", "quantity": 2, "unit_price": 49.90},
{"description": "Shipping", "quantity": 1, "unit_price": 8.00}
],
"notes": "Payment via bank transfer to Maybank 5612-1234-5678"
}
INVOICE_DATA
echo "Invoice saved: /tmp/invoice-INV001.html"
Convert HTML to PDF
wkhtmltopdf --quiet /tmp/invoice-INV001.html /tmp/invoice-INV001.pdf
echo "PDF saved: /tmp/invoice-INV001.pdf"
Email the Invoice (with send-email skill)
ATTACHMENT=$(base64 -i /tmp/invoice-INV001.pdf)
curl -s -X POST "https://api.resend.com/emails" \
-H "Authorization: Bearer $RESEND_API_KEY" \
-H "Content-Type: application/json" \
-d "{
\"from\": \"$EMAIL_FROM\",
\"to\": [\"siti@example.com\"],
\"subject\": \"Invoice INV-2026-001 from $INVOICE_COMPANY_NAME\",
\"text\": \"Dear Siti,\n\nPlease find your invoice attached.\n\nTotal: MYR 107.80\n\nThank you!\",
\"attachments\": [{
\"filename\": \"invoice-INV001.pdf\",
\"content\": \"$ATTACHMENT\"
}]
}" | jq -r '.id'
Batch Invoices from CSV
# invoices.csv: invoice_number,customer_name,customer_email,description,quantity,unit_price
while IFS=, read -r inv_no name email desc qty price; do
cat << EOF | python3 /tmp/invoice.py > "/tmp/invoice-${inv_no}.html"
{"invoice_number":"$inv_no","customer":{"name":"$name","email":"$email"},"items":[{"description":"$desc","quantity":$qty,"unit_price":$price}]}
EOF
wkhtmltopdf --quiet "/tmp/invoice-${inv_no}.html" "/tmp/invoice-${inv_no}.pdf"
echo "Generated: invoice-${inv_no}.pdf"
done < invoices.csv
Tips
- Use
invoice_numberas a unique ID — include year prefix (e.g.INV-2026-001) - Store generated invoice paths in your database for retrieval
- For SST (Malaysian sales tax), add a tax row:
{"description": "SST 8%", "quantity": 1, "unit_price": total * 0.08} - wkhtmltopdf renders exactly like Chrome — test HTML in browser first
- Keep the Python script as a file (
~/.zeptoclaw/scripts/invoice.py) for reuse