Table: shopify_price_rules

This 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.

Relations

The following tables depend on shopify_price_rules:

Columns

NameType
_cq_iduuid
_cq_parent_iduuid
id (PK)int64
updated_at (Incremental Key)timestamp[us, tz=UTC]
value_typeutf8
valueutf8
customer_selectionutf8
target_typeutf8
target_selectionutf8
allocation_methodutf8
once_per_customerbool
usage_limitint64
starts_attimestamp[us, tz=UTC]
ends_attimestamp[us, tz=UTC]
created_attimestamp[us, tz=UTC]
entitled_product_idsjson
entitled_variant_idsjson
entitled_collection_idsjson
entitled_country_idsjson
prerequisite_product_idsjson
prerequisite_variant_idsjson
prerequisite_collection_idsjson
customer_segment_prerequisite_idsjson
prerequisite_customer_idsjson
prerequisite_to_entitlement_quantity_ratiojson
prerequisite_to_entitlement_purchasejson
titleutf8
admin_graphql_api_idutf8