Web & Software E-commerce

Shopify Revenue Dashboard | Home Decor Brand

Saved 15hrs/week in manual reporting

The Challenge

A home decor brand was rebuilding the same revenue report in spreadsheets every Monday, pulling numbers from Shopify, a supplier spreadsheet and the warehouse's own list by hand.

The Solution

We built a real-time dashboard that pulls Shopify orders, products and inventory into one clean view for the whole team, with webhook-driven updates so numbers stay current.

Deliverables

  • Next.js dashboard with Supabase data layer and scheduled sync
  • Revenue, AOV, repeat-rate and inventory KPI views
  • Shopify webhook handling for near real-time order updates
  • Role-based access for owners, marketers and warehouse staff
  • CSV export and date-range comparison

Tools & Stack

Next.js Supabase PostgreSQL Shopify API

Final Result

15hrs

Saved Weekly

100%

Uptime

4

Data Sources Unified

Related Projects