Skip to content
Blotout Blotout Blotout
Dashboard

Shopify

Use the Shopify connector to sync orders, products, customers, and related commerce data into your Athena lakehouse. Blotout runs the Airbyte Shopify connector inside your deployment.

For connector reference (streams, scopes, changelog), see the Airbyte Shopify docs.

Prerequisites

Section titled “Prerequisites”
  • A tag with Blotout Cloud set up (green checkmark in the Tags table)
  • An active Shopify store
  • If you do not own the store, request access from the store owner
  • A Shopify custom app with Admin API read_ scopes enabled, and its Admin API access token (used as the API Password)

Create a Shopify custom app

Section titled “Create a Shopify custom app”
  1. Log in to your Shopify admin.
  2. Go to Settings → Apps and sales channels → Develop apps → Create an app.
  3. Name the app, then open Configure Admin API scopes.
  4. Enable the required read_ scopes only (do not enable write_ scopes). See the Airbyte Shopify scope list for the full set.
  5. Click Install app, then open API credentials and copy the Admin API access token.

Create the pipeline

Section titled “Create the pipeline”

Follow the shared Create a pipeline steps until the source catalogue appears, then select Shopify.

Source configuration

Section titled “Source configuration”

On the Source step, configure the connector:

FieldPurpose
Schedule TypeHow the pipeline runs — typically Scheduled
Sync FrequencyHow often Airbyte syncs (for example, Every 24 hours)
Source NameName for this pipeline — used in the Athena schema <SOURCE_NAME>_<ENV>

Authentication (API Password)

Section titled “Authentication (API Password)”

Blotout Cloud uses API Password authentication for Shopify (Admin API access token from a custom app):

  1. Under Shopify Configuration, enter your Shopify Store name — the subdomain from your admin URL (for example, my-store for https://my-store.myshopify.com), also available under Settings → Store details.
  2. Set Shopify Authorization Method to API Password.
  3. Paste the custom app Admin API access token into the API Password field.

Shopify source configuration with API Password

Optional fields (for example, replication start date) can be expanded under Optional if you need to limit how far back historical data is synced.

Complete Schema and Summary

Section titled “Complete Schema and Summary”

Continue through the Schema and Summary steps to choose streams and confirm the connection. Save and run the first sync.

After a successful sync, Airflow creates an organization-scoped DAG for the pipeline, and dbt models feed the Shopify Dashboard.

Section titled “Related documentation”