API Connectors

users-love-us medal soc2
Send your Cart data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabaseGemini EnterpriseCursorManusGrok

Cart Connector Reference

97 metrics249 dimensions
Fields

The Cart connector exposes 346 fields (97 metrics, 249 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Cart Fields

Cart addresses fields

The addresses report of the Cart connector includes 20 fields.

ID Type Name Description
addresses__address_line_1 TEXT addresses.address_line_1 addresses.address_line_1
addresses__address_line_2 TEXT addresses.address_line_2 addresses.address_line_2
addresses__address_type TEXT addresses.address_type addresses.address_type
addresses__alternate_phone TEXT addresses.alternate_phone addresses.alternate_phone
addresses__city TEXT addresses.city addresses.city
addresses__comments TEXT addresses.comments addresses.comments
addresses__company TEXT addresses.company addresses.company
addresses__country TEXT addresses.country addresses.country
addresses__created_at TEXT addresses.created_at addresses.created_at
addresses__customer_id NUMERIC addresses.customer_id addresses.customer_id
addresses__fax TEXT addresses.fax addresses.fax
addresses__first_name TEXT addresses.first_name addresses.first_name
addresses__id NUMERIC addresses.id addresses.id
addresses__is_default_billing_address BOOLEAN addresses.is_default_billing_address addresses.is_default_billing_address
addresses__is_default_shipping_address BOOLEAN addresses.is_default_shipping_address addresses.is_default_shipping_address
addresses__last_name TEXT addresses.last_name addresses.last_name
addresses__phone TEXT addresses.phone addresses.phone
addresses__postal_code TEXT addresses.postal_code addresses.postal_code
addresses__state TEXT addresses.state addresses.state
addresses__updated_at TEXT addresses.updated_at addresses.updated_at

Cart customers_cart fields

The customers_cart report of the Cart connector includes 38 fields.

ID Type Name Description
customers_cart__adcode TEXT customers_cart.adcode customers_cart.adcode
customers_cart__adcode_id NUMERIC customers_cart.adcode_id customers_cart.adcode_id
customers_cart__affiliate_id NUMERIC customers_cart.affiliate_id customers_cart.affiliate_id
customers_cart__alternate_phone_number TEXT customers_cart.alternate_phone_number customers_cart.alternate_phone_number
customers_cart__comments TEXT customers_cart.comments customers_cart.comments
customers_cart__company TEXT customers_cart.company customers_cart.company
customers_cart__created_at TEXT customers_cart.created_at customers_cart.created_at
customers_cart__credit_limit TEXT customers_cart.credit_limit customers_cart.credit_limit
customers_cart__customer_number TEXT customers_cart.customer_number customers_cart.customer_number
customers_cart__customer_payment_methods_availability OBJECT customers_cart.customer_payment_methods_availability customers_cart.customer_payment_methods_availability
customers_cart__customer_type_id NUMERIC customers_cart.customer_type_id customers_cart.customer_type_id
customers_cart__email TEXT customers_cart.email customers_cart.email
customers_cart__first_name TEXT customers_cart.first_name customers_cart.first_name
customers_cart__id NUMERIC customers_cart.id customers_cart.id
customers_cart__is_affiliate_customer BOOLEAN customers_cart.is_affiliate_customer customers_cart.is_affiliate_customer
customers_cart__is_contact_information_only BOOLEAN customers_cart.is_contact_information_only customers_cart.is_contact_information_only
customers_cart__is_inactive BOOLEAN customers_cart.is_inactive customers_cart.is_inactive
customers_cart__is_no_tax_customer BOOLEAN customers_cart.is_no_tax_customer customers_cart.is_no_tax_customer
customers_cart__last_name TEXT customers_cart.last_name customers_cart.last_name
customers_cart__last_visit_at TEXT customers_cart.last_visit_at customers_cart.last_visit_at
customers_cart__lock_default_address BOOLEAN customers_cart.lock_default_address customers_cart.lock_default_address
customers_cart__no_account BOOLEAN customers_cart.no_account customers_cart.no_account
customers_cart__payment_net_term TEXT customers_cart.payment_net_term customers_cart.payment_net_term
customers_cart__phone_number TEXT customers_cart.phone_number customers_cart.phone_number
customers_cart__registered_at TEXT customers_cart.registered_at customers_cart.registered_at
customers_cart__reward_tier_id TEXT customers_cart.reward_tier_id customers_cart.reward_tier_id
customers_cart__sales_person TEXT customers_cart.sales_person customers_cart.sales_person
customers_cart__sales_person_user_id TEXT customers_cart.sales_person_user_id customers_cart.sales_person_user_id
customers_cart__search_string TEXT customers_cart.search_string customers_cart.search_string
customers_cart__source TEXT customers_cart.source customers_cart.source
customers_cart__source_group TEXT customers_cart.source_group customers_cart.source_group
customers_cart__store_id NUMERIC customers_cart.store_id customers_cart.store_id
customers_cart__store_payment_methods_enabled OBJECT customers_cart.store_payment_methods_enabled customers_cart.store_payment_methods_enabled
customers_cart__sub TEXT customers_cart.sub customers_cart.sub
customers_cart__tax_exemption_number TEXT customers_cart.tax_exemption_number customers_cart.tax_exemption_number
customers_cart__tax_rate TEXT customers_cart.tax_rate customers_cart.tax_rate
customers_cart__updated_at TEXT customers_cart.updated_at customers_cart.updated_at
customers_cart__username TEXT customers_cart.username customers_cart.username

Cart order_items fields

The order_items report of the Cart connector includes 48 fields.

Cart order_items fields (order_items__admin_comments to order_items__updated_at)

ID Type Name Description
order_items__admin_comments TEXT order_items.admin_comments order_items.admin_comments
order_items__configuration TEXT order_items.configuration order_items.configuration
order_items__cost NUMERIC order_items.cost order_items.cost
order_items__created_at TEXT order_items.created_at order_items.created_at
order_items__delivery_date TEXT order_items.delivery_date order_items.delivery_date
order_items__description TEXT order_items.description order_items.description
order_items__discount_amount NUMERIC order_items.discount_amount order_items.discount_amount
order_items__discount_percentage NUMERIC order_items.discount_percentage order_items.discount_percentage
order_items__do_not_discount BOOLEAN order_items.do_not_discount order_items.do_not_discount
order_items__fitment TEXT order_items.fitment order_items.fitment
order_items__gift_message TEXT order_items.gift_message order_items.gift_message
order_items__height NUMERIC order_items.height order_items.height
order_items__id NUMERIC order_items.id order_items.id
order_items__is_discount_item BOOLEAN order_items.is_discount_item order_items.is_discount_item
order_items__is_non_shipping_item BOOLEAN order_items.is_non_shipping_item order_items.is_non_shipping_item
order_items__is_quantity_bound_to_parent BOOLEAN order_items.is_quantity_bound_to_parent order_items.is_quantity_bound_to_parent
order_items__is_subscription_product BOOLEAN order_items.is_subscription_product order_items.is_subscription_product
order_items__is_taxable BOOLEAN order_items.is_taxable order_items.is_taxable
order_items__item_name TEXT order_items.item_name order_items.item_name
order_items__item_number TEXT order_items.item_number order_items.item_number
order_items__item_number_full TEXT order_items.item_number_full order_items.item_number_full
order_items__length NUMERIC order_items.length order_items.length
order_items__line_item_note TEXT order_items.line_item_note order_items.line_item_note
order_items__order_id NUMERIC order_items.order_id order_items.order_id
order_items__order_shipping_address_id TEXT order_items.order_shipping_address_id order_items.order_shipping_address_id
order_items__parent_order_item_id NUMERIC order_items.parent_order_item_id order_items.parent_order_item_id
order_items__personalizations OBJECT order_items.personalizations order_items.personalizations
order_items__price NUMERIC order_items.price order_items.price
order_items__product_id NUMERIC order_items.product_id order_items.product_id
order_items__quantity NUMERIC order_items.quantity order_items.quantity
order_items__selected_shipping_method TEXT order_items.selected_shipping_method order_items.selected_shipping_method
order_items__selected_shipping_method_id TEXT order_items.selected_shipping_method_id order_items.selected_shipping_method_id
order_items__selected_shipping_provider_service TEXT order_items.selected_shipping_provider_service order_items.selected_shipping_provider_service
order_items__shipping_classification_code TEXT order_items.shipping_classification_code order_items.shipping_classification_code
order_items__shipping_total TEXT order_items.shipping_total order_items.shipping_total
order_items__size_unit TEXT order_items.size_unit order_items.size_unit
order_items__status TEXT order_items.status order_items.status
order_items__tax NUMERIC order_items.tax order_items.tax
order_items__tax_code TEXT order_items.tax_code order_items.tax_code
order_items__updated_at TEXT order_items.updated_at order_items.updated_at

Cart order_items fields (order_items__variant_inventory_id to order_items__width)

ID Type Name Description
order_items__variant_inventory_id TEXT order_items.variant_inventory_id order_items.variant_inventory_id
order_items__variants OBJECT order_items.variants order_items.variants
order_items__vendor_store_id NUMERIC order_items.vendor_store_id order_items.vendor_store_id
order_items__warehouse_id NUMERIC order_items.warehouse_id order_items.warehouse_id
order_items__weigh_unit TEXT order_items.weigh_unit order_items.weigh_unit
order_items__weight NUMERIC order_items.weight order_items.weight
order_items__weight_unit TEXT order_items.weight_unit order_items.weight_unit
order_items__width NUMERIC order_items.width order_items.width

Cart order_payments fields

The order_payments report of the Cart connector includes 34 fields.

ID Type Name Description
order_payments__amount NUMERIC order_payments.amount order_payments.amount
order_payments__approved_at TEXT order_payments.approved_at order_payments.approved_at
order_payments__authorization_code TEXT order_payments.authorization_code order_payments.authorization_code
order_payments__avs_code TEXT order_payments.avs_code order_payments.avs_code
order_payments__card_expiration_month NUMERIC order_payments.card_expiration_month order_payments.card_expiration_month
order_payments__card_expiration_year NUMERIC order_payments.card_expiration_year order_payments.card_expiration_year
order_payments__card_type TEXT order_payments.card_type order_payments.card_type
order_payments__cardholder_name TEXT order_payments.cardholder_name order_payments.cardholder_name
order_payments__created_at TEXT order_payments.created_at order_payments.created_at
order_payments__customer_id NUMERIC order_payments.customer_id order_payments.customer_id
order_payments__customer_payment_method_id NUMERIC order_payments.customer_payment_method_id order_payments.customer_payment_method_id
order_payments__cvv_response_code TEXT order_payments.cvv_response_code order_payments.cvv_response_code
order_payments__gateway_response_code TEXT order_payments.gateway_response_code order_payments.gateway_response_code
order_payments__gift_certificate_id NUMERIC order_payments.gift_certificate_id order_payments.gift_certificate_id
order_payments__id NUMERIC order_payments.id order_payments.id
order_payments__is_approved BOOLEAN order_payments.is_approved order_payments.is_approved
order_payments__is_captured BOOLEAN order_payments.is_captured order_payments.is_captured
order_payments__is_declined BOOLEAN order_payments.is_declined order_payments.is_declined
order_payments__is_void BOOLEAN order_payments.is_void order_payments.is_void
order_payments__last_four TEXT order_payments.last_four order_payments.last_four
order_payments__order_id NUMERIC order_payments.order_id order_payments.order_id
order_payments__paid_at TEXT order_payments.paid_at order_payments.paid_at
order_payments__payment_method_id NUMERIC order_payments.payment_method_id order_payments.payment_method_id
order_payments__payment_method_name TEXT order_payments.payment_method_name order_payments.payment_method_name
order_payments__payment_note TEXT order_payments.payment_note order_payments.payment_note
order_payments__payment_ref_num TEXT order_payments.payment_ref_num order_payments.payment_ref_num
order_payments__payment_type TEXT order_payments.payment_type order_payments.payment_type
order_payments__reject_reason TEXT order_payments.reject_reason order_payments.reject_reason
order_payments__sent_to_spark_pay BOOLEAN order_payments.sent_to_spark_pay order_payments.sent_to_spark_pay
order_payments__store_payment_method_id NUMERIC order_payments.store_payment_method_id order_payments.store_payment_method_id
order_payments__token TEXT order_payments.token order_payments.token
order_payments__transaction_id TEXT order_payments.transaction_id order_payments.transaction_id
order_payments__transaction_type TEXT order_payments.transaction_type order_payments.transaction_type
order_payments__updated_at TEXT order_payments.updated_at order_payments.updated_at

Cart order_statuses fields

The order_statuses report of the Cart connector includes 14 fields.

ID Type Name Description
order_statuses__color TEXT order_statuses.color order_statuses.color
order_statuses__created_at TEXT order_statuses.created_at order_statuses.created_at
order_statuses__email_template_id NUMERIC order_statuses.email_template_id order_statuses.email_template_id
order_statuses__id NUMERIC order_statuses.id order_statuses.id
order_statuses__is_cancelled BOOLEAN order_statuses.is_cancelled order_statuses.is_cancelled
order_statuses__is_declined BOOLEAN order_statuses.is_declined order_statuses.is_declined
order_statuses__is_fully_refunded BOOLEAN order_statuses.is_fully_refunded order_statuses.is_fully_refunded
order_statuses__is_open BOOLEAN order_statuses.is_open order_statuses.is_open
order_statuses__is_partially_refunded BOOLEAN order_statuses.is_partially_refunded order_statuses.is_partially_refunded
order_statuses__is_partially_shipped BOOLEAN order_statuses.is_partially_shipped order_statuses.is_partially_shipped
order_statuses__is_quote_status BOOLEAN order_statuses.is_quote_status order_statuses.is_quote_status
order_statuses__is_shipped BOOLEAN order_statuses.is_shipped order_statuses.is_shipped
order_statuses__name TEXT order_statuses.name order_statuses.name
order_statuses__updated_at TEXT order_statuses.updated_at order_statuses.updated_at

Cart orders fields

The orders report of the Cart connector includes 62 fields.

Cart orders fields (orders__adcode to orders__order_status_id)

ID Type Name Description
orders__adcode TEXT orders.adcode orders.adcode
orders__adcode_id NUMERIC orders.adcode_id orders.adcode_id
orders__additional_fees NUMERIC orders.additional_fees orders.additional_fees
orders__admin_comments TEXT orders.admin_comments orders.admin_comments
orders__affiliate_id NUMERIC orders.affiliate_id orders.affiliate_id
orders__campaign_code TEXT orders.campaign_code orders.campaign_code
orders__channel TEXT orders.channel orders.channel
orders__cost_total NUMERIC orders.cost_total orders.cost_total
orders__coupon_code TEXT orders.coupon_code orders.coupon_code
orders__created_at TEXT orders.created_at orders.created_at
orders__customer_id NUMERIC orders.customer_id orders.customer_id
orders__customer_type_id NUMERIC orders.customer_type_id orders.customer_type_id
orders__delivery_tax TEXT orders.delivery_tax orders.delivery_tax
orders__device TEXT orders.device orders.device
orders__discount_total NUMERIC orders.discount_total orders.discount_total
orders__discounted_shipping_total NUMERIC orders.discounted_shipping_total orders.discounted_shipping_total
orders__due_date TEXT orders.due_date orders.due_date
orders__entered_by TEXT orders.entered_by orders.entered_by
orders__entered_by_type TEXT orders.entered_by_type orders.entered_by_type
orders__expires BOOLEAN orders.expires orders.expires
orders__expires_at TEXT orders.expires_at orders.expires_at
orders__exported_to_accounting_system NUMERIC orders.exported_to_accounting_system orders.exported_to_accounting_system
orders__from_quote_id NUMERIC orders.from_quote_id orders.from_quote_id
orders__from_subscription_id NUMERIC orders.from_subscription_id orders.from_subscription_id
orders__gift_message TEXT orders.gift_message orders.gift_message
orders__grand_total NUMERIC orders.grand_total orders.grand_total
orders__handling_total NUMERIC orders.handling_total orders.handling_total
orders__id NUMERIC orders.id orders.id
orders__instructions TEXT orders.instructions orders.instructions
orders__ip_address TEXT orders.ip_address orders.ip_address
orders__is_gift BOOLEAN orders.is_gift orders.is_gift
orders__is_payment_order_only BOOLEAN orders.is_payment_order_only orders.is_payment_order_only
orders__is_ppc BOOLEAN orders.is_ppc orders.is_ppc
orders__manufacturer_invoice_amount NUMERIC orders.manufacturer_invoice_amount orders.manufacturer_invoice_amount
orders__manufacturer_invoice_number TEXT orders.manufacturer_invoice_number orders.manufacturer_invoice_number
orders__manufacturer_invoice_paid BOOLEAN orders.manufacturer_invoice_paid orders.manufacturer_invoice_paid
orders__order_billing_address_id NUMERIC orders.order_billing_address_id orders.order_billing_address_id
orders__order_number TEXT orders.order_number orders.order_number
orders__order_shipping_address_id NUMERIC orders.order_shipping_address_id orders.order_shipping_address_id
orders__order_status_id NUMERIC orders.order_status_id orders.order_status_id

Cart orders fields (orders__order_status_last_changed_at to orders__updated_at)

ID Type Name Description
orders__order_status_last_changed_at TEXT orders.order_status_last_changed_at orders.order_status_last_changed_at
orders__order_type TEXT orders.order_type orders.order_type
orders__ordered_at TEXT orders.ordered_at orders.ordered_at
orders__ppc_keyword TEXT orders.ppc_keyword orders.ppc_keyword
orders__previous_order_status_id NUMERIC orders.previous_order_status_id orders.previous_order_status_id
orders__public_comments TEXT orders.public_comments orders.public_comments
orders__referrer TEXT orders.referrer orders.referrer
orders__reward_points_credited BOOLEAN orders.reward_points_credited orders.reward_points_credited
orders__sales_agent_user_id TEXT orders.sales_agent_user_id orders.sales_agent_user_id
orders__search_phrase TEXT orders.search_phrase orders.search_phrase
orders__selected_shipping_method TEXT orders.selected_shipping_method orders.selected_shipping_method
orders__selected_shipping_provider_service TEXT orders.selected_shipping_provider_service orders.selected_shipping_provider_service
orders__session_id NUMERIC orders.session_id orders.session_id
orders__shipping_selections OBJECT orders.shipping_selections orders.shipping_selections
orders__shipping_total NUMERIC orders.shipping_total orders.shipping_total
orders__source TEXT orders.source orders.source
orders__source_group TEXT orders.source_group orders.source_group
orders__special_instructions TEXT orders.special_instructions orders.special_instructions
orders__store_id NUMERIC orders.store_id orders.store_id
orders__subtotal NUMERIC orders.subtotal orders.subtotal
orders__tax_total NUMERIC orders.tax_total orders.tax_total
orders__updated_at TEXT orders.updated_at orders.updated_at

Cart products fields

The products report of the Cart connector includes 125 fields.

Cart products fields (products__add_to_cart_message to products__exclude_parent_from_display)

ID Type Name Description
products__add_to_cart_message TEXT products.add_to_cart_message products.add_to_cart_message
products__additional_points_earned NUMERIC products.additional_points_earned products.additional_points_earned
products__allowed_variable_subscription_types TEXT products.allowed_variable_subscription_types products.allowed_variable_subscription_types
products__approval_required BOOLEAN products.approval_required products.approval_required
products__available_region_id NUMERIC products.available_region_id products.available_region_id
products__average_review_rating NUMERIC products.average_review_rating products.average_review_rating
products__break_out_shipping BOOLEAN products.break_out_shipping products.break_out_shipping
products__bullets TEXT products.bullets products.bullets
products__bullets_external_url TEXT products.bullets_external_url products.bullets_external_url
products__call_for_pricing NUMERIC products.call_for_pricing products.call_for_pricing
products__call_for_shipping NUMERIC products.call_for_shipping products.call_for_shipping
products__call_for_shipping_on_whole_order BOOLEAN products.call_for_shipping_on_whole_order products.call_for_shipping_on_whole_order
products__cost NUMERIC products.cost products.cost
products__created_at TEXT products.created_at products.created_at
products__custom_flag_1 BOOLEAN products.custom_flag_1 products.custom_flag_1
products__custom_flag_2 BOOLEAN products.custom_flag_2 products.custom_flag_2
products__custom_flag_3 BOOLEAN products.custom_flag_3 products.custom_flag_3
products__custom_flag_4 BOOLEAN products.custom_flag_4 products.custom_flag_4
products__custom_flag_5 BOOLEAN products.custom_flag_5 products.custom_flag_5
products__custom_upsell_url TEXT products.custom_upsell_url products.custom_upsell_url
products__days_until_reorder_allowed NUMERIC products.days_until_reorder_allowed products.days_until_reorder_allowed
products__do_not_discount BOOLEAN products.do_not_discount products.do_not_discount
products__do_not_send_review_request BOOLEAN products.do_not_send_review_request products.do_not_send_review_request
products__drop_ship BOOLEAN products.drop_ship products.drop_ship
products__e_product_allow_multiple_deliveries NUMERIC products.e_product_allow_multiple_deliveries products.e_product_allow_multiple_deliveries
products__e_product_delivery_action TEXT products.e_product_delivery_action products.e_product_delivery_action
products__e_product_email TEXT products.e_product_email products.e_product_email
products__e_product_generic_password TEXT products.e_product_generic_password products.e_product_generic_password
products__e_product_generic_username TEXT products.e_product_generic_username products.e_product_generic_username
products__e_product_password TEXT products.e_product_password products.e_product_password
products__e_product_serial_number_file_path TEXT products.e_product_serial_number_file_path products.e_product_serial_number_file_path
products__e_product_type TEXT products.e_product_type products.e_product_type
products__e_product_url TEXT products.e_product_url products.e_product_url
products__e_product_verification_link_expiration NUMERIC products.e_product_verification_link_expiration products.e_product_verification_link_expiration
products__earns_points BOOLEAN products.earns_points products.earns_points
products__enable_low_stock_warning BOOLEAN products.enable_low_stock_warning products.enable_low_stock_warning
products__eta_date TEXT products.eta_date products.eta_date
products__exclude_children_from_display BOOLEAN products.exclude_children_from_display products.exclude_children_from_display
products__exclude_from_commissions BOOLEAN products.exclude_from_commissions products.exclude_from_commissions
products__exclude_parent_from_display BOOLEAN products.exclude_parent_from_display products.exclude_parent_from_display

Cart products fields (products__force_separate_order to products__long_description_tab_name_3)

ID Type Name Description
products__force_separate_order BOOLEAN products.force_separate_order products.force_separate_order
products__gtin TEXT products.gtin products.gtin
products__handling_fee NUMERIC products.handling_fee products.handling_fee
products__has_visible_variants BOOLEAN products.has_visible_variants products.has_visible_variants
products__head_tags TEXT products.head_tags products.head_tags
products__height TEXT products.height products.height
products__hide_variant_surcharges BOOLEAN products.hide_variant_surcharges products.hide_variant_surcharges
products__id NUMERIC products.id products.id
products__in_stock_notification_email_template_id NUMERIC products.in_stock_notification_email_template_id products.in_stock_notification_email_template_id
products__insurance_cost NUMERIC products.insurance_cost products.insurance_cost
products__is_child_product BOOLEAN products.is_child_product products.is_child_product
products__is_discontinued BOOLEAN products.is_discontinued products.is_discontinued
products__is_featured_item BOOLEAN products.is_featured_item products.is_featured_item
products__is_hidden NUMERIC products.is_hidden products.is_hidden
products__is_kit BOOLEAN products.is_kit products.is_kit
products__is_linked_product BOOLEAN products.is_linked_product products.is_linked_product
products__is_non_inventory BOOLEAN products.is_non_inventory products.is_non_inventory
products__is_non_shipping_item BOOLEAN products.is_non_shipping_item products.is_non_shipping_item
products__is_non_taxable NUMERIC products.is_non_taxable products.is_non_taxable
products__is_shipped_individually NUMERIC products.is_shipped_individually products.is_shipped_individually
products__is_spotlight_item NUMERIC products.is_spotlight_item products.is_spotlight_item
products__is_subscription_product BOOLEAN products.is_subscription_product products.is_subscription_product
products__item_name TEXT products.item_name products.item_name
products__item_number TEXT products.item_number products.item_number
products__keywords TEXT products.keywords products.keywords
products__last_item_number TEXT products.last_item_number products.last_item_number
products__length TEXT products.length products.length
products__long_description_1 TEXT products.long_description_1 products.long_description_1
products__long_description_2 TEXT products.long_description_2 products.long_description_2
products__long_description_3 TEXT products.long_description_3 products.long_description_3
products__long_description_4 TEXT products.long_description_4 products.long_description_4
products__long_description_5 TEXT products.long_description_5 products.long_description_5
products__long_description_external_url_1 TEXT products.long_description_external_url_1 products.long_description_external_url_1
products__long_description_external_url_2 TEXT products.long_description_external_url_2 products.long_description_external_url_2
products__long_description_external_url_3 TEXT products.long_description_external_url_3 products.long_description_external_url_3
products__long_description_external_url_4 TEXT products.long_description_external_url_4 products.long_description_external_url_4
products__long_description_external_url_5 TEXT products.long_description_external_url_5 products.long_description_external_url_5
products__long_description_tab_name_1 TEXT products.long_description_tab_name_1 products.long_description_tab_name_1
products__long_description_tab_name_2 TEXT products.long_description_tab_name_2 products.long_description_tab_name_2
products__long_description_tab_name_3 TEXT products.long_description_tab_name_3 products.long_description_tab_name_3

Cart products fields (products__long_description_tab_name_4 to products__use_variant_inventory)

ID Type Name Description
products__long_description_tab_name_4 TEXT products.long_description_tab_name_4 products.long_description_tab_name_4
products__long_description_tab_name_5 TEXT products.long_description_tab_name_5 products.long_description_tab_name_5
products__low_stock_warning_threshold NUMERIC products.low_stock_warning_threshold products.low_stock_warning_threshold
products__manufacturer_id NUMERIC products.manufacturer_id products.manufacturer_id
products__manufacturer_part_number TEXT products.manufacturer_part_number products.manufacturer_part_number
products__master_product_id NUMERIC products.master_product_id products.master_product_id
products__maximum_quantity NUMERIC products.maximum_quantity products.maximum_quantity
products__meta_description TEXT products.meta_description products.meta_description
products__minimum_quantity NUMERIC products.minimum_quantity products.minimum_quantity
products__no_price_mask TEXT products.no_price_mask products.no_price_mask
products__override_theme_use_tabs BOOLEAN products.override_theme_use_tabs products.override_theme_use_tabs
products__page_title TEXT products.page_title products.page_title
products__price NUMERIC products.price products.price
products__primary_category_id NUMERIC products.primary_category_id products.primary_category_id
products__product_rating_dimension_group_override_id TEXT products.product_rating_dimension_group_override_id products.product_rating_dimension_group_override_id
products__product_status_id NUMERIC products.product_status_id products.product_status_id
products__profile_id NUMERIC products.profile_id products.profile_id
products__quantity_increment NUMERIC products.quantity_increment products.quantity_increment
products__quantity_on_hand NUMERIC products.quantity_on_hand products.quantity_on_hand
products__quantity_on_order NUMERIC products.quantity_on_order products.quantity_on_order
products__quickbooks_item_id TEXT products.quickbooks_item_id products.quickbooks_item_id
products__rate_adjustment_type TEXT products.rate_adjustment_type products.rate_adjustment_type
products__related_name TEXT products.related_name products.related_name
products__retail NUMERIC products.retail products.retail
products__review_count NUMERIC products.review_count products.review_count
products__shipping_classification_code TEXT products.shipping_classification_code products.shipping_classification_code
products__shipping_override NUMERIC products.shipping_override products.shipping_override
products__short_description TEXT products.short_description products.short_description
products__size_unit TEXT products.size_unit products.size_unit
products__sort_order NUMERIC products.sort_order products.sort_order
products__starting_quantity NUMERIC products.starting_quantity products.starting_quantity
products__subscription_frequency NUMERIC products.subscription_frequency products.subscription_frequency
products__subscription_frequency_type TEXT products.subscription_frequency_type products.subscription_frequency_type
products__tax_code TEXT products.tax_code products.tax_code
products__updated_at TEXT products.updated_at products.updated_at
products__url_rewrite TEXT products.url_rewrite products.url_rewrite
products__use_map_pricing BOOLEAN products.use_map_pricing products.use_map_pricing
products__use_pricing_from_parent BOOLEAN products.use_pricing_from_parent products.use_pricing_from_parent
products__use_tabs BOOLEAN products.use_tabs products.use_tabs
products__use_variant_inventory BOOLEAN products.use_variant_inventory products.use_variant_inventory

Cart products fields (products__vendor_store_id to products__width)

ID Type Name Description
products__vendor_store_id NUMERIC products.vendor_store_id products.vendor_store_id
products__warehouse_id NUMERIC products.warehouse_id products.warehouse_id
products__weight NUMERIC products.weight products.weight
products__weight_unit TEXT products.weight_unit products.weight_unit
products__width TEXT products.width products.width

Cart other fields

The Cart connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date