{% docs model__shopify_stores_master %}
One row per Shopify store — the spine for all mart models. Combines store metadata from two sources: CRM-managed stores and Fansifter-managed stores. Vendor and label names are resolved via Orchard data. Multi-artist stores store their artist list as a JSON array in MULTI_ARTIST_STORE_ARTISTS. All mart models join here on STORE_SCHEMA to obtain store metadata.
{% enddocs %}

{% docs col__store_id %}
Internal store identifier from shopify_stores_master.
{% enddocs %}

{% docs col__store_schema %}
Snowflake schema name for the store's raw Fivetran data.
{% enddocs %}

{% docs col__store_name %}
Human-readable store name.
{% enddocs %}

{% docs col__artist %}
Artist or brand name associated with the Shopify store.
{% enddocs %}

{% docs col__vendor_name %}
Sony Music vendor or label name associated with the store.
{% enddocs %}

{% docs col__vendor_id %}
Sony Music vendor identifier for the label or distributor associated with the store.
{% enddocs %}

{% docs col__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA.
{% enddocs %}

{% docs col___fivetran_synced %}
The timestamp of the most recent Fivetran sync that loaded or updated this record.
{% enddocs %}

{% docs col___fivetran_deleted %}
Fivetran soft-delete flag. True if the record was deleted in Shopify but retained for history.
{% enddocs %}

{% docs col__created_at %}
The date and time (ISO 8601) when the record was created.
{% enddocs %}

{% docs col__updated_at %}
The date and time (ISO 8601) when the record was last modified.
{% enddocs %}

{% docs col__processed_at %}
The date and time (ISO 8601) when the record was processed.
{% enddocs %}

{% docs col__published_at %}
The date and time (ISO 8601) when the record was published.
{% enddocs %}

{% docs col__created_at_date %}
The date (UTC) when the record was created, derived from CREATED_AT::DATE.
{% enddocs %}

{% docs col__updated_at_date %}
The date (UTC) when the record was last modified, derived from UPDATED_AT::DATE.
{% enddocs %}

{% docs col__processed_at_date %}
The date (UTC) when the record was processed, derived from PROCESSED_AT::DATE.
{% enddocs %}

{% docs col__published_at_date %}
The date (UTC) when the record was published, derived from PUBLISHED_AT::DATE.
{% enddocs %}

{% docs col__completed_at_date %}
The date (UTC) when the checkout was completed, derived from COMPLETED_AT::DATE.
{% enddocs %}

{% docs col__closed_at_date %}
The date (UTC) when the record was closed, derived from CLOSED_AT::DATE.
{% enddocs %}

{% docs col__cancelled_at_date %}
The date (UTC) when the order was cancelled, derived from CANCELLED_AT::DATE.
{% enddocs %}

{% docs col__happened_at_date %}
The date (UTC) when the fulfillment event occurred, derived from HAPPENED_AT::DATE.
{% enddocs %}

{% docs col__estimated_delivery_at_date %}
The estimated delivery date (UTC), derived from ESTIMATED_DELIVERY_AT::DATE.
{% enddocs %}

{% docs col__accepts_marketing_updated_at_date %}
The date (UTC) when the accepts_marketing status was last updated, derived from ACCEPTS_MARKETING_UPDATED_AT::DATE.
{% enddocs %}

{% docs col__email_marketing_consent_consent_updated_at_date %}
The date (UTC) when the customer last updated their email marketing consent, derived from EMAIL_MARKETING_CONSENT_CONSENT_UPDATED_AT::DATE.
{% enddocs %}

{% docs col__sms_marketing_consent_updated_at_date %}
The date (UTC) when the customer last updated their SMS marketing consent, derived from SMS_MARKETING_CONSENT_UPDATED_AT::DATE.
{% enddocs %}

{% docs col__default_phone_number_marketing_updated_at_date %}
The date (UTC) when the default phone number's SMS marketing consent was last updated, derived from DEFAULT_PHONE_NUMBER_MARKETING_UPDATED_AT::DATE.
{% enddocs %}

{% docs col__fulfill_at_date %}
The date (UTC) at which the fulfillment order is scheduled to be fulfilled, derived from FULFILL_AT::DATE.
{% enddocs %}

{% docs col__authorization_expires_at_date %}
The date (UTC) when the authorization expires, derived from AUTHORIZATION_EXPIRES_AT::DATE.
{% enddocs %}

{% docs col__extended_authorization_standard_authorization_expires_at_date %}
The date (UTC) when the standard authorization window expires under extended authorization, derived from EXTENDED_AUTHORIZATION_STANDARD_AUTHORIZATION_EXPIRES_AT::DATE.
{% enddocs %}

{% docs col__extended_authorization_extended_authorization_expires_at_date %}
The date (UTC) when the extended authorization window expires, derived from EXTENDED_AUTHORIZATION_EXTENDED_AUTHORIZATION_EXPIRES_AT::DATE.
{% enddocs %}

{% docs col__customer_address__customer_id %}
The unique Shopify identifier for the customer who owns this address. Joins to customer.customer_id.
{% enddocs %}

{% docs col__customer_address__id %}
The unique numeric identifier for this specific address record.
{% enddocs %}

{% docs col__customer_address__name %}
The full name of the person at this address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__customer_address__first_name %}
The first name of the person at this address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__customer_address__last_name %}
The last name of the person at this address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__customer_address__company %}
The company name at this address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__customer_address__phone %}
The phone number at this address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__customer_address__address_1 %}
The primary street address line. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__customer_address__address_2 %}
An optional secondary street address line. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__customer_address__city %}
The city, town, or village of the address.
{% enddocs %}

{% docs col__customer_address__country %}
The full name of the country for this address.
{% enddocs %}

{% docs col__customer_address__country_code %}
The two-letter ISO 3166-1 alpha-2 country code for this address (e.g. US, GB, DE).
{% enddocs %}

{% docs col__customer_address__province %}
The name of the state, province, or territory of this address.
{% enddocs %}

{% docs col__customer_address__province_code %}
The two-letter abbreviation for the state, province, or territory of this address.
{% enddocs %}

{% docs col__customer_address__zip %}
The zip or postal code of this address.
{% enddocs %}

{% docs col__customer_address__latitude %}
The geographic latitude coordinate of this address, as a string.
{% enddocs %}

{% docs col__customer_address__longitude %}
The geographic longitude coordinate of this address, as a string.
{% enddocs %}

{% docs col__customer_address__is_default %}
Whether this is the customer's default address used for shipping and billing.
{% enddocs %}

{% docs col__fulfillment__id %}
The unique numeric identifier for the fulfillment.
{% enddocs %}

{% docs col__fulfillment__order_id %}
The unique identifier of the order this fulfillment belongs to. Joins to order.order_id.
{% enddocs %}

{% docs col__fulfillment__location_id %}
The ID of the Shopify location from which the fulfillment was processed.
{% enddocs %}

{% docs col__fulfillment__created_at %}
The date and time (ISO 8601) when the fulfillment was created.
{% enddocs %}

{% docs col__fulfillment__updated_at %}
The date and time (ISO 8601) when the fulfillment was last modified.
{% enddocs %}

{% docs col__fulfillment__status %}
The current status of the fulfillment. Valid values: pending, open, success, cancelled, error, failure.
{% enddocs %}

{% docs col__fulfillment__service %}
The fulfillment service associated with the fulfillment (e.g. manual, shipwire).
{% enddocs %}

{% docs col__fulfillment__tracking_company %}
The name of the shipping carrier used for the fulfillment (e.g. UPS, FedEx, USPS).
{% enddocs %}

{% docs col__fulfillment__tracking_number %}
The primary tracking number for the shipment provided by the carrier.
{% enddocs %}

{% docs col__fulfillment__tracking_numbers %}
A JSON array of all tracking numbers associated with this fulfillment, if multiple parcels were shipped.
{% enddocs %}

{% docs col__fulfillment__tracking_urls %}
A JSON array of tracking URLs for the shipment, one per tracking number.
{% enddocs %}

{% docs col__fulfillment__shipment_status %}
The current shipment status from the carrier. Values: label_printed, label_purchased, attempted_delivery, ready_for_pickup, picked_up, confirmed, in_transit, out_for_delivery, delivered, failure.
{% enddocs %}

{% docs col__fulfillment__name %}
The human-readable identifier for the fulfillment (e.g. #1001.1 for the first fulfillment of order #1001).
{% enddocs %}

{% docs col__fulfillment__receipt_authorization %}
The authorization code from the payment gateway associated with the fulfillment, if applicable.
{% enddocs %}

{% docs col__fulfillment_event__id %}
The unique numeric identifier for the fulfillment event.
{% enddocs %}

{% docs col__fulfillment_event__order_id %}
The unique identifier of the order associated with this event. Joins to order.order_id.
{% enddocs %}

{% docs col__fulfillment_event__fulfillment_id %}
The unique identifier of the fulfillment this event belongs to. Joins to fulfillment.id.
{% enddocs %}

{% docs col__fulfillment_event__shop_id %}
The unique identifier of the Shopify store where the event occurred.
{% enddocs %}

{% docs col__fulfillment_event__status %}
The status of the fulfillment event representing the tracking milestone. Values: label_printed, label_purchased, attempted_delivery, ready_for_pickup, picked_up, confirmed, in_transit, out_for_delivery, delivered, failure.
{% enddocs %}

{% docs col__fulfillment_event__message %}
An optional message describing the fulfillment event in more detail.
{% enddocs %}

{% docs col__fulfillment_event__happened_at %}
The date and time (ISO 8601) when the fulfillment event actually occurred.
{% enddocs %}

{% docs col__fulfillment_event__estimated_delivery_at %}
The estimated delivery date and time (ISO 8601) for the shipment, if provided by the carrier.
{% enddocs %}

{% docs col__fulfillment_event__created_at %}
The date and time (ISO 8601) when the fulfillment event record was created in Shopify.
{% enddocs %}

{% docs col__fulfillment_event__updated_at %}
The date and time (ISO 8601) when the fulfillment event record was last modified.
{% enddocs %}

{% docs col__fulfillment_event__address_1 %}
The street address of the location where the fulfillment event occurred, if provided.
{% enddocs %}

{% docs col__fulfillment_event__city %}
The city where the fulfillment event occurred, if provided.
{% enddocs %}

{% docs col__fulfillment_event__province %}
The state or province where the fulfillment event occurred, if provided.
{% enddocs %}

{% docs col__fulfillment_event__country %}
The country where the fulfillment event occurred, if provided.
{% enddocs %}

{% docs col__fulfillment_event__zip %}
The zip or postal code where the fulfillment event occurred, if provided.
{% enddocs %}

{% docs col__fulfillment_event__latitude %}
The geographic latitude of the fulfillment event location, if provided.
{% enddocs %}

{% docs col__fulfillment_event__longitude %}
The geographic longitude of the fulfillment event location, if provided.
{% enddocs %}

{% docs col__customer__customer_id %}
The unique numeric identifier for the customer (sourced from the id column of the raw CUSTOMER table).
{% enddocs %}

{% docs col__customer__first_name %}
The customer's first name. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__customer__last_name %}
The customer's last name. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__customer__email %}
The customer's email address. Hashed at the database level for PII compliance.
{% enddocs %}

{% docs col__customer__phone %}
The customer's unique phone number in E.164 format. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__customer__verified_email %}
Whether the customer has verified their email address. Defaults to true if the customer was created through the Shopify admin or API.
{% enddocs %}

{% docs col__customer__multipass_identifier %}
A unique identifier for the customer used with Shopify Multipass login.
{% enddocs %}

{% docs col__customer__state %}
The state of the customer's account with the store. Valid values: enabled, disabled, invited, declined. Meaningful only when Classic Customer Accounts is active.
{% enddocs %}

{% docs col__customer__note %}
A merchant-facing note about the customer.
{% enddocs %}

{% docs col__customer__can_delete %}
Whether the merchant can delete this customer. A customer can only be deleted if they have not yet placed any orders.
{% enddocs %}

{% docs col__customer__created_at %}
The date and time (ISO 8601) when the customer record was created.
{% enddocs %}

{% docs col__customer__updated_at %}
The date and time (ISO 8601) when the customer record was last updated.
{% enddocs %}

{% docs col__customer__orders_count %}
The total number of orders associated with this customer across their order history.
{% enddocs %}

{% docs col__customer__total_spent %}
The total amount of money the customer has spent across all their orders, in shop currency.
{% enddocs %}

{% docs col__customer__lifetime_duration %}
The amount of time since the customer was first added to the store, expressed as a human-readable string (e.g. "about 12 years"). Read-only.
{% enddocs %}

{% docs col__customer__currency %}
The three-letter ISO 4217 currency code for the currency used in the customer's last order. Defaults to the shop currency.
{% enddocs %}

{% docs col__customer__tax_exempt %}
Whether the customer is exempt from paying taxes on their orders. If true, taxes are not applied at checkout.
{% enddocs %}

{% docs col__customer__accepts_marketing %}
Whether the customer consented to receive marketing emails. Deprecated as of Shopify API 2022-04; superseded by email_marketing_consent_state.
{% enddocs %}

{% docs col__customer__accepts_marketing_updated_at %}
The date and time when the accepts_marketing status was last updated. Deprecated as of Shopify API 2022-04; superseded by email_marketing_consent_consent_updated_at.
{% enddocs %}

{% docs col__customer__marketing_opt_in_level %}
The marketing subscription opt-in level the customer gave when consenting to marketing emails. Deprecated as of Shopify API 2022-04; superseded by email_marketing_consent_opt_in_level. Valid values: single_opt_in, confirmed_opt_in, unknown.
{% enddocs %}

{% docs col__customer__email_marketing_consent_state %}
The current email marketing consent state for the customer. Replaces the deprecated accepts_marketing field. Reflects whether the customer has opted in, out, or not responded.
{% enddocs %}

{% docs col__customer__email_marketing_consent_opt_in_level %}
The email marketing subscription opt-in level as described in M3AAWG best practices. Replaces the deprecated marketing_opt_in_level field. Valid values: single_opt_in, confirmed_opt_in, unknown.
{% enddocs %}

{% docs col__customer__email_marketing_consent_consent_updated_at %}
The date and time when the customer last updated their email marketing consent. Replaces the deprecated accepts_marketing_updated_at field.
{% enddocs %}

{% docs col__customer__sms_marketing_consent_state %}
The current SMS marketing consent state for the customer. Flattened by Fivetran from the sms_marketing_consent object.
{% enddocs %}

{% docs col__customer__sms_marketing_consent_opt_in_level %}
The marketing subscription opt-in level the customer gave when consenting to SMS marketing. Flattened by Fivetran. Valid values: single_opt_in, confirmed_opt_in, unknown.
{% enddocs %}

{% docs col__customer__sms_marketing_consent_collected_from %}
The source from which the SMS marketing consent was collected (e.g. SHOPIFY_ADMIN, SHOPIFY_STOREFRONT, UNKNOWN). Flattened by Fivetran.
{% enddocs %}

{% docs col__customer__sms_marketing_consent_updated_at %}
The date and time when the customer last updated their SMS marketing consent. Flattened by Fivetran.
{% enddocs %}

{% docs col__customer__default_phone_number %}
The customer's default phone number used for SMS marketing, flattened by Fivetran.
{% enddocs %}

{% docs col__customer__default_phone_number_source_location_id %}
The ID of the Shopify location where the default phone number's marketing consent was collected. Flattened by Fivetran.
{% enddocs %}

{% docs col__customer__default_phone_number_marketing_collected_from %}
The source channel from which the default phone number's SMS marketing consent was collected (e.g. SHOPIFY_ADMIN, SHOPIFY_STOREFRONT). Flattened by Fivetran.
{% enddocs %}

{% docs col__customer__default_phone_number_marketing_state %}
The current SMS marketing consent state associated with the default phone number. Flattened by Fivetran.
{% enddocs %}

{% docs col__customer__default_phone_number_marketing_opt_in_level %}
The SMS marketing subscription opt-in level associated with the default phone number. Flattened by Fivetran.
{% enddocs %}

{% docs col__customer__default_phone_number_marketing_updated_at %}
The date and time when the default phone number's SMS marketing consent was last updated. Flattened by Fivetran.
{% enddocs %}

{% docs col__customer__default_email_address %}
The customer's default email address used for email marketing, flattened by Fivetran.
{% enddocs %}

{% docs col__customer__default_email_address_source_location_id %}
The ID of the Shopify location where the default email address's marketing consent was collected. Flattened by Fivetran.
{% enddocs %}

{% docs col__customer__metafield %}
Additional metadata attached to the customer record (JSON). Contains key, namespace, value, type, and description sub-fields for storing custom attributes.
{% enddocs %}

{% docs col__customer___fivetran_deleted %}
Fivetran soft-delete flag. True if the record was deleted in Shopify but retained for history.
{% enddocs %}

{% docs col__collection_product__collection_id %}
The unique numeric identifier of the collection. Joins to collection.id.
{% enddocs %}

{% docs col__collection_product__product_id %}
The unique numeric identifier of the product in the collection. Joins to product.id.
{% enddocs %}

{% docs col__collection__id %}
The unique numeric identifier for the collection (custom or smart).
{% enddocs %}

{% docs col__collection__title %}
The name of the collection, up to 255 characters.
{% enddocs %}

{% docs col__collection__handle %}
A human-friendly unique string for the collection automatically generated from the title. Used in Liquid templates and storefront URLs (e.g. "summer-sale").
{% enddocs %}

{% docs col__collection__body_html %}
The description of the collection with full HTML markup, as displayed on the collection page in the storefront.
{% enddocs %}

{% docs col__collection__published_at %}
The date and time (ISO 8601) when the collection was published and made visible on the storefront. Null if the collection is hidden.
{% enddocs %}

{% docs col__collection__published_scope %}
The publication channel for the collection. Values: web (Online Store only), global (Online Store and Point of Sale).
{% enddocs %}

{% docs col__collection__updated_at %}
The date and time (ISO 8601) when the collection was last modified.
{% enddocs %}

{% docs col__collection__sort_order %}
The default sort order for products within the collection. Values: alpha-asc, alpha-desc, best-selling, created, created-desc, manual, price-asc, price-desc.
{% enddocs %}

{% docs col__collection__template_suffix %}
The suffix of the Liquid template used to render the collection page. Null uses the default collection.liquid template.
{% enddocs %}

{% docs col__collection__disjunctive %}
Smart collection logic operator. False means products must match ALL rules (AND logic); true means products match if they satisfy ANY one rule (OR logic). Null for custom collections.
{% enddocs %}

{% docs col__collection__rules %}
A JSON array of rule conditions that determine automatic product membership for smart collections (e.g. matching by tag, title, vendor, price). Null for custom collections.
{% enddocs %}

{% docs col__collection__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT).
{% enddocs %}

{% docs col__abandoned_checkout__id %}
The unique numeric identifier for the abandoned checkout record.
{% enddocs %}

{% docs col__abandoned_checkout__token %}
A unique token identifier for the checkout session.
{% enddocs %}

{% docs col__abandoned_checkout__cart_token %}
The identifier for the cart attached to the checkout. Deprecated by Shopify.
{% enddocs %}

{% docs col__abandoned_checkout__name %}
The checkout name identifier (e.g. #1002). Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__abandoned_checkout_url %}
The recovery URL sent to the customer so they can return and complete their checkout.
{% enddocs %}

{% docs col__abandoned_checkout__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran ABANDONED_CHECKOUT table.
{% enddocs %}

{% docs col__abandoned_checkout__source_name %}
The sales channel or platform through which the checkout was initiated (e.g. web, pos).
{% enddocs %}

{% docs col__abandoned_checkout__source %}
The source identifier for the checkout, indicating the origin channel or integration.
{% enddocs %}

{% docs col__abandoned_checkout__source_url %}
The URL of the product or page that initiated the checkout session.
{% enddocs %}

{% docs col__abandoned_checkout__gateway %}
The payment gateway selected or used during the checkout transaction. Deprecated by Shopify.
{% enddocs %}

{% docs col__abandoned_checkout__app_id %}
The ID of the Shopify app that created the checkout, if applicable.
{% enddocs %}

{% docs col__abandoned_checkout__created_at %}
The date and time (ISO 8601) when the checkout was created.
{% enddocs %}

{% docs col__abandoned_checkout__updated_at %}
The date and time (ISO 8601) when the checkout was last modified.
{% enddocs %}

{% docs col__abandoned_checkout__completed_at %}
The date and time (ISO 8601) when the checkout was completed. Null for truly abandoned checkouts; populated only if the customer completes checkout via the recovery URL.
{% enddocs %}

{% docs col__abandoned_checkout__closed_at %}
The date and time (ISO 8601) when the checkout was closed. Deprecated by Shopify.
{% enddocs %}

{% docs col__abandoned_checkout__subtotal_price %}
The total merchandise cost in shop currency before taxes and shipping charges.
{% enddocs %}

{% docs col__abandoned_checkout__total_price %}
The final checkout total in shop currency, including line items, shipping, and taxes, after discounts.
{% enddocs %}

{% docs col__abandoned_checkout__total_discounts %}
The aggregate discount amount applied across the entire checkout in shop currency.
{% enddocs %}

{% docs col__abandoned_checkout__total_line_items_price %}
The combined price of all line items in shop currency before discounts and taxes.
{% enddocs %}

{% docs col__abandoned_checkout__total_tax %}
The sum of all applicable taxes on the checkout in shop currency.
{% enddocs %}

{% docs col__abandoned_checkout__total_weight %}
The combined weight of all items in the checkout, in grams.
{% enddocs %}

{% docs col__abandoned_checkout__total_duties %}
Total duty fees assessed on the checkout, if applicable.
{% enddocs %}

{% docs col__abandoned_checkout__taxes_included %}
True if the listed prices already include taxes (tax-inclusive pricing).
{% enddocs %}

{% docs col__abandoned_checkout__currency %}
The three-letter ISO 4217 currency code for the shop's default currency at the time of checkout. Deprecated by Shopify; use presentment_currency instead.
{% enddocs %}

{% docs col__abandoned_checkout__presentment_currency %}
The three-letter ISO 4217 currency code of the currency the customer checked out in.
{% enddocs %}

{% docs col__abandoned_checkout__applied_discount_title %}
The title or name of the discount applied to the checkout, flattened by Fivetran.
{% enddocs %}

{% docs col__abandoned_checkout__applied_discount_description %}
A description of the discount applied to the checkout, flattened by Fivetran.
{% enddocs %}

{% docs col__abandoned_checkout__applied_discount_value %}
The value of the discount (e.g. 10 for 10% or $10), flattened by Fivetran.
{% enddocs %}

{% docs col__abandoned_checkout__applied_discount_value_type %}
The type of discount value. Valid values: percentage, fixed_amount. Flattened by Fivetran.
{% enddocs %}

{% docs col__abandoned_checkout__applied_discount_amount %}
The actual monetary amount discounted from the checkout in shop currency, flattened by Fivetran.
{% enddocs %}

{% docs col__abandoned_checkout__applied_discount_applicable %}
Whether the discount code was successfully applicable to the checkout, flattened by Fivetran.
{% enddocs %}

{% docs col__abandoned_checkout__applied_discount_non_applicable_reason %}
The reason the discount was not applicable, if applied_discount_applicable is false. Flattened by Fivetran.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_rate_id %}
The identifier for the selected shipping rate, flattened by Fivetran from shipping_lines.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_rate_title %}
The display name of the selected shipping method (e.g. "Standard Shipping"), flattened by Fivetran.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_rate_price %}
The price of the selected shipping rate in shop currency, flattened by Fivetran.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_line %}
Raw shipping line information for the checkout as a text field, sourced from Fivetran.
{% enddocs %}

{% docs col__abandoned_checkout__customer_id %}
The unique Shopify identifier for the customer associated with the abandoned checkout.
{% enddocs %}

{% docs col__abandoned_checkout__email %}
The customer's email address. Hashed at the database level for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__phone %}
The customer's phone number provided during checkout. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__buyer_accepts_marketing %}
Whether the customer consented to receive marketing email updates from the store.
{% enddocs %}

{% docs col__abandoned_checkout__customer_locale %}
The two or three-letter language code for the customer's locale, optionally followed by a region modifier (e.g. en, en-CA, fr-FR).
{% enddocs %}

{% docs col__abandoned_checkout__user_id %}
The ID of the staff member who created the checkout. Populated for POS checkouts; null for online.
{% enddocs %}

{% docs col__abandoned_checkout__device_id %}
The identifier of the Shopify POS device that created the checkout. Deprecated by Shopify.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_address_id %}
The internal identifier for the shipping address record.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_address_name %}
The full name of the recipient at the shipping address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_address_first_name %}
The first name of the recipient at the shipping address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_address_last_name %}
The last name of the recipient at the shipping address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_address_company %}
The company name at the shipping address, if provided.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_address_phone %}
The phone number at the shipping address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_address_address_1 %}
The primary street address line of the shipping destination. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_address_address_2 %}
An optional secondary street address line for the shipping destination. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_address_city %}
The city, town, or village of the shipping destination.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_address_country %}
The full name of the destination country for the shipment.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_address_country_code %}
The two-letter ISO 3166-1 alpha-2 country code for the shipping destination (e.g. US, GB, DE).
{% enddocs %}

{% docs col__abandoned_checkout__shipping_address_province %}
The name of the state, province, or territory of the shipping destination.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_address_province_code %}
The two-letter abbreviation for the state, province, or territory of the shipping destination.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_address_zip %}
The zip or postal code of the shipping destination.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_address_latitude %}
The geographic latitude coordinate of the shipping address, as a string.
{% enddocs %}

{% docs col__abandoned_checkout__shipping_address_longitude %}
The geographic longitude coordinate of the shipping address, as a string.
{% enddocs %}

{% docs col__abandoned_checkout__billing_address_id %}
The internal identifier for the billing address record.
{% enddocs %}

{% docs col__abandoned_checkout__billing_address_name %}
The full name of the person at the billing address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__billing_address_first_name %}
The first name of the person at the billing address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__billing_address_last_name %}
The last name of the person at the billing address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__billing_address_company %}
The company name at the billing address, if provided.
{% enddocs %}

{% docs col__abandoned_checkout__billing_address_phone %}
The phone number at the billing address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__billing_address_address_1 %}
The primary street address line of the billing address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__billing_address_address_2 %}
An optional secondary street address line for the billing address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__billing_address_city %}
The city, town, or village of the billing address.
{% enddocs %}

{% docs col__abandoned_checkout__billing_address_country %}
The full name of the country for the billing address.
{% enddocs %}

{% docs col__abandoned_checkout__billing_address_country_code %}
The two-letter ISO 3166-1 alpha-2 country code for the billing address (e.g. US, GB, DE).
{% enddocs %}

{% docs col__abandoned_checkout__billing_address_province %}
The name of the state, province, or territory of the billing address.
{% enddocs %}

{% docs col__abandoned_checkout__billing_address_province_code %}
The two-letter abbreviation for the state, province, or territory of the billing address.
{% enddocs %}

{% docs col__abandoned_checkout__billing_address_zip %}
The zip or postal code of the billing address.
{% enddocs %}

{% docs col__abandoned_checkout__billing_address_latitude %}
The geographic latitude coordinate of the billing address, as a string.
{% enddocs %}

{% docs col__abandoned_checkout__billing_address_longitude %}
The geographic longitude coordinate of the billing address, as a string.
{% enddocs %}

{% docs col__abandoned_checkout__credit_card_number %}
The masked credit card number (last 4 digits) used at checkout. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__credit_card_first_name %}
The first name on the credit card used at checkout. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__credit_card_last_name %}
The last name on the credit card used at checkout. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__credit_card_month %}
The expiration month of the credit card used at checkout. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__credit_card_year %}
The expiration year of the credit card used at checkout. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__credit_card_verification_value %}
The CVV/security code of the credit card. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__abandoned_checkout__landing_site_base_url %}
The base URL (without query parameters) of the webpage where the customer first entered the shop before initiating the checkout.
{% enddocs %}

{% docs col__abandoned_checkout__referring_site %}
The full URL of the website that referred the customer to the shop.
{% enddocs %}

{% docs col__abandoned_checkout__location_id %}
The store location identifier associated with the checkout (relevant for POS checkouts).
{% enddocs %}

{% docs col__abandoned_checkout__note %}
Optional merchant or customer notes recorded for the checkout.
{% enddocs %}

{% docs col__abandoned_checkout__note_attributes %}
Extra information added to the checkout as an array of key-value pairs (JSON). Displayed in the merchant's Shopify admin.
{% enddocs %}

{% docs col__abandoned_checkout___fivetran_deleted %}
Fivetran soft-delete flag. True if the record has been deleted in the Shopify source but is retained in the warehouse for historical reference.
{% enddocs %}

{% docs col__order__order_id %}
Unique numeric identifier for the Shopify order. Sourced from the id column of the raw ORDER table and renamed to avoid collision with Snowflake reserved words.
{% enddocs %}

{% docs col__order__name %}
The order name as displayed to customers, typically formatted as #1001. Generated by combining order_number with the store-configured order prefix and suffix.
{% enddocs %}

{% docs col__order__number %}
The order's sequential position in the store's count of orders, starting at 1.
{% enddocs %}

{% docs col__order__order_number %}
A unique numeric identifier for the order used throughout the Shopify admin and storefront. Starts at 1001 by default. Shown to customers on receipts and order status pages.
{% enddocs %}

{% docs col__order__token %}
A unique token for referencing the order in the Storefront API and other Shopify contexts.
{% enddocs %}

{% docs col__order__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran ORDER table.
{% enddocs %}

{% docs col__order__source_name %}
The channel where the order originated. Common values: web, pos, shopify_draft_order, iphone, android.
{% enddocs %}

{% docs col__order__app_id %}
The ID of the Shopify app that created the order, if applicable.
{% enddocs %}

{% docs col__order__payment_gateway_names %}
A JSON array of the payment gateways used to process the order (e.g. ["shopify_payments", "gift_card"]). Replaces the deprecated gateway field.
{% enddocs %}

{% docs col__order__processing_method %}
How the payment was processed. Valid values: checkout, direct, manual, offsite, express, free.
{% enddocs %}

{% docs col__order__company_id %}
The ID of the company associated with the order. Populated for B2B (business-to-business) orders only.
{% enddocs %}

{% docs col__order__company_location_id %}
The ID of the company location associated with the order. Populated for B2B orders only.
{% enddocs %}

{% docs col__order__created_at %}
The date and time (ISO 8601) when the order was created in Shopify.
{% enddocs %}

{% docs col__order__updated_at %}
The date and time (ISO 8601) when the order was last modified.
{% enddocs %}

{% docs col__order__processed_at %}
The date and time (ISO 8601) when the order was processed, i.e. when payment was captured or the order was authorized.
{% enddocs %}

{% docs col__order__closed_at %}
The date and time (ISO 8601) when the order was closed (all line items fulfilled or explicitly closed). Null if the order is not yet closed.
{% enddocs %}

{% docs col__order__cancelled_at %}
The date and time (ISO 8601) when the order was canceled. Null if the order has not been canceled.
{% enddocs %}

{% docs col__order__financial_status %}
The payment status of the order. Valid values: pending, authorized, partially_paid, paid, partially_refunded, refunded, voided.
{% enddocs %}

{% docs col__order__fulfillment_status %}
The fulfillment status of the order. Valid values: fulfilled (all items shipped), partial (some items shipped), null (no items shipped), restocked (order canceled and items restocked).
{% enddocs %}

{% docs col__order__cancel_reason %}
The reason the order was canceled. Valid values: customer, fraud, inventory, declined, other. Null if the order has not been canceled.
{% enddocs %}

{% docs col__order__confirmed %}
Whether the customer confirmed the order via email after checkout.
{% enddocs %}

{% docs col__order__test %}
True if this is a test order placed using a payment gateway configured in test mode. Test orders are excluded from revenue reporting.
{% enddocs %}

{% docs col__order__subtotal_price %}
The price of the order in shop currency after discounts but before shipping costs and taxes.
{% enddocs %}

{% docs col__order__subtotal_price_set %}
The subtotal of the order in both shop and presentment currencies (JSON object with shop_money and presentment_money sub-objects).
{% enddocs %}

{% docs col__order__total_price %}
The grand total charged to the customer in shop currency, including line items, discounts, shipping, and taxes.
{% enddocs %}

{% docs col__order__total_price_set %}
The grand total of the order in both shop and presentment currencies (JSON object with shop_money and presentment_money sub-objects).
{% enddocs %}

{% docs col__order__total_price_usd %}
The total price of the order in USD, regardless of the shop currency.
{% enddocs %}

{% docs col__order__total_outstanding %}
The total amount remaining unpaid on the order in shop currency. Zero for fully paid orders; positive for partially paid or payment-pending orders.
{% enddocs %}

{% docs col__order__total_discounts %}
The total amount of all discounts applied to the order in shop currency.
{% enddocs %}

{% docs col__order__total_discounts_set %}
The total discounts applied to the order in both shop and presentment currencies (JSON object with shop_money and presentment_money sub-objects).
{% enddocs %}

{% docs col__order__total_line_items_price %}
The sum of all line item prices in shop currency, before discounts and shipping.
{% enddocs %}

{% docs col__order__total_line_items_price_set %}
The total of all line item prices in both shop and presentment currencies (JSON object with shop_money and presentment_money sub-objects).
{% enddocs %}

{% docs col__order__total_tax %}
The sum of all taxes applied to the order in shop currency.
{% enddocs %}

{% docs col__order__total_tax_set %}
The sum of all taxes applied to the order in both shop and presentment currencies (JSON object with shop_money and presentment_money sub-objects).
{% enddocs %}

{% docs col__order__total_shipping_price_set %}
The total shipping charges for the order in both shop and presentment currencies, including any refunded shipping amounts (JSON object with shop_money and presentment_money).
{% enddocs %}

{% docs col__order__original_total_duties_set %}
The original total duties charged on the order in both shop and presentment currencies (JSON object with shop_money and presentment_money sub-objects). Does not reflect edits.
{% enddocs %}

{% docs col__order__current_total_price %}
The current total price of the order in shop currency including taxes and discounts. Reflects any post-purchase edits made to the order.
{% enddocs %}

{% docs col__order__current_total_price_set %}
The current total price of the order in both shop and presentment currencies (JSON object). Reflects any post-purchase edits.
{% enddocs %}

{% docs col__order__current_subtotal_price %}
The current subtotal of the order in shop currency after discounts, excluding shipping and taxes. Reflects any post-purchase edits made to the order.
{% enddocs %}

{% docs col__order__current_subtotal_price_set %}
The current subtotal of the order in both shop and presentment currencies (JSON object). Reflects any post-purchase edits.
{% enddocs %}

{% docs col__order__current_total_discounts %}
The current total amount of discounts applied to the order in shop currency. Reflects any post-purchase edits made to the order.
{% enddocs %}

{% docs col__order__current_total_discounts_set %}
The current total discounts applied to the order in both shop and presentment currencies (JSON object). Reflects any post-purchase edits.
{% enddocs %}

{% docs col__order__current_total_tax %}
The current sum of all taxes applied to the order in shop currency. Reflects any post-purchase edits made to the order.
{% enddocs %}

{% docs col__order__current_total_tax_set %}
The current total taxes applied to the order in both shop and presentment currencies (JSON object). Reflects any post-purchase edits.
{% enddocs %}

{% docs col__order__current_total_duties_set %}
The current total duties charged on the order in both shop and presentment currencies (JSON object). Reflects any post-purchase edits.
{% enddocs %}

{% docs col__order__total_tip_received %}
The sum of all tip amounts received for the order in shop currency.
{% enddocs %}

{% docs col__order__total_weight %}
The total weight of all line items in the order, in grams.
{% enddocs %}

{% docs col__order__taxes_included %}
True if applicable taxes are already included in the line item prices (tax-inclusive pricing). False if taxes are added on top of prices.
{% enddocs %}

{% docs col__order__currency %}
The three-letter ISO 4217 currency code for the store's shop currency (e.g. USD, GBP, EUR).
{% enddocs %}

{% docs col__order__presentment_currency %}
The three-letter ISO 4217 currency code of the currency the customer checked out in. May differ from currency when a store sells in multiple currencies.
{% enddocs %}

{% docs col__order__customer_id %}
The unique Shopify identifier for the customer who placed the order.
{% enddocs %}

{% docs col__order__email %}
The customer's email address. Hashed at the database level for PII compliance.
{% enddocs %}

{% docs col__order__buyer_accepts_marketing %}
Whether the customer consented to receive marketing email updates from the store at the time the order was placed.
{% enddocs %}

{% docs col__order__customer_locale %}
The ISO 639-1 language code for the customer's preferred language (e.g. en, fr, de, ja).
{% enddocs %}

{% docs col__order__user_id %}
The ID of the staff member (Shopify user) who created the order. Populated for orders created via Shopify POS; null for online orders.
{% enddocs %}

{% docs col__order__billing_address_id %}
The internal Shopify identifier for the billing address record.
{% enddocs %}

{% docs col__order__billing_address_address_1 %}
The primary street address line of the billing address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__billing_address_address_2 %}
An optional secondary street address line for the billing address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__billing_address_city %}
The city, town, or village of the billing address.
{% enddocs %}

{% docs col__order__billing_address_company %}
The company name at the billing address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__billing_address_country %}
The full name of the country for the billing address (e.g. United States, United Kingdom).
{% enddocs %}

{% docs col__order__billing_address_country_code %}
The two-letter ISO 3166-1 alpha-2 country code for the billing address (e.g. US, GB, DE).
{% enddocs %}

{% docs col__order__billing_address_first_name %}
The first name of the person at the billing address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__billing_address_last_name %}
The last name of the person at the billing address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__billing_address_name %}
The full name of the person at the billing address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__billing_address_phone %}
The phone number at the billing address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__billing_address_province %}
The name of the state, province, or territory of the billing address.
{% enddocs %}

{% docs col__order__billing_address_province_code %}
The two-letter abbreviation for the state, province, or territory of the billing address (e.g. CA, NY).
{% enddocs %}

{% docs col__order__billing_address_zip %}
The zip or postal code of the billing address.
{% enddocs %}

{% docs col__order__billing_address_latitude %}
The geographic latitude coordinate of the billing address, as a string.
{% enddocs %}

{% docs col__order__billing_address_longitude %}
The geographic longitude coordinate of the billing address, as a string.
{% enddocs %}

{% docs col__order__shipping_address_id %}
The internal Shopify identifier for the shipping address record.
{% enddocs %}

{% docs col__order__shipping_address_address_1 %}
The primary street address line of the shipping destination. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__shipping_address_address_2 %}
An optional secondary street address line for the shipping destination. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__shipping_address_city %}
The city, town, or village of the shipping destination.
{% enddocs %}

{% docs col__order__shipping_address_company %}
The company name at the shipping destination. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__shipping_address_country %}
The full name of the destination country for the shipment (e.g. United States, Canada).
{% enddocs %}

{% docs col__order__shipping_address_country_code %}
The two-letter ISO 3166-1 alpha-2 country code for the shipping destination (e.g. US, CA, GB).
{% enddocs %}

{% docs col__order__shipping_address_first_name %}
The first name of the recipient at the shipping address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__shipping_address_last_name %}
The last name of the recipient at the shipping address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__shipping_address_name %}
The full name of the recipient at the shipping address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__shipping_address_phone %}
The phone number at the shipping address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__shipping_address_province %}
The name of the state, province, or territory of the shipping destination.
{% enddocs %}

{% docs col__order__shipping_address_province_code %}
The two-letter abbreviation for the state, province, or territory of the shipping destination.
{% enddocs %}

{% docs col__order__shipping_address_zip %}
The zip or postal code of the shipping destination.
{% enddocs %}

{% docs col__order__shipping_address_latitude %}
The geographic latitude coordinate of the shipping address, as a string.
{% enddocs %}

{% docs col__order__shipping_address_longitude %}
The geographic longitude coordinate of the shipping address, as a string.
{% enddocs %}

{% docs col__order__browser_ip %}
The IP address of the browser used by the customer when placing the order. Supports IPv4 and IPv6. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__client_details_user_agent %}
The browser user agent string of the client that placed the order. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__landing_site_base_url %}
The base URL (without query parameters) for the page where the buyer landed when first entering the shop before placing the order.
{% enddocs %}

{% docs col__order__referring_site %}
The full URL of the website that referred the customer to the shop.
{% enddocs %}

{% docs col__order__device_id %}
The ID of the Shopify POS device that created the order. Populated for POS orders only.
{% enddocs %}

{% docs col__order__landing_site_ref %}
The reference code or identifier appended to the landing site URL (e.g. a UTM parameter value or affiliate code). Extracted from the landing_site query string.
{% enddocs %}

{% docs col__order__reference %}
An additional reference identifier for the order, often used by external systems or sales channels to correlate with their own records.
{% enddocs %}

{% docs col__order__source_url %}
The URL of the product or page that was the source of the order, if applicable.
{% enddocs %}

{% docs col__order__cart_token %}
A unique value referencing the cart associated with this order. Deprecated by Shopify; use checkout_token instead.
{% enddocs %}

{% docs col__order__checkout_token %}
A unique value referencing the checkout session associated with this order. Deprecated by Shopify.
{% enddocs %}

{% docs col__order__checkout_id %}
The ID of the checkout that created this order. Deprecated by Shopify.
{% enddocs %}

{% docs col__order__order_status_url %}
The URL for the order status page displayed to customers after completing checkout, allowing them to track their order.
{% enddocs %}

{% docs col__order__note %}
An optional note attached to the order by the merchant or customer. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__note_attributes %}
Extra information added to the order as an array of key-value pairs (JSON). Displayed in the merchant's Shopify admin on the order page. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__order__location_id %}
The ID of the physical Shopify location (e.g. retail store) where the order was processed. Populated for POS orders; null for online orders.
{% enddocs %}

{% docs col__order___fivetran_deleted %}
Fivetran soft-delete flag. True if the record has been deleted in the Shopify source but is retained in the warehouse for historical reference.
{% enddocs %}

{% docs col__order___fivetran_synced %}
The timestamp of the most recent Fivetran sync that loaded or updated this record.
{% enddocs %}

{% docs col__fulfillment_order__order_id %}
The ID of the Shopify order this fulfillment order belongs to.
{% enddocs %}

{% docs col__fulfillment_order__id %}
The unique numeric identifier for this fulfillment order.
{% enddocs %}

{% docs col__fulfillment_order__updated_at %}
The date and time when the fulfillment order was last updated.
{% enddocs %}

{% docs col__fulfillment_order__created_at %}
The date and time when the fulfillment order was created.
{% enddocs %}

{% docs col__fulfillment_order__fulfill_at %}
The date and time at which the fulfillment order will be fulfilled (scheduled fulfillment date).
{% enddocs %}

{% docs col__fulfillment_order__fulfill_by %}
The latest date and time by which the fulfillment order must be fulfilled.
{% enddocs %}

{% docs col__fulfillment_order__status %}
The current status of the fulfillment order. Possible values: open, in_progress, cancelled, incomplete, closed, pending_fulfillment, scheduled.
{% enddocs %}

{% docs col__fulfillment_order__request_status %}
The request status of the fulfillment order sent to the fulfillment service. Possible values: unsubmitted, submitted, accepted, rejected, cancellation_requested, cancellation_accepted, cancellation_rejected, closed.
{% enddocs %}

{% docs col__fulfillment_order__destination_id %}
The unique identifier for the destination address of this fulfillment order.
{% enddocs %}

{% docs col__fulfillment_order__destination_address_1 %}
The first line of the destination street address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__fulfillment_order__destination_address_2 %}
An optional second line of the destination street address. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__fulfillment_order__destination_city %}
The city of the destination address.
{% enddocs %}

{% docs col__fulfillment_order__destination_company %}
The company name at the destination address, if applicable.
{% enddocs %}

{% docs col__fulfillment_order__destination_country_code %}
The two-letter ISO 3166-1 alpha-2 country code for the destination address (e.g. US, GB).
{% enddocs %}

{% docs col__fulfillment_order__destination_email %}
The email address of the recipient at the destination. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__fulfillment_order__destination_first_name %}
The first name of the recipient at the destination. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__fulfillment_order__destination_last_name %}
The last name of the recipient at the destination. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__fulfillment_order__destination_phone %}
The phone number of the recipient at the destination. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__fulfillment_order__destination_province %}
The province, state, or territory of the destination address.
{% enddocs %}

{% docs col__fulfillment_order__destination_zip %}
The ZIP or postal code of the destination address.
{% enddocs %}

{% docs col__fulfillment_order__supported_actions %}
JSON array of actions that can be performed on this fulfillment order (e.g. request_fulfillment, cancel_fulfillment_order, move, request_cancellation).
{% enddocs %}

{% docs col__fulfillment_order__international_duties_incoterm %}
The international duties incoterm specifying who pays customs and import duties. Common values: DAP (Delivered At Place), DDP (Delivered Duty Paid).
{% enddocs %}

{% docs col__fulfillment_order__delivery_method_id %}
The unique identifier for the delivery method assigned to this fulfillment order.
{% enddocs %}

{% docs col__fulfillment_order__delivery_method_min_delivery_date_time %}
The earliest expected delivery date and time for this fulfillment order.
{% enddocs %}

{% docs col__fulfillment_order__delivery_method_max_delivery_date_time %}
The latest expected delivery date and time for this fulfillment order.
{% enddocs %}

{% docs col__fulfillment_order__delivery_method_method_type %}
The type of delivery method. Possible values: none, retail, shipping, local, pick_up, external.
{% enddocs %}

{% docs col__fulfillment_order__delivery_method_service_code %}
The carrier service code for the selected shipping method (e.g. usps_first_class_package).
{% enddocs %}

{% docs col__fulfillment_order__delivery_method_presented_name %}
The display name of the delivery method as presented to customers at checkout.
{% enddocs %}

{% docs col__fulfillment_order__assigned_location_address_1 %}
The first line of the address for the location assigned to fulfill this order.
{% enddocs %}

{% docs col__fulfillment_order__assigned_location_address_2 %}
An optional second line of the address for the assigned fulfillment location.
{% enddocs %}

{% docs col__fulfillment_order__assigned_location_city %}
The city of the assigned fulfillment location.
{% enddocs %}

{% docs col__fulfillment_order__assigned_location_country_code %}
The two-letter ISO 3166-1 alpha-2 country code for the assigned fulfillment location.
{% enddocs %}

{% docs col__fulfillment_order__assigned_location_name %}
The name of the fulfillment location assigned to fulfill this order (e.g. warehouse name).
{% enddocs %}

{% docs col__fulfillment_order__assigned_location_phone %}
The phone number of the assigned fulfillment location.
{% enddocs %}

{% docs col__fulfillment_order__assigned_location_province %}
The province or state of the assigned fulfillment location.
{% enddocs %}

{% docs col__fulfillment_order__assigned_location_zip %}
The ZIP or postal code of the assigned fulfillment location.
{% enddocs %}

{% docs col__fulfillment_order__assigned_location_id %}
An internal identifier for the assigned location record within the fulfillment order.
{% enddocs %}

{% docs col__fulfillment_order__assigned_location_location_id %}
The Shopify Location ID for the assigned fulfillment location. Joins to the Shopify locations resource.
{% enddocs %}

{% docs col__fulfillment_order___fivetran_deleted %}
Fivetran soft-delete flag. True if the record was deleted in the Shopify source.
{% enddocs %}

{% docs col__fulfillment_order__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran FULFILLMENT_ORDER table.
{% enddocs %}

{% docs col__fulfillment_order_line__fulfillment_id %}
The ID of the fulfillment this line item belongs to. Joins to fulfillment.id.
{% enddocs %}

{% docs col__fulfillment_order_line__order_line_id %}
The ID of the original order line item. Joins to order_line.id.
{% enddocs %}

{% docs col__fulfillment_order_line__product_id %}
The ID of the product associated with this line item.
{% enddocs %}

{% docs col__fulfillment_order_line__variant_id %}
The ID of the product variant associated with this line item.
{% enddocs %}

{% docs col__fulfillment_order_line__name %}
The name of the product variant (typically "{product title} - {variant title}").
{% enddocs %}

{% docs col__fulfillment_order_line__title %}
The title of the product at the time of fulfillment.
{% enddocs %}

{% docs col__fulfillment_order_line__vendor %}
The name of the vendor or supplier for this product.
{% enddocs %}

{% docs col__fulfillment_order_line__price %}
The price of the line item at the time of fulfillment, in the shop's default currency.
{% enddocs %}

{% docs col__fulfillment_order_line__price_set %}
The price of the line item in both the shop's currency and the presentment currency. JSON object with shop_money and presentment_money sub-objects, each containing amount and currency_code.
{% enddocs %}

{% docs col__fulfillment_order_line__quantity %}
The number of units of this line item included in the fulfillment.
{% enddocs %}

{% docs col__fulfillment_order_line__grams %}
The weight of the item in grams.
{% enddocs %}

{% docs col__fulfillment_order_line__sku %}
The stock-keeping unit (SKU) for the product variant.
{% enddocs %}

{% docs col__fulfillment_order_line__fulfillable_quantity %}
The number of units of this line item that can still be fulfilled.
{% enddocs %}

{% docs col__fulfillment_order_line__fulfillment_service %}
The fulfillment service that stocks this item. Common values: manual, amazon_marketplace_web, or a custom fulfillment service handle.
{% enddocs %}

{% docs col__fulfillment_order_line__gift_card %}
Whether the line item is a gift card. True if the item is a gift card.
{% enddocs %}

{% docs col__fulfillment_order_line__requires_shipping %}
Whether the line item requires physical shipping.
{% enddocs %}

{% docs col__fulfillment_order_line__taxable %}
Whether the line item is taxable.
{% enddocs %}

{% docs col__fulfillment_order_line__variant_title %}
The title of the product variant (e.g. "Large / Blue").
{% enddocs %}

{% docs col__fulfillment_order_line__properties %}
JSON array of custom attributes (key-value pairs) associated with this line item, as entered by the customer.
{% enddocs %}

{% docs col__fulfillment_order_line__order_id %}
The ID of the order this fulfillment line item belongs to. Joins to order.order_id.
{% enddocs %}

{% docs col__fulfillment_order_line__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran FULFILLMENT_ORDER_LINE table.
{% enddocs %}

{% docs col__fulfillment_order_line_item__fulfillment_order_id %}
The ID of the parent fulfillment order. Joins to fulfillment_order.id.
{% enddocs %}

{% docs col__fulfillment_order_line_item__id %}
The unique numeric identifier for this fulfillment order line item assignment.
{% enddocs %}

{% docs col__fulfillment_order_line_item__inventory_item_id %}
The ID of the inventory item for this line. Joins to inventory_item.id.
{% enddocs %}

{% docs col__fulfillment_order_line_item__remaining_quantity %}
The number of units of this inventory item that have not yet been fulfilled for this fulfillment order.
{% enddocs %}

{% docs col__fulfillment_order_line_item__total_quantity %}
The total number of units of this inventory item assigned to this fulfillment order.
{% enddocs %}

{% docs col__fulfillment_order_line_item__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran FULFILLMENT_ORDER_LINE_ITEM table.
{% enddocs %}

{% docs col__inventory_item__id %}
The unique numeric identifier for this inventory item. Each product variant has exactly one inventory item.
{% enddocs %}

{% docs col__inventory_item__country_code_of_origin %}
The two-letter ISO 3166-1 alpha-2 country code where this inventory item was manufactured or produced.
{% enddocs %}

{% docs col__inventory_item__created_at %}
The date and time when the inventory item was created.
{% enddocs %}

{% docs col__inventory_item__duplicate_sku_count %}
The number of duplicate SKUs for this inventory item across the store. A value greater than 0 indicates duplicate SKUs exist.
{% enddocs %}

{% docs col__inventory_item__harmonized_system_code %}
The harmonized system (HS) tariff code for the item, used for international shipping and customs classification.
{% enddocs %}

{% docs col__inventory_item__inventory_history_url %}
The URL for viewing the inventory history of this item in the Shopify admin.
{% enddocs %}

{% docs col__inventory_item__legacy_resource_id %}
The legacy resource ID for this inventory item, used for backwards compatibility with older Shopify API integrations.
{% enddocs %}

{% docs col__inventory_item__measurement_id %}
The ID of the measurement record associated with this inventory item.
{% enddocs %}

{% docs col__inventory_item__measurement_weight_value %}
The numeric weight value of the inventory item, in the unit specified by measurement_weight_unit.
{% enddocs %}

{% docs col__inventory_item__measurement_weight_unit %}
The unit of weight measurement for this inventory item (e.g. kg, lb, oz, g).
{% enddocs %}

{% docs col__inventory_item__province_code_of_origin %}
The province or state code of the location where this inventory item was manufactured, if applicable.
{% enddocs %}

{% docs col__inventory_item__requires_shipping %}
Whether this inventory item requires physical shipping. False for digital products and gift cards.
{% enddocs %}

{% docs col__inventory_item__sku %}
The stock-keeping unit (SKU) for this inventory item, used to track inventory in the store.
{% enddocs %}

{% docs col__inventory_item__tracked %}
Whether Shopify tracks inventory quantity for this item. When false, inventory is not decremented on purchase.
{% enddocs %}

{% docs col__inventory_item__tracked_editable_locked %}
Whether the tracked setting is locked and cannot be changed. True when tracking is managed externally (e.g. by a fulfillment service).
{% enddocs %}

{% docs col__inventory_item__tracked_editable_reason %}
The reason why the tracked setting cannot be edited, if tracked_editable_locked is true.
{% enddocs %}

{% docs col__inventory_item__unit_cost_amount %}
The cost per unit of this inventory item, in the currency specified by unit_cost_currency_code.
{% enddocs %}

{% docs col__inventory_item__unit_cost_currency_code %}
The three-letter ISO 4217 currency code for the unit cost (e.g. USD, GBP, EUR).
{% enddocs %}

{% docs col__inventory_item__updated_at %}
The date and time when the inventory item was last updated.
{% enddocs %}

{% docs col__inventory_item___fivetran_deleted %}
Fivetran soft-delete flag. True if the record was deleted in the Shopify source.
{% enddocs %}

{% docs col__inventory_item__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran INVENTORY_ITEM table.
{% enddocs %}

{% docs col__inventory_level__inventory_item_id %}
The ID of the inventory item this level belongs to. Joins to inventory_item.id.
{% enddocs %}

{% docs col__inventory_level__id %}
An internal identifier for the inventory level record.
{% enddocs %}

{% docs col__inventory_level__location_id %}
The ID of the location where this inventory is stocked. Joins to the Shopify locations resource.
{% enddocs %}

{% docs col__inventory_level__can_deactivate %}
Whether this inventory level can be deactivated (i.e. the item can be removed from the location).
{% enddocs %}

{% docs col__inventory_level__created_at %}
The date and time when this inventory level record was created.
{% enddocs %}

{% docs col__inventory_level__deactivation_alert %}
A message explaining why the inventory level cannot be deactivated, if can_deactivate is false.
{% enddocs %}

{% docs col__inventory_level__updated_at %}
The date and time when this inventory level was last updated (e.g. when quantities changed).
{% enddocs %}

{% docs col__inventory_level__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran INVENTORY_LEVEL table.
{% enddocs %}

{% docs col__inventory_quantity__id %}
An internal identifier for this inventory quantity record.
{% enddocs %}

{% docs col__inventory_quantity__inventory_item_id %}
The ID of the inventory item this quantity belongs to. Joins to inventory_item.id.
{% enddocs %}

{% docs col__inventory_quantity__inventory_level_id %}
The ID of the inventory level (item + location) this quantity belongs to. Joins to inventory_level.id.
{% enddocs %}

{% docs col__inventory_quantity__name %}
The name of the inventory quantity type. Common values: available (sellable stock), committed (reserved for open orders), on_hand (total physical stock), incoming (stock in transit), reserved (held for other reasons).
{% enddocs %}

{% docs col__inventory_quantity__quantity %}
The number of units for this inventory quantity type at the associated location.
{% enddocs %}

{% docs col__inventory_quantity__updated_at %}
The date and time when this inventory quantity was last updated.
{% enddocs %}

{% docs col__inventory_quantity__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran INVENTORY_QUANTITY table.
{% enddocs %}

{% docs col__order_discount_code__order_id %}
The ID of the order this discount code was applied to. Joins to order.order_id.
{% enddocs %}

{% docs col__order_discount_code__index %}
The position of this discount code in the list of discount codes applied to the order (1-based).
{% enddocs %}

{% docs col__order_discount_code__code %}
The discount code string entered by the customer at checkout (e.g. SUMMER20, FANCLUB10).
{% enddocs %}

{% docs col__order_discount_code__type %}
The type of discount. Possible values: percentage (a percentage off), fixed_amount (a fixed dollar/currency amount off), shipping (free or discounted shipping).
{% enddocs %}

{% docs col__order_discount_code__amount %}
The value of the discount applied. For percentage type, this is the percentage value; for fixed_amount, it is the currency amount.
{% enddocs %}

{% docs col__order_discount_code__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran ORDER_DISCOUNT_CODE table.
{% enddocs %}

{% docs col__order_line__order_id %}
The ID of the order this line item belongs to. Joins to order.order_id.
{% enddocs %}

{% docs col__order_line__id %}
The unique numeric identifier for this order line item.
{% enddocs %}

{% docs col__order_line__product_id %}
The ID of the product associated with this line item.
{% enddocs %}

{% docs col__order_line__variant_id %}
The ID of the product variant ordered. Joins to product_variant.id.
{% enddocs %}

{% docs col__order_line__name %}
The name of the product variant (typically "{product title} - {variant title}").
{% enddocs %}

{% docs col__order_line__title %}
The title of the product at the time of purchase.
{% enddocs %}

{% docs col__order_line__vendor %}
The name of the vendor or supplier for this product.
{% enddocs %}

{% docs col__order_line__price %}
The unit price of the item in the shop's default currency, before discounts.
{% enddocs %}

{% docs col__order_line__price_set %}
The unit price in both the shop's currency and the presentment currency. JSON object with shop_money and presentment_money sub-objects, each containing amount and currency_code.
{% enddocs %}

{% docs col__order_line__quantity %}
The number of units of this item ordered.
{% enddocs %}

{% docs col__order_line__grams %}
The weight of a single unit of this item in grams.
{% enddocs %}

{% docs col__order_line__sku %}
The stock-keeping unit (SKU) for the product variant.
{% enddocs %}

{% docs col__order_line__fulfillable_quantity %}
The number of units of this item that have not yet been fulfilled (quantity minus already-fulfilled units).
{% enddocs %}

{% docs col__order_line__fulfillment_service %}
The fulfillment service responsible for this item. Common values: manual, amazon_marketplace_web, or a custom fulfillment service handle.
{% enddocs %}

{% docs col__order_line__gift_card %}
Whether this line item is a gift card. Gift card line items are not physically shipped.
{% enddocs %}

{% docs col__order_line__requires_shipping %}
Whether this line item requires physical shipping.
{% enddocs %}

{% docs col__order_line__taxable %}
Whether this line item is subject to taxes.
{% enddocs %}

{% docs col__order_line__variant_title %}
The title of the product variant (e.g. "Large / Blue").
{% enddocs %}

{% docs col__order_line__properties %}
JSON array of custom attributes (key-value pairs) associated with this line item, as entered by the customer (e.g. engraving text, gift message).
{% enddocs %}

{% docs col__order_line__index %}
The position of this line item in the order's list of line items (1-based).
{% enddocs %}

{% docs col__order_line__total_discount %}
The total discount applied to this line item in the shop's default currency.
{% enddocs %}

{% docs col__order_line__total_discount_set %}
The total discount applied to this line item in both shop and presentment currencies. JSON object with shop_money and presentment_money sub-objects.
{% enddocs %}

{% docs col__order_line__product_exists %}
Whether the product associated with this line item still exists in the store's catalog.
{% enddocs %}

{% docs col__order_line__pre_tax_price %}
The pre-tax price of the line item in the shop's default currency.
{% enddocs %}

{% docs col__order_line__pre_tax_price_set %}
The pre-tax price in both shop and presentment currencies. JSON object with shop_money and presentment_money sub-objects.
{% enddocs %}

{% docs col__order_line__fulfillment_status %}
The fulfillment status of this line item. Possible values: fulfilled, null (unfulfilled), partial (partially fulfilled), restocked.
{% enddocs %}

{% docs col__order_line__variant_inventory_management %}
The inventory management system for this variant. Common values: shopify (managed by Shopify), null (no tracking), or a fulfillment service handle.
{% enddocs %}

{% docs col__order_line__tax_code %}
The tax code applied to this line item (used with external tax services such as Avalara).
{% enddocs %}

{% docs col__order_line__origin_location_id %}
The ID of the location from which this line item ships.
{% enddocs %}

{% docs col__order_line__origin_location_name %}
The name of the fulfillment location from which this line item ships.
{% enddocs %}

{% docs col__order_line__origin_location_address_1 %}
The first line of the street address for the origin fulfillment location.
{% enddocs %}

{% docs col__order_line__origin_location_address_2 %}
The second line of the street address for the origin fulfillment location.
{% enddocs %}

{% docs col__order_line__origin_location_city %}
The city of the origin fulfillment location.
{% enddocs %}

{% docs col__order_line__origin_location_zip %}
The ZIP or postal code of the origin fulfillment location.
{% enddocs %}

{% docs col__order_line__origin_location_country_code %}
The two-letter ISO 3166-1 alpha-2 country code for the origin fulfillment location.
{% enddocs %}

{% docs col__order_line__origin_location_province_code %}
The province or state code of the origin fulfillment location.
{% enddocs %}

{% docs col__order_line__destination_location_id %}
The ID of the destination location for this line item.
{% enddocs %}

{% docs col__order_line__destination_location_name %}
The name of the destination location for this line item.
{% enddocs %}

{% docs col__order_line__destination_location_address_1 %}
The first line of the street address for the destination location.
{% enddocs %}

{% docs col__order_line__destination_location_address_2 %}
The second line of the street address for the destination location.
{% enddocs %}

{% docs col__order_line__destination_location_city %}
The city of the destination location.
{% enddocs %}

{% docs col__order_line__destination_location_zip %}
The ZIP or postal code of the destination location.
{% enddocs %}

{% docs col__order_line__destination_location_country_code %}
The two-letter ISO 3166-1 alpha-2 country code for the destination location.
{% enddocs %}

{% docs col__order_line__destination_location_province_code %}
The province or state code of the destination location.
{% enddocs %}

{% docs col__order_line__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran ORDER_LINE table.
{% enddocs %}

{% docs col__order_line_refund__id %}
The unique numeric identifier for this order line item refund record.
{% enddocs %}

{% docs col__order_line_refund__location_id %}
The ID of the location where the refund was processed. Joins to the Shopify locations resource.
{% enddocs %}

{% docs col__order_line_refund__refund_id %}
The ID of the parent refund this line item refund belongs to. Joins to refund.id.
{% enddocs %}

{% docs col__order_line_refund__restock_type %}
How the refunded item was restocked. Possible values: no_restock (not restocked), cancel (order was cancelled before fulfillment), return (item was physically returned), legacy_restock (restocked via an older Shopify API flow).
{% enddocs %}

{% docs col__order_line_refund__quantity %}
The number of units of this line item that were refunded.
{% enddocs %}

{% docs col__order_line_refund__subtotal %}
The subtotal of the refunded line item in the shop's default currency, before taxes.
{% enddocs %}

{% docs col__order_line_refund__subtotal_set %}
The subtotal of the refunded line item in both shop and presentment currencies. JSON object with shop_money and presentment_money sub-objects, each containing amount and currency_code.
{% enddocs %}

{% docs col__order_line_refund__total_tax %}
The total taxes refunded for this line item in the shop's default currency.
{% enddocs %}

{% docs col__order_line_refund__total_tax_set %}
The total taxes refunded for this line item in both shop and presentment currencies. JSON object with shop_money and presentment_money sub-objects.
{% enddocs %}

{% docs col__order_line_refund__order_line_id %}
The ID of the original order line item being refunded. Joins to order_line.id.
{% enddocs %}

{% docs col__order_line_refund__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran ORDER_LINE_REFUND table.
{% enddocs %}

{% docs col__order_url_tag__order_id %}
The ID of the order this URL tag belongs to. Joins to order.order_id.
{% enddocs %}

{% docs col__order_url_tag__key %}
The URL parameter name (e.g. utm_source, utm_medium, utm_campaign, ref).
{% enddocs %}

{% docs col__order_url_tag__value %}
The URL parameter value corresponding to the key (e.g. instagram, email, summer_sale).
{% enddocs %}

{% docs col__order_url_tag__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran ORDER_URL_TAG table.
{% enddocs %}

{% docs col__product__product_id %}
The unique numeric identifier for this product. Renamed from id to avoid Snowflake reserved word collision.
{% enddocs %}

{% docs col__product__title %}
The title of the product as displayed in the Shopify storefront and admin.
{% enddocs %}

{% docs col__product__handle %}
A unique, URL-safe string identifying the product. Used in the product's storefront URL (e.g. /products/vinyl-record-deluxe-edition).
{% enddocs %}

{% docs col__product__vendor %}
The name of the vendor or manufacturer of the product.
{% enddocs %}

{% docs col__product__product_type %}
A merchant-defined category for the product (e.g. Vinyl, T-Shirt, Poster).
{% enddocs %}

{% docs col__product__status %}
The product's publish status. Possible values: active (published and available for sale), draft (not published), archived (removed from the storefront).
{% enddocs %}

{% docs col__product__published_at %}
The date and time when the product was published to the online store. Null if not yet published.
{% enddocs %}

{% docs col__product__created_at %}
The date and time when the product was created.
{% enddocs %}

{% docs col__product__updated_at %}
The date and time when the product was last modified.
{% enddocs %}

{% docs col__product__template_suffix %}
The suffix of the Liquid template used to render the product page (e.g. preorder, bundle). Null uses the default product template.
{% enddocs %}

{% docs col__product__published_scope %}
Where the product is published. Possible values: web (online store only), global (online store and all sales channels).
{% enddocs %}

{% docs col__product__body_html %}
The product description in raw HTML as stored in the Shopify REST API (legacy field).
{% enddocs %}

{% docs col__product__description %}
The product description as plain text, sourced from the Shopify GraphQL API.
{% enddocs %}

{% docs col__product__description_html %}
The product description in HTML, sourced from the Shopify GraphQL API.
{% enddocs %}

{% docs col__product__seo_title %}
The SEO page title for this product, shown in search engine results.
{% enddocs %}

{% docs col__product__seo_description %}
The SEO meta description for this product, shown in search engine result snippets.
{% enddocs %}

{% docs col__product__requires_selling_plan %}
Whether this product can only be purchased as part of a selling plan (subscription). True for subscription-only products.
{% enddocs %}

{% docs col__product__tracks_inventory %}
Whether inventory is tracked for any variant of this product.
{% enddocs %}

{% docs col__product__total_inventory %}
The total number of units in stock across all variants and locations.
{% enddocs %}

{% docs col__product__has_out_of_stock_variants %}
Whether any variant of this product is currently out of stock.
{% enddocs %}

{% docs col__product__has_only_default_variant %}
Whether this product has no variants — only the default single variant. True for products without options (e.g. size, color).
{% enddocs %}

{% docs col__product__has_variants_that_requires_components %}
Whether any variant of this product requires components (used with bundles).
{% enddocs %}

{% docs col__product__is_gift_card %}
Whether this product is a gift card.
{% enddocs %}

{% docs col__product__gift_card_template_suffix %}
The Liquid template suffix used to render the gift card page, if is_gift_card is true.
{% enddocs %}

{% docs col__product__online_store_preview_url %}
The URL for previewing this product in the online store before publishing.
{% enddocs %}

{% docs col__product__legacy_resource_id %}
The legacy REST API resource ID for this product, used for backwards compatibility.
{% enddocs %}

{% docs col__product__featured_media_id %}
The ID of the featured media (image or video) displayed as the product's primary image.
{% enddocs %}

{% docs col__product__min_variant_price_amount %}
The lowest price among all variants of this product.
{% enddocs %}

{% docs col__product__min_variant_price_currency_code %}
The ISO 4217 currency code for the minimum variant price (e.g. USD, GBP).
{% enddocs %}

{% docs col__product__max_variant_price_amount %}
The highest price among all variants of this product.
{% enddocs %}

{% docs col__product__max_variant_price_currency_code %}
The ISO 4217 currency code for the maximum variant price.
{% enddocs %}

{% docs col__product__compare_at_price_range_min_variant_compare_at_price_amount %}
The lowest compare-at (original/crossed-out) price among all variants of this product.
{% enddocs %}

{% docs col__product__compare_at_price_range_min_variant_compare_at_price_currency_code %}
The ISO 4217 currency code for the minimum compare-at price.
{% enddocs %}

{% docs col__product__compare_at_price_range_max_variant_compare_at_price_amount %}
The highest compare-at (original/crossed-out) price among all variants of this product.
{% enddocs %}

{% docs col__product__compare_at_price_range_max_variant_compare_at_price_currency_code %}
The ISO 4217 currency code for the maximum compare-at price.
{% enddocs %}

{% docs col__product__category_id %}
The Shopify product category ID (from the standard product taxonomy).
{% enddocs %}

{% docs col__product__category_name %}
The name of the Shopify product category (e.g. Clothing, Music, Collectibles).
{% enddocs %}

{% docs col__product__category_level %}
The depth level of the category in the taxonomy hierarchy (0 = root).
{% enddocs %}

{% docs col__product__category_full_name %}
The full category path including all ancestor names (e.g. Apparel & Accessories > Clothing > Tops).
{% enddocs %}

{% docs col__product__category_parent_id %}
The ID of the parent category in the taxonomy hierarchy.
{% enddocs %}

{% docs col__product__category_is_leaf %}
Whether this category is a leaf node (has no child categories).
{% enddocs %}

{% docs col__product__category_is_root %}
Whether this category is a root node (has no parent category).
{% enddocs %}

{% docs col__product__category_is_archived %}
Whether this category has been archived in the Shopify product taxonomy.
{% enddocs %}

{% docs col__product__category_ancestor_ids %}
JSON array of category IDs for all ancestors of this category, from root to parent.
{% enddocs %}

{% docs col__product__category_children_ids %}
JSON array of category IDs for all direct children of this category.
{% enddocs %}

{% docs col__product__metafield %}
JSON object containing metafield data attached to this product. Metafields store additional custom information beyond standard product fields.
{% enddocs %}

{% docs col__product___fivetran_deleted %}
Fivetran soft-delete flag. True if the record was deleted in the Shopify source.
{% enddocs %}

{% docs col__product__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran PRODUCT table.
{% enddocs %}

{% docs col__product_tag__product_id %}
The ID of the product this tag belongs to. Joins to product.product_id.
{% enddocs %}

{% docs col__product_tag__index %}
The position of this tag in the product's ordered list of tags (1-based).
{% enddocs %}

{% docs col__product_tag__value %}
The tag string applied to the product (e.g. vinyl, pre-order, bundle, limited-edition).
{% enddocs %}

{% docs col__product_tag__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran PRODUCT_TAG table.
{% enddocs %}

{% docs col__product_variant__product_variant_id %}
The unique numeric identifier for this product variant. Renamed from id to avoid Snowflake reserved word collision.
{% enddocs %}

{% docs col__product_variant__product_id %}
The ID of the parent product this variant belongs to. Joins to product.product_id.
{% enddocs %}

{% docs col__product_variant__inventory_item_id %}
The ID of the inventory item for this variant. Joins to inventory_item.id.
{% enddocs %}

{% docs col__product_variant__available_for_sale %}
Whether this variant is currently available for purchase (in stock and published).
{% enddocs %}

{% docs col__product_variant__image_id %}
The ID of the image associated with this variant.
{% enddocs %}

{% docs col__product_variant__barcode %}
The barcode (UPC, EAN, ISBN) for this product variant.
{% enddocs %}

{% docs col__product_variant__title %}
The title of the variant (e.g. "Large / Blue", "180g Vinyl"). For products with only a default variant, this is "Default Title".
{% enddocs %}

{% docs col__product_variant__price %}
The selling price of this variant in the shop's default currency.
{% enddocs %}

{% docs col__product_variant__compare_at_price %}
The original price shown as a crossed-out "compare at" price. Used to indicate a discount.
{% enddocs %}

{% docs col__product_variant__created_at %}
The date and time when this variant was created.
{% enddocs %}

{% docs col__product_variant__sku %}
The stock-keeping unit (SKU) for this variant, used for inventory tracking.
{% enddocs %}

{% docs col__product_variant__display_name %}
The display name of the variant, combining the product title and variant title (e.g. "Vinyl Record - Large / Blue").
{% enddocs %}

{% docs col__product_variant__position %}
The order of the variant in the product's list of variants (1-based).
{% enddocs %}

{% docs col__product_variant__inventory_policy %}
How out-of-stock purchases are handled. Possible values: deny (prevent purchase when out of stock), continue (allow purchase when out of stock).
{% enddocs %}

{% docs col__product_variant__inventory_quantity %}
An aggregate of the total inventory available across all locations for this variant.
{% enddocs %}

{% docs col__product_variant__fulfillment_service %}
The fulfillment service responsible for this variant (e.g. manual, amazon_marketplace_web).
{% enddocs %}

{% docs col__product_variant__legacy_resource_id %}
The legacy REST API resource ID for this variant, used for backwards compatibility.
{% enddocs %}

{% docs col__product_variant__metafield %}
JSON object containing metafield data attached to this variant.
{% enddocs %}

{% docs col__product_variant__inventory_management %}
The inventory management system tracking this variant. Possible values: shopify (Shopify tracks inventory), null (no tracking), or a fulfillment service handle.
{% enddocs %}

{% docs col__product_variant__updated_at %}
The date and time when this variant was last modified.
{% enddocs %}

{% docs col__product_variant__taxable %}
Whether this variant is subject to taxes.
{% enddocs %}

{% docs col__product_variant__requires_components %}
Whether this variant requires components (used with product bundles).
{% enddocs %}

{% docs col__product_variant__sellable_online_quantity %}
The number of units of this variant available for sale online, accounting for inventory policy.
{% enddocs %}

{% docs col__product_variant__grams %}
The weight of this variant in grams.
{% enddocs %}

{% docs col__product_variant__tax_code %}
The tax code for this variant, used with external tax services such as Avalara.
{% enddocs %}

{% docs col__product_variant__weight %}
The weight of this variant in the unit specified by weight_unit.
{% enddocs %}

{% docs col__product_variant__weight_unit %}
The unit of measurement for the variant's weight (e.g. kg, lb, oz, g).
{% enddocs %}

{% docs col__product_variant__option_1 %}
The value of the first product option for this variant (e.g. "Large" for a Size option).
{% enddocs %}

{% docs col__product_variant__option_2 %}
The value of the second product option for this variant (e.g. "Blue" for a Color option). Null if the product has fewer than two options.
{% enddocs %}

{% docs col__product_variant__option_3 %}
The value of the third product option for this variant. Null if the product has fewer than three options.
{% enddocs %}

{% docs col__product_variant__presentment_prices %}
JSON array of prices for this variant in all currencies enabled for the shop's markets. Each entry contains a price and compare_at_price in a specific currency.
{% enddocs %}

{% docs col__product_variant__inventory_quantity_adjustment %}
The change in inventory quantity made during the most recent Fivetran sync for this variant.
{% enddocs %}

{% docs col__product_variant__old_inventory_quantity %}
The inventory quantity before the most recent adjustment. Deprecated by Shopify in favor of inventory levels.
{% enddocs %}

{% docs col__product_variant__requires_shipping %}
Whether this variant requires physical shipping.
{% enddocs %}

{% docs col__product_variant__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran PRODUCT_VARIANT table.
{% enddocs %}

{% docs col__refund__id %}
The unique numeric identifier for this refund.
{% enddocs %}

{% docs col__refund__created_at %}
The date and time when the refund was created.
{% enddocs %}

{% docs col__refund__processed_at %}
The date and time when the refund was processed (money was returned to the customer).
{% enddocs %}

{% docs col__refund__note %}
An optional internal note about the reason for the refund, visible to the merchant.
{% enddocs %}

{% docs col__refund__restock %}
Whether the refunded line items were restocked to inventory.
{% enddocs %}

{% docs col__refund__user_id %}
The ID of the Shopify staff member who created the refund.
{% enddocs %}

{% docs col__refund__order_id %}
The ID of the order this refund applies to. Joins to order.order_id.
{% enddocs %}

{% docs col__refund__total_duties_set %}
The total duties refunded in both shop and presentment currencies. JSON object with shop_money and presentment_money sub-objects.
{% enddocs %}

{% docs col__refund__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran REFUND table.
{% enddocs %}

{% docs col__shop__id %}
The unique numeric Shopify identifier for the shop.
{% enddocs %}

{% docs col__shop__name %}
The name of the shop as displayed in the Shopify admin.
{% enddocs %}

{% docs col__shop__email %}
The primary contact email address for the shop (merchant contact, not customer-facing).
{% enddocs %}

{% docs col__shop__domain %}
The custom storefront domain for the shop (e.g. shop.artistname.com).
{% enddocs %}

{% docs col__shop__province %}
The name of the province, state, or territory where the shop is located.
{% enddocs %}

{% docs col__shop__country %}
The full name of the country where the shop is located.
{% enddocs %}

{% docs col__shop__address_1 %}
The first line of the shop's address.
{% enddocs %}

{% docs col__shop__address_2 %}
The second line of the shop's address.
{% enddocs %}

{% docs col__shop__zip %}
The ZIP or postal code of the shop's address.
{% enddocs %}

{% docs col__shop__city %}
The city of the shop's address.
{% enddocs %}

{% docs col__shop__phone %}
The phone number for the shop.
{% enddocs %}

{% docs col__shop__primary_locale %}
The IETF language tag for the shop's primary language (e.g. en, fr, de).
{% enddocs %}

{% docs col__shop__country_code %}
The two-letter ISO 3166-1 alpha-2 country code for the shop's location.
{% enddocs %}

{% docs col__shop__country_name %}
The full name of the country where the shop is located (same as country field).
{% enddocs %}

{% docs col__shop__currency %}
The three-letter ISO 4217 currency code for the shop's default currency (e.g. USD, GBP, EUR).
{% enddocs %}

{% docs col__shop__customer_email %}
The email address used for customer-facing communications from the store.
{% enddocs %}

{% docs col__shop__timezone %}
The shop's timezone in a human-readable format (e.g. (GMT-05:00) Eastern Time).
{% enddocs %}

{% docs col__shop__iana_timezone %}
The IANA timezone identifier for the shop (e.g. America/New_York, Europe/London).
{% enddocs %}

{% docs col__shop__shop_owner %}
The name of the person who owns the shop.
{% enddocs %}

{% docs col__shop__money_format %}
The format used to display prices in the shop's currency (e.g. ${{amount}}).
{% enddocs %}

{% docs col__shop__money_with_currency_format %}
The format used to display prices with currency code (e.g. ${{amount}} USD).
{% enddocs %}

{% docs col__shop__weight_unit %}
The default unit of weight measurement for the shop (e.g. kg, lb, oz, g).
{% enddocs %}

{% docs col__shop__province_code %}
The two-letter abbreviation for the province or state where the shop is located.
{% enddocs %}

{% docs col__shop__plan_name %}
The internal name of the Shopify subscription plan the merchant is on (e.g. shopify, advanced, enterprise).
{% enddocs %}

{% docs col__shop__plan_display_name %}
The human-readable display name of the Shopify plan (e.g. Basic, Shopify, Advanced Shopify).
{% enddocs %}

{% docs col__shop__myshopify_domain %}
The shop's myshopify.com subdomain (e.g. artistname.myshopify.com). Permanent and unique per shop.
{% enddocs %}

{% docs col__shop__money_in_emails_format %}
The format used to display prices in emails sent from the shop.
{% enddocs %}

{% docs col__shop__money_with_currency_in_emails_format %}
The format used to display prices with currency in emails sent from the shop.
{% enddocs %}

{% docs col__shop__cookie_consent_level %}
The shop's cookie consent level setting. Possible values: implicit (no banner required), explicit (explicit consent required for tracking cookies).
{% enddocs %}

{% docs col__shop__visitor_tracking_consent_preference %}
The merchant's preference for visitor tracking consent (e.g. opt-in, opt-out).
{% enddocs %}

{% docs col__shop__source %}
The source through which the shop was created.
{% enddocs %}

{% docs col__shop__google_apps_domain %}
The Google Apps domain linked to the shop, if Google Apps login is enabled.
{% enddocs %}

{% docs col__shop__enabled_presentment_currencies %}
JSON array of three-letter ISO 4217 currency codes that the shop supports for presentment to customers.
{% enddocs %}

{% docs col__shop__primary_location_id %}
The ID of the shop's primary fulfillment location.
{% enddocs %}

{% docs col__shop__latitude %}
The latitude coordinate of the shop's address.
{% enddocs %}

{% docs col__shop__longitude %}
The longitude coordinate of the shop's address.
{% enddocs %}

{% docs col__shop__created_at %}
The date and time when the shop was created.
{% enddocs %}

{% docs col__shop__updated_at %}
The date and time when the shop was last updated.
{% enddocs %}

{% docs col__shop__taxes_included %}
Whether taxes are included in product prices (tax-inclusive pricing). Common in EU stores.
{% enddocs %}

{% docs col__shop__county_taxes %}
Whether county-level taxes are applied for US orders.
{% enddocs %}

{% docs col__shop__tax_shipping %}
Whether taxes are applied to shipping charges.
{% enddocs %}

{% docs col__shop__has_discounts %}
Whether the shop has any active discount codes.
{% enddocs %}

{% docs col__shop__has_gift_cards %}
Whether the shop sells gift cards.
{% enddocs %}

{% docs col__shop__eligible_for_payments %}
Whether the shop is eligible to use Shopify Payments as a payment provider.
{% enddocs %}

{% docs col__shop__requires_extra_payments_agreement %}
Whether the shop must agree to additional terms to use certain payment methods.
{% enddocs %}

{% docs col__shop__password_enabled %}
Whether the online store is password-protected (not publicly accessible).
{% enddocs %}

{% docs col__shop__has_storefront %}
Whether the shop has an active online storefront.
{% enddocs %}

{% docs col__shop__eligible_for_card_reader_giveaway %}
Whether the shop is eligible for a Shopify card reader promotion.
{% enddocs %}

{% docs col__shop__force_ssl %}
Whether the shop forces HTTPS for all storefront connections.
{% enddocs %}

{% docs col__shop__checkout_api_supported %}
Whether the shop supports the Shopify Checkout API.
{% enddocs %}

{% docs col__shop__multi_location_enabled %}
Whether the shop has multiple fulfillment locations enabled.
{% enddocs %}

{% docs col__shop__setup_required %}
Whether the shop requires additional setup steps before it can accept orders.
{% enddocs %}

{% docs col__shop__pre_launch_enabled %}
Whether the shop is in pre-launch mode (storefront visible only to invited visitors).
{% enddocs %}

{% docs col__shop__google_apps_login_enabled %}
Whether Google Apps single sign-on is enabled for the shop's Shopify admin.
{% enddocs %}

{% docs col__shop__auto_configure_tax_inclusivity %}
Whether Shopify automatically configures tax-inclusive pricing based on the customer's market.
{% enddocs %}

{% docs col__shop___fivetran_deleted %}
Fivetran soft-delete flag. True if the record was deleted in the Shopify source.
{% enddocs %}

{% docs col__shop__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran SHOP table.
{% enddocs %}

{% docs col__transaction__id %}
The unique numeric identifier for this transaction.
{% enddocs %}

{% docs col__transaction__order_id %}
The ID of the order this transaction belongs to. Joins to order.order_id.
{% enddocs %}

{% docs col__transaction__refund_id %}
The ID of the refund this transaction is associated with, if it is a refund transaction. Joins to refund.id.
{% enddocs %}

{% docs col__transaction__amount %}
The amount of money transacted, in the currency specified by the currency field.
{% enddocs %}

{% docs col__transaction__authorization %}
The authorization code from the payment gateway. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__transaction__created_at %}
The date and time when the transaction was created.
{% enddocs %}

{% docs col__transaction__processed_at %}
The date and time when the transaction was processed by the payment gateway.
{% enddocs %}

{% docs col__transaction__device_id %}
The ID of the POS device that processed the transaction, for in-person retail transactions.
{% enddocs %}

{% docs col__transaction__gateway %}
The payment gateway used to process the transaction (e.g. shopify_payments, paypal, bogus).
{% enddocs %}

{% docs col__transaction__source_name %}
The origin of the transaction. Common values: web, pos, iphone, android.
{% enddocs %}

{% docs col__transaction__message %}
The human-readable message returned by the payment gateway describing the transaction result.
{% enddocs %}

{% docs col__transaction__currency %}
The three-letter ISO 4217 currency code for this transaction (e.g. USD, GBP, EUR).
{% enddocs %}

{% docs col__transaction__location_id %}
The ID of the Shopify location where the transaction was processed, for POS transactions.
{% enddocs %}

{% docs col__transaction__parent_id %}
The ID of the parent transaction, if this is a follow-on transaction (e.g. a capture following an authorization).
{% enddocs %}

{% docs col__transaction__payment_avs_result_code %}
The AVS (Address Verification System) result code returned by the payment gateway. Indicates whether the billing address matches the card issuer's records.
{% enddocs %}

{% docs col__transaction__payment_credit_card_bin %}
The first six digits of the credit card number (Bank Identification Number), identifying the card issuer.
{% enddocs %}

{% docs col__transaction__payment_cvv_result_code %}
The CVV (Card Verification Value) result code returned by the payment gateway.
{% enddocs %}

{% docs col__transaction__payment_credit_card_number %}
The masked credit card number. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__transaction__payment_credit_card_company %}
The name of the credit card company (e.g. Visa, Mastercard, American Express).
{% enddocs %}

{% docs col__transaction__kind %}
The type of transaction. Possible values: authorization (reserved funds), capture (collected funds), sale (authorization + capture in one step), void (cancellation of an authorization), refund (money returned to customer).
{% enddocs %}

{% docs col__transaction__receipt %}
JSON object containing the transaction receipt data returned by the payment gateway. Contents vary by gateway.
{% enddocs %}

{% docs col__transaction__currency_exchange_id %}
The ID of the currency exchange record, for multi-currency transactions.
{% enddocs %}

{% docs col__transaction__currency_exchange_adjustment %}
The adjustment amount applied due to currency exchange rate differences.
{% enddocs %}

{% docs col__transaction__currency_exchange_original_amount %}
The original transaction amount in the presentment currency, before conversion.
{% enddocs %}

{% docs col__transaction__currency_exchange_final_amount %}
The final transaction amount in the shop's default currency, after conversion.
{% enddocs %}

{% docs col__transaction__currency_exchange_currency %}
The presentment currency used by the customer for this transaction.
{% enddocs %}

{% docs col__transaction__error_code %}
The error code returned by the payment gateway if the transaction failed. Common values: incorrect_number, invalid_expiry_date, card_declined, insufficient_funds.
{% enddocs %}

{% docs col__transaction__status %}
The current status of the transaction. Possible values: pending, failure, success, error.
{% enddocs %}

{% docs col__transaction__test %}
Whether this is a test transaction created using a Shopify Bogus Gateway.
{% enddocs %}

{% docs col__transaction__authorization_expires_at %}
The date and time when the authorization for this transaction expires.
{% enddocs %}

{% docs col__transaction__extended_authorization_standard_authorization_expires_at %}
The expiry date for the standard authorization window under extended authorization.
{% enddocs %}

{% docs col__transaction__extended_authorization_extended_authorization_expires_at %}
The expiry date for the extended authorization window (typically 30 days, compared to the standard few days).
{% enddocs %}

{% docs col__transaction__user_id %}
The ID of the Shopify staff member or app that created this transaction.
{% enddocs %}

{% docs col__transaction__payment_credit_card_wallet %}
The digital wallet used for this transaction (e.g. apple_pay, google_pay, shopify_pay).
{% enddocs %}

{% docs col__transaction__payment_id %}
An identifier for the payment associated with this transaction.
{% enddocs %}

{% docs col__transaction__payment_credit_card_expiration_month %}
The expiration month of the credit card used (1–12).
{% enddocs %}

{% docs col__transaction__payment_credit_card_expiration_year %}
The four-digit expiration year of the credit card used.
{% enddocs %}

{% docs col__transaction__payment_credit_card_name %}
The cardholder name on the credit card. Masked to NULL for PII compliance.
{% enddocs %}

{% docs col__transaction__source_identifier %}
Fully qualified source location for the row, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT). Overrides the source_identifier column present in the raw Fivetran TRANSACTION table.
{% enddocs %}

{% docs col__shopify_stores_master__store_id %}
The canonical Shopify store identifier — the numeric shop ID from SHOPIFY_SHOP.ID, sourced by unioning SHOP tables across all store schemas. Used as the primary store key in all mart models.
{% enddocs %}

{% docs col__shopify_stores_master__store_schema %}
The Snowflake schema name for the store's raw Fivetran data (e.g. SHOPIFY_DOJACAT). Used as the join key between all mart models and this spine table.
{% enddocs %}

{% docs col__shopify_stores_master__store_name %}
The human-readable display name of the Shopify store (e.g. "Doja Cat Official Store"). Sourced from the CRM ECOMMERCE_STORES table or the Fansifter SHOPIFY_SHOP table.
{% enddocs %}

{% docs col__shopify_stores_master__vendor_name %}
The Sony Music vendor or label name associated with this store (e.g. "RCA Records", "Columbia Records"). Resolved via ORCHARD_FACTS.PROD.VENDOR using the store's VENDOR_ID.
{% enddocs %}

{% docs col__shopify_stores_master__vendor_id %}
The Sony Music vendor identifier for the label or distributor that owns this store. For CRM-managed stores, bridged via SME_ACCOUNT_DBT using CRM territory and label IDs. For Fansifter stores, sourced directly from SHOPIFY_STORE_ASSOCIATION.VENDOR_ID.
{% enddocs %}

{% docs col__shopify_stores_master__artist %}
The artist or brand name associated with this store. For single-artist stores this is the artist's name (e.g. "Doja Cat"). For multi-artist stores (label stores, compilation stores) this is "Multiple Artists" — see MULTI_ARTIST_STORE_ARTISTS for the full list.
{% enddocs %}

{% docs col__shopify_stores_master__global_participant_id %}
The Sony Music Global Participant ID (GP_ID) for the artist associated with this store. Null for multi-artist stores (use MULTI_ARTIST_STORE_ARTISTS instead). For CRM stores, resolved by matching the ARTIST name against FS_ARTIST_ROSTER_DBT.
{% enddocs %}

{% docs col__shopify_stores_master__multi_artist_store_artists %}
JSON array of artist objects for multi-artist stores. Each element contains ARTIST_NAME (string) and GLOBAL_PARTICIPANT_ID (string). Null for single-artist stores. Example: [{"ARTIST_NAME": "Artist A", "GLOBAL_PARTICIPANT_ID": "GP123"}, ...]
{% enddocs %}

{% docs col__shopify_stores_master__multi_artist_store %}
True if this store sells merchandise for multiple artists (e.g. a label store or compilation store). False for dedicated single-artist stores.
{% enddocs %}

{% docs col__shopify_stores_master__brand %}
The Sony Music brand or business unit associated with this store's vendor (e.g. "SME", "The Orchard", "AWAL"). Sourced from Orchard COMPANY_BRAND data.
{% enddocs %}

{% docs col__shopify_stores_master__crm_territory %}
The CRM territory name associated with this store (e.g. "US", "UK", "Germany"). Populated for CRM-managed stores from the CRM territory field; null for Fansifter-only and D2C stores. D2C stores' geographic market is in SELLING_COUNTRY (see selling_country) instead.
{% enddocs %}

{% docs col__shopify_stores_master__crm_territory_id %}
The CRM territory identifier used to bridge to Fansifter vendor data via SME_ACCOUNT_DBT. Populated for CRM-managed stores only; null for Fansifter-only stores.
{% enddocs %}

{% docs col__shopify_stores_master__crm_label %}
The CRM label name associated with this store (e.g. "RCA Records", "Columbia Records"). Populated for CRM-managed stores from the CRM label field; null for Fansifter-only and D2C stores. D2C stores' vendor/label is in VENDOR_NAME (see vendor_name) instead.
{% enddocs %}

{% docs col__shopify_stores_master__crm_label_id %}
The CRM label identifier used to bridge to Fansifter vendor data via SME_ACCOUNT_DBT. Populated for CRM-managed stores only; null for Fansifter-only stores.
{% enddocs %}

{% docs col__shopify_stores_master__shopify_domain %}
The myshopify.com URL for the store (e.g. https://dojacat.myshopify.com). For Fansifter stores sourced from SHOPIFY_SHOP.MYSHOPIFY_DOMAIN; for CRM stores derived from STORE_URL_PREFIX.
{% enddocs %}

{% docs col__shopify_stores_master__custom_domain %}
The custom storefront domain for the store, if one exists (e.g. https://shop.dojacat.com). For Fansifter stores sourced from SHOPIFY_SHOP.DOMAIN; for CRM stores sourced from the shopify_store_custom_domain seed table.
{% enddocs %}

{% docs col__shopify_stores_master__source %}
The data management source for this store record. Possible values: "CRM Ecommerce" (managed via CRM_ECOMMERCE_DATA), "Fansifter" (managed via the Fansifter platform).
{% enddocs %}

{% docs col__shopify_stores_master__source_identifier %}
The fully qualified Snowflake source location for this store's raw data, formatted as DATABASE.SCHEMA (e.g. CRM_ECOMMERCE_DATA.SHOPIFY_DOJACAT or PROD_SHOPIFY_INTEGRATIONS.SHOPIFY_DOJACAT). This is the value propagated to all mart models as their SOURCE_IDENTIFIER column.
{% enddocs %}

{% docs col__shopify_stores_master__active %}
Whether the store is currently active. Sourced from the CRM ECOMMERCE_STORES.ACTIVE flag for CRM-managed stores. Defaults to true for Fansifter-managed stores.
{% enddocs %}

{% docs col__shopify_stores_master__first_paid_order_date %}
The timestamp of the first paid order ever placed through this store. Computed by the int_paid_order_dates intermediate model from the ORDERS table across all store schemas. Null if the store has no paid orders.
{% enddocs %}

{% docs col__shopify_stores_master__last_paid_order_date %}
The timestamp of the most recent paid order placed through this store. Computed by the int_paid_order_dates intermediate model. Useful for identifying inactive stores.
{% enddocs %}

{% docs col__shopify_stores_master__last_refresh %}
The most recent Fivetran sync timestamp for this store. Computed by the int_last_refresh intermediate model as the maximum _FIVETRAN_SYNCED value across all of the store's synced Shopify tables. Indicates how recently Fivetran loaded data from this store.
{% enddocs %}

{% docs col__shopify_stores_master__merch_company %}
The company that manufactures and sells the physical merchandise for this store on behalf of the IP rights holder (label) — e.g. Ceremony of Roses, Kings Road, IndieMerch. Not the same as the label. Populated for D2C stores; NULL for CRM/Fansifter stores.
{% enddocs %}

{% docs col__shopify_stores_master__selling_country %}
Geographic market where the store operates (e.g. UK, US, EU). Distinct from CRM_TERRITORY which is a business territory name. Populated for D2C stores; NULL for CRM/Fansifter stores.
{% enddocs %}

{% docs col__shopify_stores_master__rep_owner %}
The owning label / rep owner for this store — the Sony label or division, or distribution partner, that holds the commercial relationship (a short entity name, e.g. Columbia, RCA, Epic, Sony Nashville, The Orchard). Not a person. Sourced from ECOMMERCE_STORE_REGISTRY.REP_OWNER. Populated for D2C stores only; NULL for CRM/Fansifter stores.
{% enddocs %}