Integrate Shopify with BigQuery
The only Shopify-to-BigQuery integration that syncs client-side web pixel events alongside server-side order, customer, and product data. Get complete storefront behavior and commerce lifecycle data in your warehouse.
One Setup, Four Data Inputs
The Shopify + BigQuery integration combines no-code installation, client events, server events, and full catalog sync.
One-Click No-Code Installation
Shopify-readyInstall the Vendo Shopify app and connect your BigQuery project — no manual pipeline code required.
Shopify Client Events → BigQuery
Only VendoVendo is the only solution that streams Shopify web pixel client-side events directly into BigQuery. No other tool does this.
Shopify Server Events
Payment-verifiedSync order lifecycle data from server-side: orders, fulfillment, delivery, refunds, and abandoned checkouts.
Full Catalog & Customer Sync
IncrementalContinuously sync customer profiles, product catalog, inventory, and fulfillment data into BigQuery tables.
What Happens When You Click Save
Vendo runs a coordinated sync so BigQuery starts with live events, historical data, and full catalog context.
1. Install & Connect
Vendo installs the Shopify web pixel and connects to your BigQuery project using your service account.
2. Real-Time Streaming
Client-side browsing events and server-side order data start streaming into BigQuery tables.
3. Historical Backfill
Orders, customers, products, and abandoned checkouts are backfilled so your warehouse is complete from day one.
Full Event Coverage
All client-side and server-side Shopify events streamed into BigQuery.
Client-Side Events
17 eventsLogs when a customer visits a page across store, checkout, or order status.
Logs when a customer visits a product details page.
Logs when a customer views a collection page.
Logs storefront search actions and intent.
Logs add-to-cart actions with product context.
Logs product removals from cart.
Logs cart page visits and cart state.
Logs checkout initiation.
Logs contact information step completion.
Logs checkout address step completion.
Logs shipping method selection during checkout.
Logs payment details submission.
Logs successful checkout completion.
Logs checkout alerts and validation warnings.
Logs checkout UI extension runtime failures.
Logs variant option selections like size or color.
Logs custom Shopify customer events published by your store or apps.
Server-Side Events
6 eventsTriggered when a new order is created in Shopify.
Triggered when an order is fulfilled and shipped.
Triggered when delivery is confirmed.
Triggered on full refund.
Triggered on partial refund.
Triggered when checkout is abandoned after threshold.
BigQuery Tables
6 tablesShopify data lands in structured, time-partitioned BigQuery tables in your own Google Cloud project.
Customers
29 columnsFull customer profiles: identity, contact, addresses, email marketing consent, order history aggregates, and tax status.
Orders
78 columnsComplete order data: line items, pricing, fulfillments, refunds, shipping, discounts, tax, client details, and UTM attribution.
Products
Full catalogProduct catalog with variants, pricing, inventory, images, and metadata.
Abandoned Checkouts
Full schemaCheckout sessions that were abandoned: cart contents, customer info, and checkout URLs.
Inventory Items
6 columnsSKU-level inventory data: item ID, SKU, currency, unit cost, and timestamps.
Events
14 columnsShopify timeline events: order activities, app actions, and admin operations with full context.
The Only Way to Get Shopify Client-Side Events in BigQuery
Other Shopify-BigQuery tools only sync server-side order data. Vendo streams web pixel events — page views, product views, cart actions, checkout steps — directly into your warehouse alongside complete order and customer data.
Frequently Asked Questions
