Back to plugin list
shopify
Official
Premium

Shopify

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

Publisher

cloudquery

Latest version

v5.5.2

Type

Source

Platforms
Date Published

Price per 1M rows

Starting from $15

monthly free quota

1M rows

  • shopify_abandoned_checkouts
  • shopify_customers
  • shopify_orders
  • shopify_price_rules
    • shopify_price_rule_discount_codes
  • shopify_products
    • shopify_product_variants
    • shopify_product_images

Shopify Price Rules

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
NameType
admin_graphql_api_idutf8
allocation_limitutf8
allocation_methodutf8
_cq_iduuid
_cq_parent_iduuid
created_attimestamp[us, tz=UTC]
customer_segment_prerequisite_idsjson
customer_selectionutf8
ends_attimestamp[us, tz=UTC]
entitled_collection_idsjson
entitled_country_idsjson
entitled_product_idsjson
entitled_variant_idsjson
idint64
once_per_customerbool
prerequisite_collection_idsjson
prerequisite_customer_idsjson
prerequisite_product_idsjson
prerequisite_quantity_rangejson
prerequisite_shipping_price_rangejson
prerequisite_subtotal_rangejson
prerequisite_to_entitlement_purchasejson
prerequisite_to_entitlement_quantity_ratiojson
prerequisite_variant_idsjson
starts_attimestamp[us, tz=UTC]
target_selectionutf8
target_typeutf8
titleutf8
updated_attimestamp[us, tz=UTC]
usage_limitint64
valueutf8
value_typeutf8
Relations

The following tables depend on "Shopify Price Rules":


© 2024 CloudQuery, Inc. All rights reserved.