Login
Start Trial
Request Demo

Shopify

Knowi enables visualization, analysis, and reporting automation from your Shopify store data.

Connect your Shopify store to pull orders, products, customers, inventory, and transaction data into Knowi for analytics and dashboards ? no manual exports or CSV files needed.

Overview

Connect directly to your Shopify store using OAuth. Knowi handles authentication, pagination, and data extraction automatically.

Connecting

  1. Log in to Knowi and select "Queries" from the left sidebar.

  2. Click on the "New Datasource +" button and select Shopify from the list of datasources.

  3. Configure the following details:

    a. Datasource Name: Enter a name for your datasource (e.g., "My Shopify Store")

    b. Store URL: Enter your Shopify store URL (e.g., mystore.myshopify.com). This is the subdomain you use to log into your Shopify admin.

  4. Click "Connect to Shopify" to authorize Knowi to access your store data. You will be redirected to Shopify to approve the connection.

  5. After approving, you'll be redirected back to Knowi. Click "Save" to finish setting up the datasource.

Collections

After connecting, select a collection from the dropdown to query your Shopify data.

Orders

Retrieves order data including order ID, customer email, financial status, fulfillment status, totals, and line items.

Optional Filters: * Order Status - Filter by any, open, closed, or cancelled. Default is any (all orders).

Default Cloud9QL:

select orders;
select expand(orders);
select id, name, email, financial_status, fulfillment_status, total_price, created_at, updated_at order by created_at desc;

The expand(orders) flattens Shopify's nested JSON response so each order becomes its own row.

Products

Retrieves product catalog data including title, vendor, product type, variants, and images.

Optional Filters: * Product Status - Filter by active, archived, or draft.

Default Cloud9QL:

select products;
select expand(products);
select id, title, vendor, product_type, status, created_at, updated_at order by created_at desc;

Customers

Retrieves customer data including email, name, order count, and total spend.

Default Cloud9QL:

select customers;
select expand(customers);
select id, email, first_name, last_name, orders_count, total_spent, created_at order by created_at desc;

Inventory Levels

Retrieves inventory quantities by location.

Required Parameters: * Location IDs - Comma-separated list of Shopify location IDs to retrieve inventory for. You can find your location IDs in Shopify Admin under Settings > Locations.

Default Cloud9QL:

select inventory_levels;
select expand(inventory_levels);

Order Transactions

Retrieves payment transaction data for a specific order, including payment gateway, amount, and status.

Required Parameters: * Order ID - The Shopify order ID to retrieve transactions for.

Default Cloud9QL:

select transactions;
select expand(transactions);

Custom Query

For power users who need to access any Shopify Admin API resource not covered by the predefined collections.

Required Parameters: * Resource - The Shopify resource path (e.g., orders, products, customers, collects, smart_collections, custom_collections).

Refer to the Shopify Admin API documentation for available resources.

Querying

After selecting a collection, click Preview to see the data. Use the Cloud9QL editor to transform and filter the results.

Common transformations:

Scheduling

Once your query is configured, you can schedule it to run automatically (e.g., every hour, daily) to keep your dashboards up to date. Knowi handles pagination automatically ? even large stores with thousands of orders are fetched in full.

Notes