StoreScope for Shopify Owners
A Mac Mini app that pulls in years of raw Shopify or Amazon order exports and turns them into instant dashboards — best-selling SKUs by season, refund cohorts, ad spend vs. profit — without ever sending data to a cloud warehouse.
DTC store owners running on Shopify or Amazon with $200k–$5M annual revenue
- Drag-and-drop import of CSV or directly connect Shopify/Amazon APIs to pull every order ever
- Pre-built dashboards for COGS, ad payback, repeat-customer cohorts, and inventory turns
- Natural-language query bar ('what sold best in October across bundles?') that returns a chart and the underlying SQL
- Local-first storage so a single Mac Mini holds 10+ years of order history without monthly cloud fees
The Dev.to benchmark proved a $600 Mac Mini can crunch 100 million rows of analytics-style data with sub-second queries using ClickHouse, which means an indie merchant no longer needs to rent BigQuery or Snowflake to ask real questions about their own sales history.
A 2023 Shopify community thread seeking a desktop Shopify monitor got 4 posts and modest engagement (2 hearts), and Storebar already exists as a menubar app — confirms niche desire but limited evidence of strong, unaddressed demand beyond what existing menu-bar widgets serve.Looking for a Desktop App to Monitor Shopify Store Performance? ↗
The DTC analytics category is crowded with well-funded incumbents (Triple Whale, Polar Analytics, BeProfit, Glew, Conjura, Klar, Northbeam, Hyros), plus a direct analog (Storebar menubar app) — the local-first/ClickHouse angle is differentiated, but the overall whitespace is modest, not wide-open.5 Triple Whale Alternatives Every eCommerce Brand Should Test-Drive in 2025 ↗
Competitors price at $129–$259+/mo with GMV-based tiers (Triple Whale Foundation ~$219/mo), proving $200k–$5M DTC merchants readily pay $100+/mo for analytics — a $200–500 one-time Mac license or $30–50/mo subscription would convert easily against the subscription norm.Triple Whale Pricing 2026: Plans, Costs & GMV Tiers ↗Triple Whale Pricing (2026) — Plans, Costs & True Price ↗
Shopify/Amazon and DTC are durable, ClickHouse is open-source, and privacy/local-first is a real trend — but Mac-only and on-device constraints exclude Windows users (large share of merchants) and lock out the AI-agent/cloud features competitors are adding rapidly.ClickHouse benchmarks: Performance, cost & scalability compared ↗
The Dev.to Mac Mini + ClickHouse benchmark validates sub-second queries on 100M rows, proving the core engine — but a real product also needs Shopify/Amazon API sync, ad-platform integrations (Meta/Google/TikTok) for ad-spend-vs-profit, ETL pipelines, and a polished native Mac UI, all of which are substantial engineering work.Can a Mac Mini Handle 100 Million Rows? - DEV Community ↗