When you connect Shopify to Triple Whale, Shopify integration data is populated in the Orders Table, Products Table, Refunds Table, and Customers Table. These base tables also feed related reporting and derived tables across the Triple Whale schema. This guide lists the Triple Whale column IDs that are populated from Shopify integration data in each base table.

Orders Table

Use orders_table for order-level Shopify data. One row represents one order.

Data area	Shopify-backed Triple Whale column IDs
Order and shop metadata	`platform` `shop_id` `shop_name` `shop_timezone` `event_date` `event_hour` `created_at` `cancelled_at` `order_id` `order_name` `source_name` `fulfillment_status`
Customer fields on the order	`customer_id` `customer_id_key` `customer_first_name` `customer_last_name` `customer_email` `customer_from_country_code` `customer_from_country_name` `customer_from_state_code` `customer_from_city` `customer_tags` `is_new_customer` `is_subscription_order` `is_first_order_in_subscription`
Shipping address and checkout shipping amount	`shipping_country_code` `shipping_country_name` `shipping_state_code` `shipping_state` `shipping_city` `shipping_zip` `shipping_price`
Revenue, discounts, taxes, refunds, and order counts	`currency` `order_revenue` `gross_product_sales` `product_quantity_sold_in_order` `discount_code` `discount_type` `discount_amount` `discount_amount_for_product` `discount_amount_for_shipping` `taxes` `refund_money` `orders` `orders_with_amount` `new_customer_orders` `returning_customer_orders` `new_customer_revenue` `returning_customer_revenue` `new_customers_percent` `returning_customers_percent` `aov` `true_aov` `ltv` `unique_customers`
Product line items in the order	`products_info` `products_info.product_id` `products_info.product_name` `products_info.vendor` `products_info.product_type` `products_info.product_tags` `products_info.product_sku` `products_info.variant_id` `products_info.product_name_price` `products_info.discount_amount_for_product` `products_info.net_discount_amount_for_product` `products_info.product_name_quantity_sold` `products_info.is_gift_card` `products_info.single_product_cost` `products_info.properties` `products_info.properties.name` `products_info.properties.value`
Shopify transaction details	`payment_gateway_costs` `transactions` `transactions.created_at` `transactions.processed_at` `transactions.payment_gateway_name` `transactions.currency` `transactions.status` `transactions.amount` `transactions.fees`
Shopify order tags and metafields	`tags` `metafields` `metafields.metafield_id` `metafields.key` `metafields.value` `metafields.namespace` `metafields.type` `metafields.updated_at` `metafields.created_at`
Shopify product cost	`cost_of_goods`

Products Table

Use products_table for Shopify product catalog data. One row represents one product.

Data area	Shopify-backed Triple Whale column IDs
Product identity and status	`shop_id` `shop_name` `integration_id` `platform` `product_id` `product_name` `product_description` `vendor` `product_status` `product_tags` `product_type` `product_inventory_quantity`
Product images	`product_image_url` `images` `images.image_position` `images.image_width` `images.image_height` `images.image_src`
Product variants	`variants` `variants.variant_id` `variants.variant_name` `variants.sku` `variants.variant_price` `variants.variant_compare_at_price` `variants.variant_inventory_quantity`
Collections	`collections`

Refunds Table

Use refunds_table for individual Shopify refund transactions. One row represents one refund transaction.

Data area	Shopify-backed Triple Whale column IDs
Refund and order metadata	`shop_id` `shop_name` `platform` `event_date` `event_hour` `order_date` `order_id` `source_name` `tags`
Refund amounts	`total_refunded_price` `total_refunded_tax` `total_refunded_shipping` `total_refunded_cogs`
Refunded products	`products_info` `products_info.product_id` `products_info.product_name` `products_info.product_sku` `products_info.variant_id` `products_info.product_name_price` `products_info.discount_amount_for_product` `products_info.product_name_quantity_sold` `products_info.is_gift_card` `products_info.single_product_cost`
Refund order adjustments	`refund_order_adjustment` `refund_order_adjustment.kind` `refund_order_adjustment.order_adjustment_tax_amount` `refund_order_adjustment.order_adjustment_amount`

Customers Table

Use customers_table for Shopify customer profile data. One row represents one customer on one platform.

Data area	Shopify-backed Triple Whale column IDs
Customer identity and contact fields	`platform` `customer_id` `customer_id_key` `created_at` `email_address` `phone` `first_name` `last_name` `display_name` `customer_tags` `note`
Customer address and geography	`address1` `address2` `city` `country` `country_code` `state` `state_code` `zip` `latitude` `longitude` `coordinates_validated` `locale`
Customer status and consent	`status` `product_subscriber_status` `valid_email_address` `verified_email_address` `email_marketing_consent_status` `email_marketing_consent_opt_in_level` `email_marketing_consent_updated_at` `tax_exempt`
Customer purchase and value fields	`last_order_id` `amount_spent` `orders` `statistic_predicted_spend_tier`