Amazon Seller CentralShopify

eCommerce Analytics

Automated reports and alerts
for Amazon and Shopify sellers.

Connect your store in one click. Taptic Data imports your orders, inventory, financials, and traffic into queryable tables — then delivers scheduled reports and real-time alerts so you never miss a beat.

Live store metrics
Revenue (MTD)
$48,291.44
Orders (MTD)
1,204
Avg. Order Value
$40.11
FBA Fee Impact
-$6,218.50
Buy Box %
94.2%
Return Rate
3.1%
Last Synced
8 min ago
🔔Alert triggered: SKU B08XZ12 return rate exceeded 5% threshold — 3 hours ago
🛒Amazon Seller Central
🟢Shopify
📦QuickBooks Online
🔜WooCommerceSoon
🔜EtsySoon
Revenue by SKU
FBA vs FBM split
Top returning products
Customer LTV
Refund rate by category
Settlement reconciliation
Buy box % by ASIN
Inventory aging
Orders by state
AOV trend
Units sold by month
Fee impact analysis
Shopify conversion rate
Multi-channel revenue
Repeat purchase rate
Revenue by SKU
FBA vs FBM split
Top returning products
Customer LTV
Refund rate by category
Settlement reconciliation
Buy box % by ASIN
Inventory aging
Orders by state
AOV trend
Units sold by month
Fee impact analysis
Shopify conversion rate
Multi-channel revenue
Repeat purchase rate

Every table you need, auto-imported and ready to query

On first connect, Taptic pulls your full history and organizes it into clean, queryable tables. Delta refreshes run on your schedule — keeping everything current without re-importing from scratch.

🛒 Amazon Seller Central — 8 tables
amazon_orders
All orders + status
amazon_order_items
SKU-level line items
amazon_financial_events
Charges & fees
amazon_settlement
Settlement payouts
amazon_sales_traffic
Sessions & buy box %
amazon_returns
Return data
amazon_fba_fees
Estimated FBA fees
amazon_fba_inventory
Aged inventory
🟢 Shopify — 8 tables
shopify_orders
Orders & totals
shopify_order_line_items
Product line details
shopify_customers
Customer profiles
shopify_products
Product catalog
shopify_product_variants
SKU variants
shopify_inventory_levels
Stock by location
shopify_fulfillments
Shipment records
shopify_refunds
Refund events

Know before it becomes a problem.

Set thresholds on any metric — return rate, revenue drop, buy box loss, inventory running low — and get notified the moment something moves outside your expected range.

  • Threshold alerts — set floors and ceilings on any metric across any table
  • Triggered after every refresh — alerts evaluate against fresh data, not stale snapshots
  • Email delivery — get notified immediately when a condition is breached
  • Per-platform scoping — separate alert sets for Amazon and Shopify
eCommerce Alerts
Alert
Return rate exceeded threshold
SKU B08XZ12 · 6.2% (threshold: 5%) · Amazon · 3h ago
Warning
Revenue down 18% vs last week
Amazon Seller · Mon–Sun comparison · 6h ago
Info
Buy box % dropped below 90%
ASIN B09K3LMN2 · 87.4% · Amazon · 12h ago
Clear
Shopify daily revenue target met
$4,210 vs $4,000 target · Today · 2h ago
Warning
FBA inventory — 3 SKUs below reorder point
amazon_fba_inventory · Checked after refresh · 1h ago
Amazon Revenue & Orders
Auto-refreshed
Revenue
$48.3K
↑ 12.4%
Orders
1,204
↑ 8.1%
AOV
$40.11
↑ 3.9%
Units
2,841
↓ 1.2%
Revenue & OrdersProduct PerformanceFulfillment AnalysisFinancial SummaryUS Geographic

Premade Amazon & Shopify reports.
Ready the moment you connect.

No setup required. The moment your store connects, Taptic seeds a full set of pre-built reports — each with KPIs, charts, and trend lines already configured and populated with your real data.

  • Amazon: Revenue & Orders, Product Performance, Fulfillment Analysis, Financial Summary, US Geographic
  • Shopify: Revenue & Orders, Product Performance, Customer Insights, Refunds & Returns, Inventory Health
  • Auto-refresh — every report stays current on your sync schedule
  • Fully customizable — edit any query, add tiles, change layouts, schedule PDF emails

Ask any question about your store.
Get a trusted answer in minutes.

Your store data lives in real SQL tables. Taptic's AI knows your schema and writes queries that actually run — not plausible-sounding SQL that references columns that don't exist.

  • "Which SKUs have the highest return rate this quarter?"
  • "Show me revenue by state for FBA orders only"
  • "What's my net after FBA fees vs Shopify orders?"
  • "Which customers ordered more than 3 times in the last 90 days?"

Every answer is backed by real SQL you can inspect, edit, and save as a report.

AI Console — amazon_orders
"Which SKUs have the highest return rate this quarter?"
SELECT i.sku,
COUNT(*) FILTER (WHERE r.return_quantity > 0) * 100.0
/ COUNT(*) AS return_rate_pct
FROM amazon_order_items i
LEFT JOIN amazon_returns r ON r.sku = i.sku
WHERE i.item_price IS NOT NULL
GROUP BY 1 ORDER BY 2 DESC LIMIT 10
B08XZ126.2%312 orders
A77KL904.8%201 orders
C34NM013.1%589 orders

Up and running in under 10 minutes

01
🔗

Connect your store

One-click OAuth for Amazon and Shopify. No API keys to copy, no credentials to manage. Authorize access and you're done.

02
⬇️

Data imports automatically

Taptic pulls your full order history, inventory, financials, and traffic into organized SQL tables — typically under 15 minutes for 90 days.

03
📊

Reports appear instantly

A full set of premade reports are pre-built and waiting for you the moment the import finishes — no setup required.

04
🔔

Set alerts, stay informed

Configure thresholds on any metric. Taptic evaluates them every refresh and emails you the moment something needs attention.

One plan. Everything included.

Commerce Plan
$29.99/mo

No setup fees. Cancel any time.

  • Amazon Seller Central integration — all 8 tables
  • Shopify integration — all 8 tables
  • Premade Amazon & Shopify reports — ready on connect
  • eCommerce alerts on any metric
  • AI console — ask questions in plain English
  • Scheduled PDF email reports
  • Delta refreshes on your schedule
  • Unlimited saved reports and charts

Your store is generating data.
Start using it.

Connect Amazon or Shopify in one click. Your premade reports will be ready before you finish your coffee.