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
Name | Type |
---|---|
_cq_source_name | String |
_cq_sync_time | Timestamp |
_cq_id | UUID |
_cq_parent_id | UUID |
id (PK) | Int |
updated_at (Incremental Key) | Timestamp |
value_type | String |
value | String |
customer_selection | String |
target_type | String |
target_selection | String |
allocation_method | String |
once_per_customer | Bool |
usage_limit | Int |
starts_at | Timestamp |
ends_at | Timestamp |
created_at | Timestamp |
entitled_product_ids | JSON |
entitled_variant_ids | JSON |
entitled_collection_ids | JSON |
entitled_country_ids | JSON |
prerequisite_product_ids | JSON |
prerequisite_variant_ids | JSON |
prerequisite_collection_ids | JSON |
customer_segment_prerequisite_ids | JSON |
prerequisite_customer_ids | JSON |
prerequisite_to_entitlement_quantity_ratio | JSON |
prerequisite_to_entitlement_purchase | JSON |
title | String |
admin_graphql_api_id | String |