Send your Shopify data to Looker Studio, Power BI, Google Sheets, Excel, Tableau, Google BigQuery, Amazon S3, Azure Blob Storage, Snowflake, MySQL, PostgreSQL, Python, Azure SQL, Amazon Redshift, Databricks
Shopify Field Reference
78 metrics253 dimensions
https://connectors.windsor.ai/shopify?api_key=[your API key]&date_preset=last_7d&fields=order_id,order_current_total_price,order_email,order_updated_at&_renderer=csv
The Shopify connector lets you pull Shopify data on an object level (e.g. order, contact). If you specify the fields
date_from and date_to it will filter for a date range in which the objects were created.Sample query for order objects
https://connectors.windsor.ai/shopify?api_key=[your API key]&date_preset=last_28d&fields=order_app_id,order_sales_channel,order_name,order_note,order_tags,order_cancelled_at,order_cancel_reason,order_closed_at,order_created_at,order_count,order_currency,order_current_total_discounts,order_total_discounts,order_total_discounts_set,order_current_total_price,order_current_subtotal_price,order_current_total_tax,order_total_price,order_email,order_financial_status,order_updated_at,order_line_items,order_fulfillable_quantity,order_shipping_address
Sample query for customer objects
https://connectors.windsor.ai/shopify?api_key=[your API key]&date_preset=last_28d&fields=customer_email,customer_created_at,customer_updated_at,customer_date,customer_first_name,customer_last_name,customer_state,customer_total_spent,customer_verified_email,customer_multipass_identifier,customer_tax_exempt,customer_phone,customer_currency,customer_id,customer_last_order_id,customer_last_order_name,customer_note,customer_orders_count,customer_tags&_renderer=powerbi
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| Loading... | ||||