Shopify to BigQuery

Use this workflow when Shopify is the source and BigQuery is the destination. Vendo loads server-side commerce records and first-party storefront events into a queryable warehouse dataset.

Before you start

• Connect Shopify as a source.
• Confirm that the Vendo web pixel or theme integration collects storefront events.
• Prepare a Google Cloud project and a service account with the permissions in BigQuery setup.

Data sent to BigQuery

The Shopify data model documents the canonical event names and commerce objects. Table schemas has the BigQuery table definitions. Do not use this page as a second schema reference.

Configure the destination

1. In the Vendo Shopify app, open Destinations.
2. Click Add destination and click BigQuery.
3. On the Tracking step, select the events that you need.
4. On the Credentials step, enter the Project ID, Dataset ID and Service Account JSON.
5. Click Complete Setup. Vendo checks the credentials before it saves the setup.
6. To send commerce tables, open the Events tab. Under Server-side table sync, turn on the tables that you need.
7. Click Save.

See BigQuery setup for the Google Cloud steps and least-privilege roles.

Verify

1. Open the Overview tab of the BigQuery destination.
2. Open the configured dataset in BigQuery.
3. Check that the expected Shopify tables exist and contain recent rows.
4. Trigger a storefront test event and confirm that it appears in the event table.
5. Compare one order total and one customer identifier with Shopify.

Troubleshooting

Related

• BigQuery overview
• BigQuery table schemas
• Client-side event reference
• Historical backfill