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 (ordersadcode to ordersorder_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
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

API Connectors