price-increase-letter
Generate one personalized, branded HTML price-increase letter per customer from a CSV (name, email, current rate) plus a brand.json and the new rate. Each letter announces the change with old and new rates, gives one brief honest reason, and thanks the customer for their loyalty. Use when raising rates and wanting every customer told personally instead of with a mass blast.
$ skillbank install price-increase-letter@1.0.0 # pins exactly 1.0.0 · README + changelog included
Price Increase Letter
Overview
Raising prices is uncomfortable; announcing it badly loses customers. letters.py takes your customer list and produces one personalized HTML letter per customer — their name, their current rate, the new rate with the percentage change, one brief honest reason, and a thank-you for their loyalty. Branded with your business name and tagline from brand.json.
Each letter is a self-contained HTML file you can attach to an email or print. The script does not send anything — you keep control of delivery.
All data stays local — customer names, emails, and rates are never uploaded anywhere.
Installation
1. Copy the price-increase-letter/ directory anywhere convenient. 2. Make the script executable (Unix):
chmod +x scripts/letters.py
No pip install needed — standard library only.
Configuration
Two input files, both yours to create:
customers.csv — headers exactly name,email,current_rate:
name,email,current_rate
Jane Miller,jane.miller@example.com,85
Tom Alvarez,tom.alvarez@example.com,85
brand.json — business_name required; the rest optional:
{
"business_name": "Maple Street Cleaning Co.",
"tagline": "Spotless, every time.",
"contact": "hello@example.com",
"reason": "our supply and labor costs have risen over the past year"
}
Omit reason and the letter uses a generic honest line about rising costs. Keep the reason to one sentence — nobody believes a paragraph of justification, and a long one reads as guilt.
Inputs
| Flag | Required | Description | |---|---|---| | --customers | yes | Path to the customers CSV | | --brand | yes | Path to brand.json | | --new-rate | yes | The new rate in dollars (applies to every customer) | | --effective-date | yes | When the new rate takes effect (e.g. 2026-11-01) | | --out | no | Output directory (default letters) |
Bad rows (missing name, invalid email, non-numeric rate) stop the run with a clear error naming the file and line number — fix the row and re-run. Exit codes: 0 = ok, 2 = bad/missing input.
Worked example
$ cat customers.csv
name,email,current_rate
Jane Miller,jane.miller@example.com,85
Tom Alvarez,tom.alvarez@example.com,85
Priya Nair,priya.nair@example.com,85
$ ./scripts/letters.py --customers customers.csv --brand brand.json \
--new-rate 95 --effective-date 2026-11-01 --out letters
wrote letters/jane-miller.html (Jane Miller $85.00 -> $95.00)
wrote letters/tom-alvarez.html (Tom Alvarez $85.00 -> $95.00)
wrote letters/priya-nair.html (Priya Nair $85.00 -> $95.00)
done: 3 letter(s) in letters/
Each letter is addressed by name, shows the customer's own old rate ($85.00 → $95.00, +11.8%), states the reason from brand.json, and closes with thanks. Open one in a browser to proofread before sending.
See references/letter-writing-guide.md for how to think about the announcement itself.
Version history
Changelog
1.0.0 — 2026-09-27
- Initial release:
scripts/letters.pygenerates one personalized branded HTML price-increase letter per customer from a customers CSV + brand.json, with per-customer old/new rate and percentage change, a one-sentence reason, and a loyalty thank-you. Validates CSV rows with file-and-line-number errors. Includesreferences/letter-writing-guide.md.