Windsor brings all your Cart data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Cart Field Reference

Fields
ID | Type | Name | Description | Report |
---|---|---|---|---|
addresses__address_line_1 | TEXT | addresses.address_line_1 | addresses.address_line_1 | addresses |
addresses__address_line_2 | TEXT | addresses.address_line_2 | addresses.address_line_2 | addresses |
addresses__address_type | TEXT | addresses.address_type | addresses.address_type | addresses |
addresses__alternate_phone | TEXT | addresses.alternate_phone | addresses.alternate_phone | addresses |
addresses__city | TEXT | addresses.city | addresses.city | addresses |
addresses__comments | TEXT | addresses.comments | addresses.comments | addresses |
addresses__company | TEXT | addresses.company | addresses.company | addresses |
addresses__country | TEXT | addresses.country | addresses.country | addresses |
addresses__created_at | TEXT | addresses.created_at | addresses.created_at | addresses |
addresses__customer_id | NUMERIC | addresses.customer_id | addresses.customer_id | addresses |
addresses__fax | TEXT | addresses.fax | addresses.fax | addresses |
addresses__first_name | TEXT | addresses.first_name | addresses.first_name | addresses |
addresses__id | NUMERIC | addresses.id | addresses.id | addresses |
addresses__is_default_billing_address | BOOLEAN | addresses.is_default_billing_address | addresses.is_default_billing_address | addresses |
addresses__is_default_shipping_address | BOOLEAN | addresses.is_default_shipping_address | addresses.is_default_shipping_address | addresses |
addresses__last_name | TEXT | addresses.last_name | addresses.last_name | addresses |
addresses__phone | TEXT | addresses.phone | addresses.phone | addresses |
addresses__postal_code | TEXT | addresses.postal_code | addresses.postal_code | addresses |
addresses__state | TEXT | addresses.state | addresses.state | addresses |
addresses__updated_at | TEXT | addresses.updated_at | addresses.updated_at | addresses |
customers_cart__adcode | TEXT | customers_cart.adcode | customers_cart.adcode | customers_cart |
customers_cart__adcode_id | NUMERIC | customers_cart.adcode_id | customers_cart.adcode_id | customers_cart |
customers_cart__affiliate_id | NUMERIC | customers_cart.affiliate_id | customers_cart.affiliate_id | customers_cart |
customers_cart__alternate_phone_number | TEXT | customers_cart.alternate_phone_number | customers_cart.alternate_phone_number | customers_cart |
customers_cart__comments | TEXT | customers_cart.comments | customers_cart.comments | customers_cart |
customers_cart__company | TEXT | customers_cart.company | customers_cart.company | customers_cart |
customers_cart__created_at | TEXT | customers_cart.created_at | customers_cart.created_at | customers_cart |
customers_cart__credit_limit | TEXT | customers_cart.credit_limit | customers_cart.credit_limit | customers_cart |
customers_cart__customer_number | TEXT | customers_cart.customer_number | customers_cart.customer_number | customers_cart |
customers_cart__customer_payment_methods_availability | OBJECT | customers_cart.customer_payment_methods_availability | customers_cart.customer_payment_methods_availability | customers_cart |
customers_cart__customer_type_id | NUMERIC | customers_cart.customer_type_id | customers_cart.customer_type_id | customers_cart |
customers_cart__email | TEXT | customers_cart.email | customers_cart.email | customers_cart |
customers_cart__first_name | TEXT | customers_cart.first_name | customers_cart.first_name | customers_cart |
customers_cart__id | NUMERIC | customers_cart.id | customers_cart.id | customers_cart |
customers_cart__is_affiliate_customer | BOOLEAN | customers_cart.is_affiliate_customer | customers_cart.is_affiliate_customer | customers_cart |
customers_cart__is_contact_information_only | BOOLEAN | customers_cart.is_contact_information_only | customers_cart.is_contact_information_only | customers_cart |
customers_cart__is_inactive | BOOLEAN | customers_cart.is_inactive | customers_cart.is_inactive | customers_cart |
customers_cart__is_no_tax_customer | BOOLEAN | customers_cart.is_no_tax_customer | customers_cart.is_no_tax_customer | customers_cart |
customers_cart__last_name | TEXT | customers_cart.last_name | customers_cart.last_name | customers_cart |
customers_cart__last_visit_at | TEXT | customers_cart.last_visit_at | customers_cart.last_visit_at | customers_cart |
customers_cart__lock_default_address | BOOLEAN | customers_cart.lock_default_address | customers_cart.lock_default_address | customers_cart |
customers_cart__no_account | BOOLEAN | customers_cart.no_account | customers_cart.no_account | customers_cart |
customers_cart__payment_net_term | TEXT | customers_cart.payment_net_term | customers_cart.payment_net_term | customers_cart |
customers_cart__phone_number | TEXT | customers_cart.phone_number | customers_cart.phone_number | customers_cart |
customers_cart__registered_at | TEXT | customers_cart.registered_at | customers_cart.registered_at | customers_cart |
customers_cart__reward_tier_id | TEXT | customers_cart.reward_tier_id | customers_cart.reward_tier_id | customers_cart |
customers_cart__sales_person | TEXT | customers_cart.sales_person | customers_cart.sales_person | customers_cart |
customers_cart__sales_person_user_id | TEXT | customers_cart.sales_person_user_id | customers_cart.sales_person_user_id | customers_cart |
customers_cart__search_string | TEXT | customers_cart.search_string | customers_cart.search_string | customers_cart |
customers_cart__source | TEXT | customers_cart.source | customers_cart.source | customers_cart |
customers_cart__source_group | TEXT | customers_cart.source_group | customers_cart.source_group | customers_cart |
customers_cart__store_id | NUMERIC | customers_cart.store_id | customers_cart.store_id | customers_cart |
customers_cart__store_payment_methods_enabled | OBJECT | customers_cart.store_payment_methods_enabled | customers_cart.store_payment_methods_enabled | customers_cart |
customers_cart__sub | TEXT | customers_cart.sub | customers_cart.sub | customers_cart |
customers_cart__tax_exemption_number | TEXT | customers_cart.tax_exemption_number | customers_cart.tax_exemption_number | customers_cart |
customers_cart__tax_rate | TEXT | customers_cart.tax_rate | customers_cart.tax_rate | customers_cart |
customers_cart__updated_at | TEXT | customers_cart.updated_at | customers_cart.updated_at | customers_cart |
customers_cart__username | TEXT | customers_cart.username | customers_cart.username | customers_cart |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
order_items__admin_comments | TEXT | order_items.admin_comments | order_items.admin_comments | order_items |
order_items__configuration | TEXT | order_items.configuration | order_items.configuration | order_items |
order_items__cost | NUMERIC | order_items.cost | order_items.cost | order_items |
order_items__created_at | TEXT | order_items.created_at | order_items.created_at | order_items |
order_items__delivery_date | TEXT | order_items.delivery_date | order_items.delivery_date | order_items |
order_items__description | TEXT | order_items.description | order_items.description | order_items |
order_items__discount_amount | NUMERIC | order_items.discount_amount | order_items.discount_amount | order_items |
order_items__discount_percentage | NUMERIC | order_items.discount_percentage | order_items.discount_percentage | order_items |
order_items__do_not_discount | BOOLEAN | order_items.do_not_discount | order_items.do_not_discount | order_items |
order_items__fitment | TEXT | order_items.fitment | order_items.fitment | order_items |
order_items__gift_message | TEXT | order_items.gift_message | order_items.gift_message | order_items |
order_items__height | NUMERIC | order_items.height | order_items.height | order_items |
order_items__id | NUMERIC | order_items.id | order_items.id | order_items |
order_items__is_discount_item | BOOLEAN | order_items.is_discount_item | order_items.is_discount_item | order_items |
order_items__is_non_shipping_item | BOOLEAN | order_items.is_non_shipping_item | order_items.is_non_shipping_item | order_items |
order_items__is_quantity_bound_to_parent | BOOLEAN | order_items.is_quantity_bound_to_parent | order_items.is_quantity_bound_to_parent | order_items |
order_items__is_subscription_product | BOOLEAN | order_items.is_subscription_product | order_items.is_subscription_product | order_items |
order_items__is_taxable | BOOLEAN | order_items.is_taxable | order_items.is_taxable | order_items |
order_items__item_name | TEXT | order_items.item_name | order_items.item_name | order_items |
order_items__item_number | TEXT | order_items.item_number | order_items.item_number | order_items |
order_items__item_number_full | TEXT | order_items.item_number_full | order_items.item_number_full | order_items |
order_items__length | NUMERIC | order_items.length | order_items.length | order_items |
order_items__line_item_note | TEXT | order_items.line_item_note | order_items.line_item_note | order_items |
order_items__order_id | NUMERIC | order_items.order_id | order_items.order_id | order_items |
order_items__order_shipping_address_id | TEXT | order_items.order_shipping_address_id | order_items.order_shipping_address_id | order_items |
order_items__parent_order_item_id | NUMERIC | order_items.parent_order_item_id | order_items.parent_order_item_id | order_items |
order_items__personalizations | OBJECT | order_items.personalizations | order_items.personalizations | order_items |
order_items__price | NUMERIC | order_items.price | order_items.price | order_items |
order_items__product_id | NUMERIC | order_items.product_id | order_items.product_id | order_items |
order_items__quantity | NUMERIC | order_items.quantity | order_items.quantity | order_items |
order_items__selected_shipping_method | TEXT | order_items.selected_shipping_method | order_items.selected_shipping_method | order_items |
order_items__selected_shipping_method_id | TEXT | order_items.selected_shipping_method_id | order_items.selected_shipping_method_id | order_items |
order_items__selected_shipping_provider_service | TEXT | order_items.selected_shipping_provider_service | order_items.selected_shipping_provider_service | order_items |
order_items__shipping_classification_code | TEXT | order_items.shipping_classification_code | order_items.shipping_classification_code | order_items |
order_items__shipping_total | TEXT | order_items.shipping_total | order_items.shipping_total | order_items |
order_items__size_unit | TEXT | order_items.size_unit | order_items.size_unit | order_items |
order_items__status | TEXT | order_items.status | order_items.status | order_items |
order_items__tax | NUMERIC | order_items.tax | order_items.tax | order_items |
order_items__tax_code | TEXT | order_items.tax_code | order_items.tax_code | order_items |
order_items__updated_at | TEXT | order_items.updated_at | order_items.updated_at | order_items |
order_items__variant_inventory_id | TEXT | order_items.variant_inventory_id | order_items.variant_inventory_id | order_items |
order_items__variants | OBJECT | order_items.variants | order_items.variants | order_items |
order_items__vendor_store_id | NUMERIC | order_items.vendor_store_id | order_items.vendor_store_id | order_items |
order_items__warehouse_id | NUMERIC | order_items.warehouse_id | order_items.warehouse_id | order_items |
order_items__weigh_unit | TEXT | order_items.weigh_unit | order_items.weigh_unit | order_items |
order_items__weight | NUMERIC | order_items.weight | order_items.weight | order_items |
order_items__weight_unit | TEXT | order_items.weight_unit | order_items.weight_unit | order_items |
order_items__width | NUMERIC | order_items.width | order_items.width | order_items |
order_payments__amount | NUMERIC | order_payments.amount | order_payments.amount | order_payments |
order_payments__approved_at | TEXT | order_payments.approved_at | order_payments.approved_at | order_payments |
order_payments__authorization_code | TEXT | order_payments.authorization_code | order_payments.authorization_code | order_payments |
order_payments__avs_code | TEXT | order_payments.avs_code | order_payments.avs_code | order_payments |
order_payments__card_expiration_month | NUMERIC | order_payments.card_expiration_month | order_payments.card_expiration_month | order_payments |
order_payments__card_expiration_year | NUMERIC | order_payments.card_expiration_year | order_payments.card_expiration_year | order_payments |
order_payments__card_type | TEXT | order_payments.card_type | order_payments.card_type | order_payments |
order_payments__cardholder_name | TEXT | order_payments.cardholder_name | order_payments.cardholder_name | order_payments |
order_payments__created_at | TEXT | order_payments.created_at | order_payments.created_at | order_payments |
order_payments__customer_id | NUMERIC | order_payments.customer_id | order_payments.customer_id | order_payments |
order_payments__customer_payment_method_id | NUMERIC | order_payments.customer_payment_method_id | order_payments.customer_payment_method_id | order_payments |
order_payments__cvv_response_code | TEXT | order_payments.cvv_response_code | order_payments.cvv_response_code | order_payments |
order_payments__gateway_response_code | TEXT | order_payments.gateway_response_code | order_payments.gateway_response_code | order_payments |
order_payments__gift_certificate_id | NUMERIC | order_payments.gift_certificate_id | order_payments.gift_certificate_id | order_payments |
order_payments__id | NUMERIC | order_payments.id | order_payments.id | order_payments |
order_payments__is_approved | BOOLEAN | order_payments.is_approved | order_payments.is_approved | order_payments |
order_payments__is_captured | BOOLEAN | order_payments.is_captured | order_payments.is_captured | order_payments |
order_payments__is_declined | BOOLEAN | order_payments.is_declined | order_payments.is_declined | order_payments |
order_payments__is_void | BOOLEAN | order_payments.is_void | order_payments.is_void | order_payments |
order_payments__last_four | TEXT | order_payments.last_four | order_payments.last_four | order_payments |
order_payments__order_id | NUMERIC | order_payments.order_id | order_payments.order_id | order_payments |
order_payments__paid_at | TEXT | order_payments.paid_at | order_payments.paid_at | order_payments |
order_payments__payment_method_id | NUMERIC | order_payments.payment_method_id | order_payments.payment_method_id | order_payments |
order_payments__payment_method_name | TEXT | order_payments.payment_method_name | order_payments.payment_method_name | order_payments |
order_payments__payment_note | TEXT | order_payments.payment_note | order_payments.payment_note | order_payments |
order_payments__payment_ref_num | TEXT | order_payments.payment_ref_num | order_payments.payment_ref_num | order_payments |
order_payments__payment_type | TEXT | order_payments.payment_type | order_payments.payment_type | order_payments |
order_payments__reject_reason | TEXT | order_payments.reject_reason | order_payments.reject_reason | order_payments |
order_payments__sent_to_spark_pay | BOOLEAN | order_payments.sent_to_spark_pay | order_payments.sent_to_spark_pay | order_payments |
order_payments__store_payment_method_id | NUMERIC | order_payments.store_payment_method_id | order_payments.store_payment_method_id | order_payments |
order_payments__token | TEXT | order_payments.token | order_payments.token | order_payments |
order_payments__transaction_id | TEXT | order_payments.transaction_id | order_payments.transaction_id | order_payments |
order_payments__transaction_type | TEXT | order_payments.transaction_type | order_payments.transaction_type | order_payments |
order_payments__updated_at | TEXT | order_payments.updated_at | order_payments.updated_at | order_payments |
order_statuses__color | TEXT | order_statuses.color | order_statuses.color | order_statuses |
order_statuses__created_at | TEXT | order_statuses.created_at | order_statuses.created_at | order_statuses |
order_statuses__email_template_id | NUMERIC | order_statuses.email_template_id | order_statuses.email_template_id | order_statuses |
order_statuses__id | NUMERIC | order_statuses.id | order_statuses.id | order_statuses |
order_statuses__is_cancelled | BOOLEAN | order_statuses.is_cancelled | order_statuses.is_cancelled | order_statuses |
order_statuses__is_declined | BOOLEAN | order_statuses.is_declined | order_statuses.is_declined | order_statuses |
order_statuses__is_fully_refunded | BOOLEAN | order_statuses.is_fully_refunded | order_statuses.is_fully_refunded | order_statuses |
order_statuses__is_open | BOOLEAN | order_statuses.is_open | order_statuses.is_open | order_statuses |
order_statuses__is_partially_refunded | BOOLEAN | order_statuses.is_partially_refunded | order_statuses.is_partially_refunded | order_statuses |
order_statuses__is_partially_shipped | BOOLEAN | order_statuses.is_partially_shipped | order_statuses.is_partially_shipped | order_statuses |
order_statuses__is_quote_status | BOOLEAN | order_statuses.is_quote_status | order_statuses.is_quote_status | order_statuses |
order_statuses__is_shipped | BOOLEAN | order_statuses.is_shipped | order_statuses.is_shipped | order_statuses |
order_statuses__name | TEXT | order_statuses.name | order_statuses.name | order_statuses |
order_statuses__updated_at | TEXT | order_statuses.updated_at | order_statuses.updated_at | order_statuses |
orders__adcode | TEXT | orders.adcode | orders.adcode | orders |
orders__adcode_id | NUMERIC | orders.adcode_id | orders.adcode_id | orders |
orders__additional_fees | NUMERIC | orders.additional_fees | orders.additional_fees | orders |
orders__admin_comments | TEXT | orders.admin_comments | orders.admin_comments | orders |
orders__affiliate_id | NUMERIC | orders.affiliate_id | orders.affiliate_id | orders |
orders__campaign_code | TEXT | orders.campaign_code | orders.campaign_code | orders |
orders__channel | TEXT | orders.channel | orders.channel | orders |
orders__cost_total | NUMERIC | orders.cost_total | orders.cost_total | orders |
orders__coupon_code | TEXT | orders.coupon_code | orders.coupon_code | orders |
orders__created_at | TEXT | orders.created_at | orders.created_at | orders |
orders__customer_id | NUMERIC | orders.customer_id | orders.customer_id | orders |
orders__customer_type_id | NUMERIC | orders.customer_type_id | orders.customer_type_id | orders |
orders__delivery_tax | TEXT | orders.delivery_tax | orders.delivery_tax | orders |
orders__device | TEXT | orders.device | orders.device | orders |
orders__discount_total | NUMERIC | orders.discount_total | orders.discount_total | orders |
orders__discounted_shipping_total | NUMERIC | orders.discounted_shipping_total | orders.discounted_shipping_total | orders |
orders__due_date | TEXT | orders.due_date | orders.due_date | orders |
orders__entered_by | TEXT | orders.entered_by | orders.entered_by | orders |
orders__entered_by_type | TEXT | orders.entered_by_type | orders.entered_by_type | orders |
orders__expires | BOOLEAN | orders.expires | orders.expires | orders |
orders__expires_at | TEXT | orders.expires_at | orders.expires_at | orders |
orders__exported_to_accounting_system | NUMERIC | orders.exported_to_accounting_system | orders.exported_to_accounting_system | orders |
orders__from_quote_id | NUMERIC | orders.from_quote_id | orders.from_quote_id | orders |
orders__from_subscription_id | NUMERIC | orders.from_subscription_id | orders.from_subscription_id | orders |
orders__gift_message | TEXT | orders.gift_message | orders.gift_message | orders |
orders__grand_total | NUMERIC | orders.grand_total | orders.grand_total | orders |
orders__handling_total | NUMERIC | orders.handling_total | orders.handling_total | orders |
orders__id | NUMERIC | orders.id | orders.id | orders |
orders__instructions | TEXT | orders.instructions | orders.instructions | orders |
orders__ip_address | TEXT | orders.ip_address | orders.ip_address | orders |
orders__is_gift | BOOLEAN | orders.is_gift | orders.is_gift | orders |
orders__is_payment_order_only | BOOLEAN | orders.is_payment_order_only | orders.is_payment_order_only | orders |
orders__is_ppc | BOOLEAN | orders.is_ppc | orders.is_ppc | orders |
orders__manufacturer_invoice_amount | NUMERIC | orders.manufacturer_invoice_amount | orders.manufacturer_invoice_amount | orders |
orders__manufacturer_invoice_number | TEXT | orders.manufacturer_invoice_number | orders.manufacturer_invoice_number | orders |
orders__manufacturer_invoice_paid | BOOLEAN | orders.manufacturer_invoice_paid | orders.manufacturer_invoice_paid | orders |
orders__order_billing_address_id | NUMERIC | orders.order_billing_address_id | orders.order_billing_address_id | orders |
orders__order_number | TEXT | orders.order_number | orders.order_number | orders |
orders__order_shipping_address_id | NUMERIC | orders.order_shipping_address_id | orders.order_shipping_address_id | orders |
orders__order_status_id | NUMERIC | orders.order_status_id | orders.order_status_id | orders |
orders__order_status_last_changed_at | TEXT | orders.order_status_last_changed_at | orders.order_status_last_changed_at | orders |
orders__order_type | TEXT | orders.order_type | orders.order_type | orders |
orders__ordered_at | TEXT | orders.ordered_at | orders.ordered_at | orders |
orders__ppc_keyword | TEXT | orders.ppc_keyword | orders.ppc_keyword | orders |
orders__previous_order_status_id | NUMERIC | orders.previous_order_status_id | orders.previous_order_status_id | orders |
orders__public_comments | TEXT | orders.public_comments | orders.public_comments | orders |
orders__referrer | TEXT | orders.referrer | orders.referrer | orders |
orders__reward_points_credited | BOOLEAN | orders.reward_points_credited | orders.reward_points_credited | orders |
orders__sales_agent_user_id | TEXT | orders.sales_agent_user_id | orders.sales_agent_user_id | orders |
orders__search_phrase | TEXT | orders.search_phrase | orders.search_phrase | orders |
orders__selected_shipping_method | TEXT | orders.selected_shipping_method | orders.selected_shipping_method | orders |
orders__selected_shipping_provider_service | TEXT | orders.selected_shipping_provider_service | orders.selected_shipping_provider_service | orders |
orders__session_id | NUMERIC | orders.session_id | orders.session_id | orders |
orders__shipping_selections | OBJECT | orders.shipping_selections | orders.shipping_selections | orders |
orders__shipping_total | NUMERIC | orders.shipping_total | orders.shipping_total | orders |
orders__source | TEXT | orders.source | orders.source | orders |
orders__source_group | TEXT | orders.source_group | orders.source_group | orders |
orders__special_instructions | TEXT | orders.special_instructions | orders.special_instructions | orders |
orders__store_id | NUMERIC | orders.store_id | orders.store_id | orders |
orders__subtotal | NUMERIC | orders.subtotal | orders.subtotal | orders |
orders__tax_total | NUMERIC | orders.tax_total | orders.tax_total | orders |
orders__updated_at | TEXT | orders.updated_at | orders.updated_at | orders |
products__add_to_cart_message | TEXT | products.add_to_cart_message | products.add_to_cart_message | products |
products__additional_points_earned | NUMERIC | products.additional_points_earned | products.additional_points_earned | products |
products__allowed_variable_subscription_types | TEXT | products.allowed_variable_subscription_types | products.allowed_variable_subscription_types | products |
products__approval_required | BOOLEAN | products.approval_required | products.approval_required | products |
products__available_region_id | NUMERIC | products.available_region_id | products.available_region_id | products |
products__average_review_rating | NUMERIC | products.average_review_rating | products.average_review_rating | products |
products__break_out_shipping | BOOLEAN | products.break_out_shipping | products.break_out_shipping | products |
products__bullets | TEXT | products.bullets | products.bullets | products |
products__bullets_external_url | TEXT | products.bullets_external_url | products.bullets_external_url | products |
products__call_for_pricing | NUMERIC | products.call_for_pricing | products.call_for_pricing | products |
products__call_for_shipping | NUMERIC | products.call_for_shipping | products.call_for_shipping | products |
products__call_for_shipping_on_whole_order | BOOLEAN | products.call_for_shipping_on_whole_order | products.call_for_shipping_on_whole_order | products |
products__cost | NUMERIC | products.cost | products.cost | products |
products__created_at | TEXT | products.created_at | products.created_at | products |
products__custom_flag_1 | BOOLEAN | products.custom_flag_1 | products.custom_flag_1 | products |
products__custom_flag_2 | BOOLEAN | products.custom_flag_2 | products.custom_flag_2 | products |
products__custom_flag_3 | BOOLEAN | products.custom_flag_3 | products.custom_flag_3 | products |
products__custom_flag_4 | BOOLEAN | products.custom_flag_4 | products.custom_flag_4 | products |
products__custom_flag_5 | BOOLEAN | products.custom_flag_5 | products.custom_flag_5 | products |
products__custom_upsell_url | TEXT | products.custom_upsell_url | products.custom_upsell_url | products |
products__days_until_reorder_allowed | NUMERIC | products.days_until_reorder_allowed | products.days_until_reorder_allowed | products |
products__do_not_discount | BOOLEAN | products.do_not_discount | products.do_not_discount | products |
products__do_not_send_review_request | BOOLEAN | products.do_not_send_review_request | products.do_not_send_review_request | products |
products__drop_ship | BOOLEAN | products.drop_ship | products.drop_ship | products |
products__e_product_allow_multiple_deliveries | NUMERIC | products.e_product_allow_multiple_deliveries | products.e_product_allow_multiple_deliveries | products |
products__e_product_delivery_action | TEXT | products.e_product_delivery_action | products.e_product_delivery_action | products |
products__e_product_email | TEXT | products.e_product_email | products.e_product_email | products |
products__e_product_generic_password | TEXT | products.e_product_generic_password | products.e_product_generic_password | products |
products__e_product_generic_username | TEXT | products.e_product_generic_username | products.e_product_generic_username | products |
products__e_product_password | TEXT | products.e_product_password | products.e_product_password | products |
products__e_product_serial_number_file_path | TEXT | products.e_product_serial_number_file_path | products.e_product_serial_number_file_path | products |
products__e_product_type | TEXT | products.e_product_type | products.e_product_type | products |
products__e_product_url | TEXT | products.e_product_url | products.e_product_url | products |
products__e_product_verification_link_expiration | NUMERIC | products.e_product_verification_link_expiration | products.e_product_verification_link_expiration | products |
products__earns_points | BOOLEAN | products.earns_points | products.earns_points | products |
products__enable_low_stock_warning | BOOLEAN | products.enable_low_stock_warning | products.enable_low_stock_warning | products |
products__eta_date | TEXT | products.eta_date | products.eta_date | products |
products__exclude_children_from_display | BOOLEAN | products.exclude_children_from_display | products.exclude_children_from_display | products |
products__exclude_from_commissions | BOOLEAN | products.exclude_from_commissions | products.exclude_from_commissions | products |
products__exclude_parent_from_display | BOOLEAN | products.exclude_parent_from_display | products.exclude_parent_from_display | products |
products__force_separate_order | BOOLEAN | products.force_separate_order | products.force_separate_order | products |
products__gtin | TEXT | products.gtin | products.gtin | products |
products__handling_fee | NUMERIC | products.handling_fee | products.handling_fee | products |
products__has_visible_variants | BOOLEAN | products.has_visible_variants | products.has_visible_variants | products |
products__head_tags | TEXT | products.head_tags | products.head_tags | products |
products__height | TEXT | products.height | products.height | products |
products__hide_variant_surcharges | BOOLEAN | products.hide_variant_surcharges | products.hide_variant_surcharges | products |
products__id | NUMERIC | products.id | products.id | products |
products__in_stock_notification_email_template_id | NUMERIC | products.in_stock_notification_email_template_id | products.in_stock_notification_email_template_id | products |
products__insurance_cost | NUMERIC | products.insurance_cost | products.insurance_cost | products |
products__is_child_product | BOOLEAN | products.is_child_product | products.is_child_product | products |
products__is_discontinued | BOOLEAN | products.is_discontinued | products.is_discontinued | products |
products__is_featured_item | BOOLEAN | products.is_featured_item | products.is_featured_item | products |
NUMERIC | products.is_hidden | products.is_hidden | products | |
products__is_kit | BOOLEAN | products.is_kit | products.is_kit | products |
products__is_linked_product | BOOLEAN | products.is_linked_product | products.is_linked_product | products |
products__is_non_inventory | BOOLEAN | products.is_non_inventory | products.is_non_inventory | products |
products__is_non_shipping_item | BOOLEAN | products.is_non_shipping_item | products.is_non_shipping_item | products |
products__is_non_taxable | NUMERIC | products.is_non_taxable | products.is_non_taxable | products |
products__is_shipped_individually | NUMERIC | products.is_shipped_individually | products.is_shipped_individually | products |
products__is_spotlight_item | NUMERIC | products.is_spotlight_item | products.is_spotlight_item | products |
products__is_subscription_product | BOOLEAN | products.is_subscription_product | products.is_subscription_product | products |
products__item_name | TEXT | products.item_name | products.item_name | products |
products__item_number | TEXT | products.item_number | products.item_number | products |
products__keywords | TEXT | products.keywords | products.keywords | products |
products__last_item_number | TEXT | products.last_item_number | products.last_item_number | products |
products__length | TEXT | products.length | products.length | products |
products__long_description_1 | TEXT | products.long_description_1 | products.long_description_1 | products |
products__long_description_2 | TEXT | products.long_description_2 | products.long_description_2 | products |
products__long_description_3 | TEXT | products.long_description_3 | products.long_description_3 | products |
products__long_description_4 | TEXT | products.long_description_4 | products.long_description_4 | products |
products__long_description_5 | TEXT | products.long_description_5 | products.long_description_5 | products |
products__long_description_external_url_1 | TEXT | products.long_description_external_url_1 | products.long_description_external_url_1 | products |
products__long_description_external_url_2 | TEXT | products.long_description_external_url_2 | products.long_description_external_url_2 | products |
products__long_description_external_url_3 | TEXT | products.long_description_external_url_3 | products.long_description_external_url_3 | products |
products__long_description_external_url_4 | TEXT | products.long_description_external_url_4 | products.long_description_external_url_4 | products |
products__long_description_external_url_5 | TEXT | products.long_description_external_url_5 | products.long_description_external_url_5 | products |
products__long_description_tab_name_1 | TEXT | products.long_description_tab_name_1 | products.long_description_tab_name_1 | products |
products__long_description_tab_name_2 | TEXT | products.long_description_tab_name_2 | products.long_description_tab_name_2 | products |
products__long_description_tab_name_3 | TEXT | products.long_description_tab_name_3 | products.long_description_tab_name_3 | products |
products__long_description_tab_name_4 | TEXT | products.long_description_tab_name_4 | products.long_description_tab_name_4 | products |
products__long_description_tab_name_5 | TEXT | products.long_description_tab_name_5 | products.long_description_tab_name_5 | products |
products__low_stock_warning_threshold | NUMERIC | products.low_stock_warning_threshold | products.low_stock_warning_threshold | products |
products__manufacturer_id | NUMERIC | products.manufacturer_id | products.manufacturer_id | products |
products__manufacturer_part_number | TEXT | products.manufacturer_part_number | products.manufacturer_part_number | products |
products__master_product_id | NUMERIC | products.master_product_id | products.master_product_id | products |
products__maximum_quantity | NUMERIC | products.maximum_quantity | products.maximum_quantity | products |
products__meta_description | TEXT | products.meta_description | products.meta_description | products |
products__minimum_quantity | NUMERIC | products.minimum_quantity | products.minimum_quantity | products |
products__no_price_mask | TEXT | products.no_price_mask | products.no_price_mask | products |
products__override_theme_use_tabs | BOOLEAN | products.override_theme_use_tabs | products.override_theme_use_tabs | products |
products__page_title | TEXT | products.page_title | products.page_title | products |
products__price | NUMERIC | products.price | products.price | products |
products__primary_category_id | NUMERIC | products.primary_category_id | products.primary_category_id | products |
products__product_rating_dimension_group_override_id | TEXT | products.product_rating_dimension_group_override_id | products.product_rating_dimension_group_override_id | products |
products__product_status_id | NUMERIC | products.product_status_id | products.product_status_id | products |
products__profile_id | NUMERIC | products.profile_id | products.profile_id | products |
products__quantity_increment | NUMERIC | products.quantity_increment | products.quantity_increment | products |
products__quantity_on_hand | NUMERIC | products.quantity_on_hand | products.quantity_on_hand | products |
products__quantity_on_order | NUMERIC | products.quantity_on_order | products.quantity_on_order | products |
products__quickbooks_item_id | TEXT | products.quickbooks_item_id | products.quickbooks_item_id | products |
products__rate_adjustment_type | TEXT | products.rate_adjustment_type | products.rate_adjustment_type | products |
products__related_name | TEXT | products.related_name | products.related_name | products |
products__retail | NUMERIC | products.retail | products.retail | products |
products__review_count | NUMERIC | products.review_count | products.review_count | products |
products__shipping_classification_code | TEXT | products.shipping_classification_code | products.shipping_classification_code | products |
products__shipping_override | NUMERIC | products.shipping_override | products.shipping_override | products |
products__short_description | TEXT | products.short_description | products.short_description | products |
products__size_unit | TEXT | products.size_unit | products.size_unit | products |
products__sort_order | NUMERIC | products.sort_order | products.sort_order | products |
products__starting_quantity | NUMERIC | products.starting_quantity | products.starting_quantity | products |
products__subscription_frequency | NUMERIC | products.subscription_frequency | products.subscription_frequency | products |
products__subscription_frequency_type | TEXT | products.subscription_frequency_type | products.subscription_frequency_type | products |
products__tax_code | TEXT | products.tax_code | products.tax_code | products |
products__updated_at | TEXT | products.updated_at | products.updated_at | products |
products__url_rewrite | TEXT | products.url_rewrite | products.url_rewrite | products |
products__use_map_pricing | BOOLEAN | products.use_map_pricing | products.use_map_pricing | products |
products__use_pricing_from_parent | BOOLEAN | products.use_pricing_from_parent | products.use_pricing_from_parent | products |
products__use_tabs | BOOLEAN | products.use_tabs | products.use_tabs | products |
products__use_variant_inventory | BOOLEAN | products.use_variant_inventory | products.use_variant_inventory | products |
products__vendor_store_id | NUMERIC | products.vendor_store_id | products.vendor_store_id | products |
products__warehouse_id | NUMERIC | products.warehouse_id | products.warehouse_id | products |
products__weight | NUMERIC | products.weight | products.weight | products |
products__weight_unit | TEXT | products.weight_unit | products.weight_unit | products |
products__width | TEXT | products.width | products.width | products |
source | TEXT | Source | The name of the Windsor connector returning the row | |
today | DATE | Today | Today's date |