Shopify Plugin documentation

Report an issue

Back to plugin list

Official

Premium

Shopify

The CloudQuery Shopify plugin pulls data from Shopify and loads it into any supported CloudQuery destination

Make sure to sign up and run cloudquery login before running your first sync.

Publisher

cloudquery

Latest version

v5.1.12

Type

Source

Platforms

Date Published

April 23, 2024

Price per 1M rows

Starting from $15

monthly free quota

1M rows

Documentation Tables Changelog Destinations

shopify_abandoned_checkouts
shopify_customers
shopify_orders
shopify_price_rules
shopify_products

Shopify Price Rules

This is a premium table. To sync this table you must be logged in via cloudquery login or use a valid API Key which can be generated via the CloudQuery Cloud Website.

The shopify_price_rules table shows data for Shopify Price Rules.

The primary key for this table is id.

It supports incremental syncs based on the updated_at column.

Columns

Name	Type
admin_graphql_api_id	`utf8`
allocation_limit	`utf8`
allocation_method	`utf8`
_cq_id	`uuid`
_cq_parent_id	`uuid`
created_at	`timestamp[us, tz=UTC]`
customer_segment_prerequisite_ids	`json`
customer_selection	`utf8`
ends_at	`timestamp[us, tz=UTC]`
entitled_collection_ids	`json`
entitled_country_ids	`json`
entitled_product_ids	`json`
entitled_variant_ids	`json`
id	`int64`
once_per_customer	`bool`
prerequisite_collection_ids	`json`
prerequisite_customer_ids	`json`
prerequisite_product_ids	`json`
prerequisite_quantity_range	`json`
prerequisite_shipping_price_range	`json`
prerequisite_subtotal_range	`json`
prerequisite_to_entitlement_purchase	`json`
prerequisite_to_entitlement_quantity_ratio	`json`
prerequisite_variant_ids	`json`
starts_at	`timestamp[us, tz=UTC]`
target_selection	`utf8`
target_type	`utf8`
title	`utf8`
updated_at	`timestamp[us, tz=UTC]`
usage_limit	`int64`
value	`utf8`
value_type	`utf8`

Relations

The following tables depend on "Shopify Price Rules":

Shopify Price Rule Discount Codes