bhavipopli

bhavipopli / open-commerce-ops

Public

Self-hosted Shopify and Google Ads operations dashboard for ecommerce teams

analytics ecommerce google-ads postgres react
15
0
89% credibility
Found May 31, 2026 at 15 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
TypeScript
AI Summary

Open Commerce Ops is a free, self-hosted dashboard for small ecommerce teams that combines Shopify store sales with Google Ads advertising spend into unified reports. It solves the common problem of Shopify and Google Ads reporting in different timezones and currencies by normalizing everything into one view. The project runs entirely on your own infrastructure, keeping your business data private and under your control.

How It Works

1
💡 You need better sales reports

You run a small ecommerce business and you're tired of expensive analytics tools that don't talk to each other. You hear about a free, self-hosted dashboard that combines your Shopify sales with your Google Ads spending.

2
📦 You install the dashboard

You download the project and start it up on your computer. It immediately shows you realistic demo data so you can see what the reports look like before connecting any real stores.

3
🏪 You add your Shopify stores

You open a simple configuration file and add your store names and website addresses. The dashboard recognizes your stores and starts pulling in your real sales data.

4
📊 You connect your Google Ads account

You paste a small script into your Google Ads account that automatically sends your ad spending data to the dashboard every hour, so you always see fresh numbers.

5
🎯 Your unified report is ready

The dashboard shows your sales, ad spend, and profit after advertising all in one place, normalized to your preferred timezone so the numbers always match up.

6
🔐 You set up a password

You add a simple username and password to keep your business data private, so only you and your team can access the dashboard.

🚀 You launch it to the web

With one click, you publish your dashboard to the internet. Your team can now access real-time sales and advertising reports from anywhere, and your historical data stays safe in your own database.

Sign up to see the full architecture

5 more

Sign Up Free

Star Growth

See how this repo grew from 15 to 15 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is open-commerce-ops?

Open Commerce Ops is a self-hosted dashboard that pulls Shopify orders and Google Ads spend into one view, built for ecommerce teams who want control over their data without paying for expensive analytics platforms. It runs on React and Vite, stores everything in Postgres, and can be deployed to Vercel or run locally. The system normalizes both Shopify orders and Google Ads rows into a single reporting timezone, maps campaigns to storefronts automatically, and calculates profit after ads. It ships with demo data so you can run it immediately without connecting any accounts.

Why is it gaining traction?

The project solves a real headache: Shopify and Google Ads report in different timezones, use different currency assumptions, and disagree on attribution. This dashboard forces them into one canonical view. Instead of requiring Google Ads API access (which needs manager accounts and developer tokens), it uses Google Ads Scripts to push spend data via a simple webhook endpoint. The Shopify CLI sync worker means you do not need a custom OAuth app to pull order history. Teams running multiple stores with shared ad accounts finally have a transparent, self-hosted alternative to duct-taped spreadsheets.

Who should use this?

Small ecommerce operators running one to five Shopify stores who want to see sales, ad spend, and profit after ads in one place. Marketing managers who need campaign-to-store attribution without Google Ads manager account access. Developers building internal tools who want a starting point for commerce reporting without licensing fees. It is less suited for teams already invested in enterprise platforms like Glew or Daasity, or those needing real-time webhooks out of the box.

Verdict

This is a promising early-stage project with a solid architectural foundation and clear problem framing, but the 15 stars and placeholder URLs in the source-of-truth endpoint signal it is not yet production-hardened for every use case. The credibility score of 0.8999999761581421% reflects that maturity gap. If you are comfortable with a self-hosted setup and want to avoid vendor lock-in, this is worth a serious look. Start with the demo mode, validate it against your actual store data, and contribute back as you find gaps.

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.