The premise came from a real complaint. Shopify agencies bill for projects, then go quiet between them, and the client forgets what they are paying for. A weekly report fixes that, but building one by hand costs hours nobody bills for.
MerchantPilot connected each client store over Shopify Partner OAuth, read the trailing 30 days of orders, and every Monday sent one email per agency covering all their stores. The header carried the agency's logo. The footer said "Prepared by" and their name. Revenue, order count, average order value, and a week-over-week delta computed from the actual order timestamps — null, not zero, when there was no prior week to compare.
It worked end to end. Payment went live on 2026-07-27 with real card charges at $49 a month.
Then the distribution failed. 40 cold emails over ten days, individually researched, addresses verified on each agency's own site. Two replies. Zero expressions of interest. Zero revenue. The one substantive reply explained why: their client KPI sheet pulls Google Ads, Meta, GA and Search Console together, and a Shopify-only feed replaces none of that work.
The honest limit is that sentence. MerchantPilot read one source. Fixing that is not a feature, it is a different product. We shut it down and wrote the postmortem instead.