SaaS Product · Case study
ConversionID — Affiliate Sales Tracking
A multi-tenant SaaS that plugs into Shopify, auto-matches orders to affiliates, calculates commissions, and generates payout invoices. Built so marketing agencies can run every client's affiliate program from a single workspace.
3 days → 5 minutes
Monthly payout invoices that used to eat a working week now finish before coffee.
Real revenue, not clicks
Merchants finally see which affiliates drive actual sales — and can pay and double down on the right ones.
One account, every client
Agencies onboard new clients in minutes instead of spinning up separate tools each time.
the situation
Shopify merchants running affiliate programs had no reliable way to know who actually drove a sale. Data lived in mismatched spreadsheets, commissions were eyeballed, and generating a month's payout invoices took two to three days of manual work. Agencies handling multiple clients had to juggle separate logins and broken exports for each one.
what i built
- ▸Built an automated Shopify importer that pulls orders in real time and matches each to the correct affiliate — no more spreadsheet reconciliation.
- ▸Designed the commission engine to handle the messy edge cases: refunds, partial refunds, tiered rates, and custom rules per campaign.
- ▸Shipped batch invoice generation with status tracking, so a month of payouts becomes a five-minute task instead of a three-day one.
- ▸Made the whole thing multi-tenant from day one — an agency logs in once and serves every client in an isolated workspace.
built with
Next.js 15React 19TypeScriptDrizzle ORMPostgreSQLSupabaseStripe