Sync Shopify to Looker
Automatically sync your Shopify data into Looker with Flatly's no-code, triggerless, turnkey integration service.
Source: Shopify
Shopify is a complete commerce platform that lets you start, grow, and manage a business.
Auth: OAuth
Available datasets
- ApplicationCharges-All
- ApplicationCredits-All
- Blogs
- Blogs+Articles Combo
- Carrier Services
- Custom Collections
- Customers-All
- Customers-Last X days Date-ranged
- Customers+Metafields Combo
- Customers+Metafields-Last X days Combo Date-ranged
- InventoryLocations
- Marketing Events
- Metafields
- Orders-All
- Orders-Last X days Date-ranged
- Orders-All+Metafields Combo
- Orders-Last X days+Metafields Combo Date-ranged
- Orders+Fulfillments-All Combo
- Orders+Fulfillments-Last X days Combo Date-ranged
- Orders+Refunds-All Combo
- Orders+Refunds-Last X days Combo Date-ranged
- Orders+Transactions-All Combo
- Orders+Transactions-Last X days Combo Date-ranged
- Pages-OnlineStore
- PaymentsBalance
- PaymentsPayouts-All
- PaymentsPayouts-Last X days Date-ranged
- PaymentsPayouts-Last X days+Transactions Combo Date-ranged
- Policies-OnlineStore
- PriceRules
- PriceRules+Discounts Combo
- Products-All
- Products+Variants Combo
- Products+Metafields Combo
- Recurring Application Charges
- Redirects
Destination: Looker
Looker reads tables from Google BigQuery.
Auth: Service Account
Supported file formats
- NDJSON
How it works
- 1
Connect Shopify
Authenticate Shopify (OAuth) and Looker (Service Account) in the Flatly dashboard. You only have to do this once.
- 2
Choose your datasets
Pick which Shopify datasets to sync and set your sync frequency. The frequencies available to you depend on your Flatly plan.
- 3
Data lands in Looker
Flatly uploads your Shopify data to Looker automatically and refreshes it based on your sync frequency.
Shopify
What are Metafields and Metaobjects?
Some of the Shopify data sets Flatly offers include metafields and metaobjects automatically blended in with each parent data set (example: Orders-Last X Days+MetaFields). Since these metas can contain nested data, Flatly outputs these data sets in a left-joined format. The parent to each meta has its fields repeated in each row, whereas each meta is unique to each row. The labels from each meta are presented as column headings, to make the data intelligible for human users.
A non-left-joined option (high column count) is available as well. First, experiment with the existing Flatly Shopify data sets and check if your business intelligence platform can properly relate repeated parents to unique metas without any additional setup. Reach out to Flatly Support for more details.
“The interface is unbelievable. Flatly is so easy to use. After years of struggling with Zapier this is life changing.”
Full data refresh
Maintain up-to-date flat files when any nested or bundled data changes in your source app.
Connection Management
Manage multiple tenants, with connection health monitoring.
Bulk Job Management
Control multiple jobs at the same time, with live progress monitoring.
Merged datasets
Export left-joined combo objects like deals+products.
Write options
Refresh one flat file or create a stack of timestamped versions.
Filterability
Include only the columns or views essential for your reporting.
Notifications
Get alerts about your syncs via email, webhooks or Slack notifications.
Logging
Access up to one thousand log entries for your sync operations.
Custom Field Enrichment
Get useful values in your data instead of identifiers or definitions.
Metadata Attachment
See file statistics alongside your flat files to keep track of their origins.
Dark UI Mode
Reduce eye strain and save energy by using our built in dark mode.
Programmatic Jobs
Queue jobs by making API calls or agent requests.
Time Stamp Enrichment
Get human-readable dates and times from UNIX timestamps.
High frequency
10-minute refresh cycles mean your data store is near real-time.
High capacity
Reliably flatten billions of cells to CSV files without hiccups.
Advanced Security
Two-factor authentication and Destination Lock controls.
Stripe-powered Billing
Reliable payments provider with automatic, familiar invoicing and 1% of Sales to Stripe Climate.
Mobile access
Manage your sync operations from your phone if you are traveling.
Connect Shopify to Looker
Get started today with a 14-day free trial. No credit card required. Both human and AI support are available.