Back to portfolio
Case study
SynapSynk
A platform that automatically pulls your online store sales and advertising performance into Notion dashboards. See your real profit, track costs, and measure your return on ad spend, all updated automatically without spreadsheets or manual data entry.
Stack
GoNext.jsPostgreSQLShopify APIWooCommerce APIBigCommerce APIWix APINotion APIMeta Ads APIStripeDockerJWTAES-256
Outcomes
01
Connects to Shopify, WooCommerce, BigCommerce, and Wix to sync your store data automatically
02
Calculates real profit by factoring in product costs, payment fees, and ad spend, not just revenue
03
Creates ready-to-use Notion dashboards with orders, products, and daily performance summaries
Inside the build
01
Store Integration
- Works with Shopify, WooCommerce, BigCommerce, and Wix, connect in minutes with secure sign-in
- Orders sync automatically on a schedule you choose: every 30 minutes, 2 hours, or once a day
- Product catalogs stay up to date with SKU tracking and cost-of-goods information
- Hit a button anytime you want an instant data refresh outside the normal schedule
- Connect multiple stores and manage them all from a single account
02
Ad Performance Tracking
- Pulls in Facebook and Instagram ad campaign data automatically
- See impressions, clicks, spend, and conversions for every campaign in one place
- Calculates cost-per-click, click-through rate, and cost-per-thousand impressions
- Shows your true return on ad spend (ROAS) by matching ad costs to actual revenue
03
Notion Dashboards
- Automatically creates beautiful Notion dashboards with pre-built templates, no setup required
- Orders table shows customer details, profit per order, and which store it came from
- Products table tracks inventory with costs and profitability for each item
- Daily summary rolls up revenue, order count, average order value, profit, ad spend, and ROAS
04
Profit Calculation
- Calculates true net profit: revenue minus payment fees minus product costs
- Accounts for Stripe processing fees and platform-specific charges automatically
- Set product costs as a flat percentage or per-item for precise margin tracking
- Daily profit summaries make it easy to spot trends and make informed decisions
05
How We Built It
- High-performance backend written in Go for fast, reliable data processing
- Modern web frontend with a clean, intuitive interface
- Enterprise-grade security: all sensitive data encrypted, strict user isolation
- Concurrent sync engine processes multiple stores simultaneously without delays
- Background scheduler runs every 5 minutes to keep data fresh based on your plan
More work
Back to the index