🚀 v1.0.0 Released

Shopify data to
PostgreSQL

Enterprise data pipeline that syncs your Shopify orders, products, and customers to PostgreSQL — with automated scheduling, powerful analytics, and Power BI integration.

📦 Get Started 🐳 Docker Hub
3
Data Entities
2
Architectures
10+
Helm Configs
∞
Scalable

Everything You Need

A complete data pipeline from Shopify to your analytics stack

🔄

Real-Time Sync

Incrementally sync orders, products, and customers from Shopify. Only fetches new and updated records for maximum efficiency.

⏰

Automated Scheduling

Cron-based scheduling with presets: every 30 minutes, 1 hour, 6 hours, or daily. Persistent schedules survive restarts.

📊

Analytics Dashboard

Built-in charts for order trends, revenue metrics, top products, and customer insights. No external tools required.

🔬

Analytics Pro

Advanced analytics with cohort analysis, funnel visualization, revenue forecasting, and deep-dive filtering.

📈

Power BI Ready

Connect Power BI directly to your PostgreSQL tables for custom reports and enterprise-grade business intelligence.

🔐

Security First

Helmet headers, CORS, rate limiting, non-root container, and Kubernetes security contexts out of the box.

Deploy Anywhere

Docker Compose, Kubernetes Helm, or bare-metal — your choice

# Pull the multi-arch image
docker pull shyamkrishna21/shopsync:latest

# Run with your PostgreSQL
docker run -d --name shopsync \
  -p 3000:3000 \
  -e DATABASE_URL="postgresql://user:pass@host:5432/db" \
  shyamkrishna21/shopsync:latest
# One-command setup with PostgreSQL included
docker compose up -d

# Open http://localhost:3000
# Install in the shopsync namespace
helm install shopsync ./helm/shopsync \
  -n shopsync --create-namespace \
  --set env.DATABASE_URL="postgresql://user:pass@host:5432/db"

# Or with bundled PostgreSQL
helm install shopsync ./helm/shopsync \
  -n shopsync --create-namespace \
  --set postgresql.enabled=true
# Install dependencies
npm install
cd client && npm install && cd ..

# Build and start
npm run build
npm start

# Open http://localhost:3000

Architecture

Simple, reliable, and production-ready

  ┌──────────────┐      REST API       ┌──────────────┐       Shopify API      ┌──────────────┐
  │              │ ◄─────────────────► │              │ ◄───────────────────►  │              │
  │   Browser    │                     │   ShopSync   │                        │   Shopify    │
  │   (React)    │                     │   (Node.js)  │                        │   Store      │
  │              │                     │              │                        │              │
  └──────────────┘                     └──────┬───────┘                        └──────────────┘
                                              │
                                              │  pg driver
                                              ▼
                                      ┌──────────────┐
                                      │  PostgreSQL   │───────► Power BI / Grafana / Any SQL
                                      └──────────────┘

Tech Stack

Built with modern, reliable technologies

⚛️

React 18

Frontend UI

⚡

Vite

Build Tool

🟢

Node.js 18

Runtime

🚂

Express 4

API Framework

🐘

PostgreSQL 16

Database

📊

Chart.js

Analytics Charts

🐳

Docker

Multi-Arch

☸️

Helm 3

K8s Deployment